new & interesting places for your GPS

Cracker Barrel IL CSV problem

 

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.

AlfieG..

--
Hawkslayer http://www,fuchsialand.co.uk

I don't know about the final fix

But just put the address into your favorites for tomorrow !

--
MrKenFL- "Money can't buy you happiness .. But it does bring you a more pleasant form of misery." NUVI 260, Nuvi 1490LMT & Nuvi 2595LMT all with 2014.4 maps !

Try doing this

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.

Bon appetit!

Mike

--
Freedom isn't free...thank you veterans! Heard about the tests to detect PANCREATIC CANCER? There aren't any! R.I.P. NYPD-77/Seattle Mike/Joe S.

I added the address, thanks

I added the address, thanks for the suggestion. Why didn't I think of that? smile

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?

Thanks guys.

AlfieG..

--
Hawkslayer http://www,fuchsialand.co.uk

Alternative to Excel

alfieg wrote:

I added the address, thanks for the suggestion. Why didn't I think of that? smile

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?

Thanks guys.

AlfieG..

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

--
ɐ‾nsǝɹ Just one click away from the end of the Internet

fixing other csv problem's you'll likely encounter

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 ....

dhschneider wrote:

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)

RT

--
---------------"Internet: Don't believe half of what you read, and verify the other half."---------

Do I need to fix the file?

Was there a problem with the file or was this a user/understanding problem?

--
Garmin Nüvi 650, 255WT

File is ok

DRMCMTR wrote:

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.)

RT

--
---------------"Internet: Don't believe half of what you read, and verify the other half."---------

sponsored links