TND 710 CVS File Format

 

Hey all, Ive been playing with the data base file for Custom Poi's on my GPS. I found it to be a SQLite Data Base. So Googling it I found the program to read whats in side it. I found the format for the cvs file.

Lat. = integer
Lon. = Integer
Side = Integer Unknown I entered 0
POIID = integer Unknown I entered 0
Name = Char Unknown Length
Category = Integer Unknown I entered 0
Phone = Char(20)
Street = Char(40)
City = Char(40)
State = Char(40)
Country = Char(40)
Zip = Char(10)

For those that don't know,
Integer is a number.
Char is a (letter, space, dot).
The number following CHAR is the number of Characters allowed, if the city name is more then 40 characters it will be cut off at 40. The zip only allows 10.

Im finding that the cvs file is nothing more then a comma delimited file. I still have more to do with writing and loading cvs files into it. I do know that you can't load icons or sounds in it. This is the 710 I bought over 2 years ago. The newer ones might be different.
The sample cvs file they have for low ground clearence. Is a wrong format for the 710 Truck GPS. The street name is in the phone number column.
As I work with these files, I'm also looking at a way to correct them via a program I'm writing. Will get back to you all at a later date for an update. Hope this helps.
K100E, OTR Truck driver/ Hobbiest Programmer VB Language.

--
Choices You Make Dictate Your Life.

Another SQLite Explorer

K100E

May want to take a look at some work Sandpiper270 did a while back: http://www.poi-factory.com/node/38432 when he explored the database.

Not sure but there might be something of use.

Great

I would like to work with you off line if you want. I am also trying to bring a common thought to how to build the POI so the TND/RVND will pass it.

thanks,
Mark

gpstesternc@gmail.com