GPSbabel convert from gpx file to csv file Can't get all elements of waypoints to be converted

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

GPSbabel convert from gpx file to csv file Can't get all elements of waypoints to be converted

pizzipie
New to mapping and trying to convert my downloaded garman.gpx file to .csv file. Intend to use csv to upload to my mapping database. Using Linux Ubuntu 14.04.

My Code:

gpsbabel -w -i gpx -f "waypts.gpx" -o csv -F "waypts.csv"

Test file contents (3 waypoints) from Garman GPSmap76CSx:

<?xml version="1.0" encoding="UTF-8"?>
<gpx
  version="1.0"
  creator="GPSBabel - http://www.gpsbabel.org"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns="http://www.topografix.com/GPX/1/0"
  xsi:schemaLocation="http://www.topografix.com/GPX/1/0 http://www.topografix.com/GPX/1/0/gpx.xsd">
<time>2015-11-15T19:41:48Z</time>
<bounds minlat="0.000000000" minlon="-122.661683299" maxlat="51.643981934" maxlon="0.000000000"/>
<wpt lat="48.230667952" lon="-116.548649501">
  <ele>630.505615</ele>
  <name>010</name>
  <cmt>15-DEC-13 4:22:27PM</cmt>
  <desc>15-DEC-13 4:22:27PM</desc>
  <sym>Flag, Blue</sym>
</wpt>
<wpt lat="48.230802398" lon="-116.548433835">
  <ele>634.350830</ele>
  <name>011</name>
  <cmt>15-DEC-13 4:33:22PM</cmt>
  <desc>15-DEC-13 4:33:22PM</desc>
  <sym>Flag, Blue</sym>
</wpt>
<wpt lat="48.230802398" lon="-116.548433835">
  <ele>636.994385</ele>
  <name>012</name>
  <cmt>15-DEC-13 4:33:31PM</cmt>
  <desc>15-DEC-13 4:33:31PM</desc>
  <sym>Flag, Blue</sym>
</wpt>
</gpx>

The conversion as the code above produces:

48.23067, -116.54865, 15-DEC-13 4:22:27PM
48.23080, -116.54843, 15-DEC-13 4:33:22PM
48.23080, -116.54843, 15-DEC-13 4:33:31PM

How can I get all the <wpt> elements (7) from the file??

Thanks for your help in advance

R.



------------------------------------------------------------------------------

_______________________________________________
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
|  
Report Content as Inappropriate

Re: GPSbabel convert from gpx file to csv file Can't get all elements of waypoints to be converted

tsteven4-2
% ./gpsbabel -i gpx -f y.gpx -o unicsv -F -
No,Latitude,Longitude,Name,Altitude,Description,Symbol
1,48.230668,-116.548650,"010",630.5,"15-DEC-13 4:22:27PM","Flag, Blue"
2,48.230802,-116.548434,"011",634.4,"15-DEC-13 4:33:22PM","Flag, Blue"
3,48.230802,-116.548434,"012",637.0,"15-DEC-13 4:33:31PM","Flag, Blue"


On 11/22/2015 2:35 PM, rick wrote:
<?xml version="1.0" encoding="UTF-8"?>
<gpx
  version="1.0"
  creator="GPSBabel - http://www.gpsbabel.org"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns="http://www.topografix.com/GPX/1/0"
  xsi:schemaLocation="http://www.topografix.com/GPX/1/0 http://www.topografix.com/GPX/1/0/gpx.xsd">
<time>2015-11-15T19:41:48Z</time>
<bounds minlat="0.000000000" minlon="-122.661683299" maxlat="51.643981934" maxlon="0.000000000"/>
<wpt lat="48.230667952" lon="-116.548649501">
  <ele>630.505615</ele>
  <name>010</name>
  <cmt>15-DEC-13 4:22:27PM</cmt>
  <desc>15-DEC-13 4:22:27PM</desc>
  <sym>Flag, Blue</sym>
