Teams Importer - Page 2

DCHepler25 · 06-06-2007, 12:26 PM

Do you think this problem has to do with the blank "History ID" column in the teams.csv? What if we put the regular team ID in for that column and then try it? Thats what I will do as my league won't run even with the back-up teams.dat.

Tony M · 06-06-2007, 12:28 PM

Quote:

Originally Posted by DCHepler25

Do you think this problem has to do with the blank "History ID" column in the teams.csv? What if we put the regular team ID in for that column and then try it? Thats what I will do as my league won't run even with the back-up teams.dat.

That's peculiar, because the back-up teams.dat should be an exact copy of the one that was there before - no coding, just a straight forward windows copy and renaming it back to teams.dat should work - if you've got several of them, I'd go for the one with the earliest date time stamp.

DCHepler25 · 06-06-2007, 12:33 PM

It was my fault not your programs' redsoxford! I accidentally deleted it and then had emptied my recycle bin later and well...

No biggie though. I can always restart the league. I hadn't simmed a single day yet anyway.

Tony M · 06-10-2007, 06:07 PM

This is on hold for the time being as there seems to be some oddities with certain databases.

I remember in 2006 when you created a league there were quite often ghost teams in the file, but I haven't seen this in 2007. When I've got to the bottom of this, I'll get a refreshed version up.

AFAIK, it works fine on newly created 2007 leagues (at least it does on my machine with the latest patched version)

Tony M · 06-11-2007, 12:24 PM

OK. I have changed the processing of the teams import to not recreate the teams.dat but to load up the existing one and only alter the records for those listed in the CSV file.

This gets round the integrity issues that getting rid of the 'ghost' teams brings in.

The link is at http://www.bourtonville.co.uk/OOTPEditor/publish.htm

So, one further caveat to editing the CSV files is to make sure that you do not under any circumstances alter the team id numbers.

Also, if you open teams.csv and make changes and then save it back as CSV open it up in wordpad or notepad and make sure that each line ends in either ,0, or ,1, (unless you're running an historical league in which case each line should end in ,0,something or ,1,something)

Errors have occurred because the line doesn't have enough commas in it.

DCHepler25 · 06-11-2007, 04:16 PM

It's working great now!

Thanks for taking the time and effort to make this. It is a great mod for those who need to make mass edits to players, teams, and parks!

Tony M · 06-11-2007, 05:20 PM

Quote:

Originally Posted by DCHepler25

It's working great now!

Thanks for taking the time and effort to make this. It is a great mod for those who need to make mass edits to players, teams, and parks!

Super news.

I've got one potential small change to make to the importer, the program should pick it up automatically when it's published - because of the change in the way it works, any history that already exists won't get overwritten, but any new history will. I can't make up my mind whether that is correct and I should leave it like it is. I think it probably is right as it is.

Anyway, onto the Players load now...

Geebob · 07-18-2007, 02:37 PM

06-06-2007, 12:26 PM	#21 (permalink)
DCHepler25 Major Leagues Join Date: Jul 2002 Location: On the edge of Insanity. Posts: 371	Do you think this problem has to do with the blank "History ID" column in the teams.csv? What if we put the regular team ID in for that column and then try it? Thats what I will do as my league won't run even with the back-up teams.dat. __________________ This is my new signature. Feel free to steal it and call it your own

06-06-2007, 12:33 PM	#23 (permalink)
DCHepler25 Major Leagues Join Date: Jul 2002 Location: On the edge of Insanity. Posts: 371	It was my fault not your programs' redsoxford! I accidentally deleted it and then had emptied my recycle bin later and well... No biggie though. I can always restart the league. I hadn't simmed a single day yet anyway. __________________ This is my new signature. Feel free to steal it and call it your own

06-11-2007, 04:16 PM	#26 (permalink)
DCHepler25 Major Leagues Join Date: Jul 2002 Location: On the edge of Insanity. Posts: 371	It's working great now! Thanks for taking the time and effort to make this. It is a great mod for those who need to make mass edits to players, teams, and parks! __________________ This is my new signature. Feel free to steal it and call it your own

07-18-2007, 02:37 PM	#28 (permalink)
Geebob Minors (Double A) Join Date: Jun 2005 Location: Mwaaakee, WI Posts: 128	bump __________________ 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**

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

06-10-2007, 06:07 PM	#24 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 2,901	This is on hold for the time being as there seems to be some oddities with certain databases. I remember in 2006 when you created a league there were quite often ghost teams in the file, but I haven't seen this in 2007. When I've got to the bottom of this, I'll get a refreshed version up. AFAIK, it works fine on newly created 2007 leagues (at least it does on my machine with the latest patched version)

06-11-2007, 12:24 PM	#25 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 2,901	OK. I have changed the processing of the teams import to not recreate the teams.dat but to load up the existing one and only alter the records for those listed in the CSV file. This gets round the integrity issues that getting rid of the 'ghost' teams brings in. The link is at http://www.bourtonville.co.uk/OOTPEditor/publish.htm So, one further caveat to editing the CSV files is to make sure that you do not under any circumstances alter the team id numbers. Also, if you open teams.csv and make changes and then save it back as CSV open it up in wordpad or notepad and make sure that each line ends in either ,0, or ,1, (unless you're running an historical league in which case each line should end in ,0,something or ,1,something) Errors have occurred because the line doesn't have enough commas in it.