Can't import 4th column

 

Try as I might, I can't get imformation to import into Mapsourse with the 4th column.

Mind you, I am new at this, so I generally don't exactly know what I am doing it seems.

I take my .csv with information like this: -73.9873 40.72234 Katz's Deli "Phone: 555-1234"
and using various programs to convert it to a .gpx file, all that gets imported are 3 of the 4 columns.

Could someone help with this?

Thanks,
jerry

Welcome aboard

dancnman wrote:

Try as I might, I can't get imformation to import into Mapsourse with the 4th column.

Mind you, I am new at this, so I generally don't exactly know what I am doing it seems.

I take my .csv with information like this: -73.9873 40.72234 Katz's Deli "Phone: 555-1234"
and using various programs to convert it to a .gpx file, all that gets imported are 3 of the 4 columns.

Could someone help with this?

Thanks,
jerry

Jerry, There are several ways to create .csv files and we will explore one of them, after I ask you to do something to make sure your PC settings are correct for this POI work.

When you click on the link below, you will hold down the CNTL key while left-clicking on the link. This will open a new tab in your browser, leaving this tab open. When you finish with the instructions about settings, come back here (if you don’t have manuals, you can go back to that tab and get them later)

http://www.poi-factory.com/node/30393

You may have already had the correct settings but what we wanted to make sure of was that we did not generate double extensions.

Open Notepad.

Now key in the data (or copy and paste the next line

-73.9873,40.72234,Katz's Deli,"Phone: 555-1234"

In the Menu, do File > Save

In the dialog box, navigate to where you would like to put the file.

In the File Name box, type in “Katzs.csv” (include the quotes) and click Save

If you do not already have a copy of EPE (Extra POI Editor), then get one by holding down the CNTL key and left clicking on the link below.

http://turboccc.wikispaces.com/Extra_POI_Editor#toc5

Download the .zip file and unzip it somewhere. Then run Extra_POI_Editor.exe from that folder.

Open your Katzs.csv file and you can save it as a .gpx file.

Note that EPE assumes that the fields are lon, lat, name, address. So it is going to assume that your fourth column is an address even though we know it is only the phone number.

If you double-click on Katz's Deli in the purple area, it will open a dialog showing all of the things EPE can accept

When you later do a File > Save, you will have a .gpx file

Open that file with Notepad and you see that the Phone is in the Streetaddress line.

You could go back into EPE and play around and get the phone in the proper field and add the Houston street address.

Let us know how you fare.

.

dancnman wrote:

Try as I might, I can't get imformation to import into Mapsourse with the 4th column.

Welcome to the POI Factory Jerry!

MapSource understands GPX files, but not CSV formats. The phone number must be stored in a Garmin GPX extension field.

If you use the EPE program as jgermann suggested, it will create GPX files with phone numbers that can be used with MapSource.

--
Nüvi 2595LMT

Use Excel and EPE

dancnman wrote:

Try as I might, I can't get imformation to import into Mapsourse with the 4th column.

Mind you, I am new at this, so I generally don't exactly know what I am doing it seems.

I take my .csv with information like this: -73.9873 40.72234 Katz's Deli "Phone: 555-1234"
and using various programs to convert it to a .gpx file, all that gets imported are 3 of the 4 columns.

Could someone help with this?

Thanks,
jerry

See http://www.poi-factory.com/node/25743 .

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

.

WAASup wrote:

...
MapSource understands GPX files, but not CSV formats. The phone number must be stored in a Garmin GPX extension field.
...

Thanks for that addition. I rarely use Mapsource so could only hope that someone like you would make my instructions more complete.