OOTP Database Converter

[actionjackson]

Originally Posted by DrDoom

Is it possible for one of the Forum Moderators to simply move this thread there?

Not sure. Just thought it deserved some eyeballs, and was thinking out loud.

[ldambrosa]

Thanks, Dr. Doom, this is sure to come in handy. I had a converter from previous years which worked but seemed to have some glitches.

[actionjackson]

Way, way, way too early to ask, DrDoom, but any idea on turn around time once OOTP23 drops?

[ldambrosa]

I did try it out on the OOTP23 stats.odb file and it worked. I have not taken the time to verify it's accuracy, but it did go through the steps with no issues.

[actionjackson]

Originally Posted by ldambrosa

I did try it out on the OOTP23 stats.odb file and it worked. I have not taken the time to verify it's accuracy, but it did go through the steps with no issues.

Thanks so much for posting this!

[spanky8992]

If i followed these directions, would i be able to add japanese hall of famers into the database?

[Mister_G]

Originally Posted by actionjackson

Hmmm...Did you get this Spritze from my links, or was it somewhere else? I'm not seeing the additional three in mine, and I also have the nine. Which of the nine .csv files are you missing when you go to convert to .odb files?

My suggestion would be to grab both 18 and 19 from my links. Extract 18 and 19 to your OOTP21 or OOTP22 stats folder. Oooh...Just thought of something. Are you using the OOTP 21 Database Converter or the OOTP 22 Database Converter with your OOTP22 game? You must use the OOTP 22 Database Converter with OOTP22. DrD's been very insistent on that throughout this thread. Because I'm using OOTP21, I'm using the OOTP 21 Database Converter, but you will definitely need the OOTP 22 Database Converter. Apparently, they don't play nice, unless they're with their specific games. So:

1) See which Database Converter you are using, and make sure it aligns with the game version you are playing, and:

2) If that does not work, do a fresh download/extract of Spritze 18 and 19, using my links.

I'm also remembering now that initially when I extracted the .csv files from the original four Spritze .odb files, I wound up with only 23 .csv files, instead of the normal 33. I went and checked with the default db, and copied over the missing .csv files, and that brought the number to 33, and since then, it's worked a charm.

The reason I set up the Google Drive downloads is that the Spritze DB is too large to send by email, so that's out. You don't need me to send you anything. Fill in any missing .csv files with the appropriate .csv file from the default stats_csv folder that you're gonna convert your stats folder to.

So, what you should do is have two different sets of three folders in your C:\temp folder. The default set: An (hopefully) unadulterated copy of the stats folder that ships with the game in C:\temp, as DrD suggested you set up. Use the converter for OOTP 22 to convert those files to .csv files, which go in the second folder: stats_csv, and then to convert back to the .odb files, sending those to the third folder: stats_modified. There is also a stats.odb file in the default stats folder. Probably need that one too. And there's a draft_list.csv file in there as well. Those may or may not get converted from the stats_csv folder. I don't think they do, so if you want them, copy/paste them into your stats_modified folder.

Now, do the same thing for Spritze, using an unadulterated copy of Spritze 19. If you need a new one, you know where to find it. Your three folders would be: spritze_stats, spritze_stats_csv, and spritze_stats_modified. You would convert the fresh contents of the spritze_stats folder into .csv form, and that goes in the spritze_stats_csv folder. Copy over any .csv files that you see in the stats_csv folder, that you do not see in the spritze_stats_csv folder. The total number of folders should now be 33.

I just checked with a backup Spritze 19. It will convert 23 .csv files over to your spritze_stats_csv folder. You're going to need the other 10 from the default stats_csv folder, to make it work. Thankfully, by the process of elimination, I can name them all for you. They are: AllstarFull.csv, AwardsManagers.csv, AwardsPlayers.csv, BattingPost.csv, FieldingPost.csv, HallOfFame.csv, Managers.csv, PitchingPost.csv, RecordsSingleGame.csv, and TeamFranchises.csv. Even in alphabetical order!

Copy those ten files from the stats_csv folder, that houses the .odb to .csv converted data from the default stats folder over to .csv files, and paste each file into your spritze_stats_csv folder. You should now have 33 .csv files in your spritze_stats_csv folder.

