Address import

Description

An address layer is any layer that contains dot-shaped objects.

Before you can work with address data, you first need to import them.

During the import action, each address is assigned to the corresponding position on the map.

The imported address data are stored on a separate layer.

You cannot display data with addresses, such as customer addresses, locations, resources or orders on the map or plan with these data until you have successfully completed importing and geocoding the data.

The address layer can be accessed by

                                 Click on menu bar --> Click on menu → Select Addresses

To Import address layer, proceed as follows

1. Open  address import wizard by  'Click on menu bar --> Click on menu → Select Addresses'.

2. In project list, showing the project selected in dashboard by default.

By default address filled in the type list.

3. Import address file.

Click on button to upload required file.

or You can upload the File from server. In file from server, listing all the uploaded files by the login user

4. Click button

5.In the Table name field, select the desired table. The Table name field shows the names of the existing tables

The table will now be displayed in Preview.

If you import contents as a text file you must enter the following data:

•  Select proper Encoding type. Following encoding types are available:-

• ISO-8859-1
• ANSI
• UNICODE
• OEM
• UTF-8

• Select proper decimal(Comma or point).
• In the area Delimiter, enter which separator divides the fields of a data record
• Enable the First line contains field names option, if the first line of the file you are importing contains the field names.

In the ID field, select a unique field (Primary key)

Enter required layer name in Layer Name field   

 

6. Click on button.

7. Data target area and column type specification

    In the Data target area, select/enter target column name and set proper data type for each field in the uploaded file.

    Remove the unwanted field by uncheck the tick mark of checkbox.

8. Click on button.

9. Displaying Geocoding section.

            Select  Geographic reference - Addresses/ Coordinates

If you choose to import via addresses, proceed as follows:

• Map the fields Country code, Postcode, Town, District, Street and House number with the corresponding fields in your data tables. If there are no matching fields, select - Select- .
•  At the bottom area, in the Default country code field, enter the country in which the addresses are located.
• Enable the option Append geocoded addresses if you are importing data via address details and want to determine and append the coordinates in the process.

If you choose to import via coordinates, follow these steps:

1. Map the fields X coordinates and Y coordinates to the corresponding fields in your data tables.

2. Select the coordinate format that your data uses

 Coordinate formats are

• Geodecimal (+/-GGG, NNNNNN; Eg:"10,736805555")
• Mercator (map & guide co-ordinate)
• GMS 1 (GGGMMSS; Eg: "0104412")
• GMS 2 (GGGMMSSS; Eg: "01044125")

10. Click button         

Post - Geocoding button is shown if the data records that were not geocoded.

User will find the addresses as a data table in the Layers area and as a map level in the map.

User can delete imported address layer in Manage layer screen.