OOTP Developments Forums - View Single Post

terpsfan101 · 05-17-2010, 08:41 PM

There are two ways you can get the correct history to import. Both methods require you to use the neutralized version of the database. I used the first method in OOTP10. The second method didn't work in last years version of the game, but supposedly worked in OOTP9 and previous versions of the game. I haven't tested either method out yet in OOTP11.

1. Import the batting, pitching, fielding, and fieldingOF tables from Spritze or Gambo's database in MS Acess. Then import the batting, pitching, fielding, and fieldingOF tables from the Lahman database. Delete all previous years from Gambo/Spritze's batting, pitching, fielding, and fieldingOF tables prior to your starting year. If your starting in 1920, then delete everything prior to 1920. Then append the statistics from the lahman database from 1871-1919 to the batting, pitching, fielding, and fieldingOF tables. Export your tables, and select import entire history. Warning, if you don't have a lot of memory (less than a Gigabyte), you will have to increase the size of your paging file. I would say your memory + paging file has to equal approximately 2 GB, or the game will crash when trying to load the database during the initial league creation.

2. Replace the fake Major league statistics in Spritze's/Gambo's database with blank stat lines in the batting, pitching, fielding, and fieldingOF tables. Basically, you begin with the standard Lahman batting, pitching, fielding, and fieldingOF tables, and do an update query with the Spritze/Gambo tables. Once Spritze fixes the teamID's in his databases and Gambo releases his database, I am going to see if this method works in OOTP11. If it does work successfully, I'll make available a modified version of their databases (with their permission).

05-17-2010, 08:41 PM	#130
terpsfan101 Minors (Rookie Ball) Join Date: Feb 2010 Posts: 31	There are two ways you can get the correct history to import. Both methods require you to use the neutralized version of the database. I used the first method in OOTP10. The second method didn't work in last years version of the game, but supposedly worked in OOTP9 and previous versions of the game. I haven't tested either method out yet in OOTP11. 1. Import the batting, pitching, fielding, and fieldingOF tables from Spritze or Gambo's database in MS Acess. Then import the batting, pitching, fielding, and fieldingOF tables from the Lahman database. Delete all previous years from Gambo/Spritze's batting, pitching, fielding, and fieldingOF tables prior to your starting year. If your starting in 1920, then delete everything prior to 1920. Then append the statistics from the lahman database from 1871-1919 to the batting, pitching, fielding, and fieldingOF tables. Export your tables, and select import entire history. Warning, if you don't have a lot of memory (less than a Gigabyte), you will have to increase the size of your paging file. I would say your memory + paging file has to equal approximately 2 GB, or the game will crash when trying to load the database during the initial league creation. 2. Replace the fake Major league statistics in Spritze's/Gambo's database with blank stat lines in the batting, pitching, fielding, and fieldingOF tables. Basically, you begin with the standard Lahman batting, pitching, fielding, and fieldingOF tables, and do an update query with the Spritze/Gambo tables. Once Spritze fixes the teamID's in his databases and Gambo releases his database, I am going to see if this method works in OOTP11. If it does work successfully, I'll make available a modified version of their databases (with their permission).