Stadium Importer

Tony M · 05-06-2007, 08:15 AM

I've been looking into the idea of a stadium importer mod. The easiest way I can see to do that is to have a csv file of the same format as the exported one from the game and add a column saying team name so that the team can be assigned the correct park.

I was thinking of basing it on the Gambo spreadsheet but it doesn't list weather for the parks, and for some reason the weather data is stored against parks and not cities, but as far as I can see all the relevant data that appears in the OOTP export file is also present in Gambo.

I just need to finalise the writing back of teams.dat to complete this task as parks.dat is fairly simple.

I just wanted to check that the Gambo spreadsheet is the main source of this data for dimensions and factors and that there aren't others out there?

neojonas · 05-06-2007, 02:21 PM

I always use Gambo's and it seems to be the best resource.

Gambo · 05-16-2007, 12:37 AM

I may be biased but I know it's the best!

Tony M · 05-24-2007, 09:39 AM

I've put up the first attempt at a ballpark importer at http://www.bourtonville.co.uk/OOTPStadium.zip

Unzip the file and then double click the OOTP Stadium Importer.application to install it.

How this works is as follows:

1. Start the program and exit OOTP
2. Choose your saved league directory by clicking on the ... next to the Saved Game Dir text box and navigating to it.
3. On the first go through only the top button will be enabled as there isn't an import file made at that point. Click on create new format CSV and when the other button has become enabled it has finished the first stage.
4. If you look in your saved league directory you will see a file called parks_output.csv - open this up in Excel or any other spreadsheet and you'll see the main parts of stadium data. Each park will have its teams listed against it as well. Make the changes to the data that you want and save it back as csv with the same name 'parks_output.csv'
5. Click the Import Ballparks button and it will read the file back in and update teams.dat and parks.dat

Points to note

a. It doesn't allow addition or deletion of stadiums.
b. If a team is allocated to more than one stadium, they'll be allocated the last one in the list.
c. If a team is mispelled in the list it won't get allocated its rightful stadium.
d. A ballpark can have up to five teams that play there.
e. A back-up of both teams and parks.dat are created so if it screws up you can delete teams.dat and parks.dat and rename the last backup copy.

I know it's not the same format as Gambo's list but I was trying to find someway of tying up a park to a team as well.

Gambo · 05-25-2007, 12:05 AM

Looking Good! I can just tweak the stadium chart to match up better for the importer...

the only other thing I think it may be missing in setting up the ballpark photos and places. Are you planning on touching on those things?

Tony M · 05-25-2007, 03:33 AM

Quote:

Originally Posted by Gambo

Looking Good! I can just tweak the stadium chart to match up better for the importer...

the only other thing I think it may be missing in setting up the ballpark photos and places. Are you planning on touching on those things?

Yep, I'll add them to the file. I just wanted to make sure the principle worked.

galaril · 05-26-2007, 06:18 PM

So does this have the changes already done or do we still have to make all the manual changes just using this utility? Since I don't have excel on my home pc I am asking if the ballpark_csv is already set up or not?

Tony M · 05-26-2007, 07:12 PM

Quote:

Originally Posted by galaril

So does this have the changes already done or do we still have to make all the manual changes just using this utility? Since I don't have excel on my home pc I am asking if the ballpark_csv is already set up or not?

No it doesn't. The problem with making up one correct to start with is that it might not match up with the team names that are in your game. A standard ML fictional league will have different nicknames every time you set it up, and unless you go through and manually edit all 212 (I think) team nicknames, a default stadium file won't be much use.

galaril · 05-26-2007, 07:36 PM

Quote:

Originally Posted by redsoxford

No it doesn't. The problem with making up one correct to start with is that it might not match up with the team names that are in your game. A standard ML fictional league will have different nicknames every time you set it up, and unless you go through and manually edit all 212 (I think) team nicknames, a default stadium file won't be much use.

Oh so this is really best used with a fictional ML world not say playing with the 2007 rosters? BTW, what does the game come with as far as stadium dimensions for each team does it have arandomge nerator or is it the same with evry team same ballpark? Just curious.

Tony M · 05-29-2007, 05:43 AM

I've updated the program at the link above. It now allows you to re-import directly the parks.csv that is generated in the import_export directory when you do a CSV data dump.

This means all the fields are changeable and stadiums can be deleted and added at will from that file, but it loses the link between a stadium and a team.

So if you do a standard ML setup and export parks.csv and change Park ID 1 to be Fenway Park, you'll find the Orioles playing there.

My next task is to import the teams csvs and that should enable the two sets to be tied together that way and allow history to be imported.

Gambo · 05-29-2007, 10:53 PM

Even Better! This is going to be awesome when it's finished... still curious as to when you can get to implement the photo file info... once you get the columns set i'll restructure a ballpark chart for it and maybe add in a few more stadiums.

spanishfly · 06-11-2007, 11:33 AM

Quote:

Originally Posted by Gambo

Even Better! This is going to be awesome when it's finished... still curious as to when you can get to implement the photo file info... once you get the columns set i'll restructure a ballpark chart for it and maybe add in a few more stadiums.

Anything like this for Mac?

Geebob · 07-17-2007, 07:56 PM

bumpski

eriqjaffe · 11-17-2011, 08:55 PM

Sorry to bump a 4-year-old thread, but does anybody out there have a copy of this? Tony's links are all dead now.

Gambo · 11-18-2011, 12:25 AM

I may be wrong but I don't think it works anymore since they restructured the parks.dat file. Kinda sucks if it still works since I stopped using it.

eriqjaffe · 11-18-2011, 05:54 PM

Quote:

Originally Posted by Gambo

