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?

06-12-2007, 05:23 PM	#1 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 3,305	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 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,396	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. __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

06-13-2007, 10:52 AM	#5 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,396	I bet it only happens every 30 years... __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

06-27-2008, 06:56 PM	#13 (permalink)
texasmame Major Leagues Join Date: Apr 2007 Location: Planet Texas Posts: 417	Is this proggy working correctly or is it user error on my end? __________________ Thank you, Curt, for 2004. Without you, we would still be looking. . . GM, Manager and clubhouse attendant - GRANITE CITY KRAZY KATS - World Champs 2000, 2003 and 2004; Pennants in 2001, 2005. A.L. East Champions 2010. (No seasons 2002, 2006-2009) ". . .at the moment, I'm trying to hurt Toby Hall." - Eriqjaffe

06-28-2008, 03:56 AM	#14 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 3,305	Not working for OOTP9 yet... __________________ Tony M Technical Support Moderator

06-13-2007, 08:50 AM	#2 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 3,305	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 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 3,305	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 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 3,305	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 (permalink)
texasmame Major Leagues Join Date: Apr 2007 Location: Planet Texas Posts: 417	K. Thx. Besides this proggy, any way to edit players.csv and re-import it? __________________ Thank you, Curt, for 2004. Without you, we would still be looking. . . GM, Manager and clubhouse attendant - GRANITE CITY KRAZY KATS - World Champs 2000, 2003 and 2004; Pennants in 2001, 2005. A.L. East Champions 2010. (No seasons 2002, 2006-2009) ". . .at the moment, I'm trying to hurt Toby Hall." - Eriqjaffe

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