Just figured something else out. You're going to need both Spritze 18 and 19. Spritze 19 only comes with the historical_database.odb file. You will need to copy the historical_lineups.odb, the historical_minor_database.odb, and the historical_transactions.odb files from 18 into 19. That may be the bork up that's creating those extra three "unknown" .csv files that you're seeing. Probably, you should do a fresh download/extract of 18 and 19 at this point. Extract the 18 and 19 folders into your OOTP Baseball 22 > stats folder, so you don't overwrite anything, and they are separate from the stats folder, but within the stats folder.

Also, when you've made your conversions back to .odb files in the stats_modified or spritze_stats_modified folders, you're going to want to copy/paste them. The stats_modified folder should be pasted to your OOTP Baseball 22 > stats folder, and the spritze_stats_modified folder should be pasted to your stats > SpritzeHSforOOTP19 folder. Always do this to make sure that:

1) You never overwrite the original files, and

2) Your edits don't become victims of the latest patch updates.

You will also have to reset your in-game database path (where your new amateur draftees come from), from OOTP Baseball 22 > stats to OOTP Baseball 22 > stats > stats_modified, or OOTP Baseball 22 > stats > SpritzeHSforOOTP19 > spritze_stats_modified, depending on whether or not you're using Spritze as your main database, or the default as your main database.

Well, that should confuse the heck out of you. As for PMs. We can do that too, but doing it this way also has the potential to help others who are trying to figure this stuff out, so I'll leave that up to you. If it does confuse you, ask questions, and I'll try to get to them when I can. Cheers.

Hey, I'm sorry if this has already been answered but I've had lots of trouble utilizing the Spritze database correctly in the past. I know some fo what I'm about to type is off-topic, but I plan to use the converter where necessary to make some edits...

My ultimate goal is to use real players in a fictional universe with fictional teams including minors, and having these real players appear in the draft or free agent pool at the appropriate time so that they are able to develop in the minors first. I assume there is only one copy of each player in the Spritze DB?

Firstly, am I doing this correctly by just replacing the master.csv and historical_database.odb in the stats folder with the ones I downloaded in your sig? Is that the most basic way to get the database in the game?

Secondly, can anyone point me in the right direction of how to assemble draft classes (I might want to take a few players out here and there) and import them along the lines of how I described earlier?

I have attempted this feat in past years and every time I do I run into a problem such as duplicate players, out of wack ratings, missing players, wrong years, weird ages etc. causing me to run out of steam on my ultimate goal of getting up to modern day with totally new leagues/teams but real players.

Any help with any of this idea would be appreciated! Again, I don't even remember what folder to drop the database in anymore!

NOTE: This post has been edited for clarity.

[actionjackson]

Originally Posted by Mister_G

Hey, I'm sorry if this has already been answered but I've had lots of trouble utilizing the Spritze database correctly in the past. I know some fo what I'm about to type is off-topic, but I plan to use the converter where necessary to make some edits...

My ultimate goal is to use real players in a fictional universe with fictional teams including minors, and having these real players appear in the draft or free agent pool at the appropriate time so that they are able to develop in the minors first. I assume there is only one copy of each player in the Spritze DB?

Firstly, am I doing this correctly by just replacing the master.csv and historical_database.odb in the stats folder with the ones I downloaded in your sig? Is that the most basic way to get the database in the game?

Secondly, can anyone point me in the right direction of how to assemble draft classes (I might want to take a few players out here and there) and import them along the lines of how I described earlier?

I have attempted this feat in past years and every time I do I run into a problem such as duplicate players, out of wack ratings, missing players, wrong years, weird ages etc. causing me to run out of steam on my ultimate goal of getting up to modern day with totally new leagues/teams but real players.

Any help with any of this idea would be appreciated! Again, I don't even remember what folder to drop the database in anymore!

NOTE: This post has been edited for clarity.

Oof. Haven't been around in a long time. Thank goodness you only posted five days ago. My goal in posting his final two pieces of art was to make sure people would have access to them for as long as I'm around. The reason it's the last two, is that the Master is far more comprehensive in the second last one, and the last one is the most up to date one. You can use the Master from the second last one, so you have a more comprehensive view of who you're bringing in with his final DB.

I do not use the Spritze DB for MLB players. I use it exclusively for players that were never given a chance to play in MLB. I also play Random Debut leagues exclusively. I bring in two Spritze guys in each of my five round amateur drafts, including at least one Negro Leaguer in every draft. I put a full round of them in my Inaugural Draft (44 rounds + 1 round of Spritze guys = 45 rounds = 45 players per team to start), including at least eight Negro Leaguers. These players are selected randomly from the Spritze DB, so they could be famous non-MLBers, or guys you've never heard of. As the amount of teams involved (16 to start in 1901) increases, so does the number of guys I bring in, but not by much. I'm not there in my game yet, but I can see myself adding one Spritze guy when MLB goes to 24 teams in 1969, and another one when MLB goes to its current amount of 30 teams in 1998. I hope to get past wherever real life MLB is at when I get there, and add Portland and Montreal to bring the total to 32 teams.

