Database utility now posted

Ryan W. · 06-09-2002, 05:01 PM

Guys,

My database utility is now posted. It can be downloaded at <a href="http://www.ootplinks.com/wallman/OOTPUtil.EXE" target="_blank">http://www.ootplinks.com/wallman/OOTPUtil.EXE.</a> This utility takes the HTML files from the end of the year and parses them out into a database. It can then generate some fairly informative HTML pages.

You need Java 1.4 installed on your system. This download can be found at <a href="http://java.sun.com/j2se/1.4/download.html" target="_blank">http://java.sun.com/j2se/1.4/download.html.</a>
Click on the "Windows (US English only) and "JRE" option. It is a little bit of a download (~9 MB)...

Please read the README! It is also below:

OOTP Database Utility V1.0 README

PREREQUISITES:

- Before this program runs, it needs the following things set up on your machine:

- Install the Java 1.4 JRE on your machine. This download can be found at <a href="http://java.sun.com/j2se/1.4/download.html" target="_blank">http://java.sun.com/j2se/1.4/download.html.</a>
Click on the "Windows (US English only) and "JRE" option. It is a little bit of a download (~9 MB)...

- If you are running Win9x or WinNT, you need to download the MDAC 2.52 release from Microsoft. This is found at <a href="http://www.microsoft.com/data/download.htm#252Info" target="_blank">http://www.microsoft.com/data/download.htm#252Info.</a>

USING THE UTILITY

Once the utility is launched, select File->New League Database. Select the directory where your HTML files live and click on the OK button. If you have a directory that has numerous years in it and has the directories labeled by year, select the top level directory and it will import all your years at once.

After the first year is imported, it will prompt you to enter in team abbreviations. IT IS VERY IMPORTANT THAT YOU PRESS RETURN AFTER EACH ONE, EVEN THE LAST ONE. Java seems to have a problem recognizing using the arrow key or the mouse as a way to enter and exit the table, so it will not pick up the abbreviations.

After you import a year, you can choose File->Add New Year to add another year or choose Actions->Generate HTML Reports. This will generate the baseballreference-type HTML files. Once those files are generated, they are located under your <install dir>/html/<league name> directory. There should be a index.htm file there. Double click on it and it will bring up the HTML pages.

TROUBLESHOOTING

* The application will not run! Help!

Make sure that you have Java 1.4 installed on your system! It can be found from the link above.

* The league seems to import, but it blows up on generation of HTML files.

If you have a Win9x or WinNT machine, make sure you download the MDAC 2.52 release from Microsoft.

* The awards hyperlink isn't working. What is the deal?

I'm working on it.

* What is PSN? What is XBH? I don't know these abbreviations!

I will write a glossary for all of these stats eventually. Just haven't gotten around to it yet.

* What is this 'UNK' in my player stats? He isn't from the United Kingdom!

Nope, but the utility doesn't know which team he was on from past seasons, so it lists his team as "UNK" or Unknown.

BUG REPORTING

If you have any problems, have suggestions for future releases or just want to talk, email me at rwollmuth@hotmail.com or IM me at: RWollmuth (AIM), wollmuth (Yahoo), 33233190 (ICQ) or rwollmuth (MSN).

THIS SOFTWARE IS DONATIONWARE. If you feel it is a useful addition to your OOTP experience, maybe you feel like sending me a few bucks. You can send me money a few different ways:

PayPal: You can paypal me at rwollmuth@hotmail.com

Check or Money Order to:

Ryan Wollmuth
20520 Morningside Terrace
Sterling, VA 20165

I hope this is a valuable addition to your OOTP experience.

Ryan Wollmuth

[ 06-09-2002, 11:07 PM: Message edited by: Wallman ]

Andy · 06-09-2002, 05:04 PM

I clicked on the link and got file not found

Pyroman · 06-09-2002, 05:05 PM

<blockquote>quote:<hr />Originally posted by Andy:
I clicked on the link and got file not found<hr /></blockquote>Take the period off the end.

John C · 06-09-2002, 05:06 PM

Take the period off of the EXE...the end of the sentence got caught onto the link. It will download then.

Peace
John

Andy · 06-09-2002, 05:07 PM

Thanks guys! I feel stupid now

Ryan W. · 06-09-2002, 05:08 PM

I fixed the URL. You should be able to directly click on it now...

Cooleyvol · 06-09-2002, 05:08 PM

Try this:

<a href="http://www.ootplinks.com/wallman/OOTPUtil.EXE" target="_blank">http://www.ootplinks.com/wallman/OOTPUtil.EXE</a>

[ 06-09-2002, 11:20 PM: Message edited by: Cooleyvol ]

Cooleyvol · 06-09-2002, 05:11 PM

The file is now linked on OOTPLinks.com's
"Add Ons" page.

John C · 06-09-2002, 05:32 PM

I'm running the program now. I'll have a report for those who care when it's done (if it's tonight...this is 101 seasons on a 650MB processor).

Peace
John

Tiger Fan · 06-09-2002, 06:12 PM

Just tested things out with the first 7 years of my HOB2. Reports look fantastic.

I do have one question. The awards option is not working for me. Did I do something wrong or is it not active yet?

Thanks.

John C · 06-09-2002, 06:20 PM

Tiger,

In the first post of this thread, Wallman states that the awards are not working yet. Hopefully this is something that will be working shortly; however, for now, it's a work-in-progress.

Peace
John

Tiger Fan · 06-09-2002, 06:22 PM

<blockquote>quote:<hr />Originally posted by John C:
Tiger,

In the first post of this thread, Wallman states that the awards are not working yet.
Peace
John<hr /></blockquote>You didnt really expect me to take the time to read this thread before starting to get my reports generated did you?

My bad.

John C · 06-09-2002, 06:27 PM

The only reason I read it is because I didn't know any better. ; )

Peace
John
-And knowing is half the battle...

LiveOne · 06-09-2002, 06:29 PM

Absolutely amazing....... 9 out of 10

Congrats, Wallman, this is by far the best OOTP utility EVER. I'm already dumping pages from my league site to post the new ones.

The only complaint I have is obviously unavoidable. Since it imports its data from the web pages, some stats for years before the league was started are missing, messing up the totals.

One question.... Since I'm running an active league, simming 3 times a week, how do I update the pages? Do I select "Import New Year" from the file menu and reselect the current year or do I have to start over?

One bug.... I'm running WinXP, and for some reason the shortcut on the Start Menu doesn't work. I checked to make sure it was pointing in the right direction, but I still have to go to the OOTPDBUtil folder and double-click on the batch file.

THANK YOU!!!!! THIS IS WHY I LOVE THIS GAME!!!!!!

Go Tribe · 06-09-2002, 06:51 PM

dumb question - is this for v3 AND v4? or just v4?

Scott Vibert · 06-09-2002, 07:16 PM

<blockquote>quote:<hr />Originally posted by LiveOne:
One question.... Since I'm running an active league, simming 3 times a week, how do I update the pages? Do I select "Import New Year" from the file menu and reselect the current year or do I have to start over?
<hr /></blockquote>From the README file... the utility currently has problems when you try and do the same season twice... as a result you should only import the stats at the end of each season, just before you hit proceed to next season.

<blockquote>quote:<hr />Originally posted by Go Tribe:
dumb question - is this for v3 AND v4? or just v4?<hr /></blockquote>The utility should work with both OOTP3 and OOTP4 reports.

[ 06-10-2002, 01:17 AM: Message edited by: ScottVib ]

Pyroman · 06-09-2002, 07:26 PM

Unless I am doing something wrong, I see expansion and realignment (Anything that causes the games team id to change) causing problems with the team history.

Cleveland had a team ID of 3 in my first season, but because Chicago folded in the the second season, Cleveland's new id was 2 and New York changed from 4 to 3. Now when I look at New York's History, The program thinks that Cleveland became New York. The only way I see around this is to make sure each team keeps the same team id from year to year.

Other than this, The utility is working great. Thanks for all the hard work put into this thing.

CaLíKrAzY · 06-09-2002, 07:31 PM

very very very nice, is baseball-reference happy you made a utility out of their site?

Johnny

edm · 06-09-2002, 10:11 PM

