I need help


So i went in to make some updates to a POI file that i had made long ago -

and now when i do an update this is what i get (What am i doing wrong???)

I have tried making this in 4 column in excel to CSV and also in Text edit!! i am going nutz Help!!!

record 1: Too many columns;
-111.942039,40.653255,"Cafe Rio TAYLORSVILLE","1856 West 5400 South Taylorsville UT 84110 (801) 327-9050" -111.979767,41.19228,"CAFE RIO OGDEN","4015 South Riverdale Rd Ogden UT 84405 (801) 409-9800" -111.83416,41.758575,"CAFE RIO LOGAN","1460 North Main St Logan UT 84341 (435) 774-8300" -109.551453,40.44936,CAFE RIO VERNAL,"1205 West Hwy 40, Vernal, UT 84078, (435) 781-8100" -111.696289,40.299812,CAFE RIO OREM,"147 North State St., Orem, UT, 84057, (801) 822-5700" -111.938187,40.558712,CAFE RIO SOUTH JORDAN,"1664 West Town Center Dr., South Jordan, UT, 84095, (801) 495-4340" -111.86219,40.582226,CAFE RIO SANDY,"9320 South Village Shop Drive, Sandy, UT, 84094, (801) 316-1000" -113.082123,37.670723,CAFE RIO CEDAR CITY,"1243 South Sage Drive, Cedar City, UT, 84720, (435) 867-3800" -111.892349,40.874863,CAFE RIO BOUNTIFUL,"234 South 500 West, West Bountiful, UT, 84087 (801) 383-6500" -111.811798,40.377186,CAFE RIO AMERICAN FORK,"821 West State Street, American Fork, UT 84003, (801) 756-9088" -111.875801,40.760445,CAFE RIO 4TH SOUTH,"532 East 400 South, Salt Lake City, UT, 84102, (801) 924-3800" -111.539291,40.721893,CAFE RIO PARK CITY,"1456 West Newpark Blvd., Snyderville, UT, 84098, (435) 200-6200" -111.66729,40.263317,CAFE RIO PROVO,"2250 North University Pkwy. A-16, Provo, UT, 84604, (801) 375-5133" -110.839706,40.213211,CAFE RIO DRAPER,"62 East 12300 South, Draper, UT, 84027, (801) 572-3125" -111.807228,40.699993,CAFE RIO 3300 SOUTH,"3025 East 3300 South, Salt Lake City, UT, 84109, (801) 463-7250" -111.892212,41.076069,CAFE RIO LAYTON,"2065 North Harris Blvd., Layton, UT, 84040, (801) 991-1800" -112.024719,40.708126,CAFE RIO HUNTER,"2885 South 5600 West, West Valley City, UT, 84120, (801) 613-4000" -111.851021,40.62476,CAFE RIO FORT UNION,"6985 South Park Centre, Salt lake City, UT, 84121, (801) 562-4431" -113.573303,37.110043,CAFE RIO ST GEORGE,"471 East St. George Blvd., St. George, UT 84770, (435) 656-0200"

Pierre - Garmin nuvi 1490T - MacBook Pro Navigon for iPhone

Are You Missing Line Breaks?

I copied your text.
Pasted it into an ascii text document.
I put in line breaks before each of the poi's (they all start with -111).
Then I saved it.
I renamed the file to "CafeRioTX.csv.
I opened it in Excel to view it. Each POI seemed to be in rows.
I loaded it using POILoader.
They were all on my GPS with the data nicely formatted.

I hope this helped. I suspect it was the line breaks that made the difference.

Intresting find

So I have just realized - that the csv files are working great via POI loader - this problem is only happening when I try to load this csv file to this site as a poi list to share.

Help !! What an I doing wrong???

Pierre - Garmin nuvi 1490T - MacBook Pro Navigon for iPhone

Mac vs Windows

I think the problem lies in a key difference between Mac and Windows and how the two OS's record "end of line" in text files. One uses Line Feed character at the end of line, the other uses Carriage Return character at the end of the line. Same thing happens with Windows vs Unix/Linux. You should be able to adjust that in your text editor preferences or when you do a "save as".

What's happening is that it is not recognizing your end of line character that's been saved in your file, and it sees the file as one very long SINGLE line instead of one line per POI.

Thank you!!

First of all johnC thank you you got me going in the right direction

then i realized that using a MAC made it a little different

Create Files using Text Edit
Use format -111.111111,33.333333,"XYZ","address
City, St. Zip
(123) 555-1234"
Leave a blank space between each line
save using Plan text encoding Non-lossy ASCII
save using extension .csv

i.e Example -

-117.689055,33.641619,"Cafe Rio Lake Forest","24321 Rockfield Blvd
Lake Forest, CA 92630
(949) 334-9292"

-118.380876,33.901667,"Cafe Rio Manhattan Beach","1800 Rosecrans Ave Suite G Manhattan Beach, CA 90266
(424) 456-3800"

Pierre - Garmin nuvi 1490T - MacBook Pro Navigon for iPhone