How do I convert my CSV file to various formats?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

How do I convert my CSV file to various formats?

Marianna Bradley

Hi there! I am a total nube at this so bare with me! I want to take lat and long coordinates I have and convert them into four different file formats (.USR, .GPX, .HWR & .UPT). I tried creating a .CSV file in Excel where my headers were Latitude and Longitude with the coordinates in decimal degrees (see example below). I imported this file into GpsBabel specifying the comma separated values Format and selected one of the file formats I mentioned as my output file type. I click OK and is says it translated successfully, but when I open the file in Notepad to take a look at it, I don’t see any of my coordinates. I’m not sure that it is working correctly. I am ultimately trying to create the four different file formats to be posted online, so folks can download the files and then upload them on their GPS units on their boats. Any advice you can give would be much much appreciated!

 

Example of my csv input file

 

latitude

Longitude

28.39362

-89.45263

28.38748

-89.4523

28.39323

-89.44687

28.3954

-89.45498

28.39055

-89.4587

28.39188

-89.45847

 

This is the message I get when I click ok to run….

 

gpsbabel -t -i csv -f C:/Users/mbradley.WLF/Desktop/Mariana AR Work/Website/Input_File.csv -o magellanx -F C:/Users/mbradley.WLF/Desktop/Mariana AR Work/Website/MegellaseXplorist.upt

XCSV attempt to read C:/Users/mbradley.WLF/Desktop/Mariana AR Work/Website/Input_File.csv as a track or route, but this format only supports waypoints on read. Reading as waypoints instead.

 

Translation successful

 

Thanks!

 

Marianna E. Bradley

Biologist 3

LA Dept of Wildlife and Fisheries

Artificial Reef Program

New Orleans ~ (504) 286-4176 Ext. 2070

Baton Rouge ~ (225) 765-5027 Ext. 1783

Fax ~ (504) 284-5263

 

    LDWF Logo no background

 


------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
[hidden email]
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc
Reply | Threaded
Open this post in threaded view
|

Re: How do I convert my CSV file to various formats?

tsteven4-2
Try unicsv (see http://www.gpsbabel.org/htmldoc-development/fmt_unicsv.html)


> ~/work/gc/ref% cat test.csv
> Latitude, Longitude
> 28.39362, -89.45263
> 28.38748, -89.4523
> 28.39323, -89.44687
> 28.3954, -89.45498
> 28.39055, -89.4587
> 28.39188, -89.45847
> ~/work/gc/ref% ./gpsbabel -i unicsv -f test.csv -o gpx -F test.gpx
> ~/work/gc/ref% cat test.gpx
> <?xml version="1.0" encoding="UTF-8"?>
> <gpx version="1.0" creator="GPSBabel - http://www.gpsbabel.org"
> xmlns="http://www.topografix.com/GPX/1/0">
>   <time>2015-05-14T23:46:06.969Z</time>
>   <bounds minlat="28.387480000" minlon="-89.458700000"
> maxlat="28.395400000" maxlon="-89.446870000"/>
>   <wpt lat="28.393620000" lon="-89.452630000">
>     <name>WPT001</name>
>     <cmt>WPT001</cmt>
>     <desc>WPT001</desc>
>   </wpt>
>   <wpt lat="28.387480000" lon="-89.452300000">
>     <name>WPT002</name>
>     <cmt>WPT002</cmt>
>     <desc>WPT002</desc>
>   </wpt>
>   <wpt lat="28.393230000" lon="-89.446870000">
>     <name>WPT003</name>
>     <cmt>WPT003</cmt>
>     <desc>WPT003</desc>
>   </wpt>
>   <wpt lat="28.395400000" lon="-89.454980000">
>     <name>WPT004</name>
>     <cmt>WPT004</cmt>
>     <desc>WPT004</desc>
>   </wpt>
>   <wpt lat="28.390550000" lon="-89.458700000">
>     <name>WPT005</name>
>     <cmt>WPT005</cmt>
>     <desc>WPT005</desc>
>   </wpt>
>   <wpt lat="28.391880000" lon="-89.458470000">
>     <name>WPT006</name>
>     <cmt>WPT006</cmt>
>     <desc>WPT006</desc>
>   </wpt>
> </gpx>



------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
[hidden email]
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc