Tomtom (converting to OV2)

 

Is there anyone else out there that is having trouble converting the .csv files to ov2 (Tomtom files)? I am using both the online conversion tools and poiedit and I still receive errors.I am willing to share ov2 files if anyone is interested.

--
Ray- **Garmin Nuvi760**

Need more info

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

--
Freedom isn't free...thank you veterans! Heard about the tests to detect PANCREATIC CANCER? There aren't any! In Memoriam: #77 NYPD-SCA/Seattle Mike/Joe S./Vinny D./RTC...and God bless Donald Trump!

tom tom

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

--
Ray- **Garmin Nuvi760**

Csv is in the correct format

raymazanek wrote:

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

--
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."

I had a problem too Ray

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

--
Freedom isn't free...thank you veterans! Heard about the tests to detect PANCREATIC CANCER? There aren't any! In Memoriam: #77 NYPD-SCA/Seattle Mike/Joe S./Vinny D./RTC...and God bless Donald Trump!

Great tip!

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

<>

--
Ray- **Garmin Nuvi760**

Here's a 2'fer

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

--
Freedom isn't free...thank you veterans! Heard about the tests to detect PANCREATIC CANCER? There aren't any! In Memoriam: #77 NYPD-SCA/Seattle Mike/Joe S./Vinny D./RTC...and God bless Donald Trump!

converting .xls to csv

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

--
Ray- **Garmin Nuvi760**

I heard poiedit is kinda

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.