Integration's

Click on logo to jump to appropriate section.

Competitors and Results

Competitors and Results


Competitors and Results

Competitors (Signed On)


Competitors (Signed On)

Import Competitors Into DSRC.


Competitors screen and


First copy the file to phone \ tablet - download.

Select the DISC icon

Import Competitors

Select the File from DOWNLOAD


LOAD / OVERWRITE - Replace all competitors with imported ones

or

LOAD / MERGE - Update and Adds new competitors, leave existing

Great for additions and Sign in systems, E-Signon & Sailevent


Tip Use Deselect existing when using sign on systems.


Note

Very little error checking here so any errors just reload another file


Format of the Import File.


The format for the import is a simple CSV file of up to 7 fields examples (updated 2020)

Usually just the first 5.

Fleet Class SailNo HelmName Rating Selected StartNo

Fast-HCP RS 400 1350 Keith Sykes 942 TRUE 1

Laser Laser 1231 Robbie Robertson 1021 FALSE 2


The Following Example file can be copied.


Fleet,Class,SailNo,HelmName,Rating,Selected,StartNo,

Fast-HCP,RS 500,748,Keith Sykes,962,TRUE,1,

Laser,Laser,2343,Robbie Robertson,1042,FALSE,2,

Notes

  1. Column Order is not important additional columns are ignored.

  2. Missing Columns are imported with default values

Defaults Fleet ALLCOM, Class Class, Sail NO 1234,

Rating 1000 is No Class,

StartNo1, Selected True

  1. Supported Alternative Headings -
    SailEvent Helm (FirstName&LastName 2 columns)
    SailEvent Selected(SignedAfloat=YES/NO or Blank)

Previous DSRC - HELM,SAIL,PYN

  1. Selected is True Not selected is False

  2. Ratings - In not supplied these will be taken from system ratings or from existing fleet.

  3. Fleets

Overwrite - Will take the Fleet Start No from Last entry it reads.
Merge option does not set Fleet for existing fleets.

Start can easily be set from From Fleets Screen.

Sailwave

Click for more info.

Exporting Competitors from Sailwave for Import into DSRC

Open the Sailwave Program SWCList
From the Sailwave program group.

Open the required Sailwave file

Click Cols to Publish


It is a good job to have scored the series so that all competitors have a PY.

Important Note

The fields / columns need to be visible in Sailwave file to show as exportable in Select Columns to Publish

If you can’t see the fields / columns you need open in Sailwave.exe click on the Columns button and make sure fields are visible, save file and re-open in SWClist.


You can select Cols to publish.

Would suggest SailNo, Fleet, Helm, Class, (Rating if req)


Click Done

Click CSV Export


Click Done


Save to your PC

Download file to your android device,

(I just email myself and downloaded)

Setting up for Use with Sailwave Results

Click for more info.

Settings - Results Exports

Select and tick

Sailwave -CSV – Creates a CSV file of results for import to Sailwave.

Sailwave Multi Race -CSV – Creates a CSV file of multiple race results for import to Sailwave in one go.

DSRC Importing Results to Sailwave


After a Race has been completed - Use app help for general usage instructions

Select RESULTS

Select The required Race, Tap on the RACE Date and Time

Select the CSV file – Share externally You can Email to yourself or add to Dropbox (if installed) etc.

Single Race File - This will be named in the format (RC 2021-01-19 21-01-46 Race 2.csv)

Multi Race File - This will be named in the format (RC 2021-01-19 21-01-46 Multi Race.csv)


Tip - If you wish to automatically copy Results to cloud storage, Drop Box, One Drive or Google Drive.

Please see separate article on Automatically copying Results files to the Cloud

Save the CSV file to PC

Open Sailwave and your series or a new one.

Select - File Import Results from CSV


(Warning it is very easy to select Import Series from CSV this is not the correct option!!!)

Browse to CSV File click Next

What field names click Next


This displays all the possible fields you can Import from DSRC

Click Ignore remaining fields

Click Next / Finish


Score series

Publish

And that’s It……..

DSRC - Sailwave Flexi Export - Why and how?


Why?

Sailwave - Import is supper flexible and helps to Guess what to import.

It matches to Competitors that match ALL the competitor fields you import.

You probably want to match on Class & Sail No

You may or may not want to match on Helm and or Fleet

You may or may not want to match on Fleet.


It Import all the Race fields that Match - Unless "IGNORED"


You probably want to import Elapsed Time / Finish (time in clock time) or Place (Class / Pursuit)

You may want to import Laps, Rating / RaceRating, Fleet, Corrected


Flexi Export - allows the DSRC to set the headings in the exported file so Sailwave always guesses correctly.


How?

Settings - Edit Sailwave Headers

I tend to add spaces so Sailwave can't match them ie Set Rating to R a t i n g to exclude


Sailwave Now also supports import of Racedate and Racetime.



Sailevent

Click for more info.

Importing Competitors From Sailevent

Sailevent - Race Team App (Setup)

Log on to your clubs Sailevent Club app. https://sailevent.net/app/club/login.aspx

Goto Settings - Integrations

Enable DSRC Integration.

This will enable the Download button in the Race team app.

Sailevent - Race Team App
(Suggested Method)