</wpt>
<wpt lat="48.230802398" lon="-116.548433835">
  <ele>634.350830</ele>
  <name>011</name>
  <cmt>15-DEC-13 4:33:22PM</cmt>
  <desc>15-DEC-13 4:33:22PM</desc>
  <sym>Flag, Blue</sym>
</wpt>
<wpt lat="48.230802398" lon="-116.548433835">
  <ele>636.994385</ele>
  <name>012</name>
  <cmt>15-DEC-13 4:33:31PM</cmt>
  <desc>15-DEC-13 4:33:31PM</desc>
  <sym>Flag, Blue</sym>
</wpt>
</gpx>


------------------------------------------------------------------------------

_______________________________________________
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
|  
Report Content as Inappropriate

Re: GPSbabel convert from gpx file to csv file Can't get all elements of waypoints to be converted

Robert Lipe-4
You're not the first to fall for that.  I just made the words in our doc even more strong that csv is almost never what you want.

With the benefit of almost 15 years of history in the project, naming it that is probably one of my bigger regrets..

On Sun, Nov 22, 2015 at 4:12 PM, tsteven4 <[hidden email]> wrote:
% ./gpsbabel -i gpx -f y.gpx -o unicsv -F -
No,Latitude,Longitude,Name,Altitude,Description,Symbol
1,48.230668,-116.548650,"010",630.5,"15-DEC-13 4:22:27PM","Flag, Blue"
2,48.230802,-116.548434,"011",634.4,"15-DEC-13 4:33:22PM","Flag, Blue"
3,48.230802,-116.548434,"012",637.0,"15-DEC-13 4:33:31PM","Flag, Blue"



On 11/22/2015 2:35 PM, rick wrote:
<?xml version="1.0" encoding="UTF-8"?>
<gpx
  version="1.0"
  creator="GPSBabel - http://www.gpsbabel.org"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns="http://www.topografix.com/GPX/1/0"
  xsi:schemaLocation="http://www.topografix.com/GPX/1/0 http://www.topografix.com/GPX/1/0/gpx.xsd">
<time>2015-11-15T19:41:48Z</time>
<bounds minlat="0.000000000" minlon="-122.661683299" maxlat="51.643981934" maxlon="0.000000000"/>
<wpt lat="48.230667952" lon="-116.548649501">
  <ele>630.505615</ele>
  <name>010</name>
  <cmt>15-DEC-13 4:22:27PM</cmt>
  <desc>15-DEC-13 4:22:27PM</desc>
  <sym>Flag, Blue</sym>
</wpt>
<wpt lat="48.230802398" lon="-116.548433835">
  <ele>634.350830</ele>
  <name>011</name>
  <cmt>15-DEC-13 4:33:22PM</cmt>
  <desc>15-DEC-13 4:33:22PM</desc>
  <sym>Flag, Blue</sym>
</wpt>
<wpt lat="48.230802398" lon="-116.548433835">
  <ele>636.994385</ele>
  <name>012</name>
  <cmt>15-DEC-13 4:33:31PM</cmt>
  <desc>15-DEC-13 4:33:31PM</desc>
  <sym>Flag, Blue</sym>
</wpt>
</gpx>


------------------------------------------------------------------------------

_______________________________________________
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



------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
_______________________________________________
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
|  
Report Content as Inappropriate

Can't upload edited waypoints to Garmin map76CSx

pizzipie
In reply to this post by tsteven4-2
Thanks for your reply Robert,

 By using unicvs I retrieved all the fields put out by my Garmin GPSmap76CSx so that solved that.
 I am now trying to edit the waypoints in that file and re-load them into the Garmin.

Command:  gpsbabel -D1 -w -i unicsv -f garmin-24Nov15rev1.cvs -o garmin -F usb:

Returns:

GPSBabel Version: 1.4.3
options: module/option=value: unicsv/datum="WGS 84" (=default)
options: module/option=value: unicsv/prec="6" (=default)
unicsv: Cannot open file 'garmin-24Nov15rev1.cvs'!

Don't know whether this has anything to do with the open file error but
I  changed the '/etc/apparmor.d/usr.sbin.mysqld' file by adding::

