Does anyone know the file format for HY3? I'm trying to make a web-based system that will generate a HY3 file for meet entries and that can be imported into Team Manager. I think the only thing that is stopping me from successfully generating the files is the checksum at the end of each file. Does anyone know how this is generated?
Please help! Thanks! :D
Parents
Former Member
I have some programs that read .hy3 files but none that generate them due to the checksum. This is something I'm quite interested in. The .cl2 file checksum algorithm is not the same. :)
The online meet entries software I did was geared towards our state's USA Swimming teams that all use Team Manager. Each team just did a file upload of the entries that they did in TM. The web stuff would unzip and extract the entries file, parse it out to do registrations checks, validate the events and entries times, and do a preview proof-of-times comparing entry times against our state database. Then the visiting team could also type in some meet-specific stuff (they can ask for their Sunday relays to swim in the morning instead of with the fastest relays at night for travel reasons). I generated a PDF meet entries report and calculated their fees so they did not have to also upload a entries report and entry fees report. The meet host just downloads a big zip file with all the teams' entries and reports at the entries duedate.
Benefit was that teams couldn't submit bad entries until they fixed them, rather than submitting bad entries and then the meet host would have to deal with them in a very short timeframe. Typically the entries duedate is 6 pm on a Wednesday, then most of the coaches would be at another championships meet the next day through Sunday, then our meet would start 3 days later.
It will all probably be obsoleted in the next few years as USA Swimming's Online meet entries capabilities mature and are available for the local championships meets.
What I did wasn't ever designed to replace Team Manager, just to smooth out the entries process. Email entries have been problemmatic - email not going through (bad address, inboxes getting full, anti-spam blocks, people using school/work email accts that block swim email); email delays; entry files that were empty or corrupt or for the wrong meet; multiple entry files submitted by a single team (which one is most current ?) from multiple people; reports that don't match the import files; and the hassle of trying to track down registrations issues when swimmers aren't entered with correct (name, ID, birthdate, team, LSC.). Also the relay-only swimmers (people not entered in any individual OR relay events, but in a pool of potential relay swimmers) don't show up on the usual entries reports but we were able to show them on ours.
I have some programs that read .hy3 files but none that generate them due to the checksum. This is something I'm quite interested in. The .cl2 file checksum algorithm is not the same. :)
The online meet entries software I did was geared towards our state's USA Swimming teams that all use Team Manager. Each team just did a file upload of the entries that they did in TM. The web stuff would unzip and extract the entries file, parse it out to do registrations checks, validate the events and entries times, and do a preview proof-of-times comparing entry times against our state database. Then the visiting team could also type in some meet-specific stuff (they can ask for their Sunday relays to swim in the morning instead of with the fastest relays at night for travel reasons). I generated a PDF meet entries report and calculated their fees so they did not have to also upload a entries report and entry fees report. The meet host just downloads a big zip file with all the teams' entries and reports at the entries duedate.
Benefit was that teams couldn't submit bad entries until they fixed them, rather than submitting bad entries and then the meet host would have to deal with them in a very short timeframe. Typically the entries duedate is 6 pm on a Wednesday, then most of the coaches would be at another championships meet the next day through Sunday, then our meet would start 3 days later.
It will all probably be obsoleted in the next few years as USA Swimming's Online meet entries capabilities mature and are available for the local championships meets.
What I did wasn't ever designed to replace Team Manager, just to smooth out the entries process. Email entries have been problemmatic - email not going through (bad address, inboxes getting full, anti-spam blocks, people using school/work email accts that block swim email); email delays; entry files that were empty or corrupt or for the wrong meet; multiple entry files submitted by a single team (which one is most current ?) from multiple people; reports that don't match the import files; and the hassle of trying to track down registrations issues when swimmers aren't entered with correct (name, ID, birthdate, team, LSC.). Also the relay-only swimmers (people not entered in any individual OR relay events, but in a pool of potential relay swimmers) don't show up on the usual entries reports but we were able to show them on ours.