this utility sound great! one problem though. the text, after I open the program is unreadable (too small). I checked my fonts, etc. and they looked ok (although I not that that familiar with where exactly to check). I haven't noticed and text problems anywhere else either. Does anyone know what I need to change to make it larger?

here's a screen <a href="http://home.ptd.net/~edfick/ootputil.jpg" target="_blank">----HERE----</a>

thanks in advance

edm · 06-09-2002, 10:17 PM

nevermind, I fixed it. I swithed my text size from 8 to 10 and it got larger. I then switched back to 8 and now it's ok.. go figure

[ 06-10-2002, 04:19 AM: Message edited by: edm ]

06-09-2002, 05:01 PM	#1
Ryan W. Jack of all trades Join Date: Jan 2002 Location: Somewhere, not sure where. Maybe nearby, maybe far away. Posts: 1,371	Database utility now posted Guys, My database utility is now posted. It can be downloaded at <a href="http://www.ootplinks.com/wallman/OOTPUtil.EXE" target="_blank">http://www.ootplinks.com/wallman/OOTPUtil.EXE.</a> This utility takes the HTML files from the end of the year and parses them out into a database. It can then generate some fairly informative HTML pages. You need Java 1.4 installed on your system. This download can be found at <a href="http://java.sun.com/j2se/1.4/download.html" target="_blank">http://java.sun.com/j2se/1.4/download.html.</a> Click on the "Windows (US English only) and "JRE" option. It is a little bit of a download (~9 MB)... Please read the README! It is also below: OOTP Database Utility V1.0 README PREREQUISITES: - Before this program runs, it needs the following things set up on your machine: - Install the Java 1.4 JRE on your machine. This download can be found at <a href="http://java.sun.com/j2se/1.4/download.html" target="_blank">http://java.sun.com/j2se/1.4/download.html.</a> Click on the "Windows (US English only) and "JRE" option. It is a little bit of a download (~9 MB)... - If you are running Win9x or WinNT, you need to download the MDAC 2.52 release from Microsoft. This is found at <a href="http://www.microsoft.com/data/download.htm#252Info" target="_blank">http://www.microsoft.com/data/download.htm#252Info.</a> USING THE UTILITY Once the utility is launched, select File->New League Database. Select the directory where your HTML files live and click on the OK button. If you have a directory that has numerous years in it and has the directories labeled by year, select the top level directory and it will import all your years at once. After the first year is imported, it will prompt you to enter in team abbreviations. IT IS VERY IMPORTANT THAT YOU PRESS RETURN AFTER EACH ONE, EVEN THE LAST ONE. Java seems to have a problem recognizing using the arrow key or the mouse as a way to enter and exit the table, so it will not pick up the abbreviations. After you import a year, you can choose File->Add New Year to add another year or choose Actions->Generate HTML Reports. This will generate the baseballreference-type HTML files. Once those files are generated, they are located under your <install dir>/html/<league name> directory. There should be a index.htm file there. Double click on it and it will bring up the HTML pages. TROUBLESHOOTING * The application will not run! Help! Make sure that you have Java 1.4 installed on your system! It can be found from the link above. * The league seems to import, but it blows up on generation of HTML files. If you have a Win9x or WinNT machine, make sure you download the MDAC 2.52 release from Microsoft. * The awards hyperlink isn't working. What is the deal? I'm working on it. * What is PSN? What is XBH? I don't know these abbreviations! I will write a glossary for all of these stats eventually. Just haven't gotten around to it yet. * What is this 'UNK' in my player stats? He isn't from the United Kingdom! Nope, but the utility doesn't know which team he was on from past seasons, so it lists his team as "UNK" or Unknown. BUG REPORTING If you have any problems, have suggestions for future releases or just want to talk, email me at rwollmuth@hotmail.com or IM me at: RWollmuth (AIM), wollmuth (Yahoo), 33233190 (ICQ) or rwollmuth (MSN). THIS SOFTWARE IS DONATIONWARE. If you feel it is a useful addition to your OOTP experience, maybe you feel like sending me a few bucks. You can send me money a few different ways: PayPal: You can paypal me at rwollmuth@hotmail.com Check or Money Order to: Ryan Wollmuth 20520 Morningside Terrace Sterling, VA 20165 I hope this is a valuable addition to your OOTP experience. Ryan Wollmuth <small>[ 06-09-2002, 11:07 PM: Message edited by: Wallman ]</small> __________________

