In addition to standard Garmin 4 column csv files, you can import 'n' column files and target specific gpx fields. It is pre-coded to understand Outlook and Outlook Express default Address Book export files. Additionally a set of 'obvious' header names is available so that the user can import csv files from other sources.
The field names can occur multiple times, in which case data from different columns can be concatenated together (with a space). Obviously, this only makes sense for text fields.
By way of a trivial example, we could import the following file:-
Name,Phone,Streetaddress1,City,State,Zip,Latitude,Longitude
"Garmin AT","00-1-503-364-2138","2345 Turner Road SE","Salem","OR","93702",44.909250,-122.994497
Note: the header names are not case-sensitive.
|
.gpx ‘Field Name’ |
Preferred Header |
Synonyms (These are primarily the field names found by default in the output of Outlook and Outlook Express) |
|
Longitude |
Longitude |
LON |
|
Latitude |
Latitude |
LAT |
|
Name |
Name |
WPT,FIRST NAME,MIDDLE NAME, LAST NAME,COMPANY |
|
Elevation |
Elevation |
N/A |
|
Description |
Description |
DESC,COMMENT,CMT,NOTES,USER 1,USER 2,USER 3,USER 4,KEYWORDS |
|
Street Address1 |
StreetAddress1 |
ADDR1,HOME STREET,BUSINESS STREET,BUSINESS ADDRESS,HOME ADDRESS,OTHER ADDRESS |
|
Street Address2 |
StreetAddress2 |
LOCALITY,ADDR2,BUSINESS STREET 2,BUSINESS STREET 3,HOME STREET 2,HOME STREET 3,OTHER STREET,OTHER STREET 2,OTHER STREET 3 |
|
City |
City |
HOME CITY,BUSINESS CITY,OTHER CITY |
|
State |
State |
COUNTY,HOME STATE,BUSINESS STATE,OTHER STATE |
|
Postal Code |
PostCode |
POST CODE,POSTALCODE,POSTAL CODE,ZIP,ZIPCODE,ZIP CODE,HOME POSTAL CODE,BUSINESS POSTAL CODE,OTHER POSTAL CODE |
|
Country |
Country |
HOME COUNTRY/REGION,BUSINESS COUNTRY/REGION,HOME COUNTRY,OTHER COUNTRY |
|
Phone 1 (dial-able) |
Phone |
PHONE1,PHONE 1,TEL,TEL.,PH,PH.,HOME PHONE,PRIMARY PHONE |
|
Phone 2 |
Phone2 |
PHONE 2,BUSINESS PHONE,MOBILE PHONE,COMPANY MAIN PHONE,HOME PHONE 2,CAR PHONE,BUSINESS PHONE 2 |
|
Fax |
Phone3 |
PHONE 3,FAX,HOME FAX,BUSINESS FAX,OTHER FAX,OTHER PHONE |
|
|
|
E-MAIL ADDRESS,E-MAIL,EMAIL 1 ADDRESS,E-MAIL 2 ADDRESS,E-MAIL 3 ADDRESS |
|
Link |
Link |
JPEG,MPEG,BITMAP,BMP |
|
Speed |
Speed |
N/A |
|
Proximity |
Proximity |
N/A |
Categories Categories Categories for Favourites (certain units only)
The following commonly found keywords are IGNORED. They may be deliberately added to the .csv file to discard a whole ‘column’ of data.
"IGNORE", "IGNORED" and "" {i.e. null}
"TITLE", "NICKNAME", "PERSONAL WEB PAGE", "BUSINESS WEB PAGE", "PAGER", "DEPARTMENT", "OFFICE LOCATION", "JOB TITLE", "SUFFIX", "ASSISTANT'S PHONE", "CALLBACK", "ISDN", "RADIO PHONE", "TTY/TDD PHONE", "TELEX", "ACCOUNT", "ANNIVERSARY", “ASSISTANT'S NAME", "BILLING INFORMATION", "BIRTHDAY", "BUSINESS ADDRESS PO BOX", "CATEGORIES", "CHILDREN", "DIRECTORY SERVER", "E-MAIL TYPE", "E-MAIL DISPLAY NAME", "E-MAIL 2 TYPE", "E-MAIL 2 DISPLAY NAME", "E-MAIL 3 TYPE", "E-MAIL 3 DISPLAY NAME", "GENDER", "GOVERNMENT ID NUMBER", "HOBBY", "HOME ADDRESS PO BOX", "INITIALS", "INTERNET FREE BUSY", "LANGUAGE", "LOCATION", "MANAGER'S NAME", "MILEAGE", "NOTES", "OFFICE LOCATION", "ORGANIZATIONAL ID NUMBER", "OTHER ADDRESS PO BOX", "PRIORITY", "PRIVATE", "PROFESSION", "REFERRED BY", "SENSITIVITY", "SPOUSE", "WEB PAGE"