Teams Importer

[Tony M]

Hot on the heels of the importer of parks.csv, I'm about half way through coding up an importer of all the teams*.csv's back into a teams.dat file.

This will allow you to add history to your teams, or delete history by removing relevant rows from the files etc...

[DCHepler25]

Any chance this will include team financials? Or, how about a mod that reads the financials.csv from a dump back into the necessary .dat files? If that doesn't already exist. If so, can someone point me in the right direction?

Thanks, and good work on the ballpark importer. It works great and makes editing much easier than the in-game method!

[Tony M]

Originally Posted by DCHepler25

Any chance this will include team financials? Or, how about a mod that reads the financials.csv from a dump back into the necessary .dat files? If that doesn't already exist. If so, can someone point me in the right direction?

Thanks, and good work on the ballpark importer. It works great and makes editing much easier than the in-game method!

If you download the Stadium importer from http://www.bourtonville.co.uk/OOTPStadium.zip it now has an import teams from ootp csv button.

It does financials - it took a bit of programming to get it correct because the financials are stored year by year in the history but the regular team record has current financials and last season financials (redundancy I assume put in for speed on the Front Office screen). There are also two fields in the team record that store the end balance for last season and current season and I've just zeroed them because I can't see a way to work them out because there are figures that just say 'total from trades' etc. These being zeroed might cause a following year budget to be higher or lower...

The only thing I know you will lose when importing from csv is your depth charts/lineups and pitching setup as these aren't exported anywhere. There is probably other stuff that is lost, but it's nothing that is obviously up front.

[Tony M]

note,

this only works for ootp2007 created csv's.

I've uninstalled my 2006 so can't check the format of those. Does 6.5 do export to csvs? If so and anyone wants to send an example of the 6.5 team csvs drop me a pm and I'll give you my email address and I'll add an import from 6.5 csvs to OOTP2007 format - and if you have the player ones as well that would be even more handy as I'll have the player imports done soon. I'm guessing this would clear up a lot of the issues regarding 6.5>2007 migration and the history.

[CBLCardinals]

will this program allow mass data dumps to an existing league?

I'd LOVE to be able to add MLB team history, past stats, etc to a league I've been playing since 2004...

To what extend can you add team data? MVP's by year, etc?

[Tony M]

Originally Posted by CBLCardinals

will this program allow mass data dumps to an existing league?

I'd LOVE to be able to add MLB team history, past stats, etc to a league I've been playing since 2004...

To what extend can you add team data? MVP's by year, etc?

Good question.

I'm just starting a fictional ML in 2000 and going to sim it through to 1/1/2007 and then start a new fictional ML in 2007 and stick the csvs from the original game in the new games import_export directory and see what happens.

In order to do things such as MVPs you'd need to know their player ids as this is what is in the csv files. This would be MVP for each team, not the league. Rebuilding a league history would be more of a challenge as I don't think there is quite enough data in the csv's to accurately recreate world.dat.

[CBLCardinals]

Originally Posted by redsoxford

Good question.

I'm just starting a fictional ML in 2000 and going to sim it through to 1/1/2007 and then start a new fictional ML in 2007 and stick the csvs from the original game in the new games import_export directory and see what happens.

In order to do things such as MVPs you'd need to know their player ids as this is what is in the csv files. This would be MVP for each team, not the league. Rebuilding a league history would be more of a challenge as I don't think there is quite enough data in the csv's to accurately recreate world.dat.

If that's successful then I could potentially import a Lahman DB league 1900-2003, then import the real MLB history from that file into my current league?

That would be FANTASTIC if it works that way!!

[Tony M]

Originally Posted by CBLCardinals

If that's successful then I could potentially import a Lahman DB league 1900-2003, then import the real MLB history from that file into my current league?

That would be FANTASTIC if it works that way!!

Updated version on the website. Forgot to enable the Import button.

For team statistics this copying them across from one to the other seems to work ok, subject to a few caveats.

The original csv's must be created during a pre-season. I tried it on the 1/1 and the files still held the 'current' season standings which when I imported into a blank league gave all the teams more wins and losses than they should have had (the last season was replicated).

The game into which data is being loaded must also be in pre-season.

The csvs must be exported from the new game and in copying over the csvs from the old game, the team_roster.csv and team_roster_staff.csv must not be copied over otherwise the database gets out of sorts with the players file saying players are on one team and the teams' rosters saying otherwise.

[CBLCardinals]

maybe I overlooked it but I could not find the link for this utility?

thanks in advance

[Tony M]

Originally Posted by CBLCardinals

maybe I overlooked it but I could not find the link for this utility?

thanks in advance

it's in post #3

http://www.bourtonville.co.uk/OOTPStadium.zip

[DCHepler25]

