Venue Race Application

Please add feature and function requests for PM3 firmware, DLL/API's, and documentation here.
Post Reply
majorben
Paddler
Posts: 10
Joined: April 10th, 2013, 1:30 pm
Location: Newburgh, NY
Contact:

Venue Race Application

Post by majorben » April 10th, 2013, 1:36 pm

Hi,

My club in Newburgh, NY just recently purchased 20 PM4's to aid in practice and to use in our yearly Indoor Regatta. This year's Regatta took place this past weekend, and for the past several years, we've been using the Venue Race Application for this event. I've been in charge of setting up the races the past 2 years, and I'm interested in an app that can do a race replay. Is such an app possible with the data from the VRA? I'm not a programmer, but if it is possible does anybody know if a race replay app has been or could be developed? I think having the ability to replay a race would be awesome.

BTW, I wasn't sure if this was the best place in the forum to post such questions.

Thank you,
Joe Danza

Bob S.
Marathon Poster
Posts: 5142
Joined: March 16th, 2006, 12:00 pm

Re: Venue Race Application

Post by Bob S. » April 10th, 2013, 4:39 pm

majorben wrote:Hi,

My club in Newburgh, NY just recently purchased 20 PM4's to aid in practice and to use in our yearly Indoor Regatta. This year's Regatta took place this past weekend, and for the past several years, we've been using the Venue Race Application for this event. I've been in charge of setting up the races the past 2 years, and I'm interested in an app that can do a race replay. Is such an app possible with the data from the VRA? I'm not a programmer, but if it is possible does anybody know if a race replay app has been or could be developed? I think having the ability to replay a race would be awesome.

BTW, I wasn't sure if this was the best place in the forum to post such questions.

Thank you,
Joe Danza
Have you checked directly with the folks at C2? The EIRC had been using some sort of replay system for several years until it seems to have gone out of business. Also, I believe that replays were available from the WIRC this year. I don't remember if they were available for the previous years' WIRCs.

Bob S.

majorben
Paddler
Posts: 10
Joined: April 10th, 2013, 1:30 pm
Location: Newburgh, NY
Contact:

Re: Venue Race Application

Post by majorben » April 11th, 2013, 12:42 pm

Thank you. I had contacted the people at C2 this past Sunday, and I have yet to hear back from them.

Joe D.

User avatar
Citroen
SpamTeam
Posts: 5415
Joined: March 16th, 2006, 3:28 pm
Location: Basingstoke, UK

Re: Venue Race Application

Post by Citroen » April 12th, 2013, 12:51 pm

majorben wrote:Hi,

My club in Newburgh, NY just recently purchased 20 PM4's to aid in practice and to use in our yearly Indoor Regatta. This year's Regatta took place this past weekend, and for the past several years, we've been using the Venue Race Application for this event. I've been in charge of setting up the races the past 2 years, and I'm interested in an app that can do a race replay. Is such an app possible with the data from the VRA? I'm not a programmer, but if it is possible does anybody know if a race replay app has been or could be developed? I think having the ability to replay a race would be awesome.

BTW, I wasn't sure if this was the best place in the forum to post such questions.

Thank you,
Joe Danza
Take a look at IRMM.
http://www.indoorrowing.org.uk/irmm.htm

I use that to build the website for all of my venue races. See http://rowing.dyn-o-saur.com/bstk2012/RaceReplay_01.htm for a sample race replay.

majorben
Paddler
Posts: 10
Joined: April 10th, 2013, 1:30 pm
Location: Newburgh, NY
Contact:

Re: Venue Race Application

Post by majorben » April 13th, 2013, 11:15 am

Hi,

Thank you. I've checked out IRMM, and it seems that this may be what I am looking for. Are you able to create replays from the data generated by the Venue Race App on the C2 website? If so, that's great, however, when I try to execute the ERowDataEditor.exe file that I downloaded from the IRMM website, I get an error that it failed to execute. So I am sure that it didn't install. I know that you do not own the IRRM website, but do you know what may be the problem? I'm using Windows XP SP3, and IRMM installed just fine.

Thank you again,
Joe

BTW, I like that replay that you gave as an example. :)

User avatar
Citroen
SpamTeam
Posts: 5415
Joined: March 16th, 2006, 3:28 pm
Location: Basingstoke, UK

Re: Venue Race Application

Post by Citroen » April 14th, 2013, 6:13 am

majorben wrote: Are you able to create replays from the data generated by the Venue Race App on the C2 website? If so, that's great, however, when I try to execute the ERowDataEditor.exe file that I downloaded from the IRMM website, I get an error that it failed to execute. So I am sure that it didn't install. I know that you do not own the IRRM website, but do you know what may be the problem? I'm using Windows XP SP3, and IRMM installed just fine.
...
BTW, I like that replay that you gave as an example. :)
IRMM does lots of things:

1. Rower registration
2. Timetable/race schedule/ergo assignments
3. Generates website before the event with time table and schedule and assignments
4. Generates venue racing *.RAC files automatically no need to use ERowDataEditor
5. Collects results (stroke (needed for replays) & splits), prints race results (with split times), prints event results (if you have say 40+ heavy men spread across two races)
6. Prints certificates
7. Generates website with race results, event results, records broken & replays (race replays and event replays).
(I think I've covered everything.)

I've been using IRMM since 2007. I've even had a bug I discovered fixed by Frank. It really does take the hard work out of running a competition.

majorben
Paddler
Posts: 10
Joined: April 10th, 2013, 1:30 pm
Location: Newburgh, NY
Contact:

Re: Venue Race Application

Post by majorben » April 14th, 2013, 10:42 am

Thank you for the complete list of what IRMM can do. I will have to use it for the next indoor regatta that I am involved with, especially since it generates the .RAC files.

Since this year's regatta has concluded, is there a way that I can import the data that was generated from VRA into IRMM, so that I can create some replays of this year's regatta? If so, how is that done? I'm asking because I can't figure out how to do it using IRMM. Do I need to start a new regatta and then somehow tell it to generate the replays? I'm sorry for the newbie questions. I'm just at a loss right now.

Thank you again,
Joe

User avatar
Citroen
SpamTeam
Posts: 5415
Joined: March 16th, 2006, 3:28 pm
Location: Basingstoke, UK

Re: Venue Race Application

Post by Citroen » April 14th, 2013, 12:44 pm

majorben wrote:Thank you for the complete list of what IRMM can do. I will have to use it for the next indoor regatta that I am involved with, especially since it generates the .RAC files.

Since this year's regatta has concluded, is there a way that I can import the data that was generated from VRA into IRMM, so that I can create some replays of this year's regatta? If so, how is that done? I'm asking because I can't figure out how to do it using IRMM. Do I need to start a new regatta and then somehow tell it to generate the replays? I'm sorry for the newbie questions. I'm just at a loss right now.

Thank you again,
Joe
You'll need to register all folks who rowed.
You'll need to create races that match what was done.

Then you should be able to import the results and stroke / split data.

It should work and it should help you learn how to use IRMM.

majorben
Paddler
Posts: 10
Joined: April 10th, 2013, 1:30 pm
Location: Newburgh, NY
Contact:

Re: Venue Race Application

Post by majorben » April 14th, 2013, 4:33 pm

Thank you again. I decided to play around and try to learn IRMM today. I know that it was a brief learning period, but I just wanted to set up one meeting with one event with one race, with 14 competitors from the regatta last weekend, and it seems as though I've run into a problem. I created the meeting, the event, and the race with no problem. I also successfully loaded competitors into that event-race. I also successfully loaded the results excel file for that event/race, but I got an error when I went to store those results. Here is that error:

System Error Detected

All available information about the error has been written to the log file
IRMMerrorLog.txt, located at:

:\Documents and Settings\Administrator\My Documents\My Stuff\
2013 Indoor Champs\IRMMerrorLog.txt

If you have the time it would be appreciated if you could e-mail this file to:
support@fittm.co.uk

The error you have encountered is indicative of a bug in IRMM software,
it is however likely that you will be able to continue your session.
If you wish to exit from IRMM you should first attempt to save any work.
To save work and to exit from IRMM please use the standard IRMM features.

I'm not sure, but it may be due to either the format of that results file. I realize that you don't own IRMM, but the e-mail address in the above error message is no longer valid, and I have no one else to ask for help with this, so please see if you can, please tell me what is wrong. Here is the contents of that IRMMerrorLog.txt file. And at the end is the contents of the xls results file.

=========================================================
---------------------------------------------------------
Exception Reported at 4/14/2013 3:43:11 PM
---------------------------------------------------------
=========================================================
Machine Name: JMDANZAT400
App Domain Name: IRMM.exe
Thread Identity:
Windows Identity: JMDANZAT400\danza
*********************************************************
Current Version of IRMM: 2.5.3402.32380
Current Version of OS: Microsoft Windows NT 5.1.2600 Service Pack 3
Current Version of .NET: 2.0.50727.3643
Current Directory: C:\Documents and Settings\Administrator\My Documents\My Stuff\2013 Indoor Champs\Race Results
Memory for Process (in Hex): 29F2000
*********************************************************


1) Exception Information
*********************************************************
Exception Type: System.ArgumentException
Message: This row already belongs to another table.
ParamName: NULL
Data: System.Collections.ListDictionaryInternal
TargetSite: Void InsertRow(System.Data.DataRow, Int32, Int32, Boolean)
HelpLink: NULL
Source: System.Data

StackTrace Information
*********************************************************
at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent)
at System.Data.DataRowCollection.Add(DataRow row)
at FitTM.IRMM.IRMMLogic.StoreLoadedData.storeExcelResultData(DataBaseInfo dbInfo, LoadExcelDataInfo resultOfLoad, Object& o)
at FitTM.IRMM.MainApp.FormLoadExcelOrERow.storeButton_Click(Object sender, EventArgs e)

-----------------------------------------------
Results.xls (formatting here is not nice, sorry)

