You may have content stored in databases, spreadsheets, or other sources that you'd like to display on a map; for example you might have a customer list or a set of environmental sensor devices at specific locations. You can import this content into an ArcGIS Explorer map provided it has address or coordinate information associated with it and is in a file format ArcGIS Explorer can read, such as a .csv or a .txt file that has delimited values or uniformly fixed width fields up to 99 characters in length. To do this you use the File Import Wizard. The Wizard reads your file, gathers information from you about it and then creates place results for each item in the file. For files containing addresses you can match up to 20 addresses per file; for coordinate-based locations, your file can contain up to 64,000 coordinate or coordinate pair values.
To select a file to import choose Tools menu > File Import... In the File Open dialog box browse for text files with a .csv, .txt file extension, or any file extension so long as the file contains text only. Once you've chosen a file, the File Import Wizard dialog box will display. In addition to starting the import process from the Tools menu, you can drag a .csv or .txt file from Windows Explorer and drop it onto a running instance of ArcGIS Explorer. Once you drop the file, you'll see the first panel of the Wizard.
The first panel you see displays the File Delimiters grouping. Here's where you specify how the file is structured. If you select Delimiters you'll be able to specify how the information on each line of the file is separated; for example, in many cases each unit of information is separated from the next by the default separator, a comma. Choose from Comma, Space, Tab, Semicolon, or a character you enter in the panel's text box. If you choose Fixed Width as the delimiting structure of the file, the dialog panel changes to allow you to specify a constant width for all of the file's fields. You may specify a field width up to 99 characters.
A checkmark in the 'First line contains field names' checkbox tells the File Import Wizard to treat the first line of your file as a row of field names; if you clear the checkbox, the File Import Wizard will supply generic names for each delimited unit of information. The fields will be named Field1, Field2, Field3, and so on.
At the bottom of the dialog box on all panels of the File Import Wizard, you'll see the Data Preview section. Here's where you can see how the File Import Wizard understands what's in your file. The table will change dynamically based on the settings you make in the rest of the dialog box. Note that Data Preview only displays the first five lines of your file.
Once you've finished specifying how the file's organized, click Next to move to the next panel where you'll tell the File Import Wizard what kind of data is in your file and what fields to look in for location and descriptive information.
To instruct the Wizard as to what kind of data your file contains, choose one of the three Location Source options.
If the file contains addresses choose the Addresses option and then press the Next button at the bottom of the Wizard to move to the next panel in which you'll specify which fields contain the components of the address.
If the file contains Latitude/Longitude coordinate pairs choose that option and then specify the name of the field that contains the X-coordinate (Longitude) and which field contains the Y-coordinate (Latitude).
If your file contains USNG or MGRS coordinates choose that option and then specify the name of the field that contains the coordinate.
Once the Wizard processes the file you've supplied, it will create place results that you can inspect, navigate to, and use with other tasks. The Results Sources fields provide the Wizard with the information to distinguish each location.
The contents of the Title field can be used to identify the location in the list of results in the Results window; this may be useful since the default text used in the Result window is the coordinate pair or coordinate.
The contents of the Description field will be appended to the default text in the popup window associated with the location. This can be anything from a single word to full HTML markup, including links to web sites, etc. Learn more about HTML markup in text files and notes.
In some cases, both of the results sources may be the same field or you may only want to specify one of the fields. You may find that the most common scenario is to identify the location and use another field to supplement the default information. Note that this functionality is available for Latitude/Longitude and USNG or MGRS coordinates only. Once you've specified the coordinate location source fields and any result source fields, click Next to select a symbol that will mark any found locations assuming you want to choose the symbol yourself; otherwise, click Finish.
Your address data in text files can be in one of two formats; it can either be in one field in its entirety or it can be in multiple fields. An example of the first case would be:
StreetAddress, Description
380 New York Street Redlands CA 92373, ESRI Corporate Headquarters
In the above case, you'd check the One Field as Address option and select the field named StreetAddress as the Address field.
An example of a multiple field address would be:
Street, City, State, Zip, Description
380 New York Street, Redlands, CA, 92373, ESRI Corporate Headquarters
If your file contains multiple fields that constitute the address you must specify which field contains each part of the address. So, in the above example, you'd specify Street as the Street field, City as the City field, and so on.
If your file does not have, for example a City field and a State field, but you know that all addresses are in the same city and state, you can check the appropriate checkboxes and enter a constant value, for example:
Once you've specified the address fields and any constants, click Next to select a symbol that will mark any found locations assuming you want to choose the symbol yourself; otherwise, click Finish.
In the Symbol Selection panel of the File Import Wizard choose a symbol. The symbol you select will be used for each place found on the map. If you want to load additional styles to choose from you can browse for ServerStyle files by clicking the Styles button.
Once you are satisfied that the File Import Wizard has all the information you want to supply, click Finish. The application will take your information and the file and attempt to match as many locations as it can. If you have a file with more than 20 addresses, ArcGIS Explorer will match the first 20 addresses it can and then notify you that you should break up the file into several other files, each containing a maximum of 20 addresses. Since there's no limitation on the number of coordinates, you won't see this message and the application will find all the locations it can. In both cases, the results, and any error messages issued, will appear in the Results window and locations will be marked with the symbol you specified. You can use the context menu for any of the results as you do with any other result.
As part of your work, you may find that you use the same filename each time to create place results or add to the existing file. The Wizard looks to see if you've used the same filename before and if so, it will offer to use the parameters you specified initially so that you don't have to re-enter everything again. To do this, the Wizard creates a file with the same as your original file, but with the extension .etx in the same folder as the file you chose to import originally. You may want to verify that you have Write permission on that folder prior to running the Wizard.
If for any reason, at any time in the process, you want to stop your work before the application starts to find locations, just click Cancel.
If your text file contains field names with specific text, the Wizard will recognize them and associate them automatically with the corresponding field in the appropriate panels. You may want to take advantage of this to save time when you load your files. You can always change the field name if your files contain multiple fields. The text strings recognized by the Wizard and the fields they are assigned to are:
| These text strings | Are associated with this field |
| lon longitude x | X Coordinate field |
| lat latitude y | Y Coordinate field |
| title | Title field |
| description | Description field |