There has been discussion in the past of having sailwave automatically launch excel, pass a file (assume to be .csv) and then retrieve the results. Can someone provide the details of how to accomplish this? I realize that this can be done manually via the export/import, but am looking for an automated solution.
Thanks,
Tom Owen
Hi Tom,
Basically the later versions of Sailwave have a Windows messaging system built in. Which allows an external program to communicate with it using Windows messages. This is not currently intended for third party programs due to the complexity and the support that would be required. However it does allow us to use an external program to supply special needs. Sailwave has support for the RYA NHC (National Handicap for Cruisers) which is a progressive / personal handicapping system. The calculation support for this is handled in a separate exe program which allows this to be updated and supported without making constant changes to Sailwave.
Basically when the scoring system is set to RYA NHC Sailwave starts this external program. This program then sends to and receives messages from Sailwave. Simplified this means the program (SWHelper in this case) asks Sailwave for its list of competitors and Sailwave sends them back. SWHelper then asks for the results of Race 1 it then calculates the Handicap that should be applied for Race 2 and feeds these back into Sailwave via the messaging system. It repeats this for all races.
The RYA NHC has two modes Club racing and Regatta.
Now in addition to do this calculations internally this SWHelper program can automatically feed the results into Excel which it starts automatically for each race at a time and reads calculations back from Excel and thne feeds them back into Sailwave. For the RYA NHC handicap system, two templates are supplied one for Club and one for Regatta. This way the workings of the Handicap system cab examined and explained. You can of course modify the templates and therefore create custom handicap system using this technique
You can see some documentation at
http://www.sailwave.com/version-2-9-3-full-install-beta#more-977
There is some docmentation and links to the above on the current stable download part of the Sailwave Website
http://www.sailwave.com/category/download/sailwave
There is also a program that did something similar to this using the Sailwave blw file before the messaging was incorporated into Sailwave.
If you could let me know what you are trying to achieve - I will be willing to assist or point you in the best direction
Jon
Jon Eskdale
Sailwave
03333 443377
07976 709777
On 19 October 2013 15:13, Tom OWEN towen999@msn.com wrote:
There has been discussion in the past of having sailwave automatically launch excel, pass a file (assume to be .csv) and then retrieve the results. Can someone provide the details of how to accomplish this? I realize that this can be done manually via the export/import, but am looking for an automated solution.
Thanks,
Tom Owen