New Posts New Posts RSS Feed: Update Ratings
  FAQ FAQ  Forum Search   Register Register  Login Login

Update Ratings
 Post Reply Post Reply Page  12>
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
kevinwhead View Drop Down
Newbie
Newbie


Joined: 23 Nov 13
Location: United Kingdom
Online Status: Offline
Posts: 4 		Post Options Post Options   Quote kevinwhead Quote  Post ReplyReply Direct Link To This Post Topic: Update Ratings
    Posted: 23 Nov 13 at 7:11pm
What do you have to do to get sailwave to update all the sailors Ratings when a new Ratings file is presented? I have got the global options pointing at the new Ratings file because if I click on any one helm and select their existing Class then the rating is updated. But I really don't want to go through every helm one by one and do this. There was a menu option that appeared a couple of years back; Tools / Update Ratings  - but this has been removed in the more recent versions! Help.
Back to Top
sailingsue View Drop Down
Newbie
Newbie


Joined: 16 Feb 14
Online Status: Offline
Posts: 2 		Post Options Post Options   Quote sailingsue Quote  Post ReplyReply Direct Link To This Post Posted: 16 Feb 14 at 8:37pm
I have the same question... I have a all the club racers in a sailwave file which I use to populate future series, but I can't find a way to update the PY numbers using the new 2014 ratings file. Have you found a solution anywhere else?
Hope someone can help Smile
Back to Top
sailingsue View Drop Down
Newbie
Newbie


Joined: 16 Feb 14
Online Status: Offline
Posts: 2 		Post Options Post Options   Quote sailingsue Quote  Post ReplyReply Direct Link To This Post Posted: 16 Feb 14 at 9:28pm
Just found a way to work around the problem...
 
On the Tools menu, use 'Set Competitor Field...'
Then for example:
CLASS=TOPPER
Field to change 'Rating'
Set this value '1313'
Replace existing
 
This will change all the competitors with Toppers to PY 1313
 
Hope this helps. If anyone finds a better fix then post here!
SS
Back to Top
kevinwhead View Drop Down
Newbie
Newbie


Joined: 23 Nov 13
Location: United Kingdom
Online Status: Offline
Posts: 4 		Post Options Post Options   Quote kevinwhead Quote  Post ReplyReply Direct Link To This Post Posted: 18 Feb 14 at 10:14pm
Hum, still requires going into each class one at a time. The alternative is that you go into "Edit Competitor", and re-select the class to what it already is (picking up a change in the process), If the Edit Next tickbox is set then this makes it easier to work down the whole fleet.