Log on to your clubs Sailevent Race Team app.
(eg https://sailevent.net/r1/yourclub)

Pick todays Session.

When you are ready - Click on the Download Icon.

File Name will be "Sailevent - Session Name- Date time"

Ready to import into DSRC.

Tip If you Import - Load Merge - You can retain Fleet Start sequences.

Sailevent using Competitions Only

Log on to Sailevent with you Club Logon

Use the Menu to Select Competitions

Pick todays Session.

Select the Required Competition


Select the 3 dot Menu

Scroll down an download competitors

Choose Type CSV, File Format Sailwave

Click Download


Top Yacht

Click for more info.

Importing Competitors from Top Yacht




Delete the Top Rows

Edit to Create a Helmname - - (Note this could be boats name of a combination of fields is just an identifier in DSRC (Not to long though!!) - In this case I just change Boatname to Helmname


Save file and download to tablet for DSRC. (I just email it to tablet)

Import competitors into DSRC - See for details


Note we had a PY for Pacer but not Sabre -


Setting up for Use with TopYacht Results

In Settings - Results Exports Make sure Sailwave - .csv is selected.



TopYacht Currently supports import of Positions (or Elapsed Time)

Codes

With a small change to the Setting for SAILWAVE headers

Note Topyacht will ignore unwanted columns)


In Settings - Scroll Down to EDIT Sailwave Headers

Change Sail number from "SailNo" to "Sail NO"

Confirm Place is "Place"

Change Code from “Code” to “Didnot”

or

Change Elapsed Time "Elapased" to "Place" if you wish to import times

& Change "Place" to "P l a c e"

Note

You can change them in TopYacht on import
(Suggest you do it in DSRC as you have to do it every time in TOP yacht)

If you haven’t already
You also need to TURN on File menu in Top Yacht to use the import feature.

DSRC Importing Results to Top Yacht


After a Race has been completed - Use app help for general usage instructions

Select RESULTS

Select The required Race, Tap on the RACE Date and Time

Select the CSV file – Share externally You can Email to yourself or add to Dropbox (if installed) etc.

Single Race File - This will be named in the format (RC 2021-01-19 21-01-46 Race 2.csv)

Multi Race File - This will be named in the format (RC 2021-01-19 21-01-46 Multi Race.csv)


Tip - If you wish to automatically copy Results to cloud storage, Drop Box, One Drive or Google Drive.

Please see separate article on Automatically copying Results files to the Cloud

File Import Places / Times

Note Don't use Finish Times for this Race

TopYacht Only supports importing one race at a time.

Pick the File you have downloaded


You will get these warnings/ info.


Validate


Process Race and you are done.



Hal Sailing Results

Click for more info.

Importing Competitors from HAL (PC)

Boat Register - Output Print - Excel All Boat

Select sail No, Type, Helm

Save Excel File. - Default AllBoats.XLS

You need to convert to a CSV to import into DSRC


You need to convert to a CSV for import into DSRC

Open the spread sheet.

Delete top 2 Rows.

Remove the space from Sail N to SailNo
Replace Type with Class
Replace Helm with Helmname

You can also add columns for Fleet, Start Rating if required.

Save to your PC as a CSV

Download file to your android device,

(I just email myself and downloaded)


Setting up for Use with Hal (PC and Web)

Settings - Results Exports

Select and tick

Spread Sheet (HAL) – .XLS

Creates a excel spread sheet of results for import to HAL.

HAL Currently supports import of Positions or Elapsed Time or Finish Time

Status, Laps

Note HAL will ignore unwanted columns

With a small change to the Setting for SAILWAVE headers in DSRC


In Settings - Scroll Down to EDIT Sailwave Headers

Change Class name to "Type"

Confirm Sail Number is "SailNo"

Change Rating to "Handicap"

Confirm Place is "Place"

Confirm Laps is "Laps"

Confirm Elapsed time is "Elapsed"

Change Code to “Status”

Note You can change Finish time to "Finish" is you wish to import finish time, only do this if elapsed time is unavailable.

If you do make sure Race Start time in HAL matches DSRC start times.!!!


DSRC Importing Results to HAL PC


After a Race has been completed - Use app help for general usage instructions

Select RESULTS

Select The required Race, Tap on the RACE Date and Time

Select the XLS file – Share externally You can Email to yourself or add to Dropbox (if installed) etc.

Single Race File - This will be named in the format (RC 2021-01-19 21-01-46 Race 2.xls)


Tip - If you wish to automatically copy Results to cloud storage, Drop Box, One Drive or Google Drive.

Please see separate article on Automatically copying Results files to the Cloud

Important Note.

To Import results into both HalRaceResults (PC) the boats need to already exist

The Good news is you can use the DSRC results file to create the boats before the results import.

First you need to Create the Fleet / (Class in HAL term) in Hal Class Register

Click Boats Register - Boats - Import boats - select the DSRC results File Ok OK.

Click Enter Results

Enter RO name and click OK.

Import results from Excel Spread sheet.

Note - Import needs to be turned on by administrator.

Select the Races you are importing results too.

Select the spread sheet and import.

Importing Competitors from HAL Web

To Export Competitors from Halsail - Web version.

Select Boats - List Boats

Or Better still use Boats List Boats by racing Class

This include the Hal Class - Dsrc Fleet one Fleet at a time

Click on Download a spreadsheet

Save to PC.

Adjust as per Hal Race Results


DSRC Importing Results to HALSail Web


Coming Soon.........

Import Boats if Required - Important Note.

To Import results into both Halsail (Web) the boats need to already exist

The Good news is you can use the DSRC results file to create the boats before the result import if required.

First you need to Create the Fleet / (Class in HAL term) in Hal Class Register

Click Boats - Import Choose Source -


Select Import form Spreadsheet


Choose File and Select Preview boats



Import Boats


Import Results

Input Results - Enter New Results

Select ALL the races that are in the DSRC results file and Click enter results.

Select Import results from Spreadsheet

Select the DSRC results file - Click Submit

Will show the number of Results imported / Rejected.