Convert .csv to mgln

 

When I try to convert the file, I get an error that says Latitude and Longitude are required fields. I can see the Lat / Long data, but not sure why the program doesn't see it.

Comma as Separator

Make sure in the Import Wizard window comma is selected as the separator. In the next window the first column is "longitude", the second is "latitude", the third is "name" and the forth is "description" (at least for POI files downloaded from the POI Factory).

Tried the comma

As I was trying to work thru this, I selected "comma" as the separator. Actually, I tried all the options and got the same result.

.csv file

Joe F wrote:

As I was trying to work thru this, I selected "comma" as the separator. Actually, I tried all the options and got the same result.

Do you mind sending me the file you have trouble with so I can try it?

.CSV

hercegovac wrote:
Joe F wrote:

As I was trying to work thru this, I selected "comma" as the separator. Actually, I tried all the options and got the same result.

Do you mind sending me the file you have trouble with so I can try it?

I can do better than that!! They're here on POI Factory. I first tried the Walmart file and then the Red-light file.

POI File Editor

I'm using POI File Editor ver. 4.1.1.0 and I don't have any problems with either of these two files. To find out what version you've been using go Help/About POI File Editor.

Because of the comma use in the description (address) column of the Walmart file, we get more than 4 columns to pick up from. We can fix this problem by eliminating all commas from the original .csv file, but it would not help us so much. Magellan POI File Editor doesn't allow more than ~30 characters in description column. Getting all those information (address, phone number etc.) shown in one column doesn't mean anything for us. They wouldn't show anyway.

Designate the columns

Joe F wrote:

As I was trying to work thru this, I selected "comma" as the separator. Actually, I tried all the options and got the same result.

I think I figured out what you missed. After you select "comma" as the separator, in the next window you need to designate the columns. On the top of every column there is a drop-down menu where you need to select "longitude" for the first column, "latitude" for the second, "name" for the third and "description" as the fourth. Unlike Garmin's POI Loader where the .csv file has to be with the columns set in order: 1. longitude 2. latitude 3. name 4. description, by Magellan's POI File Editor that's not the case but you have to designate the columns by yourself.

I hope this helps.

Thanks

I'll give it a try. By the way, I have POI Editor 4.0.2.0

name field

Also be sure the name column is unique for each coordinate. If they are all the same, then when you first import the CSV it will show each location, but save only one.

Thanks

Looks like I got it. Thanks for all the help!!!