I may be wrong but I don't think it works anymore since they restructured the parks.dat file. Kinda sucks if it still works since I stopped using it.

Thanks, I was kind of afraid of that.

05-06-2007, 08:15 AM	#1
Tony M Global Moderator Join Date: Feb 2006 Location: Here Posts: 6,156	Stadium Importer I've been looking into the idea of a stadium importer mod. The easiest way I can see to do that is to have a csv file of the same format as the exported one from the game and add a column saying team name so that the team can be assigned the correct park. I was thinking of basing it on the Gambo spreadsheet but it doesn't list weather for the parks, and for some reason the weather data is stored against parks and not cities, but as far as I can see all the relevant data that appears in the OOTP export file is also present in Gambo. I just need to finalise the writing back of teams.dat to complete this task as parks.dat is fairly simple. I just wanted to check that the Gambo spreadsheet is the main source of this data for dimensions and factors and that there aren't others out there?

05-16-2007, 12:37 AM	#3
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	I may be biased but I know it's the best! __________________ *Give me league evolution with historical imports!!!* OOTP MODS: Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack available at... http://www.ootpmods.com

05-25-2007, 12:05 AM	#5
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	Looking Good! I can just tweak the stadium chart to match up better for the importer... the only other thing I think it may be missing in setting up the ballpark photos and places. Are you planning on touching on those things? __________________ *Give me league evolution with historical imports!!!* OOTP MODS: Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack available at... http://www.ootpmods.com

05-26-2007, 06:18 PM	#7
galaril Minors (Rookie Ball) Join Date: Mar 2007 Posts: 28	So does this have the changes already done or do we still have to make all the manual changes just using this utility? Since I don't have excel on my home pc I am asking if the ballpark_csv is already set up or not? Last edited by galaril; 05-26-2007 at 06:19 PM.

05-29-2007, 10:53 PM	#11
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	Even Better! This is going to be awesome when it's finished... still curious as to when you can get to implement the photo file info... once you get the columns set i'll restructure a ballpark chart for it and maybe add in a few more stadiums. __________________ *Give me league evolution with historical imports!!!* OOTP MODS: Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack available at... http://www.ootpmods.com

05-06-2007, 02:21 PM	#2
neojonas All Star Starter Join Date: Aug 2006 Posts: 1,078	I always use Gambo's and it seems to be the best resource.

05-24-2007, 09:39 AM	#4
Tony M Global Moderator Join Date: Feb 2006 Location: Here Posts: 6,156	I've put up the first attempt at a ballpark importer at http://www.bourtonville.co.uk/OOTPStadium.zip Unzip the file and then double click the OOTP Stadium Importer.application to install it. How this works is as follows: 1. Start the program and exit OOTP 2. Choose your saved league directory by clicking on the ... next to the Saved Game Dir text box and navigating to it. 3. On the first go through only the top button will be enabled as there isn't an import file made at that point. Click on create new format CSV and when the other button has become enabled it has finished the first stage. 4. If you look in your saved league directory you will see a file called parks_output.csv - open this up in Excel or any other spreadsheet and you'll see the main parts of stadium data. Each park will have its teams listed against it as well. Make the changes to the data that you want and save it back as csv with the same name 'parks_output.csv' 5. Click the Import Ballparks button and it will read the file back in and update teams.dat and parks.dat Points to note a. It doesn't allow addition or deletion of stadiums. b. If a team is allocated to more than one stadium, they'll be allocated the last one in the list. c. If a team is mispelled in the list it won't get allocated its rightful stadium. d. A ballpark can have up to five teams that play there. e. A back-up of both teams and parks.dat are created so if it screws up you can delete teams.dat and parks.dat and rename the last backup copy. I know it's not the same format as Gambo's list but I was trying to find someway of tying up a park to a team as well.

05-29-2007, 05:43 AM	#10
Tony M Global Moderator Join Date: Feb 2006 Location: Here Posts: 6,156	I've updated the program at the link above. It now allows you to re-import directly the parks.csv that is generated in the import_export directory when you do a CSV data dump. This means all the fields are changeable and stadiums can be deleted and added at will from that file, but it loses the link between a stadium and a team. So if you do a standard ML setup and export parks.csv and change Park ID 1 to be Fenway Park, you'll find the Orioles playing there. My next task is to import the teams csvs and that should enable the two sets to be tied together that way and allow history to be imported.

07-17-2007, 07:56 PM	#13
Geebob Minors (Double A) Join Date: Jun 2005 Location: Mwaaakee, WI Posts: 128	bumpski __________________ DDBL: Langlade __________________________________________ Are deaths always avenged? Is there a deserving consequence for every act of evil? Maybe in television, but in life, I'm not sure. Mengele died on a beach in South America, P-a-u-l -W-o-l-f-o-w-i-t-z and Donald Rumsfeld still have paying jobs and, oh yeah, the Baltimore Orioles have to play baseball in the same division with the Red Sox and Yankees. So... *David Simon (creator of Homocide* and The Wire) on the HBO Message Board**

11-17-2011, 08:55 PM	#14
eriqjaffe Hall Of Famer Join Date: May 2003 Location: Under The Christmas Fish Posts: 7,768	Sorry to bump a 4-year-old thread, but does anybody out there have a copy of this? Tony's links are all dead now. __________________

11-18-2011, 12:25 AM	#15
Gambo Hall Of Famer Join Date: Mar 2002 Location: Oklahoma Posts: 2,388	I may be wrong but I don't think it works anymore since they restructured the parks.dat file. Kinda sucks if it still works since I stopped using it. __________________ *Give me league evolution with historical imports!!!* OOTP MODS: Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack available at... http://www.ootpmods.com