What am I doing wrong (.csv)

 

Hi All,

I’ve crreated a poi .csv file “Amici’s East Coast Pizzeria” (see below), however, I can’t get it to load on either my Nuvi 670 or my Nuvi 880.

Please look at it and tell me if you see any error(s), I need to correct. Although you can’t see it, there are line breaks on every line in this .csv file.

I’m also using the latest version of the PoiLoader for Macintosh.

Thanks for your time.

Regards,

Tailspin

Nüvi 670 & 880
Mac Pro & OS 10.5.7
================================================
-122.03216,37.31837,“Amici‘s Cupertino CA“,"10310 S.De Anza Blvd
Cupertino, CA 95014
408-252-3333"
-121.99013,37.81010,“Amici‘s Danville CA“,"720 Camino Ramon Suite 130
Danville, CA 94526
925-837-9800"
-121.87185,37.71490,“Amici‘s Dublin CA“,"4640 Tassajara Road
Dublin, CA 94568
925-875-1600"
-122.18605,37.45026,“Amici‘s Menlo Park CA“,"880 Santa Cruz Avenue
Menlo Park, CA 94025
650-329-8888"
-122.08311,37.38714,“Amici‘s Mountain View CA“,"790 Castro Street
Mountain View, CA 94041
650-961-6666"
-122.25220,37.51928,“Amici‘s Redwood Shores CA“,"226 Redwood Shores Parkway
Redwood Shores, CA 94065
650-654-3333"
-122.39377,37.77674,“Amici‘s King Street“,"216 King Street
San Francisco, CA 94107
415-546-6666"
-122.43802,37.79980,“Amici‘s Lombard St“,"2200 Lombard Street
San Francisco, CA 94123
415-885-4500"
-122.89444,37.33426,“Amici‘s San Jose CA“,"225 W. Santa Clara Street
San Jose, CA 95113
408-289-9000"
-122.32739,37.56202,“Amici‘s San Mateo CA“,"69 Third Avenue
San Mateo, CA 94401
650-342-9392"
-122.53045,37.97341,“Amici‘s San Rafael CA“,"1242 Fourth Street
San Rafael, CA 94901
415-455-9777"
-122.96430,38.36553,“Amici‘s Vacaville CA“,"1679 E.Monte Vista Avenue
Vacaville, CA 95688
707-451-7777"

--
Sullivan's Law: Murphy was an optimist!

What am I doing wrong (.csv)

What's the error message that you're receiving?

Extra Commas?

tailspin wrote:

Hi All,

I’ve crreated a poi .csv file “Amici’s East Coast Pizzeria” (see below), however, I can’t get it to load on either my Nuvi 670 or my Nuvi 880.

-=-=-=-=-

One thing that I see is that you are using an extra comma on certain lines which makes a fifth field that .csv files are not supposed to have. Leave out those commas before 'CA'.

Gary Hayman

#yragnamyah

--
Garmin DriveSmart 61 LMT-S, Prev.GPSs: Drive61 LM, nuvi 3790LMT, 755T & 650, GPSIII+, SP 2610, 250W; Magellan 2200T; Originator of GARMIN NUVI TRICKS, TIPS, WORKAROUNDS, HINTS, SECRETS & IDEAS http://bit.ly/GARMIN-TNT

You have extra new lines in

You have extra new lines in files.

e.g.

(line 1) -122.03216,37.31837,“Amici‘s Cupertino CA“,"10310 S.De Anza Blvd
(line 2) Cupertino, CA 95014
(line 3) 408-252-3333"

Solution: Join the line 1, 2 and 3 into single line. Make sure that first column in each row is the longitude.

I have found this problem in some of the .csv here. I usually edit those manually before using those.

Hope this helps.

Are you creating this using a text editor?

Are you creating the file using a text editor or a spreadsheet program such as Excel?

There are 2 possible problem areas. The first is Column C or POI Name. Excel imports the file with the quotes around the name due to the apostrophe.

The second is the line break used in column D or the POI Description.

Other than those two things, I see no problems with the file. I would try loading the file into Turbo's Extra POI Editor and then save it as either a Garmin CSV or GPX file for loading.

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

Re: what error message...

kellym8 wrote:

What's the error message that you're receiving?

The message states:
There was an error reading the file/Applications/Garmin/Poi/Amici’s East Coast Pizzeria.csv. Either correct the problem or delete this file and try again.

Regards,

Tailspin

Nüvi 670 & 880
Mac Pro & OS 10.5.7

--
Sullivan's Law: Murphy was an optimist!

Re: Are You Creating This Using A Text Editor?

a_user wrote:

Are you creating the file using a text editor or a spreadsheet program such as Excel?

There are 2 possible problem areas. The first is Column C or POI Name. Excel imports the file with the quotes around the name due to the apostrophe.

The second is the line break used in column D or the POI Description.

Other than those two things, I see no problems with the file. I would try loading the file into Turbo's Extra POI Editor and then save it as either a Garmin CSV or GPX file for loading.

Hi a_user,

I’m using TexEdit on a Mac...

Regards,

Tailspin

Nüvi 670 & 880
Mac Pro & OS 10.5.7

--
Sullivan's Law: Murphy was an optimist!

Re: You Have Extra New Lines In

tama wrote:

You have extra new lines in files.

e.g.

(line 1) -122.03216,37.31837,“Amici‘s Cupertino CA“,"10310 S.De Anza Blvd
(line 2) Cupertino, CA 95014
(line 3) 408-252-3333"

Solution: Join the line 1, 2 and 3 into single line. Make sure that first column in each row is the longitude.

I have found this problem in some of the .csv here. I usually edit those manually before using those.

Hope this helps.

Hi tama,

Did that and it still won’t load???

Regards,

Tailspin

Nüvi 670 & 880
Mac Pro & OS 10.5.7

--
Sullivan's Law: Murphy was an optimist!

Re: Extra Commas?

ghayman wrote:
tailspin wrote:

Hi All,

I’ve crreated a poi .csv file “Amici’s East Coast Pizzeria” (see below), however, I can’t get it to load on either my Nuvi 670 or my Nuvi 880.

-=-=-=-=-

One thing that I see is that you are using an extra comma on certain lines which makes a fifth field that .csv files are not supposed to have. Leave out those commas before 'CA'.

Gary Hayman

#yragnamyah

Hi Gary,

I removed the comma(s) and it still won’t load. This is turning into “the .csv from hell”

Regards,

Tailspin

Nüvi 670 & 880
Mac Pro & OS 10.5.7

--
Sullivan's Law: Murphy was an optimist!

Copy the following into a

Copy the following into a new txt file. Rename it as .csv and try. There were funny double quotes before Amici and after CA. The other double quotes were fine.

Hope this helps.

-122.03216,37.31837,"Amici‘s Cupertino CA","10310 S.De Anza Blvd Cupertino, CA 95014 408-252-3333"
-121.99013,37.81010,"Amici‘s Danville CA","720 Camino Ramon Suite 130 Danville, CA 94526 925-837-9800"
-121.87185,37.71490,"Amici‘s Dublin CA","4640 Tassajara Road Dublin, CA 94568 925-875-1600"
-122.18605,37.45026,"Amici‘s Menlo Park CA","880 Santa Cruz Avenue Menlo Park, CA 94025 650-329-8888"
-122.08311,37.38714,"Amici‘s Mountain View CA","790 Castro Street Mountain View, CA 94041 650-961-6666"
-122.25220,37.51928,"Amici‘s Redwood Shores CA","226 Redwood Shores Parkway Redwood Shores, CA 94065 650-654-3333"
-122.39377,37.77674,"Amici‘s King Street","216 King Street San Francisco, CA 94107 415-546-6666"
-122.43802,37.79980,"Amici‘s Lombard St","2200 Lombard Street San Francisco, CA 94123 415-885-4500"
-122.89444,37.33426,"Amici‘s San Jose CA","225 W. Santa Clara Street San Jose, CA 95113 408-289-9000"
-122.32739,37.56202,"Amici‘s San Mateo CA","69 Third Avenue San Mateo, CA 94401 650-342-9392"
-122.53045,37.97341,"Amici‘s San Rafael CA","1242 Fourth Street San Rafael, CA 94901 415-455-9777"
-122.96430,38.36553,"Amici‘s Vacaville CA","1679 E.Monte Vista Avenue Vacaville, CA 95688 707-451-7777"

Let's review the steps

tailspin wrote:
kellym8 wrote:

What's the error message that you're receiving?

The message states:
There was an error reading the file/Applications/Garmin/Poi/Amici’s East Coast Pizzeria.csv. Either correct the problem or delete this file and try again.

Regards,

Tailspin

Nüvi 670 & 880
Mac Pro & OS 10.5.7

To review a little, POILoader requires the input be a folder and not a file. You are telling POILoader to load the contents of a folder and not the file, correct?

Put all the files to be loaded into a folder - and that includes your Amici's file. Tell POILoader to load everything in the folder and your problem should be solved.

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

Here is the solution

I can't explain how it got there, but when I copied your posted file to NOTEPAD, the folling line appeared at the bottom of the file:

‹ GPS satellite beset by permanent signal problem Which do I trust? (speedometer or GPS) ›

I get your error with the last line, but when it is removed. it loads just fine

-jgracey

--
I have seen the future and it is now!

What am I doing wrong (.csv) solved...

Hi All,

The file wouldn’t load, until I removed the apostrophe (‘), in the poi’s file’s name.

Amici’s.csv wouldn’t load, bit Amicis.csv did load. I was able to use the apostrophe inside the poi file, just not in the poi’s file name.

BTW, does anyone know a workaround or a character substitute, for the apostrophe, that can be used in a poi’s file name?

Thanks all for your help...

Regards,

Tailspin

Nüvi 670 & 880
Mac Pro & OS 10.5.7

--
Sullivan's Law: Murphy was an optimist!

It's a POI Loader Bug?

tailspin wrote:

Hi All,

The file wouldn’t load, until I removed the apostrophe (‘), in the poi’s file’s name.

Amici’s.csv wouldn’t load, bit Amicis.csv did load. I was able to use the apostrophe inside the poi file, just not in the poi’s file name.

Hello Tailspin,

I was able to duplicate your problem with the Windows version of POI Loader.

It's the type of apostrophe in the file name that creates the "there was an error reading the file" error.

A "normal" apostrophe ' (0X22) is OK in the file name, but the left apostrophe ‘ (0X91) or the right apostrophe ’ (0X92) is not.

--
DriveAssist 50 (stolen), Nüvi 2595LMT

It's just the hokey double quotes around the POI name.

Take your original file with the three lines, legal as defined in the POI Loader help, replace the unusual double quotes around the POI name with the standard double quote and the file loads into POI Loader. There is no problem with the single apostrophe, there is no problem with having a 3 line address contained within double quotes as you have, there is no problem with commas nested within the double quotes.

--
Zumo 550 & Zumo 665 My alarm clock is sunshine on chrome.

Yes, name change worked

jgracey wrote:

I can't explain how it got there, but when I copied your posted file to NOTEPAD, the folling line appeared at the bottom of the file:

‹ GPS satellite beset by permanent signal problem Which do I trust? (speedometer or GPS) ›

I get your error with the last line, but when it is removed. it loads just fine

-jgracey

In addition to removing the bogus last line I changed the file name to test.csv

Even with the file name change, the file would not load without removing that bogus last line.

MAC vs. PC incompatibiblty?

--
I have seen the future and it is now!

Re: the bogus last line...

Hi jgracey,

I have no idea where the line “GPS satellite beset by permanent signal problem Which do I trust? (speedometer or GPS)“ came from, in the poi file. That text was never typed into the file, when I created it...???

It’s also not in my OP (original post) to the forum, so I have no idea where that came from...

Regards,

Tailspin

Nüvi 670 & 880
Mac Pro & OS 10.5.7

--
Sullivan's Law: Murphy was an optimist!

RE: Bogus Line

tailspin wrote:

Hi jgracey,

I have no idea where the line “GPS satellite beset by permanent signal problem Which do I trust? (speedometer or GPS)“ came from, in the poi file. That text was never typed into the file, when I created it...???

It’s also not in my OP (original post) to the forum, so I have no idea where that came from...

Regards,

Tailspin

Nüvi 670 & 880
Mac Pro & OS 10.5.7

The text in the bogus last line are the titles from two forum topics. One is here --> http://www.poi-factory.com/node/25746 ...

I suspect the forum somehow picked up the text string while parsing the data and became confused with the incorrect quote characters.

Thanks Bstpm

Quote:

The text in the bogus last line are the titles from two forum topics. One is here --> http://www.poi-factory.com/node/25746 ...

I suspect the forum somehow picked up the text string while parsing the data and became confused with the incorrect quote characters.

That would explain it.

--
I have seen the future and it is now!