ExpeditionExpedition Navigation Software

You are not logged in. Would you like to login or register?



4/29/2024 6:10 am  #1


Export marks to csv

Hi,
I want to export marks to a csv-file.
Here is an example:

the export csv-file looks like this:

,P,S,Start P KiWo,Start S KiWo,Ziel Kiel LT
P,,103°0.21,185°10.77,184°10.74,108°3.09
S,283°0.21,,186°10.74,185°10.71,109°2.88
Start P KiWo,005°10.77,006°10.74,,087°0.26,022°10.50
Start S KiWo,004°10.74,005°10.71,267°0.26,,020°10.40
Ziel Kiel LT,288°3.09,289°2.88,202°10.50,200°10.40,


I was expecting the format mark name, latitude, longitude, mark group name, range circle, comment, as it is describe in the help file. The numbers have changed. E.g. mark P has the coordinates 54°30,970n and 010°11,184e.

Is it a bug or just user's incompetence? ;-)

 

5/01/2024 12:35 am  #2


Re: Export marks to csv

You can always fall back on the freeware called GPSBABEL. I use this to convert .GPX files to .USR format for pushing waypoints into B&G MFD. Here is a sample from GPSBABEL--LAT, LON, NAME: 

24.69853, -81.12273, MOSERCHATBOOT
24.67987, -81.15910, MOS01
24.68398, -81.16796, MOS02
24.69006, -81.16943, MOS03
24.69388, -81.16754, MOS04
24.69974, -81.17008, MOS05
24.70563, -81.17219, MOS06
24.72235, -81.17447, MOS07
24.73401, -81.17512, MOS08
24.75650, -81.17527, MOS09
24.76126, -81.16981, MOS10
24.79209, -81.16520, MOS11

 

5/01/2024 10:33 pm  #3


Re: Export marks to csv

Bjoern wrote:

Hi,
I want to export marks to a csv-file.
Here is an example:

the export csv-file looks like this:

,P,S,Start P KiWo,Start S KiWo,Ziel Kiel LT
P,,103°0.21,185°10.77,184°10.74,108°3.09
S,283°0.21,,186°10.74,185°10.71,109°2.88
Start P KiWo,005°10.77,006°10.74,,087°0.26,022°10.50
Start S KiWo,004°10.74,005°10.71,267°0.26,,020°10.40
Ziel Kiel LT,288°3.09,289°2.88,202°10.50,200°10.40,


I was expecting the format mark name, latitude, longitude, mark group name, range circle, comment, as it is describe in the help file. The numbers have changed. E.g. mark P has the coordinates 54°30,970n and 010°11,184e.

Is it a bug or just user's incompetence? ;-)

The .csv table from within Edit Marks in  is supposed to give a table of ranges and bearings between all the marks in a specific folder - it does appear that this is broken...am sure Nick will address it. EDIT: MY MISTAKE - IT WORKS AS EXPECTED.

In your example:
,P,S,Start P KiWo,Start S KiWo,Ziel Kiel LT
P,,103°0.21,185°10.77,184°10.74,108°3.09

The bearing/range between mark P and mark Ziel Kiel LT is 108deg, 3.09nm

Export .csv from the Marks Ribbon/Exchange panel does work, giving a list of marks with name,lat,lon,group,rangecircle,comment
 

Last edited by Campbell_Field (5/01/2024 10:43 pm)


:::Campbell Field::::::www.fieldyachting.com:::
 

5/01/2024 10:38 pm  #4


Re: Export marks to csv

Where are you exporting from? It seems ok here.

 

5/01/2024 10:40 pm  #5


Re: Export marks to csv

Nick wrote:

Where are you exporting from? It seems ok here.

I stand corrected - it works fine - my mistake - corrected above

Last edited by Campbell_Field (5/01/2024 10:46 pm)


:::Campbell Field::::::www.fieldyachting.com:::
 

Board footera

 

Powered by Boardhost. Create a Free Forum




Check out RaceData for iOS and Android. Expedition data in the palm of your hand, or on your wrist! RaceData

Interested in advertising here? Over one thousand active navigators and Expedition users visit this forum. Click here to contact the administrator.