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.