My other solution was to write some Java which would read the blw file and re-write it !
import java.io.*;
import java.lang.*;
import java.util.Vector;
public class StartHere {
public static void main(String[] args) {
Vector<Ratings> Ratings = new Vector<Ratings>();
System.out.println("Hello World");
String RatingsFile = "";
String OutputFile  = "";
String inputStr = "";
if(args[0].compareTo("Normal")==0) {
RatingsFile = "C:/Dropbox/Kevin/Sailing/PH_Sailwave/NormalHandicaps/NormalRatingsXXAutumn2013.csv";
OutputFile  = "C:/Dropbox/Kevin/Sailing/PH_Sailwave/PH Everybody 2014 Normal.blw";
} else if(args[0].compareTo("Personal")==0) {
RatingsFile = "C:/Dropbox/Kevin/Sailing/PH_Sailwave/PersonalHandicaps/PHratingsXXAutumn2013.csv";
OutputFile  = "C:/Dropbox/Kevin/Sailing/PH_Sailwave/PH Everybody 2014 PH.blw";
} else {
System.out.println("Usage is ConvertBLW Normal/Personal");
}
if(RatingsFile.compareTo("")!=0) {
try{
InputStream is = new FileInputStream(RatingsFile);
int size = is.available();
int iField = 0;
String TextFieldOne   = "";
String TextFieldTwo   = "";
String TextFieldThree = "";
for(int iReadLine=0; iReadLine< size; iReadLine++){
char nextchar=(char)is.read();
if(nextchar==','){
if( iField==0) {
TextFieldOne = inputStr;
inputStr = "";
} else if( iField==1) {
TextFieldTwo = inputStr;
inputStr = "";
}
iField += 1;
}else if (nextchar=='\r') {
TextFieldThree = inputStr;
inputStr = "";
iField = 0;
System.out.println(".");
}else if (nextchar=='\n') {
Ratings ptrRating = new Ratings(TextFieldOne, TextFieldTwo, TextFieldThree);
Ratings.add(ptrRating);
}else{
System.out.print(nextchar);
inputStr = inputStr.concat(Character.toString(nextchar));
}
} // end for
is.close();
}catch(IOException e){
System.out.print("Exception failed to read ratings file");
}
// now read and convert the blw file
try{
int iField = 0;
boolean bFoundClass = false;
boolean bFoundRating = false;
String inputLine = "";
String StringNewRating = "";
String StrCompClass  = "\"compclass\"";
String StrCompRating = "\"comprating\"";
InputStream is = new FileInputStream("C:/Dropbox/Kevin/Sailing/PH_Sailwave/PH Everybody 2014.blw");
int size = is.available();
OutputStream iout = new FileOutputStream(OutputFile);
for (int iReadLine=0; iReadLine< size; iReadLine++){
char nextchar=(char)is.read();
inputLine = inputLine.concat(Character.toString(nextchar));
if (nextchar==','){
if (iField==0) { // looking for start of first field
if (inputStr.compareTo(StrCompClass)==0) {
bFoundClass = true;
}else if (inputStr.compareTo(StrCompRating)==0) {
bFoundRating = true;
}
}else if (iField==1) {
if (bFoundClass == true) {
// look through the vectors of ratings to find this one
int iRatings = Ratings.size();
int iLength  = inputStr.length()-1;
String StrClass = inputStr.substring(1,iLength);
boolean boolFound = false;
for (int i=0; (i<iRatings && boolFound==false); i++){
Ratings ptrRating = (Ratings) Ratings.elementAt(i);
StringNewRating = ptrRating.Match(StrClass);
if (StringNewRating.compareTo("")!=0){
boolFound = true; // break out of loop
}
}  // end for
if (boolFound == false) {
System.out.println("There is no Rating entry for " + inputStr + " FIX THIS NOW!");
}
bFoundClass = false;
}
}
iField += 1;
inputStr = "";
}else if (nextchar=='\n') {
// write the line back out
if (bFoundRating == true) {
// overwrite inputLine with a nobled version
String StrTail = inputLine.substring(18);
if (inputLine.charAt(17)=='"') {
StrTail = inputLine.substring(17);
}
inputLine = "\"comprating\",\"";
inputLine = inputLine.concat(StringNewRating);
inputLine = inputLine.concat(StrTail);
bFoundRating = false;
}
int iBytes = inputLine.length();
for (int i=0; i<iBytes; i++){
int iChar = inputLine.charAt(i);
try {
iout.write(iChar);
} catch (IOException e) {
e.printStackTrace();
}
} // end for
iField    = 0;
inputStr  = "";
inputLine = "";
} else {
inputStr = inputStr.concat(Character.toString(nextchar));
}
System.out.print(nextchar);
} // end for
is.close();
iout.flush();
iout.close();
}catch(IOException e){
System.out.print("Exception failed to read the blw file correctly");
}
finally {
}
}
System.out.println("Goodbye World");
}
}
Back to Top
Eskdale View Drop Down
Newbie
Newbie


Joined: 18 Feb 14
Online Status: Offline
Posts: 5 		Post Options Post Options   Quote Eskdale Quote  Post ReplyReply Direct Link To This Post Posted: 19 Feb 14 at 12:11am
There is an easy way built into Sailwave

Go to Setup - Scoring System - Rating system tab

At the bottom there is a tick box Auto set competitor ratings
see screen shot below




When you score the series this will read the ratings file and update the competitors automatically

