Players Importer

Tony M · 06-12-2007, 05:23 PM

Just a quick heads up on where this is.

The re-importation of players*.csv files is progressing nicely. In terms of the csv's left to add into the reading routine, there are just over half. It should progress quickly, but the brain does tend to gloss over staring at the list of field numbers file after file.

I would say it should be ready by the end of the week (that's Sunday, not Friday)

Tony M · 06-13-2007, 08:50 AM

Leaderboard positions and values will not be able to reloaded through this utility due to a fairly important field being missing in the players_league_leaders.csv file (the League ID is not there!)

That just leaves players_pitching, players_roster_status, players_streak and players_value to program the load for now.

Comedian2004 · 06-13-2007, 09:52 AM

Couldn't you look up the year in another file.

For instance, in the league leader file, there is the player's ID and the year. So, you can look up the players league in the players.csv file based on this information.

NOTE ALSO: I reported that this file is not complete. Not all of the league leader data is there.

Tony M · 06-13-2007, 10:09 AM

Quote:

Originally Posted by Comedian2004

For instance, in the league leader file, there is the player's ID and the year. So, you can look up the players league in the players.csv file based on this information.

There is a potential that a player has been in more than one league in a season and got onto the leaderboard in both of them. It would then involve calculating the relevant stats and comparing them.

I'll probably look at that after I've completed the import process.

Comedian2004 · 06-13-2007, 10:52 AM

I bet it only happens every 30 years...

Tony M · 06-13-2007, 11:29 AM

Well, it seems to work fine...

Apart from the occassional Joe somebody or somebody Unknown or Joe Unknown appearing in the game.

Very strange that a name appears in a new game, but doesn't necessarily appear in the names file. Unless first names are being used as surnames and vice versa by the game...

When I've sorted that issue, I'll publish it for general testing!

Tony M · 06-13-2007, 11:36 AM

Quote:

Originally Posted by redsoxford

Very strange that a name appears in a new game, but doesn't necessarily appear in the names file. Unless first names are being used as surnames and vice versa by the game...

The guy who became Joe Santana after re-import was originally called Jos Santana and Jos only appears in names.txt not in firstnames.txt so the game must be using surnames as first names and vice versa.

Rather wonder what the point of having separate files is...

edit, my mistake. Opening the files in ASCII in the code is stripping off the accented characters...

injury log · 06-13-2007, 12:19 PM

Quote:

Originally Posted by redsoxford

Well, it seems to work fine...

Apart from the occassional Joe somebody or somebody Unknown or Joe Unknown appearing in the game.

If 'Joe Unknown' is the only problematic name you're seeing, it's just a ghost player- they're all named 'Joe Unknown'. I would expect the surname 'Unknown' to be purposefully excluded from the surnames database for that reason, but I've never checked.

Tony M · 06-13-2007, 12:27 PM

Quote:

Originally Posted by injury log

If 'Joe Unknown' is the only problematic name you're seeing, it's just a ghost player- they're all named 'Joe Unknown'. I would expect the surname 'Unknown' to be purposefully excluded from the surnames database for that reason, but I've never checked.

Nope,

It was down to me using ASCII encoding to load the csv's when I shouldn't have.. I cleared that problem now, and tested a full import (minus leaderboards at the moment)

I put one team's players all on 10 year, $1,000,000 a year salaries and the rest of players on irrevocable waivers.

It took a fair while to process the following three days because of 8000+ players on the waiver wire!

The program is available at http://www.bourtonville.co.uk/OOTPEditor/publish.htm for testing...

CBLCardinals · 06-14-2007, 12:43 AM

Quote:

Originally Posted by redsoxford

Just a quick heads up on where this is.

The re-importation of players*.csv files is progressing nicely. In terms of the csv's left to add into the reading routine, there are just over half. It should progress quickly, but the brain does tend to gloss over staring at the list of field numbers file after file.

I would say it should be ready by the end of the week (that's Sunday, not Friday)

would this utility allow me to import past, retired players (from a dummy league importing from lahman for 2003 season) into a league that started in 2004? (ie anyone that played & retired from 1900-2003).

thanks for your time,
HP

Tony M · 06-18-2007, 06:20 PM

Quote:

Originally Posted by CBLCardinals

would this utility allow me to import past, retired players (from a dummy league importing from lahman for 2003 season) into a league that started in 2004? (ie anyone that played & retired from 1900-2003).

thanks for your time,
HP

Let me have a look into that. The problem there will come with a new game expecting the player IDs to be down near the start (ie 1 upwards) but a copy of the files from a previous game will probably be there instead.

I've added an Import Coach tab to the program as well now at http://www.bourtonville.co.uk/OOTPEditor/publish.htm

Tony M · 06-26-2007, 07:13 AM

An update is available at that link now. There are no new parts to the program, but I found a field in teams.dat that was different to what I had seen before so it now takes that into account.

texasmame · 06-27-2008, 06:56 PM

Is this proggy working correctly or is it user error on my end?

Tony M · 06-28-2008, 03:56 AM

Not working for OOTP9 yet...

texasmame · 06-28-2008, 10:14 PM

K. Thx. Besides this proggy, any way to edit players.csv and re-import it?

endgame · 06-21-2009, 08:07 PM

Okay, looks like this is the thread AND the OP I should be looking for and talking with.

Tony? Help on the .csv file? I have a thread active in beta, one in General Discussions, and now adding this one looking for some help? Is this process dead in the water for X?

gabychan · 03-02-2010, 03:09 AM

promotional corporate gifts
bag filter
filling machine
nail products
seo firm
china market research
china market entry

06-12-2007, 05:23 PM	#1
Tony M Global Moderator Join Date: Feb 2006 Location: Here Posts: 6,156 Blog Entries: 3	Players Importer Just a quick heads up on where this is. The re-importation of players*.csv files is progressing nicely. In terms of the csv's left to add into the reading routine, there are just over half. It should progress quickly, but the brain does tend to gloss over staring at the list of field numbers file after file. I would say it should be ready by the end of the week (that's Sunday, not Friday)

06-13-2007, 09:52 AM	#3
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 7,085	Couldn't you look up the year in another file. For instance, in the league leader file, there is the player's ID and the year. So, you can look up the players league in the players.csv file based on this information. NOTE ALSO: I reported that this file is not complete. Not all of the league leader data is there. __________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

06-13-2007, 10:52 AM	#5
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 7,085	I bet it only happens every 30 years... __________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

06-27-2008, 06:56 PM	#13
texasmame All Star Starter Join Date: Apr 2007 Location: Planet Texas Posts: 1,559	Is this proggy working correctly or is it user error on my end? __________________ Stewarding the expansion TAIWAN EXPLOSIVE GO SALMON in the NL West. As the defending NL West Champions, the SALMON fall to the wildcard Dakota Rushmores in the first round in seven games.

06-28-2008, 03:56 AM	#14
Tony M Global Moderator Join Date: Feb 2006 Location: Here Posts: 6,156 Blog Entries: 3	Not working for OOTP9 yet... __________________ This signature is intentionally blank

06-13-2007, 08:50 AM	#2
Tony M Global Moderator Join Date: Feb 2006 Location: Here Posts: 6,156 Blog Entries: 3	Leaderboard positions and values will not be able to reloaded through this utility due to a fairly important field being missing in the players_league_leaders.csv file (the League ID is not there!) That just leaves players_pitching, players_roster_status, players_streak and players_value to program the load for now.

06-13-2007, 11:29 AM	#6
Tony M Global Moderator Join Date: Feb 2006 Location: Here Posts: 6,156 Blog Entries: 3	Well, it seems to work fine... Apart from the occassional Joe somebody or somebody Unknown or Joe Unknown appearing in the game. Very strange that a name appears in a new game, but doesn't necessarily appear in the names file. Unless first names are being used as surnames and vice versa by the game... When I've sorted that issue, I'll publish it for general testing!

06-26-2007, 07:13 AM	#12
Tony M Global Moderator Join Date: Feb 2006 Location: Here Posts: 6,156 Blog Entries: 3	An update is available at that link now. There are no new parts to the program, but I found a field in teams.dat that was different to what I had seen before so it now takes that into account.

06-28-2008, 10:14 PM	#15
texasmame All Star Starter Join Date: Apr 2007 Location: Planet Texas Posts: 1,559	K. Thx. Besides this proggy, any way to edit players.csv and re-import it? __________________ Stewarding the expansion TAIWAN EXPLOSIVE GO SALMON in the NL West. As the defending NL West Champions, the SALMON fall to the wildcard Dakota Rushmores in the first round in seven games.

06-21-2009, 08:07 PM	#16
endgame Hall Of Famer Join Date: Aug 2002 Posts: 16,843	Okay, looks like this is the thread AND the OP I should be looking for and talking with. Tony? Help on the .csv file? I have a thread active in beta, one in General Discussions, and now adding this one looking for some help? Is this process dead in the water for X? __________________ "Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________

03-02-2010, 03:09 AM	#17
gabychan Bat Boy Join Date: Mar 2010 Posts: 2	promotional corporate gifts bag filter filling machine nail products seo firm china market research china market entry