Anderson Utilities 2006

[Comedian2004]

Still available:


http://www.planetootp.com/auballpark/

It has not been updated with any new ballparks since the initial release, since NO ONE sent me any to update it with. Lazy people.

Originally Posted by kagnew35

Larry, you had an AUBallpark utility at one time, is it defunct?

[Comedian2004]

I was writing a new program and solved a problem that has hindered some of my programs.

OOTP dumps tons of CSV files that give me tons of valuable information, however, there are some problems when they use CSV files.

They are not fixed length for each line. So, you have to read in each line, one at a time and examine each line to see if it applies to what you need.

It is not a problem for small files, such as the teams.csv or the leagues.csv file, as those files can be read in microseconds. However, bigger files, such as players.csv or even larger ones like the stat files, take a long time to load.

An example is the program I am currently working on. It is a program that tracks players home runs over their career and displays them as an HTML file.

When I read in a csv file, line by line, it looks for matches for that particular player. On some files, it stops looking when it finds the match, but some files may contain more than one match, like the stats files. So, it usually has to read in the whole file. This slows down the program quite a bit in long routines. As it reads in much, much more data than it really needs.

The plan this time around was to read in the file upon loading the league. Keep it in memory in an array and then access the array instead of loading the file each time it is needed. I do this stuff already for the players names and some other data. But it is only loading in part of the data. As in players.csv, it just loads the players names in one array, the players position in another array, etc. The problem is, there is no way that I can tell how many items are in the file, without reading the file in twice. Not a solution.

An array is like this:

dim Players() as string

now, I can redimension that to add players. I redim it after each read and redim it to the players ID. But, I can do this with an array like this:

dim Players(NumPlayers, StatFields), as I have to know how many players there are and how many fields.

Anyhow, in this example, I load in the entire players_at_bat_batting_stats.csv file and then when I want to access it again, I just access the array.

This will speed up tons of my utils and open some doors that were closed (and had a barricade) before. We are talking about a routine that took 15 minutes before, will now take 15 seconds.

Just a quick note, AUHOMERUNTRACK will work this way:

You run it anytime before you proceed to the next season. It can be run during the season, as long as the day is complete. (no unplayed games)

It will go through the above CSV file and read in all of the home runs. It will copy them over a txt file for each player, logging all of his home runs. It will keep the pitcher, team, inning, outs, men on base, was it PH, was it a close game, balls, strikes, etc.

Then when you tell it to create the HTML, it will create HTML pages for each player. (You will be able to toggle to include retired players). The HTML pages will be SION look a likes with the headers and stuff like all of your other HTML pages. It will also modify all of the players HTML pages to show a link to this html page.

Each players page will include stats, very much like the baseball reference page does.

Sorry for the long post, but this is my way to log on what I am working on.

I was really excited to be working on the HOF program, but the interest went from very little to NONE. So, I put it back on the back-burner, since it is such a complex program.

[Neags23]

Originally Posted by Comedian2004

The problem is, there is no way that I can tell how many items are in the file, without reading the file in twice. Not a solution.

An array is like this:

dim Players() as string

now, I can redimension that to add players. I redim it after each read and redim it to the players ID. But, I can do this with an array like this:

dim Players(NumPlayers, StatFields), as I have to know how many players there are and how many fields.

Anyhow, in this example, I load in the entire players_at_bat_batting_stats.csv file and then when I want to access it again, I just access the array.

This will speed up tons of my utils and open some doors that were closed (and had a barricade) before. We are talking about a routine that took 15 minutes before, will now take 15 seconds.

Larry, there may be a more memory efficient way to do this than re-instantiating the array each time.

There is a readToEnd() method in .net that will return the entire file as one huge string. Use a streamreader to do this. Assign the array to be whatever size the length of that string is (using string.length() -- then divide by 50 or so). Last, just split the string with the "\n" character using the split("\n") method, and that fills up your array.

[Comedian2004]

