Linked Series

Hi Gary,

Funny you should ask today as I was just looking at what was involved to implement it last night. As I had just done the mods for Mark. I’ve been working on the automatically download of data from an online entry system and creating the Sailwave files automatically fully populated with the entries. So that users could be entering on one terminal or even their mobile phone and then at the click of a button they are in Sailwave. But as I’m not in control of the online entry system and they have been extremely slow to respond - it has delayed me - even to the extent of looking at creating an online entry system using Google forms - which may be something for the future as it would be free and an user could configure it themselves easily.

Trouble is a work full time and have a busy period at the moment at work. Hoping to have next weekend off for a family weekend (I might be in big trouble if I don’t)

I’m keen to do this as it is something I often need myself. Even one of the events I would normally be scoring this weekend could do with it.

Jon

···

Jon Eskdale
Sailwave

03333 443377

07976 709777

On 30 June 2013 07:08, gazza2290 hosieg@optusnet.com.au wrote:

Jon,

Is there likely to be any action on this request? I can’t find anything further in the thread.

Garry

— In sailwave@yahoogroups.com, “gazza2290” <hosieg@…> wrote:

Jon,

The requirement is your first option from below. We would want to be able to publish the separate results for each of the 3 series on a weekly basis. We normally sail 2 races a week - one counts as a Champ Series race, the other counts as a Perp Series race, and both count as an Agg Series race. The Agg series is a handicap series using VYC yardsticks, the other 2 series are position based results.

Having to merge files and delete races on a weekly basis is pretty yuk! Our results officer is not terribly computer literate - so we need to keep it as simple as possible.

Thanks for all your help

Garry

— In sailwave@yahoogroups.com, Jon Eskdale <jon@> wrote:

Hi Garry,

Just so I am clear - you would like to import a specified race from one

series to a specific race in another series.

You would like to import them as position plus codes or elapsed time plus

codes for that particular race

or do you want to specify a set of races from one series to create a new

series?

or would you prefer the ability to score selected races as an event?

I’m sure we can find a solution, but as a temporary solution don’t ignore

the merge as once you have merged it is extremely easy to delete the races

that you don’t want.

Jon

Jon Eskdale

Sailwave

03333 443377

07976 709777

On 29 May 2013 11:32, gazza2290 <hosieg@> wrote:

**

Guys,

Thanks for the responses. My club currently uses TopYacht for scoring, and

I want to move away from it. One function it does have is to allow you to

link the series as I described earlier. It provides the option to nominate

the series and race that the results should be taken from for the linked

(child) series. The advantage of this method is that you only need to enter

results once (in the parent series). DNC’s are not an issue because the

linked series only recognises the 10 races (or however many are linked).

In my case the champ series races can be any that you want to choose from

the Agg series, although we typically take every 2nd race as a Champ series

race. We then take every other race in the Agg series and link them into a

3rd series (Perp series). Importantly, the choice of race to link to the

child series could be completely random - non sequential. For this reason I

don’t think the Merge facility will work.

Garry

+61 419 891 036

— In sailwave@yahoogroups.com, Colin Jenkins <colin@> wrote:

could have a competitor filter too - can score blocks of results then.

given the filters would be in the scoring system - just need to set up N

scoring systems and use appropriately.

Cheers,

Colin J

http://sailwave.com

On Tue, May 28, 2013 at 2:57 PM, Chris Gandy <chrisgandy@> wrote:

**

Colin/John,

The filter Colin proposes would be ideal.

I’ve been looking to create the first and second half year series from

the

overall file, but yes your method would also work I guess.

I think the filter is the cleanest solution though as you could control

all the series using one .blw file to do all the work, whereas the

other

methods needed to do this require multiple files so in my experience

allow

for more user errors.

In our scenario, the DNC values differ depending which series. So the

full

year series will have larger DNC values, but when split out in to the

two

half year series we deleted boats which hadn’t entered any races in

that

series. Therefore once the first half year series is finalised any

competitor entering the second half wouldn’t have an entry in the first

half series. Hope that sort of makes sense.

Chris

On 28 May 2013, at 14:47, Jon Eskdale <jon@> wrote:

Hi Chris,

There is the merge faciltiy.

So if you had the first half as one file and the second half as

another.

You only have to run the merge to create the whole year series. - This

will append the second file results to the first.

This allows you to also have different titles and discard profiles

should

they change.

What happens in your scenario with DNC values? If you have them all in

