Expedition Navigation Software » Format for race note import

SWE204 · 11/11/2016 11:55 am

Hi,
I am struggling to import a race note that is a long list of lat and lon.
The expedition Help does not give any details about the format to use for lat and lon.
Could you provide these details and possibly attach an example of a .CSV race note that is valid for the import feature?
BR
Anders

Nick · 11/11/2016 5:33 pm

See the help - Expedition Interface, Sail panel

ZeeZee · 11/11/2016 9:47 pm

I see your problem Anders. I created the following test CSV file which I tried to import but I get the error message "unable to import exclusion zones". This is when I try to import it via the Sail-Race notes-Import button.

TestRaceNote1
52.7929783,5.3115183
52.7931817,5.3114517
53.7931817,5.3114517
TestRaceNote2
53.7929783,6.3115183
53.7931817,6.3114517
54.7931817,6.3114517

My Windows decimal separator is by default set to "," (comma). So switched it to a decimal point and tried importing again but I get the same error message.
The format for Lon and Lat in my test file I have derived from the Exp log files on my PC.

Any clue what's wrong Nick?

Last edited by ZeeZee (11/11/2016 11:42 pm)

ZeeZee · 11/11/2016 11:57 pm

SOLVED!
I couldn't stand it didn't work, so did some more investigation.
I needed to add "n" or "e" to the coordinates. So when my CSV file looks like this the import works:

TestRaceNote1
52.7929783n,5.3115183e
52.7931817n,5.3114517e
53.7931817n,5.3114517e
TestRaceNote2
53.7929783n,6.3115183e
53.7931817n,6.3114517e
54.7931817n,6.3114517e

Interestingly, as the exp log file doesn't have this format (it uses '-' (minus) for s and w coordinates)

Last edited by ZeeZee (11/11/2016 11:58 pm)

SWE204 · 11/12/2016 2:33 am

Thanks ZeeZee, much appreciated!
BR
Anders

Nick · 11/12/2016 11:56 am

I forgot about that. It works with a space

TestRaceNote1
52.7929783 5.3115183

The comma delimiter has been fixed for the next update

DuncanR · 11/13/2016 3:34 am

You guys don't have enough to do in the daytime!
Great insight.

Index
» Technical Q&A
» Format for race note import

11/11/2016 11:55 am #1

Format for race note import

11/11/2016 5:33 pm #2

Re: Format for race note import

11/11/2016 9:47 pm #3

Re: Format for race note import

11/11/2016 11:57 pm #4

Re: Format for race note import

11/12/2016 2:33 am #5

Re: Format for race note import

11/12/2016 11:56 am #6

Re: Format for race note import

11/13/2016 3:34 am #7

Re: Format for race note import

Index
» Technical Q&A
» Format for race note import

Board footera