06-09-2002, 05:05 PM	#3
Pyroman Minors (Double A) Join Date: Jan 2002 Location: New York Posts: 158	</font><blockquote><font size="1" face="Verdana, Arial">quote:</font><hr /><font size="2" face="Verdana, Arial">Originally posted by Andy: <strong>I clicked on the link and got file not found</strong></font><hr /></blockquote><font size="2" face="Verdana, Arial">Take the period off the end.

06-09-2002, 05:06 PM	#4
John C Hall Of Famer Join Date: Mar 2002 Location: Albion, RI Posts: 2,286 Infractions: 1/0 (0)	Take the period off of the EXE...the end of the sentence got caught onto the link. It will download then. Peace John __________________ Facebook \| My Videos

06-09-2002, 05:08 PM	#6
Ryan W. Jack of all trades Join Date: Jan 2002 Location: Somewhere, not sure where. Maybe nearby, maybe far away. Posts: 1,371	I fixed the URL. You should be able to directly click on it now... __________________

06-09-2002, 05:08 PM	#7
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	Try this: <a href="http://www.ootplinks.com/wallman/OOTPUtil.EXE" target="_blank">http://www.ootplinks.com/wallman/OOTPUtil.EXE</a> <small>[ 06-09-2002, 11:20 PM: Message edited by: Cooleyvol ]</small>

06-09-2002, 05:04 PM	#2
Andy Hall Of Famer Join Date: Dec 2001 Location: Dayton, OH Posts: 2,270	I clicked on the link and got file not found

06-09-2002, 05:07 PM	#5
Andy Hall Of Famer Join Date: Dec 2001 Location: Dayton, OH Posts: 2,270	Thanks guys! I feel stupid now

06-09-2002, 05:11 PM	#8
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	The file is now linked on OOTPLinks.com's "Add Ons" page.

06-09-2002, 05:32 PM	#9
John C Hall Of Famer Join Date: Mar 2002 Location: Albion, RI Posts: 2,286 Infractions: 1/0 (0)	I'm running the program now. I'll have a report for those who care when it's done (if it's tonight...this is 101 seasons on a 650MB processor). Peace John __________________ Facebook \| My Videos

06-09-2002, 06:12 PM	#10
Tiger Fan Hall Of Famer Join Date: Dec 2001 Location: Ontario Canada Posts: 9,873	Just tested things out with the first 7 years of my HOB2. Reports look fantastic. I do have one question. The awards option is not working for me. Did I do something wrong or is it not active yet? Thanks. __________________ Cliff Markle HOB1 greatest pitcher 360-160, 9 Welch Awards, 11 WS titles

06-09-2002, 06:20 PM	#11
John C Hall Of Famer Join Date: Mar 2002 Location: Albion, RI Posts: 2,286 Infractions: 1/0 (0)	Tiger, In the first post of this thread, Wallman states that the awards are not working yet. Hopefully this is something that will be working shortly; however, for now, it's a work-in-progress. Peace John __________________ Facebook \| My Videos

06-09-2002, 06:22 PM	#12
Tiger Fan Hall Of Famer Join Date: Dec 2001 Location: Ontario Canada Posts: 9,873	</font><blockquote><font size="1" face="Verdana, Arial">quote:</font><hr /><font size="2" face="Verdana, Arial">Originally posted by John C: <strong>Tiger, In the first post of this thread, Wallman states that the awards are not working yet. Peace John</strong></font><hr /></blockquote><font size="2" face="Verdana, Arial">You didnt really expect me to take the time to read this thread before starting to get my reports generated did you? My bad. __________________ Cliff Markle HOB1 greatest pitcher 360-160, 9 Welch Awards, 11 WS titles

06-09-2002, 06:27 PM	#13
John C Hall Of Famer Join Date: Mar 2002 Location: Albion, RI Posts: 2,286 Infractions: 1/0 (0)	The only reason I read it is because I didn't know any better. ; ) Peace John -And knowing is half the battle... __________________ Facebook \| My Videos