Hope this helps

If you need any help let me know

Jon
Back to Top
kevinwhead View Drop Down
Newbie
Newbie


Joined: 23 Nov 13
Location: United Kingdom
Online Status: Offline
Posts: 4 		Post Options Post Options   Quote kevinwhead Quote  Post ReplyReply Direct Link To This Post Posted: 19 Feb 14 at 9:31pm
Excellent - that works fine.

Shame its so difficult to find.

Thanks for the Info.
Kevin W,
SCSC
Back to Top
Medway Maniac View Drop Down
Really should get out more
Really should get out more
Avatar

Joined: 13 May 05
Location: United Kingdom
Online Status: Offline
Posts: 2788 		Post Options Post Options   Quote Medway Maniac Quote  Post ReplyReply Direct Link To This Post Posted: 29 Mar 15 at 4:57pm
Thanks to all above for this thread from last year.  It's just saved me a lot of head-scratching.

If I was a seven-days-a-week race officer I'd no doubt fully master Sailwave, but it just has too many hidden tricks and pitfalls like this for occasional ROs, or even for semi-regular ROs like myself to discover then remember.

Hope that doesn't sound ungrateful, because I'm not.  Sailwave is  great program for sailing clubs that covers a host of possibilities, but I'd suggest that future development needs to be focussed improving accessibility for twice-a-year ROs.
Wilsonian SC
3000 Class
Back to Top
Eskdale View Drop Down
Newbie
Newbie


Joined: 18 Feb 14
Online Status: Offline
Posts: 5 		Post Options Post Options   Quote Eskdale Quote  Post ReplyReply Direct Link To This Post Posted: 31 Mar 15 at 3:06pm
Hi Medway Maniac,

Hopefully I can clarify it a little.  Ratings come from the ratings file when you first enter them and Sailwave remembers the ratings for any class that you override.  So in normal use it is very easy it gives you the default but allows you to override it to a value that is specific to your club.

If you want to load all the values from a file every time (or a new set then you tick the box) but this is not the normal.

You don't say what version of Sailwave you are running but the later ones do have a User interface in the Setup to make it easier for the twice a year RO's as this enables it to be configured with features removed that are not applicable to the specific user.  Unfortunately Scoring is not always a simple job due to the different rules and parameters that different clubs use.  Please if you have any suggestions as to how it can be made easier then please let us know.

Jon
Back to Top
Medway Maniac View Drop Down
Really should get out more
Really should get out more
Avatar

Joined: 13 May 05
Location: United Kingdom
Online Status: Offline
Posts: 2788 		Post Options Post Options   Quote Medway Maniac Quote  Post ReplyReply Direct Link To This Post Posted: 31 Mar 15 at 3:46pm
We're currently using 2.9.7.0, frozen simply so that the various users in the club can exchange files without the risk of problems such as we had in the past when we upgraded independently.  We should probably update the version regularly, say once a year, and now would be a good time to do it.

I think to make S'wave really user-friendly would probably require a complete re-write, but one thing everyone I've introduced it to stumbles on is that it looks like an Excel spreadsheet but can't be edited the same way. Typically (trivially even, but I must admit this erks me still) you can't just double click on a cell or press F2 to edit it, you get the whole entry with the cursor where you don't want it.  If the cursor sprang to the data you'd clicked it would do the trick, I guess - I seem to be forever changing helm/crew names  Confused
Wilsonian SC
3000 Class
Back to Top
JimC View Drop Down
Really should get out more
Really should get out more
Avatar

Joined: 17 May 04
Location: United Kingdom
Online Status: Offline
Posts: 6625 		Post Options Post Options   Quote JimC Quote  Post ReplyReply Direct Link To This Post Posted: 31 Mar 15 at 6:55pm
I must agree. The more it behaves like a spreadsheet the better for the casual user.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Bulletin Board Software by Web Wiz Forums® version 9.665y
Copyright ©2001-2010 Web Wiz
Change your personal settings, or read our privacy policy