Tomtom (converting to OV2)

Can you be more specific? I've downloaded plenty of .csv's and converted them to ov2 format for my TT One without any problems at all.

ML

To be specific i downloded cracker BarrelUS. csv and tried to convert it with poiedit 2007 and received "'Cracker Barrel' is not a valid floating point value'" I click again and get "3 to 3 values expected on line 1" When i use the online tools it converts the file but without the Longitude and latitude. This happens with quite a few files. I am also trying to convert a few .xls files to ov2 with limited success. I first save them as a txt file then copy and paste into batchgeocode.com then it gives me a csv file. I then try and convert the csv file to ov2 with limited success. If you have any tips or hints please let me know.
Ray

'Cracker Barrel US.csv' is the correct format. Check it with POI Verifier.

I used a quick csv to os2 conversion tool. It converted ok; but I don't know if it's in the correct TomTom format as I don't have a TomTom GPS to check it with.

RT

I found that when I opened the file in Excel the cells in 'Row 4' contained info that was not immediately displayed until a given 'cell' was highlighted in that column (i.e., the address, city, zip and phone #). Once the info was displayed it appeared on 3 separate lines; to remedy this I removed the CR's and was able to get all the info to display on one line. I also deleted 'Row #3' (Cracker Barrel) as ov2 files only use 3 rows of info: description, latitude and longitude.

Once I did all of this I was able to convert the file from .csv to ov2 without any other problems! I would recommend that you check your .xls files for CR's as well.

Hope this helps!

ML

Thanks Mike. I deleted the CR with the excel clean() function. Everything works great now, it imported and converted without a problem. Do you know of a better way to get the longitude and Latitude from a xls file? I tried www.batchgeocode.com with hit and miss results.

Thanks for your help

<>

Try either/both of these sites for your geocoding needs:

http://stevemorse.org/jcal/latlon.php and/or www.gpsvisualizer.com/geocoder/

Hope this helps!

ML

I am still having problems converting some csv files to Ov2 files I keep getting errors, mostly files that I converted from .xls. I am wondering if it may be how Excel converts the .xls file to csv. Does anyone know that to be true and if so is there a third party app that is better?

Ray

I heard poiedit is kinda limited. Is this true? I just got a TomTom One and haven't tried putting any new POIs on it yet.