Using CSV results files in combination with data entered via "Edit race"

Imported from Yahoo
1

Cedar Point Yacht Club (CPYC) in Westport, Connecticut, USA
has decided to use Sailwave to replace its Excel-based method of scoring PHRF
races. Sail wave has terrific features, and we hope there is one more we do not
know about.

On a typical day of sailing, CPYC starts multiple divisions at
reasonable intervals. The Race Committee records the start time, distance,
course, etc., for each division. A single finishing record is created, noting
the sail numbers and finish times of all the boats. The sequence of this list often mixes finishes
of boats from different divisions. (We expect this scenario is familiar to many
Sailwave users.)

Entering the race information into Sailwave works well. The
race criteria (start time, distance, etc.) for each division) is entered using
the “Edit Race” dialogue. Using
the “Sail number wizard” to enter sail number, finish time, and/or code (If applicable) from the
finishing list completes the necessary data entry. The competitor list provides
all other needed information, such as Division and rating. This is the
straight-forward process all Sailwave users know.

CPYC would like to use CSV files to streamline the data entry process. The paper finish list information containing
Race number, Sail number, finish time and, if necessary, scoring codes can easily be transcribed to a
CSV file. We were disappointed when, using “Edit race” to enter the
race criteria manually", and then importing a CSV file containing the finish
information did not work the way anticipated.
We know now that the start time(s) defined in “Edit race” were
not used.

It appears from testing that the CSV list must contain the
start time, along with the finish time for each boat. Is there a way to prompt
the “Score series” process to use the race criteria stored via
“Edit race” in combination with a CSV file which defines only the Race
number, Sail number, Finish time and Code of each boat as it finishes?

Having to add the start times for each boat in a CSV list definitely
complicates an on-the-water simplicity we would prefer.

Hoping there is a
solution, Hank Sykes

2

Hi Hank

I assume you have read the http://www.sailwave.com/how-do-i-import-a-list-of-race-results

If you don’t specify the Start times in the csv you must set the start time for the race in Edit Race after the import.

Sailwave will automatically update all the competitors

Let me know if this solves your issue assuming that I understood your problem or if I can help more.

There are other alternatives but this should be the simplest.

Jon

···

On 15 May 2015 at 21:54, hank_sykes@yahoo.com [sailwave] sailwave@yahoogroups.com wrote:

Cedar Point Yacht Club (CPYC) in Westport, Connecticut, USA
has decided to use Sailwave to replace its Excel-based method of scoring PHRF
races. Sail wave has terrific features, and we hope there is one more we do not
know about.

On a typical day of sailing, CPYC starts multiple divisions at
reasonable intervals. The Race Committee records the start time, distance,
course, etc., for each division. A single finishing record is created, noting
the sail numbers and finish times of all the boats. The sequence of this list often mixes finishes
of boats from different divisions. (We expect this scenario is familiar to many
Sailwave users.)

Entering the race information into Sailwave works well. The
race criteria (start time, distance, etc.) for each division) is entered using
the “Edit Race” dialogue. Using
the “Sail number wizard” to enter sail number, finish time, and/or code (If applicable) from the
finishing list completes the necessary data entry. The competitor list provides
all other needed information, such as Division and rating. This is the
straight-forward process all Sailwave users know.

CPYC would like to use CSV files to streamline the data entry process. The paper finish list information containing
Race number, Sail number, finish time and, if necessary, scoring codes can easily be transcribed to a
CSV file. We were disappointed when, using “Edit race” to enter the
race criteria manually", and then importing a CSV file containing the finish
information did not work the way anticipated.
We know now that the start time(s) defined in “Edit race” were
not used.

It appears from testing that the CSV list must contain the
start time, along with the finish time for each boat. Is there a way to prompt
the “Score series” process to use the race criteria stored via
“Edit race” in combination with a CSV file which defines only the Race
number, Sail number, Finish time and Code of each boat as it finishes?

Having to add the start times for each boat in a CSV list definitely
complicates an on-the-water simplicity we would prefer.

Hoping there is a
solution, Hank Sykes

Jon Eskdale
07976 709777

Skype “eskdale”

3

Hello Jon,

The “How-to-import” FAQ had been scoured. Fearing I had missed something, I read it again, concluding I had not missed your tip.

Testing again by entering the race criteria after importing the CSV file with results solved the problem. You have one happy camper (or more appropriately, “sailor”) here.)

Thanks, Hank

Skype “hasykes”

4

I have a problem… We start a small PHRF fleet and one design fleet together. When scoring sailwave determines a corrected time for the one design fleet even though no handicap is specified. I would like to publish corrected times for the phrf fleet and places only for the one design. How do I set this up?

···

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: Friday, May 15, 2015 3:26 PM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Using CSV results files in combination with data entered via “Edit race”

Hi Hank

I assume you have read the http://www.sailwave.com/how-do-i-import-a-list-of-race-results

If you don’t specify the Start times in the csv you must set the start time for the race in Edit Race after the import.

Sailwave will automatically update all the competitors

Let me know if this solves your issue assuming that I understood your problem or if I can help more.

There are other alternatives but this should be the simplest.

Jon

Jon Eskdale

07976 709777

Skype “eskdale”

On 15 May 2015 at 21:54, hank_sykes@yahoo.com [sailwave] sailwave@yahoogroups.com wrote:

Cedar Point Yacht Club (CPYC) in Westport, Connecticut, USA has decided to use Sailwave to replace its Excel-based method of scoring PHRF races. Sail wave has terrific features, and we hope there is one more we do not know about.

On a typical day of sailing, CPYC starts multiple divisions at reasonable intervals. The Race Committee records the start time, distance, course, etc., for each division. A single finishing record is created, noting the sail numbers and finish times of all the boats. The sequence of this list often mixes finishes of boats from different divisions. (We expect this scenario is familiar to many Sailwave users.)

Entering the race information into Sailwave works well. The race criteria (start time, distance, etc.) for each division) is entered using the “Edit Race” dialogue. Using the “Sail number wizard” to enter sail number, finish time, and/or code (If applicable) from the finishing list completes the necessary data entry. The competitor list provides all other needed information, such as Division and rating. This is the straight-forward process all Sailwave users know.

CPYC would like to use CSV files to streamline the data entry process. The paper finish list information containing Race number, Sail number, finish time and, if necessary, scoring codes can easily be transcribed to a CSV file. We were disappointed when, using “Edit race” to enter the race criteria manually", and then importing a CSV file containing the finish information did not work the way anticipated. We know now that the start time(s) defined in “Edit race” were not used.

It appears from testing that the CSV list must contain the start time, along with the finish time for each boat. Is there a way to prompt the “Score series” process to use the race criteria stored via “Edit race” in combination with a CSV file which defines only the Race number, Sail number, Finish time and Code of each boat as it finishes?

Having to add the start times for each boat in a CSV list definitely complicates an on-the-water simplicity we would prefer.

Hoping there is a solution, Hank Sykes