Cruisers Forum
 


Join CruisersForum Today

Reply
 
Thread Tools Rate Thread Display Modes
Old 28-01-2013, 14:36   #1
Registered User

Join Date: Apr 2012
Posts: 332
Export Track as csv file?

I used OpenCPN to create a Track of a route I was on.

The track can be viewed perfectly both on the screen and reviewing the Track Properties which shows the distance, Long, Lat. etc.

How can the Track be exported as a CSV (or text file for that matter)?

I noticed that gpsbabel does a good job of providing the long, lat. info but I can't figure out how to get more detailed information into a csv format.
__________________

__________________
PDA1 is offline   Reply With Quote
Old 28-01-2013, 15:36   #2
Registered User
 
jstevens's Avatar

Join Date: May 2006
Location: On board Sarah, currently lying in Jacksonville, FL
Boat: Pearson, 424, 42', Sarah
Posts: 582
Images: 4
Re: Export Track as csv file?

PDA1,
AFIK OpenCPN only exports to GPX files. I wrote an MS Excel VBA program to do a number of route, track and waypoint file conversion. It will convert GPX file containing tracks to a CSV file. It is available for download at: GPXconverterVBA, however I haven't updated that web page with the latest version. If you are interested in trying the latest version send me a PM and let me know which version of Excel you are running and I'll send you copy.
__________________

__________________
jstevens is offline   Reply With Quote
Old 28-01-2013, 15:57   #3
Registered User

Join Date: Apr 2012
Posts: 332
Re: Export Track as csv file?

Thank you for the offer but I can only use Libreoffice files or Open Document formatted files.


Thank you.
__________________
PDA1 is offline   Reply With Quote
Old 28-01-2013, 20:34   #4
Registered User

Join Date: Feb 2010
Location: On the go. Not in Prague.
Posts: 4,016
Re: Export Track as csv file?

PDA1...
gpsbabel is able to convert GPX into CSV, apart from other zillion formats - Comma separated values (csv)

Pavel
__________________
nohal is offline   Reply With Quote
Old 29-01-2013, 07:55   #5
Registered User

Join Date: Apr 2012
Posts: 332
Re: Export Track as csv file?

Already tried gpsbabel.

It's nice but doesn't provide all of the information that is found in Track Properties such as Distance, Bearing.


GPS Visualizer provides a (only) slightly better service but you have to be online to use it.
__________________
PDA1 is offline   Reply With Quote
Old 29-01-2013, 08:32   #6
Registered User

Join Date: Feb 2010
Location: On the go. Not in Prague.
Posts: 4,016
PDA...

This info is not part of the GPX file at all, that's why actually no file conversion tool will give you satisfactory results without further processing.
Can't you use the "copy all as text" feature available in the route properties waypoint list context menu?
Pavel
__________________
nohal is offline   Reply With Quote
Old 29-01-2013, 08:51   #7
Registered User

Join Date: Apr 2012
Posts: 332
Re: Export Track as csv file?

No success in finding the "copy all as text" feature available in the route properties waypoint list context menu.

What I'm trying to get a text copy of the the Route Manager----->Tracks.

What I want is the text of Route Manager----->Tracks----->Track Properites with the specific Track that was created.

I'm running- Version 3.0.2 Build 2012-07-07 on Ubuntu 12.04
__________________
PDA1 is offline   Reply With Quote
Old 29-01-2013, 08:59   #8
Registered User

Join Date: Feb 2010
Location: On the go. Not in Prague.
Posts: 4,016
Time to try the 3.2 release candidate available since yesterday
__________________
nohal is offline   Reply With Quote
Old 29-01-2013, 09:35   #9
Registered User

Join Date: Apr 2012
Posts: 332
Re: Export Track as csv file?

Finally!!!!

The upgrade worked.

Thank you.
__________________

__________________
PDA1 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -7. The time now is 14:20.


Google+
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Social Knowledge Networks
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.

ShowCase vBulletin Plugins by Drive Thru Online, Inc.