06-09-2002, 06:29 PM	#14
LiveOne Minors (Single A) Join Date: Mar 2002 Location: Norwich, CT Posts: 95	Absolutely amazing....... 9 out of 10 Congrats, Wallman, this is by far the best OOTP utility EVER. I'm already dumping pages from my league site to post the new ones. The only complaint I have is obviously unavoidable. Since it imports its data from the web pages, some stats for years before the league was started are missing, messing up the totals. One question.... Since I'm running an active league, simming 3 times a week, how do I update the pages? Do I select "Import New Year" from the file menu and reselect the current year or do I have to start over? One bug.... I'm running WinXP, and for some reason the shortcut on the Start Menu doesn't work. I checked to make sure it was pointing in the right direction, but I still have to go to the OOTPDBUtil folder and double-click on the batch file. THANK YOU!!!!! THIS IS WHY I LOVE THIS GAME!!!!!! __________________ Brian Commish - RLB commish@retro-league-baseball.com GM NY Yankees - RLB <a href="http://www.retro-league-baseball.com" target="_blank">www.retro-league-baseball.com</a> GM Minny Twins - BBDL

06-09-2002, 06:51 PM	#15
Go Tribe All Star Starter Join Date: Dec 2001 Posts: 1,534 Infractions: 1/0 (0)	dumb question - is this for v3 AND v4? or just v4?

06-09-2002, 07:16 PM	#16
Scott Vibert Hall Of Famer Join Date: Dec 2001 Location: My Computer Posts: 8,267	</font><blockquote><font size="1" face="Verdana, Arial">quote:</font><hr /><font size="2" face="Verdana, Arial">Originally posted by LiveOne: <strong>One question.... Since I'm running an active league, simming 3 times a week, how do I update the pages? Do I select "Import New Year" from the file menu and reselect the current year or do I have to start over? </strong></font><hr /></blockquote><font size="2" face="Verdana, Arial">From the README file... the utility currently has problems when you try and do the same season twice... as a result you should only import the stats at the end of each season, just before you hit proceed to next season. </font><blockquote><font size="1" face="Verdana, Arial">quote:</font><hr /><font size="2" face="Verdana, Arial">Originally posted by Go Tribe: <strong>dumb question - is this for v3 AND v4? or just v4?</strong></font><hr /></blockquote><font size="2" face="Verdana, Arial">The utility should work with both OOTP3 and OOTP4 reports. <small>[ 06-10-2002, 01:17 AM: Message edited by: ScottVib ]</small>

06-09-2002, 07:26 PM	#17
Pyroman Minors (Double A) Join Date: Jan 2002 Location: New York Posts: 158	Unless I am doing something wrong, I see expansion and realignment (Anything that causes the games team id to change) causing problems with the team history. Cleveland had a team ID of 3 in my first season, but because Chicago folded in the the second season, Cleveland's new id was 2 and New York changed from 4 to 3. Now when I look at New York's History, The program thinks that Cleveland became New York. The only way I see around this is to make sure each team keeps the same team id from year to year. Other than this, The utility is working great. Thanks for all the hard work put into this thing.

06-09-2002, 07:31 PM	#18
CaLíKrAzY All Star Reserve Join Date: Dec 2001 Location: Costa Mesa, CaLí Posts: 722	very very very nice, is baseball-reference happy you made a utility out of their site? Johnny

06-09-2002, 10:11 PM	#19
edm All Star Starter Join Date: Dec 2001 Location: Philadelphia, PA Posts: 1,999	this utility sound great! one problem though. the text, after I open the program is unreadable (too small). I checked my fonts, etc. and they looked ok (although I not that that familiar with where exactly to check). I haven't noticed and text problems anywhere else either. Does anyone know what I need to change to make it larger? here's a screen <a href="http://home.ptd.net/~edfick/ootputil.jpg" target="_blank">----HERE----</a> thanks in advance

06-09-2002, 10:17 PM	#20
edm All Star Starter Join Date: Dec 2001 Location: Philadelphia, PA Posts: 1,999	nevermind, I fixed it. I swithed my text size from 8 to 10 and it got larger. I then switched back to 8 and now it's ok.. go figure <small>[ 06-10-2002, 04:19 AM: Message edited by: edm ]</small>