As I do not use the Spritze for MLB guys, it is not my primary database. What I do instead is extract the Spritze folder into the default Stats folder (the folder where all the historical players, stats etc are). That allows me to switch back and forth between the default Stats folder and the Spritze folder, depending on who I'm trying to bring in.

The main reason I do this is that I prefer the default DB for MLBers. Having tried both DBs, the MLBers in the default DB feel more realistic. The ratings seem to be well done. The careers unfold as I think they should. It just "feels right". Spritze did an excellent job of capturing Negro Leaguers, and others that didn't get to play in MLB though, so I use that DB to represent those players.

I'm not sure I can help with your other questions, as I've never played that way, even though it's more of a "normal" way to do so. I don't use minor leagues, but instead use unlimited reserve rosters. This helps me avoid the waiver system, which I have never, nor will I probably ever, understood. I hope this answers as many of your questions as I can, given that the difference in how we play, makes it impossible for me to answer all of them.

[actionjackson]

Originally Posted by spanky8992

If i followed these directions, would i be able to add japanese hall of famers into the database?

I would think so. I wouldn't know for sure though, because my way of playing is to import guys, who didn't play in RL MLB, using the Spritze DB. There are guys that did play in both MLB, and pro leagues before/after MLB, of course, and I check in with Spritze to see if he has their numbers in whatever other professional league(s) they played in, and adjust accordingly. As you might expect, this DB Converter is an excellent tool for doing that.

[Mister_G]

Originally Posted by actionjackson

I would think so. I wouldn't know for sure though, because my way of playing is to import guys, who didn't play in RL MLB, using the Spritze DB. There are guys that did play in both MLB, and pro leagues before/after MLB, of course, and I check in with Spritze to see if he has their numbers in whatever other professional league(s) they played in, and adjust accordingly. As you might expect, this DB Converter is an excellent tool for doing that.

I see what you're saying.
Do you think I could use the Minor League Master List as a base, copy over any Major Leaguers from the Major League List who never played in the minors or debuted in the Majors first, and also copy over Japanese Leaguers from Spritze and put them all in one list? Then sort by debut year, take players out if I wanted to, then create .txt files for each draft class I want to import? And would the converter help me with this?

[MarkInCincy]

I tried it with the 22 version but the minor's master file is dorked

[actionjackson]

Originally Posted by Mister_G

I see what you're saying.
Do you think I could use the Minor League Master List as a base, copy over any Major Leaguers from the Major League List who never played in the minors or debuted in the Majors first, and also copy over Japanese Leaguers from Spritze and put them all in one list? Then sort by debut year, take players out if I wanted to, then create .txt files for each draft class I want to import? And would the converter help me with this?

I'd be careful with Spritze. I've taken it out of my signature because I just noticed a bug that doesn't allow any RL RF to have their defensive stats imported, so nobody can play RF at the start of a game. I suppose they could learn it as they go along, but I would imagine it would cause quite a lot of chaos, until that happens. Seeing Clemente and Barfield come in without the ability to play RF was very jarring. Really strange.

[actionjackson]

Originally Posted by MarkInCincy

I tried it with the 22 version but the minor's master file is dorked

What's dorked about the MiLB Master file? I might be able to fix it for my DB, which is linked to in my signature. I scrubbed the issue where two players were getting identical MLB IDs, and only one had actually played in the majors in their career, which resulted in bizarre looking crossover stats.

I've also gotten rid of the bug in the MLB Master file, where two major leaguers get the same MLB ID, which crosses over their RL stats, AKA the Jerome/Jeff Williams, and Will/Willie Harris bug. Anything else you can pinpoint for me would really help, or if you can't pinpoint it, give me the specific issue that you're seeing in game, and I can backtrack from there.

[actionjackson]

Originally Posted by spanky8992

If i followed these directions, would i be able to add japanese hall of famers into the database?

