Expedition Expedition Navigation Software

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



11/11/2016 11:55 am  #1


Format for race note import

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

 

11/11/2016 5:33 pm  #2


Re: Format for race note import

See the help - Expedition Interface, Sail panel

 

11/11/2016 9:47 pm  #3


Re: Format for race note import

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)

 

11/11/2016 11:57 pm  #4


Re: Format for race note import

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)

 

11/12/2016 2:33 am  #5


Re: Format for race note import

Thanks ZeeZee, much appreciated!
BR
Anders

     Thread Starter
 

11/12/2016 11:56 am  #6


Re: Format for race note import

I forgot about that. It works with a space

TestRaceNote1
52.7929783 5.3115183

The comma delimiter has been fixed for the next update

 

11/13/2016 3:34 am  #7


Re: Format for race note import

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

 

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.