POI Loader Error - Need help

 

Hi,

I am trying to create a POI of all the Redbox DVD Locations. I have the data and created the records in a csv file. However, I get the following error when I try to load it using POI loader:


"There is a data format error on line 1 of file C:\Redbox DVD Rental.csv. The data earlier in this file will be written, but no more data can be read from this file.

Here is a quick list of the 5 first records:

Quote:

-124.240923,43.391462,"Supervalu - Albertsons","2121 Newmark Street NORTH BEND OR 97459"
-124.239239,43.39156,"McDonalds","3303 Broadway Av North Bend OR 97459"
-124.161028,47.007365,IGA ,101 E Chance A La Mer Ocean Shores WA 98569
-124.110802,43.699224,McDonalds ,310 N 14th St Reedsport OR 97467
-124.101113,43.984647,McDonalds ,2060 Hwy 101 Florence OR 97439

I'd like to figure this out before I post the .csv Anyone can help please?

.

I pasted those 5 lines into Notepad and saved it as a CSV and it loaded fine.

PC or Mac?

Are you on a Mac by any chance. THe Mac version of POI loader acts differently from the PC version in some cases. I have gotten that same message with the Mac Version in the past.

--
Nuvi 650 (SW 4.30; GPS SW 3.00) , GPSmap 60CSx (SW 3.50; GPS SW 3.00), GPS III Plus

POI Loader Error - Need help

If you're using a Garmin, the POI Verifier application will find and automatically correct errors in .csv files. Use this link for info...

http://poiverifier.com/

ejodoin wrote: Hi, I am

ejodoin wrote:

Hi,

I am trying to create a POI of all the Redbox DVD Locations. I have the data and created the records in a csv file. However, I get the following error when I try to load it using POI loader:


"There is a data format error on line 1 of file C:\Redbox DVD Rental.csv. The data earlier in this file will be written, but no more data can be read from this file.

Here is a quick list of the 5 first records:

Quote:

-124.240923,43.391462,"Supervalu - Albertsons","2121 Newmark Street NORTH BEND OR 97459"
-124.239239,43.39156,"McDonalds","3303 Broadway Av North Bend OR 97459"
-124.161028,47.007365,IGA ,101 E Chance A La Mer Ocean Shores WA 98569
-124.110802,43.699224,McDonalds ,310 N 14th St Reedsport OR 97467
-124.101113,43.984647,McDonalds ,2060 Hwy 101 Florence OR 97439

I'd like to figure this out before I post the .csv Anyone can help please?

ejodoin,
The file that you have submitted as the Red Box file is not the red box file, please try again;)

Miss POI

oops

Miss POI,

Sorry about the mix up, I keep all my POI in the same folder and I must have picked the wrong one. I sent you the correct file in the reply I sent you on email...

How are you able to save

How are you able to save from notepad into csv format? I must be doing something wrong.

It is easy

When you are ready to save, click "file save as" and change the extension to .csv

--
Glenn - Southern MD; SP C330 / Nuvi 750 / Nuvi 265WT

That is not an option. When

That is not an option. When I 'save as' from notepad, the only options are save as 'text file', or 'any file'.

.

Just select text file and TYPE IN the CSV part.

POI Loader Error - Need help

ejodoin wrote:

Hi,

I am trying to create a POI of all the Redbox DVD Locations. I have the data and created the records in a csv file. However, I get the following error when I try to load it using POI loader:


"There is a data format error on line 1 of file C:\Redbox DVD Rental.csv. The data earlier in this file will be written, but no more data can be read from this file.

Here is a quick list of the 5 first records:

Quote:

-124.240923,43.391462,"Supervalu - Albertsons","2121 Newmark Street NORTH BEND OR 97459"
-124.239239,43.39156,"McDonalds","3303 Broadway Av North Bend OR 97459"
-124.161028,47.007365,IGA ,101 E Chance A La Mer Ocean Shores WA 98569
-124.110802,43.699224,McDonalds ,310 N 14th St Reedsport OR 97467
-124.101113,43.984647,McDonalds ,2060 Hwy 101 Florence OR 97439

I'd like to figure this out before I post the .csv Anyone can help please?

Your latitude/longitude points are transposed
try these:

43.391462,-124.240923,"Supervalu - Albertsons","2121 Newmark Street NORTH BEND OR 97459"
47.007365,-124.161028,"McDonalds","3303 Broadway Av North Bend OR 97459"
43.39156,-124.239239,IGA ,101 E Chance A La Mer Ocean Shores WA 98569
43.699224,124.110802,McDonalds ,310 N 14th St Reedsport OR 97467
43.984647,-124.101113,McDonalds ,2060 Hwy 101 Florence OR 97439

--
Nuvi 260 Nuvi 295W

According to the profile

According to the profile ejodoin has a Garmin NUVI 660.The longitude is first then latitude.

--
Charlie. Nuvi 265 WT and Nuvi 2597 LMT. MapFactor Navigator - Offline Maps & GPS.