It does not really matter, as I found out this week. Even with it loaded into memory, it takes a while to go through the array with that many records.

I have been working on a new way, but it has not agreed with me. I have done it in the past, but I think a bug in Orcas is causing a problem.

Here is the plan...

Take games.csv as an example. I open the file and 'Seek' the location of where I am in the file. Since it is the 1st record, it will be position 1. I read in the string and then Seek again. This will return the location of the start of the 2nd string. I write these to a IDX file, which is my index file. So, now I can just load in the index file and reference it. I need the 1500th record, I check to see what position it is in the file, open the file, and SEEK that position and load in the string at that line. Wham bam, real quick.

I did this process for another project a few years ago, but I can't get it to work correctly.

It has been driving me crazy all week.

I even tried to read in each line in a stream, using readline and rewriting the line after I pad it. For some reason, it keeps adding a quote to the start of the line, which throws off the whole index.

If I can get this to work, then I could 'index' the larger files and be able to access the data quicker. The downside is that the index has to be rebuilt everytime you do a new CSV dump, but indexing an 8meg file only takes nano seconds, so it is not that bad.

So I am going to start a new program that will be an index making program

[Comedian2004]

My newsletter will come back in a few days. When my motherboard blew up the other day, I lost my 300 dollar mailing list program and have to wait for them to send me a new link for the DL of it. I just requested it today, so I hope to have it by the middle of the week.

[Dr. P.R. Park III]

Larry,

I'm having a problem with your AULogoWatchdog...problem is: I have configured everything according to your directions, took a dump, made sure the two essential parameters are checked, downloaded/unzipped your historical photos, matched the paths to the .lg file and the photos, and whenever I apply your application, I'm only getting a handful of the logos to work. For example, with my 1901 Test league, I applied your program, and only a few of the teams had logos, so I went into the saved-games folder, looked around, and all of your logos were displayed, but the ones that weren't appearing in-game looked like this "Cincinnati_Reds_2034657_240255255"...instead of "Cincinnati_Reds"...but the weird thing is all of your logos have the correct names in my photos folder, but something happens to the file name whenever I press "start". Any ideas?

[Comedian2004]

OK, delete all of the pictures that have the _32343_3434_ numbers attached. It would not hurt to delete all of the team logos from the HTML folder.

Then run the program again and hit start. It should be ok now. There is something weird with the colors and text that is appended on.

I just tried it this way and it worked fine again.

What year are you in?

I removed the color radio selection until I can check it out further. I noticed a problem when I released it, as shown in the thread, but no one replied, so I let it go.

[Comedian2004]

I have updated www.planetootp.com to show more of my utilities. Damn, I was behind on that! I am still not done, will add more when I locate them!!

[Comedian2004]

Now available:

Anderson Utilties 2007 on CD!!

Click here for ordering information.

http://www.planetootp.com/anderson_utilities_on_cd.asp

[jar2574]

Originally Posted by Comedian2004

OK, delete all of the pictures that have the _32343_3434_ numbers attached. It would not hurt to delete all of the team logos from the HTML folder.

Then run the program again and hit start. It should be ok now. There is something weird with the colors and text that is appended on.

I just tried it this way and it worked fine again.

What year are you in?

I removed the color radio selection until I can check it out further. I noticed a problem when I released it, as shown in the thread, but no one replied, so I let it go.

Thanks for fixing this. This explains why the program would work perfectly in newly formed leagues, but didn't work as well in leagues that I'd been playing for a while. The new league wouldn't have created jerseys yet, while a league that had been up and running for a while would have.

I'll try it again. Great utility.

[Neags23]

Originally Posted by Comedian2004

OK, delete all of the pictures that have the _32343_3434_ numbers attached. It would not hurt to delete all of the team logos from the HTML folder.

Then run the program again and hit start. It should be ok now. There is something weird with the colors and text that is appended on.

I just tried it this way and it worked fine again.

What year are you in?

