I recently bought a TND 530 and was in need to be able to import lots of address in at once. While this site has helped a lot I wasn't able to find out a way to import the phone numbers to the locations I was adding. I did some research into the database and after lots of trial and error I have found a way to do so and how to group the locations. In my case I group the locations by state. Below is how the database is setup and an example CSV file to do the above.
Field Name Field Type
-----------------------------------
Longitude -------------- Double
Latitude --------------- Double
POI Name --------------- Char
Address ---------------- Char
City ------------------- Char
State ------------------ Char
Post Code -------------- Char
Country ---------------- Char
Phone ------------------ Char(20)
Category --------------- Char
I use Extra POI Editor to add address to the CVS file. Below is how to set it up to use the above fields
Options-->M-Column CSV Fields
Col 1 Longitude
Col 2 Latitude
Col 3 POI Name
Col 4 Address
Col 5 City
Col 6 State
Col 7 Post Code
Col 8 Country
Col 9 Phone
Col 10 Category
When adding a new address enter all the info you need excluding Comments and Description, Phone2, Fax, Email or and Tour Guide Info. I always use both the address and Geocoding. To add an address to a Group, add the group to the Categories and check the box for the group you wise to add the address to.
I hope this all makes since to anyone wanting to use this. If not please feel free to contact me and I will help you out.
I recently bought a TND 530 and was in need to be able to import lots of address in at once. While this site has helped a lot I wasn't able to find out a way to import the phone numbers to the locations I was adding. I did some research into the database and after lots of trial and error I have found a way to do so and how to group the locations. In my case I group the locations by state. Below is how the database is setup and an example CSV file to do the above.
Field Name Field Type
-----------------------------------
Longitude -------------- Double
Latitude --------------- Double
POI Name --------------- Char
Address ---------------- Char
City ------------------- Char
State ------------------ Char
Post Code -------------- Char
Country ---------------- Char
Phone ------------------ Char(20)
Category --------------- Char
-Example-
Longitude,Latitude,POI Name,Address,City,State,Post Code,Country,Phone,Category
-92.466786,42.478548,DC0590 Cedar Falls,6601 Hundson Road,Cedar Falls,Iowa,50613,United States,(800) 440-0680,IA
-End Example-
I use Extra POI Editor to add address to the CVS file. Below is how to set it up to use the above fields
Options-->M-Column CSV Fields
Col 1 Longitude
Col 2 Latitude
Col 3 POI Name
Col 4 Address
Col 5 City
Col 6 State
Col 7 Post Code
Col 8 Country
Col 9 Phone
Col 10 Category
When adding a new address enter all the info you need excluding Comments and Description, Phone2, Fax, Email or and Tour Guide Info. I always use both the address and Geocoding. To add an address to a Group, add the group to the Categories and check the box for the group you wise to add the address to.
I hope this all makes since to anyone wanting to use this. If not please feel free to contact me and I will help you out.
Brian