Hi I have just started as Sailing Sec for results at Brightligsea
We use sailwave but the last secretary types in each boat data each time, unless in a series, then uses sail number wizard
Is there a way to create a club boat database, that the sail number wizard can then identify for setting up in individual races?
Regards
Piers
Hi Piers,
Welcome to the Sailwave User Group.
Unfortunately Sailwave currently does not have the sort of facility
you have described. However, what you could do is create a master
Sailwave.BLW file into which you have imported all your competitors.
Once you have this file mark all the competitors as excluded. Then
for each new club event or series take a copy of the master, set-up
the series details such as name, scoring profile, number of races,
number of starts and who on which starts etc . Then just
enter the results using the Sail Number Wizard and the competitor
should be found and the flag excluded removed.
PS - functionality to create a club competitor register in something
(spreadsheet or database like SQLLite) that would allow you to mark
the competitors to be imported for the event is on the to do list,
amongst other things. A difficulty in implementing a competitor
database is that there are many different data sets that different
users of Sailwave would require. It might be that the competitor
data base could use the smaller default sub-set of competitor
information that Sailwave provides or provides access to the
complete set of competitor information that Sailwave can hold. It
could possibly also allow the default field/column names to have a
club/event specific alternative name as Sailwave allows all
field/column names to be changed - the default names are not
overwritten just given an alternative name by the user.
FYI - The message passing functionality is already in Sailwave and
is used when using RYA NHC in external mode with Excel and in ISAF
plugin.
Hope you find this useful.
Kind regards,
Huw
On 25/07/2015 09:49,
[sailwave] wrote:
Hi I have just started as Sailing Sec for resultsat Brightligsea
We use sailwave but the last secretary types ineach boat data each time, unless in a series, then uses
sail number wizard
Is there a way to create a club boat database, thatthe sail number wizard can then identify for setting up
in individual races?
Regards
Piers
This email has been checked for
viruses by Avast antivirus software.
www.avast.com
This email has been checked for viruses by Avast antivirus software.
Thanks Huw
I will continue as before
Cheers Piers
On 25/07/2015 09:49,
[sailwave] wrote:
Hi I have just started as Sailing Sec for resultsat Brightligsea
We use sailwave but the last secretary types ineach boat data each time, unless in a series, then uses
sail number wizard
Is there a way to create a club boat database, thatthe sail number wizard can then identify for setting up
in individual races?
Regards
Piers
This email has been checked for
viruses by Avast antivirus software.
www.avast.com
This email has been checked for viruses by Avast antivirus software.
Hi Piers
Hopefully Huw has given you a comprehensive answer
One other option is to create a Sailwave file with all the boats that you want and then with the new series you can use the import competitor from another Sailwave file. This allows you to select the ones you want and import them all in one go.
Jon
On Saturday, 25 July 2015, Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com wrote:
Hi Piers,
Welcome to the Sailwave User Group. Unfortunately Sailwave currently does not have the sort of facilityyou have described. However, what you could do is create a master
Sailwave.BLW file into which you have imported all your competitors.
Once you have this file mark all the competitors as excluded. Then
for each new club event or series take a copy of the master, set-up
the series details such as name, scoring profile, number of races,
number of starts and who on which starts etc . Then just
enter the results using the Sail Number Wizard and the competitor
should be found and the flag excluded removed.PS - functionality to create a club competitor register in something(spreadsheet or database like SQLLite) that would allow you to mark
the competitors to be imported for the event is on the to do list,
amongst other things. A difficulty in implementing a competitor
database is that there are many different data sets that different
users of Sailwave would require. It might be that the competitor
data base could use the smaller default sub-set of competitor
information that Sailwave provides or provides access to the
complete set of competitor information that Sailwave can hold. It
could possibly also allow the default field/column names to have a
club/event specific alternative name as Sailwave allows all
field/column names to be changed - the default names are not
overwritten just given an alternative name by the user.FYI - The message passing functionality is already in Sailwave andis used when using RYA NHC in external mode with Excel and in ISAF
plugin.Hope you find this useful. Kind regards, Huw
On 25/07/2015 09:49, > pierslambert@btinternet.com [sailwave] wrote:
Hi I have just started as Sailing Sec for resultsat Brightligsea
We use sailwave but the last secretary types ineach boat data each time, unless in a series, then uses
sail number wizard
Is there a way to create a club boat database, thatthe sail number wizard can then identify for setting up
in individual races?
Regards
Piers
This email has been checked for
viruses by Avast antivirus software.
www.avast.com
This email has been checked for viruses by Avast antivirus software.
–
Jon Eskdale
03333 443377
07976 709777
What I tend to do each year is to take an export from the current club membership database and put it in Excel, sort out any other fields required, save as csv and then use the “import competitors from a csv file” option to create the new series files. I usually base those on last years files, but delete all the races and competitors, just leaving series information and scoring.
We have some quite complex series scored by fleets, in which I have to populate various extra fields, and I find it far more congenial to populate all the extra fields in Excel before importing the data rather than do it with the set competitor field options in Sailwave.
Jim C
Thanks Jim that might be worth a try
Cheers Piers
Sent from my iPhone
On 26 Jul 2015, at 10:06, yho@devboats.co.uk [sailwave] sailwave@yahoogroups.com wrote:
What I tend to do each year is to take an export from the current club membership database and put it in Excel, sort out any other fields required, save as csv and then use the “import competitors from a csv file” option to create the new series files. I usually base those on last years files, but delete all the races and competitors, just leaving series information and scoring.
We have some quite complex series scored by fleets, in which I have to populate various extra fields, and I find it far more congenial to populate all the extra fields in Excel before importing the data rather than do it with the set competitor field options in Sailwave.
Jim C
You can also, when you start a new series, select “File”, “New Series using one of your series as Pro-Forma” so I keep a blw file named “ProForma” all set up with our info just for that purpose, then once opened, save it with a new name for the current series.
Thanks
I could easily do that
Cheers Piers
Sent from my iPhone
On 27 Jul 2015, at 17:45, patmjones@btinternet.com [sailwave] sailwave@yahoogroups.com wrote:
You can also, when you start a new series, select “File”, “New Series using one of your series as Pro-Forma” so I keep a blw file named “ProForma” all set up with our info just for that purpose, then once opened, save it with a new name for the current series.