History question.

[Whiteydog95]

Is it possible to import or create a history (league champs, record books, hall of fame a la the real roster set) into a 2008 roster set such as cubbyfan's?

[Erich Ingram]

Yes

[Whiteydog95]

Originally Posted by Erich Ingram

Yes

Cool. So how do I do it? Is there a utility needed?

[Erich Ingram]

Yes you need the utility that Redsoxford created.

[Whiteydog95]

Found the utility. Thanks Erich.

[sofla97]

Originally Posted by Whiteydog95

Found the utility. Thanks Erich.

Where can I find it?

[Tony M]

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

There's a fair bit of work in importing history, and I know there isn't a readme.

1. To import team history a row must exist in teams_history.csv. If it doesn't anything in the other history files won't import.
2. Once you have re-imported the teams through the program, you can generate the structure on the League tab.
3. This then gives you the option to Generate structure CSVs which for each year gives the name of the sub-leagues and divisions which can then be edited and reloaded back with the button next to it.
4. If you add awards in via player_awards.csv, there's a button on the League tab that will iterate through players and retired and add the award winners to league history.

I haven't used it as much as someone like Erich, so I can offer technical help, but Erich has more real-life experience of it...

[Whiteydog95]

Originally Posted by redsoxford

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

There's a fair bit of work in importing history, and I know there isn't a readme.

1. To import team history a row must exist in teams_history.csv. If it doesn't anything in the other history files won't import.
2. Once you have re-imported the teams through the program, you can generate the structure on the League tab.
3. This then gives you the option to Generate structure CSVs which for each year gives the name of the sub-leagues and divisions which can then be edited and reloaded back with the button next to it.
4. If you add awards in via player_awards.csv, there's a button on the League tab that will iterate through players and retired and add the award winners to league history.

I haven't used it as much as someone like Erich, so I can offer technical help, but Erich has more real-life experience of it...

Thanks for the help.

[DiMaggio5CF]

Originally Posted by redsoxford

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

There's a fair bit of work in importing history, and I know there isn't a readme.

1. To import team history a row must exist in teams_history.csv. If it doesn't anything in the other history files won't import.
2. Once you have re-imported the teams through the program, you can generate the structure on the League tab.
3. This then gives you the option to Generate structure CSVs which for each year gives the name of the sub-leagues and divisions which can then be edited and reloaded back with the button next to it.
4. If you add awards in via player_awards.csv, there's a button on the League tab that will iterate through players and retired and add the award winners to league history.

I haven't used it as much as someone like Erich, so I can offer technical help, but Erich has more real-life experience of it...

Would it be possible to give detailed step-by-step instructions for a virtual noob? I'm looking at the program, and I have no idea what you're talking about.

[Whiteydog95]

Originally Posted by DiMaggio5CF

Would it be possible to give detailed step-by-step instructions for a virtual noob? I'm looking at the program, and I have no idea what you're talking about.

2nd that. I have not had a whole lot of time to fool with it since I posted but the couple of times I have looked I have been a bit confused.

[Tony M]

OK. I'll set about setting up some instructions on a website about how to do this.

[Whiteydog95]

Originally Posted by redsoxford

OK. I'll set about setting up some instructions on a website about how to do this.

That is great. Thanks

[DiMaggio5CF]

Originally Posted by redsoxford

OK. I'll set about setting up some instructions on a website about how to do this.

Any update on this?

[Tony M]

Tried to do it in a website, but couldn't get it to publish correctly, so I'll explain it in here.

Step 1

In OOTP, go to Database Info and export the data to CSV. This should create 61 files in the import_export directory

Step 2

Download the latest version of the importer tool from OOTP2007Editor

For importing previous years' history

You will need to definitely update the following files in the import_export directory

team_history.csv
team_history_record.csv

When determining the Sub League and Division, the Sub League is 0 for the left hand one and 1 for the right hand one. The divisions are numbered 0 upwards (unless you do a Lahman import in which case they seem to start at 1)

A row must exist for each year for each team that has a history in the team_history.csv for any import to work properly. It is possible to add history to inactive teams but since the teams.csv file doesn't list their IDs you'll need to experiment to find them (I am looking at expanding a teams.csv creater to include them)

This means if you put a record for team ID 12 and year 2005 in team_history_record.csv then a similar record for team ID 12 and year 2005 must exist in team_history.csv

If you don't know the player ID for any of the team awards they can be left blank (ie 0).

With regards to the following files

team_history_batting_stats.csv
team_history_fielding_stats_stats.csv
team_history_pitching_stats.csv
team_history_financials.csv

these can be filled in to produce things like the total financial history and pitching/batting totals, but there is no necessity for them.

Start up the importer program and click the Browse button and in the folder dialog box choose the league that you are doing the import for.

Click on the Teams tab and then click the Start button - the screen should then show you how many teams are in your database (don't worry if it doesn't correspond with what you think it should be - it includes inactive teams), and then click Load to import all the team csvs.

If you were to start OOTP and load your game you would be able to see team history on the history pages but not a league history.

Exit OOTP again if you've started it.

Click on the Leagues tab in the importer program and click Generate Structures. This will read through the teams.dat file and attempt to recreate the league structures for each year that has been added in team histories.

If you load the league in OOTP now you will see the league history has been created - you won't see the league winners and world series champion on the main history screen yet, but if you click a year sub-league link you'll get the standings. One thing you will notice is the sub-leagues are called Sub League 0 and Sub League 1 and the Divisions are similarly numbered.

Exit OOTP again if you've started it.

Click on the Generate CSVs button next to Generate Schedules and two new csv files will be created in the import_export directory.

divisions_history.csv
sub_leagues_history.csv

You can edit these files to change the SL and Div names and then click the Import CSVs button on that row in the importer program to get those changes back into the game.

Next step is to sort out the playoffs.

Click the Generate CSVs button next to Load Playoffs and this will create two new csv files

league_playoffs_history.csv
league_playoff_fixtures_history.csv

These can then be edited to set up the playoff histories and loaded with the Load CSVs button on that row. Round numbers start at 0 when entering series details.

Hopefully that helps with the creation of past history. I'll write up the other options later.

[OWill40315]

Originally Posted by redsoxford

Download the latest version of the importer tool from OOTP2007Editor

I was unable to download the editor today. Website could not be found. Is the editor available at a new location?

[Tony M]

Originally Posted by OWill40315

I was unable to download the editor today. Website could not be found. Is the editor available at a new location?

Hmmm... that's a bit odd. I'll check it out and see what's happened.

[Tony M]

OK. It's back up and available at OOTP Editor