Filter
Top Products
- 51 -
4. In the next screen you'll see the data from your file
sorted into columns. If the columns you see in the
screen have not sorted the address data correctly, you
need to indicate which delimiter CoPilot should
recognize when it separates the fields in your file into
columns. Each field — e.g. name, street address, city,
state, etc. — needs to be separated by a delimiter
such as a tab, semicolon, or comma. If your file uses a
delimiter other than a comma, tab, or semicolon, click
Other and type the delimiter in the box to the right.
If the first row of your file consists of column
headings, you should check Column headings in
first row. Click Next when ready.
5. Now, following the instructions on the screen,
click each column heading and match the column
headings with your data. To be accepted by CoPilot,
each imported place must have at least four fields:
Name, Address1, City, and State. Click Next
when ready.
6. In the next screen, following the instructions, you
can assign a name to the set of columns you just
defined to save you time the next time you import
addresses.
To skip this step, uncheck Save the columns as a
new set. Click Finish.
- 52 -
7. When processing is finished, the Data Import Status window shows you how many places
in your file were matched with addresses in the CoPilot database. A plus sign in the Accept
column indicates a match. Places that failed to match appear in red and do not have a plus sign.
8. To edit a failed or incomplete match, highlight it and click Edit (see Editing Custom Places,
next page). POI addresses can also be edited after they are added to the database using the
Custom Place Manager.
9. When you are satisfied with the list of addresses, click Add to add these places to the
CoPilot database.
Options below the list let you 1) choose whether to add all addresses on the list to the
database, or just those that were accepted, and 2) determine how CoPilot will handle any
address that duplicates one already in the database.