The article provides a comprehensive guide on importing sub-locations using an Excel or CSV file, including coordinates, attributes, and optional addresses. It outlines steps such as preparing data with necessary information, selecting import locations, uploading sheets, choosing mapping templates, assigning addresses, confirming column headers, and previewing data. The guide also discusses mapping choices, automatic naming, plausibility checks, executing the import, reviewing feedback, troubleshooting, and checking master data. The process ensures accurate data import and addresses potential issues like duplicate coordinates.
1. Prepare Your Data
Before you begin, ensure that you have prepared your Excel or CSV file with the necessary information. Your file should include:
- Coordinates (e.g., GK(X), GK(Y))
- Attributes (e.g., business units, residential units)
- Addresses (optional)
2. Select the Import Location
Begin by choosing the main location into which the sub-locations will be imported. This is done through the interface by clicking on the "Import Sublocations" button.
3. Upload Your Sheet
Once the overview opens, select the sheet you prepared earlier. This will allow the system to recognize the data you wish to import.
4. Choose a Mapping Template
In the import tool, you can choose a mapping template that corresponds to the structure of your data. This template helps define how the imported data will be allocated to the system.
5. Assign Addresses
You will have the option to assign addresses from your address repository. Here, you can specify whether the assignment should be static or dynamic, depending on your needs.
6. Confirm Column Headers
Check if your sheet includes column header names. This ensures that the system accurately recognizes the data categories you are importing.
7. Data Preview
Before finalizing the import, review a preview of the data to ensure everything is in order. Pay special attention to the format of your coordinates, making sure that the decimal separator (comma or point) is correct.
8. Mapping Choices
You have different options for mapping your data:
- Mapping by Full Name: Use the full names from your Excel sheet (e.g., “house connections”).
- Mapping by Location Type and Coordinates: Import using type and coordinates.
- Automatic Naming: Decide if imported locations should be auto-named.
- Plausibility Check: Enable checks to verify that imported addresses match those in the dictionary.
- Select ID and Location Type: Choose the ID and the type of location (e.g., house connection).
- Coordinate Formats: Ensure your system’s coordinate formats are correctly configured.
- Select Attributes: Import relevant attributes such as business units and residential units.
9. Automatic Naming and Plausibility Checks
Decide if the imported locations should be automatically named. Additionally, you can enable a plausibility check to ensure that the imported addresses match those in your address dictionary. If discrepancies arise, the import protocol will notify you.
10. Execute the Import
Once you've configured your settings, click the "Import" button. The system will create the new locations, along with their corresponding attributes.
11. Review Import Feedback
After the import, you will receive feedback on the process. This includes:
- The total number of objects created
- Any errors encountered, such as duplicate coordinates
12. Troubleshooting
If you notice that certain elements are not imported, the system will provide information on the specific issues. For instance, if there are duplicate coordinates, the import will fail for those entries, as each location must have unique coordinates.
13. Check Master Data
After the import, navigate to the master data section to verify that all addresses were linked correctly. Review the attributes imported to ensure everything is accurate.
Comments
0 comments
Please sign in to leave a comment.