Thanks Redsoxford! I can't wait to try this out. I had great success with the stadium importer. It was so much faster than the OOTP Park editor!

[DCHepler25]

Questions:

Which .csv do I need to edit? I made changes to teams, team_financials, and team_last_financials but upon importing them, the changes did not take.

Also, you said about the date. My league is on January 1, should I sim ahead to a different date to have these work?

Thanks for any help!

[Tony M]

Originally Posted by DCHepler25

Questions:

Which .csv do I need to edit? I made changes to teams, team_financials, and team_last_financials but upon importing them, the changes did not take.

Also, you said about the date. My league is on January 1, should I sim ahead to a different date to have these work?

Thanks for any help!

The date is only relevant if you're importing csv's from a different league folder into a new league.

Did you quit the game or at least load up another league when you ran the mod?

If the mod ran successfully you should see in your .lg directory a teams_xxxxxxxxxxxx.dat where the xxxx is the date-time the backup was made. If that file doesn't exist, then the mod didn't run successfully. I'm tidying it up so that it gives you a clue as to why it didn't work.

[DCHepler25]

Originally Posted by redsoxford

The date is only relevant if you're importing csv's from a different league folder into a new league.

This is good to know.

Did you quit the game or at least load up another league when you ran the mod?

Yes, I had OOTP shutdown when I ran the utility.

If the mod ran successfully you should see in your .lg directory a teams_xxxxxxxxxxxx.dat where the xxxx is the date-time the backup was made. If that file doesn't exist, then the mod didn't run successfully. I'm tidying it up so that it gives you a clue as to why it didn't work.

Thanks again. This will really help too!

[Tony M]

Hopefully this link will work

http://www.bourtonville.co.uk/OOTPEditor/publish.htm

It's a bit clearer on there now.

You choose the saved game directory at the top and then click on either Ballparks or Teams (Players will be added today or tomorrow)

Click on the Start button to verify the location, and then click on Load to load up the CSVs. Any errors will appear in the text box, and an error.txt file will be created in the saved game .lg directory. If it doesn't pop up with a message box saying it has loaded successfully, you'll need to email me that file and I'll have a look and see what's going on.

It works fine at my end. I just created a fictional ML setup, exported the files and then changed all the team nicknames to the proper ones, and reimported the csvs and they were all shown correctly.

[Tony M]

dola,

One other thing, raised by DCHepler, is that all the files need to be in an export to csv. I'd never noticed the options before to deselect files, but for this to work you'd need all teams csvs to be produced.

[MrHaroldG]

Awesome! Do you plan to do an importer for the coaches also?

[Tony M]

Originally Posted by MrHaroldG

Awesome! Do you plan to do an importer for the coaches also?

There will be one. One thing I can say with that is that coaches managerial history will be lost as it is not included in a csv dump. A coaches history not only contains his record, but the batting, pitching, fielding and financial stats for that season.

[Muzamba]

I'm having a bit of trouble...

I decided to do a quick test before I began mass-editing information. Glad I did, because the game keeps crashing on me after I've run the program.

For my test, I simply changed a single team nickname. (Don't know. Maybe that causes a problem for some reason?) Anyway, here's the step-by-step process I went through:

1. Opened OOTP, went to Game Setup, and picked "Extract data to CSV" from the "Import/Export" menu.

2. Shut down OOTP and opened up the "import_export" folder in my saved game's folder.

3. Opened teams.csv and changed one team nickname, then saved the file and closed it.

4. Opened up the Teams Importer, browsed to my saved game folder, selected the Teams tab, and clicked the Start button. Once it said teams.dat was loaded successfully, I clicked the Load button. After a few moments, the alert box popped up and said it teams.dat was created, as was (luckily) a backup.

5. Closed out the Teams Importer and started OOTP again. When I clicked on Continue Game, it went through the normal file-loading process, but once it got to 100% and said Checking Database, it crashed.

Here's what the error log had to say about my misfortune...

----- 2007-06-06 08:32:04 -----
Message : Index was outside the bounds of the array.
Source : OOTP2007Editor
StackTrace : at OOTP2007Editor.MainScreen.cmd_TLoad_Click(Object sender, EventArgs e)

After repeating this about a hundred times, it then said...

----- 2007-06-06 08:32:05 -----
Message : The given key was not present in the dictionary.
Source : System
StackTrace : at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.SortedDictionary`2.get_ Item(TKey key)
at OOTP2007Editor.MainScreen.cmd_TLoad_Click(Object sender, EventArgs e)

...and repeated THIS about a hundred times also.

Ok, doc. So what's the diagnosis?

[Tony M]

Originally Posted by Muzamba

3. Opened teams.csv and changed one team nickname, then saved the file and closed it.

DCHepler had an issue as well, and he sent me through his teams.csv file and it had commas missing at the end of some lines and this causes problems.