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

bump

kq76 · 08-05-2008, 10:43 AM

Will this work with converting OOTP6.5 leagues to OOTP9? Or would you have to convert it to an earlier version and then convert that game to OOTP9?

Tony M · 08-05-2008, 12:08 PM

Quote:

Originally Posted by kq76

Will this work with converting OOTP6.5 leagues to OOTP9? Or would you have to convert it to an earlier version and then convert that game to OOTP9?

Eek... even I don't remember this thread.

No, it won't work going from 6.5 to 9 because the structures are completely different and because I don't have 6.5 I have no knowledge of how the files are put together.

If the link still works, it'll only be for games created in OOTP2007 I think.

kq76 · 08-05-2008, 12:17 PM

Thanks.

Kez linked to it as a solution to no history being copied over in a conversion from 6.5 to 9 and quickly skimming over the thread it looked to me like it was only for 6.5 to 2007 so I guessed that it might not work for 9. If you know of any other solutions, please advise.

MrHaroldG · 12-27-2008, 02:19 PM

Quote:

Originally Posted by Tony M

If the link still works, it'll only be for games created in OOTP2007 I think.

The link is dead—and having just gotten OOTP9 I was wanting to find out if the program worked for it. I was looking, meanwhile, for any other utility that allowed you to export data, mass-edit it, then re-import it into the game. (I already know about the import rosters option—I'm talking about from the .dat files.)

Erich Ingram · 12-27-2008, 03:42 PM

Quote:

Originally Posted by MrHaroldG

The link is dead—and having just gotten OOTP9 I was wanting to find out if the program worked for it. I was looking, meanwhile, for any other utility that allowed you to export data, mass-edit it, then re-import it into the game. (I already know about the import rosters option—I'm talking about from the .dat files.)

The link for the 2007 version didn't work for OOTP9 as markus had changed some of the code and caused there to be issues matching up. Tony is working on updating the program to be able to do all the things it did before only now with OOTP9.

Muzamba · 03-11-2009, 03:39 AM

Tony,

Did you ever finish the teams/players importer for OOTP9?

If not, do you still have a copy of the 2007 version? The site the above links point to is down. (I know the old version doesn't work for 9, but I'm okay with doing my editing via OOTP8, if necessary.)

Thanks in advance!

Muzamba · 03-15-2009, 08:06 PM

Bumpin' this one up as well (See my "Nations Limit" thread.. This is part of the same project I'm preparing to work on)

Muzamba · 04-14-2009, 11:56 PM

Just bumpin' again as it's been a month since my last bump

06-06-2007, 12:26 PM	#21
DCHepler25 All Star Starter Join Date: Jul 2002 Location: Western Pennsylvania Posts: 1,491	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. __________________ Raise the Jolly Roger!

06-06-2007, 12:33 PM	#23
DCHepler25 All Star Starter Join Date: Jul 2002 Location: Western Pennsylvania Posts: 1,491	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. __________________ Raise the Jolly Roger!

06-11-2007, 04:16 PM	#26
DCHepler25 All Star Starter Join Date: Jul 2002 Location: Western Pennsylvania Posts: 1,491	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! __________________ Raise the Jolly Roger!

07-18-2007, 02:37 PM	#28
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**

08-05-2008, 10:43 AM	#29
kq76 Global Moderator Join Date: Nov 2002 Location: Vancouver, Canada Posts: 10,701	Will this work with converting OOTP6.5 leagues to OOTP9? Or would you have to convert it to an earlier version and then convert that game to OOTP9? __________________ My OOTP Wishlist Your Recommended Team Nicknames, By City (A Crowdsourced Project)

06-10-2007, 06:07 PM	#24
Tony M Global Moderator Join Date: Feb 2006 Location: Here Posts: 6,156 Blog Entries: 3	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
Tony M Global Moderator Join Date: Feb 2006 Location: Here Posts: 6,156 Blog Entries: 3	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.

08-05-2008, 12:17 PM	#31
kq76 Global Moderator Join Date: Nov 2002 Location: Vancouver, Canada Posts: 10,701	Thanks. Kez linked to it as a solution to no history being copied over in a conversion from 6.5 to 9 and quickly skimming over the thread it looked to me like it was only for 6.5 to 2007 so I guessed that it might not work for 9. If you know of any other solutions, please advise. __________________ My OOTP Wishlist Your Recommended Team Nicknames, By City (A Crowdsourced Project)

03-11-2009, 03:39 AM	#34
Muzamba Hall Of Famer Join Date: Apr 2002 Location: St. Louis, MO Posts: 2,325	Tony, Did you ever finish the teams/players importer for OOTP9? If not, do you still have a copy of the 2007 version? The site the above links point to is down. (I know the old version doesn't work for 9, but I'm okay with doing my editing via OOTP8, if necessary.) Thanks in advance!

03-15-2009, 08:06 PM	#35
Muzamba Hall Of Famer Join Date: Apr 2002 Location: St. Louis, MO Posts: 2,325	Bumpin' this one up as well (See my "Nations Limit" thread.. This is part of the same project I'm preparing to work on)

04-14-2009, 11:56 PM	#36
Muzamba Hall Of Famer Join Date: Apr 2002 Location: St. Louis, MO Posts: 2,325	Just bumpin' again as it's been a month since my last bump