# added by me 24Nov2015

/home/rick/DB-Web/my-mapping/ r,
/home/rick/DB-Web/my-mapping/* rw,

/tmp/** rwk,

 to that file as I was getting ERROR 13 messages from MySql.

If it's not obvious to you by now I don't have a clue about most of what I'm doing!!

Again thanks for your help.

R

Here's the file info:

no lat lon name elev description sym
1 33.86411 -113.92251 AZ-72 & Av 42E 0 6.8 mi E Bouse AZ Flag, Blue
2 34.473714 -114.344397 AZ-Hav_WalGrn 156.6 Walgreens Drug Flag, Blue
3 34.478543 -114.340469 AZ-Hav-1731 M 0 1731 Mesquite Flag, Blue
4 34.476128 -114.330683 AZ-Hav-BadDog 0 Bad Dogs Bar & Grill Flag, Blue
5 34.497413 -114.345877 AZ-Hav-St V Thr 0 St Vincent Thrift Store Flag, Blue
6 34.571432 -114.366659 AZ-Hav-WalMrt 202.7 Wallmart Flag, Blue
7 34.1368 -114.277217 AZ-Par-DMV 363.7 DMV Flag, Blue
8 34.152202 -114.290173 AZ-Par-Napa 0 Napa Auto Parts Flag, Blue
9 33.726705 -114.061403 AZ-Preach Pass 0 In Desert by Brenda Flag, Blue
10 33.687189 -111.886125 AZ-Sct-Buz&Su 574.7 Buzz & Suzanne 9015 Los Gatos Residence
11 34.861841 -111.78093 AZ-Sed-Elks 0 Sedona-Elks Flag, Blue
12 34.866011 -111.76344 AZ-Sed-Feathr 0 Feather On the Mesa Shopping Center
13 31.552235 -110.304264 AZ-SierVis-Elks 0 Elks Club Flag, Blue
14 35.168967 -114.548317 AZ-Suz&Al Skal 328.4 Suzy & Al Skallet (Punky) Residence
15 31.714268 -110.068331 AZ-Tombstone 0 City center Flag, Blue
16 31.600971 -111.050448 AZ-Tubac 0 City center Flag, Blue
17 33.783184 -113.973591 AZ-Vcksbrg Sign 0 Vicksburg Sign in desert Flag, Blue
18 33.693943 -113.88518 AZ-Wag West 367.1 Wagon West Rv Park Residence
19 33.4342 -112.5581 AZ-Yum-FryUSB 370.2 Frys Mkt & US-Bank Flag, Blue
20 49.974785 -116.908029 BC-Kaslo R & P 0 Rick & Polly 9450 Hwy 31 Residence
21 40.600767 -122.234562 CA-PaloC-Jeff 0 Jeff & Wendy 10820 Deschutes Rd Residence
22 40.534665 -121.730885 CA-Shingl-K&D 1236.9 Kathy & Denny 8708 Manz Crk Dr Residence
23 43.636598 -113.300063 ID-Arco 0 US93-US26 80.4 Mi S Challis Flag, Blue
24 48.23025 -116.389317 ID-Bird Museum 667.8 Bird Museum Flag, Blue
25 48.47082 -116.41613 ID-Dan Mathes 652.4 Dan & Charlene Matheson Residence
26 48.315484 -116.372906 ID-Gary & Mary 623.8 Gary & Mary Daubersmith Residence
27 48.23026 -116.70752 ID-Jim Thomp 720.9 Jim T 6.1 mi W Dover RR OC Residence
28 48.32797 -116.426 ID-Lee Burnett 0 Lee Burnett Residence
29 47.691967 -116.803 ID-N ID Drmtlgy 707.4 Northern ID Dermtology Flag, Blue
30 48.230659 -116.548777 ID-Sagle R & P 683.4 Rick & Polly 511 Hawkins Rd Residence
31 48.28921 -116.56098 ID-SandPt UPS 0 UPS Flag, Blue
32 45.693717 -113.94846 MT- 4 & US 93 0 Lost Trail Pass Flag, Blue
33 46.040355 -114.182476 MT-Darby Tex 1224.8 Tex Marsolek Residence
34 48.02575 -115.83436 MT-Don Ekel 0 Don Ekel Residence
35 46.864303 -114.050228 MT-Mis Kathy G 961.9 Kathy Garramone Residence
36 38.997382 -115.12418 NV-318 & US 6 635.3 23.6mi SW Ely Flag, Blue
37 39.243354 -114.869576 NV-Ely McDonal 1985.7 McDonalds Flag, Blue
38 41.98414 -114.672406 NV-Jackpot 0 Casinos Flag, Blue
39 41.10552 -114.95201 NV-Wells 0 NV-Wells Flag, Blue
40 45.544681 -122.627238 OR-Port R & J 0 Ruth & Jan 3563 NE Morris St Residence
41 48.744405 -117.418148 WA-Ione Clinic 0 Clinic Flag, Blue
42 46.334386 -118.767937 WA-Kahlot J&D 0 Joe & Dee 3410 Murphy Rd Residence
43 47.098181 -119.33436 WA-Mos R&J 0 Rick & Jan 614 S Lupine Residence
44 47.65924 -117.42256 WA-Sp Apl Com 632.2 Apple Computer Store Flag, Blue
45 47.648433 -117.413033 WA-Sp Inlnd Im 0 Inland Imaging Flag, Blue
46 47.673504 -117.287131 WA-Sp St Ward 0 Dermatologist Staci Ward Flag, Blue


------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
_______________________________________________
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
|  
Report Content as Inappropriate

Re: Can't upload edited waypoints to Garmin map76CSx

Gary Turner-6
Is there possibly a typo there? Should it be .csv, not .cvs?

On 26/11/2015 13:13, rick wrote:
Thanks for your reply Robert,

 By using unicvs I retrieved all the fields put out by my Garmin GPSmap76CSx so that solved that.
 I am now trying to edit the waypoints in that file and re-load them into the Garmin.

Command:  gpsbabel -D1 -w -i unicsv -f garmin-24Nov15rev1.cvs -o garmin -F usb:

Returns:

GPSBabel Version: 1.4.3
options: module/option=value: unicsv/datum="WGS 84" (=default)
options: module/option=value: unicsv/prec="6" (=default)
unicsv: Cannot open file 'garmin-24Nov15rev1.cvs'!

Don't know whether this has anything to do with the open file error but
I  changed the '/etc/apparmor.d/usr.sbin.mysqld' file by adding::

# added by me 24Nov2015

/home/rick/DB-Web/my-mapping/ r,
/home/rick/DB-Web/my-mapping/* rw,

/tmp/** rwk,

 to that file as I was getting ERROR 13 messages from MySql.

If it's not obvious to you by now I don't have a clue about most of what I'm doing!!

Again thanks for your help.

R

Here's the file info:

no lat lon name elev description sym
1 33.86411 -113.92251 AZ-72 & Av 42E 0 6.8 mi E Bouse AZ Flag, Blue
2 34.473714 -114.344397 AZ-Hav_WalGrn 156.6 Walgreens Drug Flag, Blue
3 34.478543 -114.340469 AZ-Hav-1731 M 0 1731 Mesquite Flag, Blue
4 34.476128 -114.330683 AZ-Hav-BadDog 0 Bad Dogs Bar & Grill Flag, Blue
5 34.497413 -114.345877 AZ-Hav-St V Thr 0 St Vincent Thrift Store Flag, Blue
6 34.571432 -114.366659 AZ-Hav-WalMrt 202.7 Wallmart Flag, Blue
7 34.1368 -114.277217 AZ-Par-DMV 363.7 DMV Flag, Blue
8 34.152202 -114.290173 AZ-Par-Napa 0 Napa Auto Parts Flag, Blue
9 33.726705 -114.061403 AZ-Preach Pass 0 In Desert by Brenda Flag, Blue
10 33.687189 -111.886125 AZ-Sct-Buz&Su 574.7 Buzz & Suzanne 9015 Los Gatos Residence
11 34.861841 -111.78093 AZ-Sed-Elks 0 Sedona-Elks Flag, Blue
12 34.866011 -111.76344 AZ-Sed-Feathr 0 Feather On the Mesa Shopping Center
13 31.552235 -110.304264 AZ-SierVis-Elks 0 Elks Club Flag, Blue
14 35.168967 -114.548317 AZ-Suz&Al Skal 328.4 Suzy & Al Skallet (Punky) Residence
15 31.714268 -110.068331 AZ-Tombstone 0 City center Flag, Blue
16 31.600971 -111.050448 AZ-Tubac 0 City center Flag, Blue
17 33.783184 -113.973591 AZ-Vcksbrg Sign 0 Vicksburg Sign in desert Flag, Blue
18 33.693943 -113.88518 AZ-Wag West 367.1 Wagon West Rv Park Residence
19 33.4342 -112.5581 AZ-Yum-FryUSB 370.2 Frys Mkt & US-Bank Flag, Blue
20 49.974785 -116.908029 BC-Kaslo R & P 0 Rick & Polly 9450 Hwy 31 Residence
21 40.600767 -122.234562 CA-PaloC-Jeff 0 Jeff & Wendy 10820 Deschutes Rd Residence
22 40.534665 -121.730885 CA-Shingl-K&D 1236.9 Kathy & Denny 8708 Manz Crk Dr Residence
23 43.636598 -113.300063 ID-Arco 0 US93-US26 80.4 Mi S Challis Flag, Blue
24 48.23025 -116.389317 ID-Bird Museum 667.8 Bird Museum Flag, Blue
25 48.47082 -116.41613 ID-Dan Mathes 652.4 Dan & Charlene Matheson Residence
26 48.315484 -116.372906 ID-Gary & Mary 623.8 Gary & Mary Daubersmith Residence
27 48.23026 -116.70752 ID-Jim Thomp 720.9 Jim T 6.1 mi W Dover RR OC Residence
28 48.32797 -116.426 ID-Lee Burnett 0 Lee Burnett Residence
29 47.691967 -116.803 ID-N ID Drmtlgy 707.4 Northern ID Dermtology Flag, Blue
30 48.230659 -116.548777 ID-Sagle R & P 683.4 Rick & Polly 511 Hawkins Rd Residence
31 48.28921 -116.56098 ID-SandPt UPS 0 UPS Flag, Blue
32 45.693717 -113.94846 MT- 4 & US 93 0 Lost Trail Pass Flag, Blue
33 46.040355 -114.182476 MT-Darby Tex 1224.8 Tex Marsolek Residence
34 48.02575 -115.83436 MT-Don Ekel 0 Don Ekel Residence
35 46.864303 -114.050228 MT-Mis Kathy G 961.9 Kathy Garramone Residence
36 38.997382 -115.12418 NV-318 & US 6 635.3 23.6mi SW Ely Flag, Blue
37 39.243354 -114.869576 NV-Ely McDonal 1985.7 McDonalds Flag, Blue
38 41.98414 -114.672406 NV-Jackpot 0 Casinos Flag, Blue
39 41.10552 -114.95201 NV-Wells 0 NV-Wells Flag, Blue
40 45.544681 -122.627238 OR-Port R & J 0 Ruth & Jan 3563 NE Morris St Residence
41 48.744405 -117.418148 WA-Ione Clinic 0 Clinic Flag, Blue
42 46.334386 -118.767937 WA-Kahlot J&D 0 Joe & Dee 3410 Murphy Rd Residence
43 47.098181 -119.33436 WA-Mos R&J 0 Rick & Jan 614 S Lupine Residence
44 47.65924 -117.42256 WA-Sp Apl Com 632.2 Apple Computer Store Flag, Blue
45 47.648433 -117.413033 WA-Sp Inlnd Im 0 Inland Imaging Flag, Blue
46 47.673504 -117.287131 WA-Sp St Ward 0 Dermatologist Staci Ward Flag, Blue



------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140


_______________________________________________
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


------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
_______________________________________________
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
Loading...