For creating races with large numbers of competitors, use the "Import CSV" feature.


A CSV file is a "Comma separated Values" text file that contains all your competitors and/or race marks with the reference to the device the competitor is carrying or the lat/long position that mark is placed at.


The CSV file needs to be formatted like this...

<Boat Number>, <Boat Name>, <Type>, <Serial Number>, <Colour>, <Latitude>, <Longitude>


This is an example of a file:


01,Boat01,yacht,GA-GP-AAAH,#42f4b6, ,
02,Boat02,yacht,GA-GK-AAFF,#4153f4, ,
03,Boat05,yacht,GA-GK-AAFFA,#4153f4, ,
04,Boat04,yacht,GA-GK-AAFFA,#4153f4, ,
  ,RaceMark01,buoy, , , 24 27.7419,118 11.6868
  ,RaceMark02,buoy, , , 24.466135,118.18566
  ,Target01,target, , , 24 26.8594,118 11.0611



All columns must contain information except for <Boat Number>, <Serial Number>,<Colour>, <Latitude> and<Longitude>.   If the column is left empty it still needs to have the comma.  eg ",Boat01,yacht,GA-GP-AAAH,,,"


Boat Number

Can be numbers or text, no longer than 25 characters long.  This could be the competitors sail number, race number, or short name. This field can't contain special characters "&,',>,<,".


Boat Name
Boat Name can only contain alphabetical letters and numbers.  This field cant contain special characters "&,',>,<," ect.


Type

The types must be written in lower case.  The supported types are, yacht, buoy, target or other.

yacht - Makes a Boat object, and must have a serial number that attaches to the boat object.

buoy - Will create a generic buoy type, attached to a serial number if supplied, or will be positioned at the Latitude and Longitude.  

target - The target can be attached to a serial number if supplied, or will be positioned at the Latitude and Longitude.

other - The other object can be attached to a serial number if supplied, or will be positioned at the Latitude and Longitude.



Serial Number

The serial number must be formatted AA-AA-AAAA. If a serial number is used that you don't have access to the data, then the "Failed Dialog", will show which serial number cant be used.  The serial number of each YachtBot device can be found on the back label of the physical device. 


Colour

 If the colour column is left blank then a random colour will be generated.  If you want to specify the colour, then it is formatted as hex RGB.  For more information on hex colours visit http://www.colorpicker.com/.  "#RRGGBB"  RR = Red colour component, GG = Green colour component, BB = Blue colour component.  


Latitude and Longitude

If both a serial number is entered for an attached tracker and a Latitude and Longitude is also supplied, the object will default to using the serial number in preference.

The numbers can be entered in for format ....

        24.466135,118.18566

or     24 26.8594,118 11.0611

or    24 26.8594N,118 11.0611E