Update to latest PY

Hi,

I seem to have a strange issue in that I cannot automatically update the PY of our Dinghy fleet.

We use Dropbox to store all our results, Rating, Styles and Template files.

I do not recall having any issue last year, but I may have done things slightly different then, however, this year i have noticed that a majority of the competitor within the 2020 list of DInghy competitors have no PY listed against the boat.

If I go into the Boat entry and select another class of Dinghy for that particular boat, the PY comes up for that class, then I switch it back to the correct class and sure enough, the Correct PY is loaded into the field.

If i do the same on another dinghy class it will not even find the PY and it is actually listed in the CSV list.

I have checked that the correct field is being referenced and it is, i have now changed the Global settings Folder to use the rating folder within the “c” drive and uploaded the correct file into that folder… and that makes no difference, the Competitor file is attached.

Thanks

Johnw

Dinghy Base 4 SW.blw (29.4 KB)

Hi John,

When you enter the first boat for a class it will use the rating from the ratings file

If you modify this boat rating all future boats you add with this class will use the manual rating you have used

If you tick this box (Auto set competitor ratings) when you score the ratings will be set from the ratings file if there is a match

If you want to manually set ratings then this box should not be ticked

The ratings will be read when Sailwave is launched based on the ratings location specified

image.png

You can see where your ratings and how many are being loaded in the Help Logbook

image.png

Hope that helps - let me know if you have any questions

Jon

Jon,
Thanks for your response.

The file did have the Auto set configurator Ratings option set, and i was expecting the ratings for each boat to be updated as soon as i loaded up the file ??? apparently this is not correct, UNLESS you have scored the series first and saved the file is that correct?

To further complicate life my end here, what i had done last year was manually added three ratings in for the Topaz classes that were not referenced in the standard files issued, so i added these into the Limited information CSV file.

This may be significant as when you score, Sailwave generates an error for each of the classes it cannot find in the Rating file, however, what it does then is to fail to load the PY for those classes that it did find, and my logic was telling me that must be because i have something else wrong…

So when it comes to 2021 i assume this is the process to take:-

  1. Make sure any “local” PY for any classes are added into the respective rating file.
  2. Load up Base set of competitors from previous year
  3. Score Base set of Competitors
  4. Save file.

One question? if the previous years Base file still contains the PF for that year will it then proceed to automatically update the PY based on the current rating file?

Thx

JohnW

Keith Thx for your offline suggestions but I thought it best for the group to document my findings here as a complete record…

Hi John,
Normally you would tick the box and score and then untick the box again so that you can manually adjust ratings if needed.

The easy way is to remember when you score if the box is ticked it will update the ratings from the ratings file.

Jon

Hi John,
Remember you can have more than 1 file in your rating folder so why not keep the extra ones in a separate file so they wont get over written next year. (They are unlikely to change)
Huw also made the less common PY available “RYA_PY_PIMITED_DATA” that does have to TOPAZ UNO init but not the PLUS.
Cheers
Keith

Jon,

Yes understood, thank you for that.

Keith,

Yes good point i need to keep things simple, i will work on the other file idea …

Thx
JohnW

OK, I tried the idea of adding a unique Club RPYA file into the rating folder, the file i created copied the exact format of the exiting files… but did not work.

Something else interesting i found by accident if I try to input a new boat with a class that is only listed in the "limitedRYA " file Sailwave fails to load the PY, however, if I use the Score function it loads all PY except the three classes of Boat i have added into the third file, which we use at the club…

So why isn’t the third file option working? and why the strange behaviour between the manual listing of a class and when you use the “Score” function?

Thanks
JohnW

Hi John,
If you care to send me your three ratings file I will take a look and see if I can spot anything.

PS - might be this afternoon before I can take a look as in Zoom presentation of Sailwave as an observer for session being run by Irish Sailing.

Kind regards,
Huw

Huw,

This forum will not accept csv files so can you use the following link please:-

Interesting about Irish Sailing Presentation, If you get a chance and If Mal Nowlan is on the call, pass on my regards, Mal used to be a resident here in Glandore and he did a lot of support work for us.

Thx

JohnW

Hi John,

I have looked at the rating file and determine it is something in the first two rows where you say it is ratings for 3 classes at GHYC. I have deleted those two lines and then Sailwave reads the file and notes that 3 ratings have been loaded. This is because I only have that rating file in my ratings folder.
Update - it is the first line of your file that is causing the problem but I have not determined the exact reason :frowning:

My modified version of your ratings file is at https://www.dropbox.com/s/w9jh98j3xlqa29m/ryapn-GHYC-Only3.csv?dl=0

I will keep looking for the exact reason your file is not being read.
Kind regards,
Huw

Hugh,

Thanks, I will try your updated file, I am sure it will work, but it would be good to know why it did not work initially.

I will try my own experiments.

Thx

JohnW

Hope the Zoom presentation went OK.

Hi John,

I have the same problem in the past where a rating file I had created would not be read by Sailwave. Can’t remember what the reason was. I will look at your file again over next 24-hours and see if I can isolate the issue.

Kind regards,
Huw

Huw,

