Expedition Expedition 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


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