Editing my league

DougWyatt · 09-16-2007, 03:48 PM

I'd like to make mass changes to teams, nicknames, logos, team colors, etc - and I think all this information is in the same file.

Is there anyway to edit this offline ? Specifically, the teams.dat file.

I see how I can export into .csv - and from there, I can edit the teams.csv file ... but how do I (or can I) go about getting the info into the game ?

Tony M · 09-16-2007, 04:42 PM

export the files to csv (make sure they're all exported), exit the game. Edit the teams ones as much as you like. Make sure that your csv editor remembers to put all the commas back (Excel 2003 has a bug that screws this up)

go to http://www.bourtonville.co.uk/OOTPEditor/publish.htm and download the editor program - point the program to your saved game directory, click the Teams tab, then click Start and if that is successful click Load and it will import the csvs back into your teams.dat

ashantewarrier · 10-01-2007, 01:38 PM

hey Redsoxford,

I am trying to run the application but keep getting

"Cannot download the application. The application is missing required files. Pleace contact administrator for assistance.

Thanks for your help!

ashantewarrier · 10-01-2007, 01:58 PM

Hey I figured it out. I need to download via IE and not Firefox.

Thanks anyway!

Tony M · 10-01-2007, 02:04 PM

Quote:

Originally Posted by ashantewarrier

Hey I figured it out. I need to download via IE and not Firefox.

Thanks anyway!

I didn't realise it didn't work via Firefox - but then I've not got Firefox to test it on.

ashantewarrier · 10-01-2007, 02:37 PM

Quote:

Originally Posted by redsoxford

I didn't realise it didn't work via Firefox - but then I've not got Firefox to test it on.

I am trying to get the program to re-import the edited .CSV files however it is not doing so. The program loads .dat files but do not load .csv files. Please help! Thanks!

Tony M · 10-01-2007, 02:39 PM

Quote:

Originally Posted by ashantewarrier

I am trying to get the program to re-import the edited .CSV files however it is not doing so. The program loads .dat files but do not load .csv files. Please help! Thanks!

Several primer questions.

1. In your import_export folder are there 61 files (IIRC there should be 61, it's possible to change which files are exported from within the game)
2. Are your edited ones in that directory?
3. Have you edited them with Excel 2003?

eriqjaffe · 10-01-2007, 02:41 PM

Quote:

Originally Posted by redsoxford

I didn't realise it didn't work via Firefox - but then I've not got Firefox to test it on.

It installs via an ActiveX control, which is why it doesn't work with Firefox.

However, Firefox users can install the IETab extension, which will work around that issue.

ashantewarrier · 10-01-2007, 02:44 PM

Quote:

Originally Posted by redsoxford

Several primer questions.

1. In your import_export folder are there 61 files (IIRC there should be 61, it's possible to change which files are exported from within the game)
2. Are your edited ones in that directory?
3. Have you edited them with Excel 2003?

1. yes 61 files in the import_export directory
2. Yes. I only edited the league.csv file
3. Yes

ashantewarrier · 10-01-2007, 02:46 PM

Quote:

Originally Posted by ashantewarrier

1. yes 61 files in the import_export directory
2. Yes. I only edited the league.csv file
3. Yes

Actually I only edited the teams.csv files

ashantewarrier · 10-01-2007, 02:49 PM

Quote:

Originally Posted by eriqjaffe

It install via an ActiveX control, which is why it doesn't work with Firefox.

However, Firefox users can install the IETab extension, which will work around that issue.

Thanks eriq..I just installed the extension!

Tony M · 10-01-2007, 03:33 PM

Quote:

Originally Posted by ashantewarrier

Actually I only edited the teams.csv files

That's the problem. Excel 2003 is pants at saving csv files. It gets the commas right for the first 15 rows and then messes up.

The last column is probably empty when you edit it. Put something like 'a' in it and then save it again and it'll get the commas right.

ashantewarrier · 10-01-2007, 04:43 PM

Quote:

Originally Posted by redsoxford

That's the problem. Excel 2003 is pants at saving csv files. It gets the commas right for the first 15 rows and then messes up.

The last column is probably empty when you edit it. Put something like 'a' in it and then save it again and it'll get the commas right.

Can I use a text editor instead of Excel?

Tony M · 10-01-2007, 05:00 PM

Quote:

Originally Posted by ashantewarrier

Can I use a text editor instead of Excel?

Yep, that shouldn't be a problem.

eriqjaffe · 10-01-2007, 05:04 PM

If using Notepad to edit a CSV files becomes something of a headache...

http://csved.sjfrancke.nl/index.html

I haven't tried it, but it looks pretty promising.

09-16-2007, 03:48 PM	#1
DougWyatt All Star Starter Join Date: Dec 2003 Location: Michigan Posts: 1,117	Editing my league I'd like to make mass changes to teams, nicknames, logos, team colors, etc - and I think all this information is in the same file. Is there anyway to edit this offline ? Specifically, the teams.dat file. I see how I can export into .csv - and from there, I can edit the teams.csv file ... but how do I (or can I) go about getting the info into the game ?

09-16-2007, 04:42 PM	#2
Tony M Global Moderator Join Date: Feb 2006 Location: Here Posts: 6,156	export the files to csv (make sure they're all exported), exit the game. Edit the teams ones as much as you like. Make sure that your csv editor remembers to put all the commas back (Excel 2003 has a bug that screws this up) go to http://www.bourtonville.co.uk/OOTPEditor/publish.htm and download the editor program - point the program to your saved game directory, click the Teams tab, then click Start and if that is successful click Load and it will import the csvs back into your teams.dat __________________ This signature is intentionally blank Last edited by Tony M; 09-16-2007 at 05:13 PM. Reason: wrong website address

10-01-2007, 01:38 PM	#3
ashantewarrier Hall Of Famer Join Date: Feb 2004 Location: Somerset, NJ via Brooklyn, NY Posts: 2,305	hey Redsoxford, I am trying to run the application but keep getting "Cannot download the application. The application is missing required files. Pleace contact administrator for assistance. Thanks for your help! __________________ "I'm not concerned with your liking or disliking me... All I ask is that you respect me as a human being." -Jackie Robinson, #42 Brooklyn Dodgers *"Hitting is better than sex."* - Reggie Jackson

10-01-2007, 01:58 PM	#4
ashantewarrier Hall Of Famer Join Date: Feb 2004 Location: Somerset, NJ via Brooklyn, NY Posts: 2,305	Hey I figured it out. I need to download via IE and not Firefox. Thanks anyway! __________________ "I'm not concerned with your liking or disliking me... All I ask is that you respect me as a human being." -Jackie Robinson, #42 Brooklyn Dodgers *"Hitting is better than sex."* - Reggie Jackson

10-01-2007, 05:04 PM	#15
eriqjaffe Hall Of Famer Join Date: May 2003 Location: Under The Christmas Fish Posts: 7,697	If using Notepad to edit a CSV files becomes something of a headache... http://csved.sjfrancke.nl/index.html I haven't tried it, but it looks pretty promising. __________________