Data Errors in CSV Files for Garmin - POI Loader Chokes

Sun, 01/03/2016 - 10:13pm

gardibolt

16 years

Hey all. I've been gone for a long while but I got a new Nuvi and was trying to put some POIs on it. I've got some CSV files I obtained from a website, and the POI Loader doesn't like something about them; it says there are data errors on say line 57 and it won't go past that. I've fixed the obvious things I can see but I'm still getting the errors.

I used to use POI Verifier for these kinds of problems but that seems to be defunct. Is there any tool that does the same sort of thing? Failing that, is there some guide to exactly what format the data needs to be in for a Garmin to be able to deal with it? I poked around in the Learn section but didn't see anything (at least anything recent) that seemed to point me in the right direction.

Thanks.

Here's one of the offending lines:

Quote:

39.037915,-95.676341,Brown v Board of Education NHS,Unit,Brown v Board of Education NHS - Visitor Center,KS,"1515 SE Monroe Street, Topeka, KS 66612",(785) 354-4273,,open from 9:00 a.m. to 5:00 p.m. daily,

Mon, 01/04/2016 - 1:34am

plunder

16 years

For one thing...

For one thing, you've got the latitude and longitude fields backwards. The line should begin

-95.676341,39.037915,...

and then you have way too many commas (fields) in the line. The format for a simple Garmin .csv file is

long,lat,name,comments (three or, more likely, four fields). If there are imbedded commas in either of the last two fields, you have to enclose the field in quotes.

So in your example, if you want all of that information in the record, make it look like this:

-95.676341,39.037915,"Brown v Board of Education","1515 SE Monroe Street, Topeka, KS 66612NHS,Unit,Brown v Board of Education NHS - Visitor Center,KS,,(785) 354-4273,,open from 9:00 a.m. to 5:00 p.m. daily"

Phil

--
"No misfortune is so bad that whining about it won't make it worse."

Mon, 01/04/2016 - 7:45am

ralphy1

16 years

POI

Plunder is right, except in this case as, Brown v Board of Education, contains no commas, the first set of Quotation marks is unnecessary.

Mon, 01/04/2016 - 10:59am

Box Car

13 years

Where it chokes is

gardibolt wrote:

Here's one of the offending lines:

Quote:

Given the quoted line there should be quote marks before the word Unit and after KS,. The order of the coordinates doesn't matter as POI Loader has since somewhere around version 2.73 accepted them either LON/LAT and LAT/LON.

--
Illiterate? Write for free help.

Mon, 01/04/2016 - 3:27pm