25-04-2006 01:46

The Lucas

Re: paper: FIRSTXMLdb beta

Just wanted to let people know about this since I rushed it out before Champs. Basically it is Java programs that compile all FIRST Event results into XML files (good for programming and excel raw data).

It also includes complied data for ALL FRC teams from all regionals including full match list and stats like Off and D avg. Java program allow you to scout individual teams or entire championship (champ xmls already included). Can be viewed in IE (allow blocked content).

This is a beta with only a few class files. The rest of the project and source will come later (once source is readable by people besides me ). Hopefully, the ChampData and ChampCompile will work and give you up to date data for every team at Championship (as long as FIRST keeps data updated and it is not too different than last year which I tested on).

PM or post problems. I will try to fix them and have updated XMLs on Friday night and possibly Fantasy FIRST scores .

Read the Readme and enjoy! Make suggestions for added features

25-04-2006 21:45

The Lucas

Re: paper: FIRSTXMLdb beta

almost forgot, in order to use java from the command prompt (for .class files) you need to set the Path variable. Funny how you take these things for granted after a semester of Java.

OK here is how you set the Path variable in Windows.
1: Open My Computer
2: Open the folder "Crogram FilesJava"
3: Open your latest (highest version number) jre folder (mine is "jre1.5.0_04")
4: Open the bin folder
5: Highlight and copy (ctrl-c) the address of this folder (mine is "Crogram FilesJavajre1.5.0_04bin")
6: Open Control Panel (Start->Control Panel or Start->Settings->Control Panel)
7: Open the System icon (Performance and Maintenance->System if you are in category view)
8: Click on the Advanced Tab
9: Click on the Environment Variables Button
10: Under the "System Variables" double click on the "Path" Variable
11: Use the right arrow key to move to the end of the string in the "Variable Value:" field
12: Type a semicolon ';' then a space, then paste the bin folder address (For me it would be "; Crogram FilesJavajre1.5.0_04bin")
13: Click OK buttons till you get back to Control Panel (3 OKs).
14: Restart Command Prompt if you are currently running it
15: Now you can run java programs like this:
C:FIRSTXMLdb Beta>java ScoutTeams 365 1495

And thats it, See you in Atlanta!

28-04-2006 21:33

The Lucas

Re: paper: FIRSTXMLdb beta

NEW FILE up with Friday data. They work as far as I can tell. no award data is up. CD will not let me attach NEWTON.xml but their data is in CMP.xml. NO FF as of yet

06-05-2006 13:18

The Lucas

Re: paper: FIRSTXMLdb beta

I got some time to work on my FIRSTXMLdb project (after catching up on some other projects) and I got the Fantasy FIRST automated scoring working. I scored it as described in this post .

I uploaded the file (CMPff.xml) which has the current data about Championship with a FFscoring element. I assume FIRST has all the award data in the Saturday Awards since the Friday, & Thursday Award links don't work. NOTE: My Program doesn't handle the WFA (worth 40pts) since it can't tell which team the winner mentors. Any award with a "-" for team number is thrown out.

The FF Categories Excel file shows how the FF pts were earned by category. It also demonstrates how the xml file can be read into excel and used as raw data.
A couple notes on categories:

• Divisions and Champ Winners and Finalists get their pts as awards (since they are listed as awards).
• Champ Winners (75 pts) and Finalists (60 pts) awards have 30 pts subtracted from them (so they are worth 45 & 30 pts) since a team has to win a Division Winner award (30 pts) to get there.
• Div Elim Level only awards 4pts to Divisional Quarter Finalists and 10 pts to Semifinalists. Finalists and Winners are handled by awards.

Please tell me if you find any errors in my calculations. I am still testing all this code and prepping it for an open-source release. I was going to release the .class file that does the scoring but it is a little confusing to use with the FFScoring template xml file (PM me if you want it)

06-05-2006 14:21

The Lucas

Re: paper: FIRSTXMLdb beta

OK I found an error. Since I there was no new Friday Awards I had remnants from Friday Awards from last year in the the data. I realized this after I saw CyberSonics won 2 Autodesk Inventor Grand Prizes (although it is impressive that they won them back to back they don't get 10 extra points for that ). The "FIXED" Files have the data recompiled after deleting the 2005 Friday Awards remnant file.

14-05-2006 15:55

Billfred

Re: paper: FIRSTXMLdb beta

I just took a stab at using FIRSTXMLdb using both OS X (10.4.6) and Windows XP (with the preferences tweak). On both computers, whenever I try to run something (say, java ScoutTeams 1293), I get the message "Exception in thread "main" java.lang.NoClassDefFoundError: ScoutTeams"

Is there some n00bish mistake I'm making?