Bookmark this page:
- Garmin-Mapsource--EasyGPS--CSV-formats
- 07-13-2008
If you were Registered and logged in, you could reply and use other advanced thread options
ahhh... format conversion gaunlet.
Garmin Mapsource doesn't support handling .CSV files
which are common ways of handling POI's from various websites.
Both Garmin & EasyGPS support the more robust GPX format,
but since neither suports the CSV plain text format,
I guess we need a 3rd program just for the CSV to GPS conversion.
I wish EasyGPS or Mapsource would support simple CSV files.
--
----------------------------------
"If everything seems to be going well,
you have obviously overlooked something." - Steven Wright
> ahhh... format conversion gaunlet.
gpsbabel.org would provide the proper tool.
gpsbabel is already installed if you have Google Earth.
C:Program FilesGoogleGoogle Earthgpsbabel.exe
gpsbabel -i garmin_poi -f Airport_V.csv -o gpx -F Airport_V.gpx
This is the command line that I used from some POIs that I downloaded from
the net. It specifies that the input is a csv file of type garmin_poi, and
the output is a gpx file.
--
Clarence A Dold - Hidden Valley Lake, CA, USA GPS: 38.8,-122.5
>> ahhh... format conversion gaunlet.
> gpsbabel.org would provide the proper tool.
> gpsbabel is already installed if you have Google Earth.
> C:Program FilesGoogleGoogle Earthgpsbabel.exe
> gpsbabel -i garmin_poi -f Airport_V.csv -o gpx -F Airport_V.gpx
> This is the command line that I used from some POIs that I downloaded from
> the net. It specifies that the input is a csv file of type garmin_poi, and
> the output is a gpx file.
> --
tnx - yup it was there....
> gpsbabel is already installed if you have Google Earth.
> C:Program FilesGoogleGoogle Earthgpsbabel.exe
> gpsbabel -i garmin_poi -f Airport_V.csv -o gpx -F Airport_V.gpx
> This is the command line that I used from some POIs that I downloaded from
> the net. It specifies that the input is a csv file of type garmin_poi, and
> the output is a gpx file.
> --
but I went and grabbed the latest version, complete with a Windows GUI,
from their website
http://www.gpsbabel.org/download.html
>> ahhh... format conversion gaunlet.
> gpsbabel.org would provide the proper tool.
> gpsbabel is already installed if you have Google Earth.
> C:Program FilesGoogleGoogle Earthgpsbabel.exe
> gpsbabel -i garmin_poi -f Airport_V.csv -o gpx -F Airport_V.gpx
> This is the command line that I used from some POIs that I downloaded from
> the net. It specifies that the input is a csv file of type garmin_poi, and
> the output is a gpx file.
having a few probs ???
> gpsbabel is already installed if you have Google Earth.
> C:Program FilesGoogleGoogle Earthgpsbabel.exe
> gpsbabel -i garmin_poi -f Airport_V.csv -o gpx -F Airport_V.gpx
> This is the command line that I used from some POIs that I downloaded from
> the net. It specifies that the input is a csv file of type garmin_poi, and
> the output is a gpx file.
here's a couple of lines from the CSV file - which in Notepad appear on
their single lines
without the embedded CR/LF -
-94.59577,39.05689,39th Street Mama's,"3906 Waddell St.
Kansas City, MO 64111
(816) 531-6422"
-69.77449,44.22993,A1 Diner,"3 Bridge St.
Gardiner ME 04345
(207) 582-5586"
-82.53071,27.28828,Alpine Steakhouse,"4520 S. Tamiami Trail
Sarasota, FL 34231
(941) 922-3797"
-93.23572,44.98062,Al's Breakfast,"413 14th Ave. S.E.
Minneapolis MN 55414
(612) 331-9991"
and here's the GPSBABEL execution from the GUI,
with the generated error.....
there is no "641" - so it must be interpreting some of the text as waypoint
coords ?
gpsbabel.exe -p "" -w -i garmin_poi -f "C:Diners.csv" -o gpx -F
"C:diners.gpx"
Invalid latitude 641.183333 in waypoint .
ps56k wrote:
>... having a few probs ???
> here's a couple of lines from the CSV file - which in Notepad appear on
> their single lines
> without the embedded CR/LF -
>
> -94.59577,39.05689,39th Street Mama's,"3906 Waddell St.
> Kansas City, MO 64111
> (816) 531-6422"
> -69.77449,44.22993,A1 Diner,"3 Bridge St.
> Gardiner ME 04345
> (207) 582-5586"
> -82.53071,27.28828,Alpine Steakhouse,"4520 S. Tamiami Trail
> Sarasota, FL 34231
> (941) 922-3797"
> -93.23572,44.98062,Al's Breakfast,"413 14th Ave. S.E.
> Minneapolis MN 55414
> (612) 331-9991"
>
> and here's the GPSBABEL execution from the GUI,
> with the generated error.....
> there is no "641" - so it must be interpreting some of the text as
> waypoint coords ?
>
> gpsbabel.exe -p "" -w -i garmin_poi -f "C:Diners.csv" -o gpx -F
> "C:diners.gpx"
>
> Invalid latitude 641.183333 in waypoint .
> here's a couple of lines from the CSV file - which in Notepad appear on
> their single lines
> without the embedded CR/LF -
>
> -94.59577,39.05689,39th Street Mama's,"3906 Waddell St.
> Kansas City, MO 64111
> (816) 531-6422"
> -69.77449,44.22993,A1 Diner,"3 Bridge St.
> Gardiner ME 04345
> (207) 582-5586"
> -82.53071,27.28828,Alpine Steakhouse,"4520 S. Tamiami Trail
> Sarasota, FL 34231
> (941) 922-3797"
> -93.23572,44.98062,Al's Breakfast,"413 14th Ave. S.E.
> Minneapolis MN 55414
> (612) 331-9991"
>
> and here's the GPSBABEL execution from the GUI,
> with the generated error.....
> there is no "641" - so it must be interpreting some of the text as
> waypoint coords ?
>
> gpsbabel.exe -p "" -w -i garmin_poi -f "C:Diners.csv" -o gpx -F
> "C:diners.gpx"
>
> Invalid latitude 641.183333 in waypoint .
No, there is a 641 in your input -- it is the first 3 digits in the zip code for
Kansas City. I had a similar problem with GPSBabel -- it is very finicky with
the input fields: I had a couple of extra fields that confused it. Just shorten
up your large address fields and try the conversion again.