I have tried all sorts of things myself, including copying cells from a working spread sheet then changing the values to what i require, not luck the only thing that seems to work is to copy what you did and cut down the number rows to around 2 or 3 before the actual PY values start, then “scoring” the entrants creates all the PY

The only thing i haven’t tried is creating the spreadsheet using Windows Excel, as i am doing everything on my MAC Microsoft Office at the moment.

The one thing that is consistent now is that i cannot get a PY to load if the boat already exists, and that does not appear to differ if “Auto” in the Rating Scheme window. the same result if you create a “New Like”. But. it will load the PY if you start with a blank row for a new entrant.

Not sure why Sailwave needs to be sensitive on this?

Thx

JohnW

The problem is that the Semi-colon ; is missing at the start of the first two lines
The Semi-colon specifies it is a comment

Jon

Jon,

I noted that, and fixed it in a later version of the file don’t seem to make any difference…

JohnW

Huw,

Creating CSV file under Windows Microsoft Office has no affect on the end result.

JohnW

You need to check the log file in the help. Can you post that section on the ratings file
Jon

Jon,

I cleared the Log Book fiel before i loaded the Series and tried to Score, this is the resulting entreis in the Log book
11:50:20 Logbook cleared
11:50:34 Loaded 10 templates from C:\Users\EJW\Dropbox\GHYC Committee Team Folder\2020 -
2021 GHYC MAIN COMMITTEE\Sailing Secretary\Race Officer\Sailwave\Templates
11:50:34 Loaded 0 templates from C:\Program Files (x86)\Sailwave\templates
11:50:42 Loading ratings from C:\Users\EJW\Dropbox\GHYC Committee Team Folder\2020 - 2021
GHYC MAIN COMMITTEE\Sailing Secretary\Race Officer\Sailwave\Ratings\2020 PY
11:50:42 Loaded 284 ratings
11:50:42 Scoring error - Cannot find rating value for PY/TOPAZ UNO PLUS in rating files

Hope this is of some help?

JohnW

Hi John,
Can you clear the log file please and then move all rating files except your custom one which includes the ratings for the 3 Topaz variants. Then close and restart Sailwave and now post the information in the log file here. At the moment just trying to see what comes up when only your custom rating file is in the ratings folder.

I have created a rating file that just includes the three Topaz variants which includes the following contents:
;
;,Sailwave rating data file created by John W April 2020
;
;,Class Name,GHYC Number
PY,Topaz Uno Plus,1255
PY,Topaz Race,1168
PY,Topaz Race Plus,1172

And this is what is in my LogBook:
12:02:42 CmdLineFile=
12:02:42 CmdLineOpenProforma=0
12:02:42 CmdLineOpenNew=0
12:02:42 CmdLineShear=0
12:02:42 CmdRunFromRoot=0
12:02:43 ScreenWidth=1366
12:02:43 ScreenHeight=768
12:02:43 WindowsVersion=6.2.9200
12:02:43 WindowsUser=Huw Pearce
12:02:43 SailwaveVersion=2.28.2
12:02:43 InstalledOn=04/07/20 11:33:35
12:02:43 InstalledBy=Huw Pearce
12:02:43 ProgramFolder=C:\Program Files (x86)\Sailwave
12:02:43 StartInFolder=C:\Users\Huw Pearce\Documents
12:02:43 TempFileFolder=C:\Users\Huw Pearce\AppData\Local\Temp
12:02:43 MyDocsFolder=C:\Users\Huw Pearce\Documents
12:02:43 CommonDocsFolder=C:\Users\Public\Documents\Sailwave
12:02:43 CommandLine=
12:02:43 Loading ratings from C:\Users\Huw Pearce\Dropbox\Sailwave Events\2020 Ratings
12:02:43 Loaded 3 ratings

Kind regards,
Huw

Interesting …

This is what i get

12:23:48 Logbook cleared
12:23:58 Confirm - Save changes to C:\Users\EJW\Dropbox\GHYC Committee Team Folder\2020 -
2021 GHYC MAIN COMMITTEE\Sailing Secretary\Race Officer\Results\2020\Dinghy\2020
Dinghy Base.blw?
12:25:24 Loaded 10 templates from C:\Users\EJW\Dropbox\GHYC Committee Team Folder\2020 -
2021 GHYC MAIN COMMITTEE\Sailing Secretary\Race Officer\Sailwave\Templates
12:25:24 Loaded 0 templates from C:\Program Files (x86)\Sailwave\templates
12:25:41 Loaded 10 templates from C:\Users\EJW\Dropbox\GHYC Committee Team Folder\2020 -
2021 GHYC MAIN COMMITTEE\Sailing Secretary\Race Officer\Sailwave\Templates
12:25:41 Loaded 0 templates from C:\Program Files (x86)\Sailwave\templates
12:26:22 Loading ratings from C:\Users\EJW\Dropbox\GHYC Committee Team Folder\2020 - 2021
GHYC MAIN COMMITTEE\Sailing Secretary\Race Officer\Sailwave\Ratings\2020 PY
12:26:22 Loaded 0 ratings
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Invalid Yes/No=
12:26:22 Scoring time is 0.01s
12:26:22 Scoring bottleneck is SeriesPositions (100%)
12:26:22 Deformat elapsed cache size/hits=0/0

And the file is CSV format

JohnW