I've tried to convert the "cracker barrel IL.csv" to ov2 and keep getting this error message: "3 to 4 values expected on line one" I did a search on the forum and see someone else had the same problem. Anyone have any ideas? Thanks. I'd like to get it soonest, I'm going to meet someone in a Cracker Barrel tomorrow.
But just put the address into your favorites for tomorrow !
When you open the Cracker Barrel, IL .csv file in Excel delete column C (Cracker Barrel) and save the new file. Convert the new file to .ov2 format using whatever program/utility you've been using.
Remember, .ov2 files (TomTom) use only 3 columns of info - Lat/Long/Data, .csv files (Garmin) use 4 columns - Long/Lat/Data/Data.
I added the address, thanks for the suggestion. Why didn't I think of that?
Mike L - I don't have Excel installed, though I do have the rest of Microsoft Office installed. Guess I'd better get it in if I'm going to be converting more csv's, hadn't I?
Another option is to use Open Office which is a free download and has an alternative to the Microsoft Office programs - including Excel. Try openoffice.org
If you have problems with spaces before or after the lat or long, or remove extra line breaks (which some of the files have on this web site) you can use the free ASAP utilities program (www.asap-utilities.com)
If you have problems with spaces before or after the lat or long, or remove extra line breaks .....
POI Verifier II not only removes the leading and trailing spaces from the coordinate fields, it has an option to configure the file for "POI Edit's" conversion to OV2, including taking care of problems associated with linebreaks (both standard and nuvi) and 4-field POIs. (http://PoiVerifier.com)
Was there a problem with the file or was this a user/understanding problem?
Nothing wrong with the file. The csv files have some limitations in order to convert them to OV2. This includes 'no linebreaks' and 'only three fields'.
'POI Verifier' now reconfigures and converts most all Garmin formatted csv POIs to TomTom's OV2 format.(Many thanks to 'Rick2' for his help in making this option possible.)
terms | privacy | contactCopyright © 2006-2020