I added Fed Leaguers to mine, so I would imagine the answer is yes. Be sure to fill in all of the appropriate .csv files though. Batting, Batting-Normalized (identical to batting, so it's a copy/paste thing - I think the game performs some voodoo magic on it to neuter the stats during the import process), Fielding, FieldingOF (if the stats don't distinguish between LF, CF, and RF), Master, Pitching, and Pitching-Normalized (same as the Pitching.csv). You may want to fill in the MiLB stuff as well, if you have access to that. That's all you should need, unless you use Lineups, and Transactions, but I would imagine those would be a real bear to come by, and wouldn't really make sense, because the players you're adding never played in MLB.

[actionjackson]

Originally Posted by actionjackson

What's dorked about the MiLB Master file? I might be able to fix it for my DB, which is linked to in my signature. I scrubbed the issue where two players were getting identical MLB IDs, and only one had actually played in the majors in their career, which resulted in bizarre looking crossover stats.

I've also gotten rid of the bug in the MLB Master file, where two major leaguers get the same MLB, which crosses over their RL stats, AKA the Jerome/Jeff Williams, and Will/Willie Harris bug. Anything else you can pinpoint for me would really help, or if you can't pinpoint it, give me the specific issue that you're seeing in game, and I can backtrack from there.

Unless, of course, you're talking about the MiLB Master, and other files in Spritze. Those may indeed be dorked. It's still a handy DB to have on hand, if you want to add in ratings for players that never played in MLB, but I wouldn't try to directly copy it in there. I manually added in stats from the Fed League, and then used Spritze for some of the defensive ratings. Haven't come across a problem yet, but gremlins have an unfortunate habit of borking things up, for those of us that want to get more out of the default DB. They need squishing, if you find them.

[actionjackson]

I'd be willing to bet cash money that the MiLB Fielding.csv file exceeds the maximum number of rows allowed in your spreadsheet program of choice, which is 1,048,576. With nearing 165,000 players in there, plus possible multiple positions for each player over careers lasting an average of 4 or 5 years, and the possibility of playing for multiple organizations in any given year, it just has to. I think that means it can still be squeezed in there, but editing needs to be done in a text editor. Wild stuff to think I used to wonder why the hell they had so many dang rows. The number of individual cells in there must be mindblowing.

[ra24mpa]

I've tried using this (the converter for OOTP 22 on OOTP 23) to clean up the early history of the game, and although it works to some extent, I have a few questions because I can't seem to get certain things to happen. What I'm trying to do is have it so the 19th century World Series matchups between the National League and American Association are counted on the league history page. I can create a hypothetical matchup between the NL and AL team in 1904, have both teams show up as their respective league champions and have a World Series winner underlined, but I can't seem to get anything to show up during the 19th century. I've made the necessary changes to the Team file and the SeriesPost file (like changing any abbreviations for the AA to AL, and nothing. Not even the respective league champions. Am I overlooking something, or is this hard-coded for MLB pre-1901 and beyond the scope of what I'm trying to accomplish? Also, is it hard-coded that the league history must start in 1871? I know there's some data out there that can be used to piece together some history before 1871, but the game doesn't seem to recognize it. If it isn't hard-coded, how do I move the first year around? I'm thinking about using this to give a league history to some of the Indy leagues in one of my mods, but having a bunch of blank history between 1871 and the 1990s/2000s probably won't look that great.

[plannine]

Originally Posted by DrDoom

I've merged my database conversion tools into a single program with a simple to use GUI for both Windows and MacOS.

The program is much more straight forward now. Simply select a folder where the files you want to convert are stored and a folder where you'd like the newly created files to be saved and click the appropriate convert button.

User Guides

OOTP 21 Database Converter User Guide (Windows)

OOTP 21 Database Converter User Guide (MacOS)

Database Converter

OOTP 21 Database Converter (Windows)

OOTP 21 Database Converter (MacOS)


Any Updates for OOTP24?

OOTP 22 Database Converter (Windows)

OOTP 22 Database Converter (MacOS)


Feel free to reach out to me if you have any issues running the program.

Note: The OOTP 21 Database Converter is strictly compatible with OOTP Baseball 21 and the OOTP 22 Database Converter is strictly compatible with OOTP Baseball 22. They cannot be used interchangeably or for other versions of the game.

Please ALWAYS back up the original databases before replacing them with your modified ones.

Any updates for OOTP 24???

[Mifr44]

Originally Posted by plannine

Any updates for OOTP 24???

I was wondering the same thing.

[Mifr44]

It appears the development on this tool stopped with OOTP 22, but it worked with OOTP 23 based on someone's comments. Has anyone tried it with OOTP 24? Sadly, I don't think the source code was posted for this project, although there were hints that might happen. I really could use this tool or a similar one with OOTP 24.