First Name Sur Name Event Race Place Erg Affiliation Age Time
Nicholas Danza 1 1 1 7 Newburgh Free Academy 15 07:24.5
Spencer Schindler 1 1 2 11 Kingston High School 15 07:26.3
Peter Yacuk 1 1 3 15 Kingston High School 15 07:37.6
Devin Wunderlick 1 1 4 13 Kingston High School 15 07:40.7
Jack Oatts 1 1 5 3 Clarkstown 15 07:41.6
Kyle Sarbak 1 1 6 4 Warwick 15 07:48.9
Jacob Dennis 1 1 7 5 Newburgh Free Academy 15 07:57.3
Joe Costello 1 1 8 12 Kingston High School 15 08:00.4
Michael McIndoe 1 1 9 1 Clarkstown 15 08:08.5
Michael Holder 1 1 10 9 Newburgh Free Academy 15 08:14.0
Bryan Feigel 1 1 11 8 Newburgh Free Academy 15 08:20.1
Michael Levinstein 1 1 12 6 Newburgh Free Academy 15 08:24.3
Devon Robinson 1 1 13 10 Clarkstown 15 08:25.9
Gabe Karcher 1 1 14 14 Clarkstown 15 08:34.0



I'll be humbly grateful if you could help me out. If you need to contact me out of this forum my email address is majorben at gmail dot com.

Thank you,
Joe Danza

P.S. From the results file, you should be able to figure out that I have a vested interest in creating a replay. :D

User avatar
Citroen
SpamTeam
Posts: 5415
Joined: March 16th, 2006, 3:28 pm
Location: Basingstoke, UK

Re: Venue Race Application

Post by Citroen » April 14th, 2013, 5:09 pm

The names in IRMM have to absolutely match the names in the *.RAC file and, therefore, match the results/stroke/split data created by running the race.

So start by getting IRMM to generate some *.RAC files so you can tell what they should look like. Then with a text editor and a copy of the stuff from VRA edit those files to match what IRMM expects. You should then be able to load them and generate the replays.

HTH.

majorben
Paddler
Posts: 10
Joined: April 10th, 2013, 1:30 pm
Location: Newburgh, NY
Contact:

Re: Venue Race Application

Post by majorben » April 14th, 2013, 10:14 pm

Citroen,

Thank you for all your help. I'm still not getting it. I must be burned out because I just taught myself how to use Regatta Workbench this weekend for our outdoor events that are about to get underway, and trying to learn how to do replays while learning another new program (IRMM) is too much for me. I know that what I am doing wrong must be something rather stupid. Unfortunately, I just t can't figure out what it is. I tried doing what you suggested - creating a .RAC file and editing the names in the Results/Splits/Stroke files to match what is in the .RAC file, but I guess that I'm not sure what IRMM is expecting those files to look like. I think that I got the results file to what IRMM expects, but I guess my problem is with the Splits/Stroke files. There's just too much guessing on my part here because I continue to get that same error message. :(

majorben
Paddler
Posts: 10
Joined: April 10th, 2013, 1:30 pm
Location: Newburgh, NY
Contact:

Re: Venue Race Application

Post by majorben » April 15th, 2013, 9:40 am

Got it!!! What a good night's sleep will do!!! Needed it... I'll post a link to the replay when I get some time.

Thank you again Citroen!!! :D

User avatar
Citroen
SpamTeam
Posts: 5415
Joined: March 16th, 2006, 3:28 pm
Location: Basingstoke, UK

Re: Venue Race Application

Post by Citroen » April 15th, 2013, 6:50 pm

majorben wrote:Got it!!! What a good night's sleep will do!!! Needed it... I'll post a link to the replay when I get some time.

Thank you again Citroen!!! :D
No prob - I do high level mainframe databases software support for my day job. My next move was going to be to ask you to send the VRA files to me. I'm pleased you've solved it.

I've got some ugly php code with a MySQL database for a self-service registration system. That spits out an Excel spreadsheet that I can read in to IRMM and a PDF form for folks paying by cheque. I'm working on an upgrade to that at the moment, if you want my code, just ask.
Dougie Lawson
55yrs, 172cm, Almost LWt (in my dreams).
Twitter: @DougieLawson
Image

majorben
Paddler
Posts: 10
Joined: April 10th, 2013, 1:30 pm
Location: Newburgh, NY
Contact:

Re: Venue Race Application

Post by majorben » April 15th, 2013, 7:51 pm

Here's the link to that replay that I so feverishly wanted to see. It's a great race, and I guess that I am a little biased with that opinion. :D

http://www.nfacrewteam.org/Replays/test ... lay_01.htm

Citroen,

Thank you again for your patience. Now I need to see if I can build a whole meeting. That will take some time, I'm sure, especially since I am new to IRMM. I do like it, and I may be interested in your code. Currently, we're using Ronin Racing - http://www.roninregistration.com/rowing ... &pt=rowing for people to register for our events. After I learned how to use Regatta Workbench, I actually asked Ronin tech support if they can format the info for Regatta Workbench. They are supposedly looking into it. I hope that they do because currently, all the registration info is in Excel spreadsheets which probably helps for getting info into IRMM. Anyway, this coding stuff and learning software isn't my day job (I actually work in building semiconductors), and using Excel has been an adventure all unto itself. Just call me a dabbler. :D


Thank you again,

Joe Danza

Post Reply