I removed the color radio selection until I can check it out further. I noticed a problem when I released it, as shown in the thread, but no one replied, so I let it go.

Larry, any other thoughts on the colors for the logo program? I just used your guide to historical fictional leagues, and am using the logo watchdog program with much success. Getting the colors in there, too, though, would be super cool.

I'd even test it more, but the program updated to the newer version without the color checkbox. Any chance I can get the older version that had the checkbox so i can play with it a little?

[Comedian2004]

Yes, I will release another version today with the checkmark enabled. I got fustrated working with it, as it was suppose to work.

[falkonisback]

Larry, I goto your site every now and again to see if you've added any new utilities for OOTP2007. I use your AUHIstoryHint and its pretty awesome. I was wondering, I seen you added some new utilities in there, but, there are no descriptions for them...What do they do? AUPlayersHistory, AUHistoryDeluxe, AUBallpark, and AUNames?

[Comedian2004]

Currently working on re-vamping the site.

There are threads here for every single program, but in a nutshell.

AUPlayersHistory - Advanced player history editor, also does other stuff, like clean up history, add events, like pitchers win streaks, walk off home runs, etc.

AUHistoryDeluxe - another not so advanced version of above program. Was designed for one guy that had duplicate and empty lines

AUBallpark - Collection of historical ball parks, makes it easy to add real ballparks to the game

AUNames - a quick and easy program. When you import a 'historical player' like the 1957 Hank Aaron into a league, you need to know his LAHMAN ID, it gives you an easy way to get this ID without having to load the csv file into excel or go to BF to get it.

NOTE: All my programs easily uninstall from add-remove programs, so you can always try it, if you don't like it or don't need it, uninstall it. None take up very much room (except the logo and photos, and that is just the data that takes the room)

THe ballpark does NOT download all the parks, it just downloads the ones that you want.

NOTE: I think my donate button is broke on the website, none are coming in! Could some test it with a few hundred bucks?

[Neags23]

Originally Posted by Comedian2004

OK, delete all of the pictures that have the _32343_3434_ numbers attached. It would not hurt to delete all of the team logos from the HTML folder.

Then run the program again and hit start. It should be ok now. There is something weird with the colors and text that is appended on.

I just tried it this way and it worked fine again.

What year are you in?

I removed the color radio selection until I can check it out further. I noticed a problem when I released it, as shown in the thread, but no one replied, so I let it go.

Originally Posted by Comedian2004

Yes, I will release another version today with the checkmark enabled. I got fustrated working with it, as it was suppose to work.

Larry, any update on this?

[Comedian2004]

No, been swapped with the work that tries to pay the bills. Busy weekend this weekend, 3 computers to repair, plus a visit to a business to install 2 cams.

I now remember that I had promised someone that I would update it so they could test that option. Was it you. My memory works as well as Cato in 2007.

I will update the program NOW to show that option again, but with a disclaimer.

Originally Posted by Neags23

Larry, any update on this?

[Comedian2004]

Having troubles publishing it now, will have to wait until I have more time. I will try to do it sometime this weekend. I will post when I do.

[Comedian2004]

I have not sold my soul to Google Ads. Do not be afraid to click on one of those Google Ad links, help me make a few pennies. Just click on each one once, as they may yell at you if you abuse it.

[Neags23]

Originally Posted by Comedian2004

No, been swapped with the work that tries to pay the bills. Busy weekend this weekend, 3 computers to repair, plus a visit to a business to install 2 cams.

I now remember that I had promised someone that I would update it so they could test that option. Was it you. My memory works as well as Cato in 2007.

I will update the program NOW to show that option again, but with a disclaimer.

Yep, it was me, but no problem. Get to it whenever you get the chance.

Thanks, Larry!

[smaller]

Hi Larry,

Do your programs work on a Mac, too? Having played Baseball Mogul on PC in the past, I was wondering if I could edit a players' individual projected stats similarly in OOTBP2007. As far as I can tell, I can only edit the general power rating, batting rating, etc.

Thanks!