Import historical player

gdf82 · 02-21-2010, 01:54 PM

How do import a single historical player to your season ?

CubbyFan23 · 02-21-2010, 02:35 PM

From the free agent signing page, click "Import Historical Player."

Enter the player ID (you can find this from bbreference, or opening the database itself in Excel), the year you are in, and any other modifiers. It will put him in free agency.

gdf82 · 02-21-2010, 02:40 PM

When I do this it says, "The historical player import failed"

CubbyFan23 · 02-21-2010, 02:48 PM

I believe that means the player ID was not in the database.

It should be the first five letters of the last name, the first two letters of the first name, and then two digits.

i.e. Albert Pujols = pujolal01

gdf82 · 02-21-2010, 02:57 PM

You do import from the csv.master?

Tickkid · 03-07-2010, 05:11 PM

I'm having the same issue. I've got the whole lehmann database. I've got it in a directory - and I select master.csv when I open the import. I put in ruthba01 for the ID and 1914 for the year (though I've also used 1915 and 1935). I get the fail to import error. I'm not sure what I'm missing. (In OOTP 10) I've done it before in 8 and 9.

Cooleyvol · 03-07-2010, 06:25 PM

I just tested this and he imported just fine for me.

Tickkid · 03-07-2010, 06:26 PM

I guess I need to find out what kinds of things could make the import fail. I have all the files in the lehmann database... I've got the correct year. I'm not sure what else I could be missing.

Bigrod · 03-07-2010, 07:43 PM

Not sure if this is the problem or not but the lastest Lahman added an extra column that has been causing problems. Search the forums lahman and maybe you can find the answer and if that is your problem they have a workaround for it. Has something to do with just deleting one of the columns . If I remember correctly, 2 columns are the same, but one has missing data or something like that.

Tickkid · 03-07-2010, 07:44 PM

Quote:

Originally Posted by Bigrod

Not sure if this is the problem or not but the lastest Lahman added an extra column that has been causing problems. Search the forums lahman and maybe you can find the answer and if that is your problem they have a workaround for it. Has something to do with just deleting one of the columns . If I remember correctly, 2 columns are the same, but one has missing data or something like that.

Ah thank you! I'll search some more.

gdf82 · 03-07-2010, 09:17 PM

I made sure I extract the zip file and it seem to work find now.

Tickkid · 03-07-2010, 11:06 PM

Quote:

Originally Posted by gdf82

I made sure I extract the zip file and it seem to work find now.

Well, I ended up using the master.csv that was located in the OOTP 10 directory in my Documents directory and it worked. I wonder why I didn't have luck with 5.6 or 5.7. *shrug* Works enough for me though.

sprague · 09-11-2011, 12:28 PM

Quote:

Originally Posted by CubbyFan23

From the free agent signing page, click "Import Historical Player."

Enter the player ID (you can find this from bbreference, or opening the database itself in Excel), the year you are in, and any other modifiers. It will put him in free agency.

you say the player id can be found on baseball reference
where exactly can you find that id on the site-
it can take some time searching the database if you have many players to import

thanks

OutS|der · 09-11-2011, 12:30 PM

From the 11 manual

One 'trick' to finding the player's ID is to visit BaseballReference.com. Look up the player you wish to import, and then check the URL string. The player's unique ID is the portion of the file name before .shtml.

02-21-2010, 01:54 PM	#1
gdf82 Minors (Rookie Ball) Join Date: Feb 2006 Location: allen, tx Posts: 34	Import historical player How do import a single historical player to your season ?

03-07-2010, 05:11 PM	#6
Tickkid Minors (Single A) Join Date: Apr 2002 Posts: 51	I'm having the same issue. I've got the whole lehmann database. I've got it in a directory - and I select master.csv when I open the import. I put in ruthba01 for the ID and 1914 for the year (though I've also used 1915 and 1935). I get the fail to import error. I'm not sure what I'm missing. (In OOTP 10) I've done it before in 8 and 9. Last edited by Tickkid; 03-07-2010 at 05:17 PM.

02-21-2010, 02:35 PM	#2
CubbyFan23 Hall Of Famer Join Date: Jan 2002 Location: St. Louis, Missouri Posts: 2,257	From the free agent signing page, click "Import Historical Player." Enter the player ID (you can find this from bbreference, or opening the database itself in Excel), the year you are in, and any other modifiers. It will put him in free agency.

02-21-2010, 02:40 PM	#3
gdf82 Minors (Rookie Ball) Join Date: Feb 2006 Location: allen, tx Posts: 34	When I do this it says, "The historical player import failed"

02-21-2010, 02:48 PM	#4
CubbyFan23 Hall Of Famer Join Date: Jan 2002 Location: St. Louis, Missouri Posts: 2,257	I believe that means the player ID was not in the database. It should be the first five letters of the last name, the first two letters of the first name, and then two digits. i.e. Albert Pujols = pujolal01

02-21-2010, 02:57 PM	#5
gdf82 Minors (Rookie Ball) Join Date: Feb 2006 Location: allen, tx Posts: 34	You do import from the csv.master?

03-07-2010, 06:25 PM	#7
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	I just tested this and he imported just fine for me.

03-07-2010, 06:26 PM	#8
Tickkid Minors (Single A) Join Date: Apr 2002 Posts: 51	I guess I need to find out what kinds of things could make the import fail. I have all the files in the lehmann database... I've got the correct year. I'm not sure what else I could be missing.

03-07-2010, 07:43 PM	#9
Bigrod OOTP Stats Master Join Date: Mar 2009 Location: Maine Posts: 3,075	Not sure if this is the problem or not but the lastest Lahman added an extra column that has been causing problems. Search the forums lahman and maybe you can find the answer and if that is your problem they have a workaround for it. Has something to do with just deleting one of the columns . If I remember correctly, 2 columns are the same, but one has missing data or something like that.

03-07-2010, 09:17 PM	#11
gdf82 Minors (Rookie Ball) Join Date: Feb 2006 Location: allen, tx Posts: 34	I made sure I extract the zip file and it seem to work find now.

09-11-2011, 12:30 PM	#14
OutS\|der Hall Of Famer Join Date: Apr 2010 Location: In A Van Down By The River Posts: 2,577 Infractions: 0/1 (1)	From the 11 manual One 'trick' to finding the player's ID is to visit BaseballReference.com. Look up the player you wish to import, and then check the URL string. The player's unique ID is the portion of the file name before .shtml.