Constructing CSV Locations files.
Procedure
To construct a CSV locations file:
-
Open the file in a spreadsheet application or a text editor.
If you use a text editor, note that the default field separator (delimiter) is a
comma. However, you can configure AIR ImportExpress to recognize a different
delimiter if desired.
Note:
Avoid the following special characters in your import files, especially in
address-related data, such as street, city, area, etc.: $, +, -, ., \. These
special characters may cause geocoding, validation, and import errors. AIR ImportExpress rounds all imported monetary
values (such as layer limits and replacement values) to the nearest whole
number if these values contain decimal places. For a list of column headings
that are valid for use with the column heading automapping feature, refer to
"Column Heading Automapping for CSV Import".
-
Enter the location data.
Sample CSV Locations File
The following example shows an excerpt from a sample CSV locations file:
