What am I doing wrong (.csv)

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

-=-=-=-=-

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

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

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

Hi a_user,

I’m using TexEdit on a Mac...

Regards,

Tailspin

Nüvi 670 & 880
Mac Pro & OS 10.5.7

Hi tama,

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

Regards,

Tailspin

Nüvi 670 & 880
Mac Pro & OS 10.5.7

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

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"

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.

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

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

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.

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.

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?

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.

That would explain it.