one file and another boat joins the series in the second half if would

affect the results of the first half as the DNC values would change.

Jon

Jon Eskdale

Sailwave

03333 443377

07976 709777

On 28 May 2013 14:24, Chris Gandy <chrisgandy@> wrote:

**

Jon,

I recently had a similar issue for one of our fleets. They have a

series

result for the whole year. They also have series results for races

taking

place in the first half, and separately, the second half of the year.

The

only solution i could come up with was to save as separate files and

publish each one individually. Thats fine for the first half series,

but

means for each data entry in the overall series file to update the

second

half either means a) updating the results in the other file too or b)

updating results once but resaving file each time with a different

name.

When you publish there is a box that asks to publish certain races. Is

there any way you could add a command where when you select race

numbers in

this box it asks you to rescore based only on these races?

Chris

On 28 May 2013, at 14:07, Jon Eskdale <jon@> wrote:

Hi,

So as I understand you have an Aggregate series which all the results

go

into. And a championship series derived from 10 of the aggregate

series.

You don’t say how the championship races are selected. Also is this

done

after every race or once at the end of the series.

You can use discard profiles but without fully understanding you

selection criteria don’t know if this is what you want.

You can of course always save the aggregate series as another file and

delete the races that you don’t want

If you can supply some more details or give me a call on the number

below

Regards

Jon

Jon Eskdale

Sailwave

03333 443377

07976 709777

On 28 May 2013 10:40, gazza2290 <hosieg@> wrote:

**

Can you link 2 series so that one automatically picks up the results

from the primary series? ie Main series is the “Aggregate” series

with 20

races. The “Championship” series consists of 10 races from the

Aggregate

series. I want to enter results only in the Aggregate series and get

the

Championship to pick the results from the Aggregate series. Is this

possible?

Been thinking about that too. I've been suggesting to the Mexican Sailing Federation that they implement a database system of Mexican sailors. As the country is just in it's second year of using a "national circuit" of 4-5 major events, this would help folks doing registration and scoring tremendously. Now, every event requires separate registration and input to Sailwave for each event.

I keep thinking that Colin's original JSON implementation might be a good start to this (gotta learn more about JSON!), but I would think that some sort of direct database connection might be the ultimate answer. As an interim step, perhaps a PHP-based web page, showing competitors already in the database, might be used to do a selection of competitors that would be exported to a Sailwave file for competitor import.

Doing this with Google Forms is dead easy - we already do this for a couple of our events. Just create an online registration form that is people-friendly with appropriate instructions, pagination, etc. You can put any fields in you want (shirt size, dinner reservations, whatever), making sure that some of the fields are the ones you will need for Sailwave. Then create another sheet in the same spreadsheet file that contains only the information you wish to import to Sailwave. Do links for each cell to the original, form-generated sheet. When it's time to import to Sailwave, just go to your Sailwave sheet and export as CSV.

I usually put in some calculated fields in the Sailwave sheet to do things like proper capitalization (our dear Mexican friends often fill forms completely in upper or lower case), concatenation, or splitting of names, etc.

In a more recent event I used a Joomla Extension called Events Booking, which has links to Paypal and other online payment systems. Everything is stored in the main Joomla MySQL database. I was hoping to have the time to do the necessary database code to extract a Sailwave-compatible file, but I just didn't make it. Eventually I ended up exporting the database to a spreadsheet and creating the fields that I needed. If you are a Joomla user, Events Booking is a great extension and the support is first rate - aside from the Sailwave issue, it worked very well for us.

···

--- In sailwave@yahoogroups.com, Jon Eskdale <jon@...> wrote:

Hi Gary,

Funny you should ask today as I was just looking at what was involved to
implement it last night. As I had just done the mods for Mark. I've been
working on the automatically download of data from an online entry system
and creating the Sailwave files automatically fully populated with the
entries. So that users could be entering on one terminal or even their
mobile phone and then at the click of a button they are in Sailwave. But
as I'm not in control of the online entry system and they have been
extremely slow to respond - it has delayed me - even to the extent of
looking at creating an online entry system using Google forms - which may
be something for the future as it would be free and an user could configure
it themselves easily.

Trouble is a work full time and have a busy period at the moment at work.
Hoping to have next weekend off for a family weekend (I might be in big
trouble if I don't)

I'm keen to do this as it is something I often need myself. Even one of
the events I would normally be scoring this weekend could do with it.