Can't import 4th column
Fri, 09/28/2012 - 6:40am
13 years
|
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
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.
.
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
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.
.
...
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.