Lahman DB missing a LOT of players

canadiancreed · 08-25-2010, 04:29 PM

Hello all Just download the lahnam DB from their site, and I was shocked to find that it is missing a lot of players. As in anyone without a last name of S-V. Is this normal? Is there a complete DB?

Bristolduke · 08-25-2010, 04:42 PM

Sounds like a bad download. Did you pull the csv version ot the Access version?

I pulled the csv version (57) earlier this month and they are all there. The file is in a very strange order however.

canadiancreed · 08-25-2010, 05:25 PM

Quote:

Originally Posted by Bristolduke

Sounds like a bad download. Did you pull the csv version ot the Access version?

I pulled the csv version (57) earlier this month and they are all there. The file is in a very strange order however.

Tried it from three different sources, including the mans site itself with the exact same result. It's like the DB is just an update or something.

And grabbed both the csv and sql version with same results. I don't have access so no sense getting that version.

actionjackson · 08-25-2010, 05:30 PM

The order is alphabetical for players that debuted in seasons prior to 2002. From 2002 through 2009 though, it is ordered by debut date. This can be fixed in Excel by sorting by the players Lahman ID numbers. David Aardsma vaults to the top of the list and Dutch Zwilling remains on the bottom, with everyone in between in the order of their Lahman IDs. I think there should be 17,293 players in your database. If not, then like Bristolduke said, you've got a bad download and you need to give it another go.

actionjackson · 08-25-2010, 05:33 PM

Quote:

Originally Posted by canadiancreed

Tried it from three different sources, including the mans site itself with the exact same result. It's like the DB is just an update or something.

And grabbed both the csv and sql version with same results. I don't have access so no sense getting that version.

Definitely try the sorting method mentioned above because this year's Lahman somehow starts with Dave Von Ohlen.

In what universe does Dave Von Ohlen come first alphabetically?

canadiancreed · 08-25-2010, 06:35 PM

I cant' seem to find a good download. even from their site it gives me Dave Von Olhem first when sorted alphabetically.

Bristolduke · 08-25-2010, 07:23 PM

I think you have the fill file.

It is NOT in alphabetical order Or ANY order.

But all the players are there.

The "order" is kind of reverse alphabetical from V to A. Then W to Z and again only for players pre-2002.

Then come the post 2002 players it looks like by year (2002-2009), but no alpha order.

Again if your master file has 17,468 rows, all the players are there.

actionjackson · 08-25-2010, 11:29 PM

Quote:

Originally Posted by canadiancreed

I cant' seem to find a good download. even from their site it gives me Dave Von Olhem first when sorted alphabetically.

Yes, that's what everybody got this year. It would appear Mr. Lahman woke up in some sort of bizarro world this year, where the alphabet ran from the middle of the Vs back through the As in reverse real world alphabetical order, picking up later with the rest of the Vs through Dutch Zwilling in real world alphabetical order and then onto the players that debuted from 2002 through 2009 in order of debut date.

If you wish to change this (and I can't see why you wouldn't because it's...well...bizarre), you must go into Excel or equivalent spreadsheet program, use the Data > Sort... function and pick which column you want to sort it by. I choose Column B, which is the LahmanID, but you can sort it by whatever category you wish to sort it by. It sounds like you want an alphabetical sort, so you probably want to sort first by Column R (Surname) and then by Column Q (First Name). I sort the Master file and the stats2 (neutralized batting, fielding, fieldingOF, and pitching stats files) in order of LahmanID, which is in Column B. I just find it makes editing these files a whole lot more simple, if they're all sorted in the same manner. Hope this helps, from your friendly fellow canuck.

canadiancreed · 08-26-2010, 08:26 AM

AH yes the random ordering of things is what tripped me up. Ugh my apologies.

Bristolduke · 08-26-2010, 11:29 AM

No Problem.

BTW I'll have an update on that file shortly you may be interested in. I'll be posting it on this board.

Cheers

actionjackson · 08-26-2010, 11:59 AM

Quote:

Originally Posted by canadiancreed

AH yes the random ordering of things is what tripped me up. Ugh my apologies.

Quote:

Originally Posted by Bristolduke

No Problem.

BTW I'll have an update on that file shortly you may be interested in. I'll be posting it on this board.

Cheers

Random to all who look at it except Sean Lahman. To him it makes perfect sense. Ok, I'll stop ripping him now. He's contributed more to the game of baseball than I could contribute in 1,000 lifetimes. No need to apologize...unless of course you're a Canadian where it's a built in reflex.

Good to hear BD. Is this one gonna be similar to the v3 photos one with the photos for all players including a "Photo Not Available" for those without a photo to prevent the team logo or the dreaded blurry default player that shows up when there isn't a photo, as well as the Master? I'm really hoping we can get something standardized around here. The Swiss Cheese Master with the D/M/YYYY H/MM/SS date format was in a word horrendous. Thanks for your efforts.

Bristolduke · 08-26-2010, 12:32 PM

Photos are the next step, master files are done. Covers all versions of OOTP from 2007 up. I'll post those today or tomorrow.

canadiancreed · 09-05-2010, 11:41 AM

Quote:

Originally Posted by Bristolduke

No Problem.

BTW I'll have an update on that file shortly you may be interested in. I'll be posting it on this board.

Cheers

I'd be interested for sure. It will be an update to the current lahman system?

08-25-2010, 04:29 PM	#1
canadiancreed Hall Of Famer Join Date: Aug 2004 Posts: 11,660 Blog Entries: 1	Lahman DB missing a LOT of players Hello all Just download the lahnam DB from their site, and I was shocked to find that it is missing a lot of players. As in anyone without a last name of S-V. Is this normal? Is there a complete DB? __________________ PT21 PT22

08-25-2010, 04:42 PM	#2
Bristolduke All Star Starter Join Date: May 2006 Posts: 1,404	Sounds like a bad download. Did you pull the csv version ot the Access version? I pulled the csv version (57) earlier this month and they are all there. The file is in a very strange order however. __________________ Commish of the Home Nations Baseball Association Commish of the Baseball Association League Commish of the League of WAR Commish of the On-Line Dynasty League SIMBL2 - Westbury Cannons Great Lakes Baseball - Toledo Neptunes World Baseball - Guantanamo Marines OMLB - Cincinnati Reds

08-25-2010, 06:35 PM	#6
canadiancreed Hall Of Famer Join Date: Aug 2004 Posts: 11,660 Blog Entries: 1	I cant' seem to find a good download. even from their site it gives me Dave Von Olhem first when sorted alphabetically. __________________ PT21 PT22

08-25-2010, 07:23 PM	#7
Bristolduke All Star Starter Join Date: May 2006 Posts: 1,404	I think you have the fill file. It is NOT in alphabetical order Or ANY order. But all the players are there. The "order" is kind of reverse alphabetical from V to A. Then W to Z and again only for players pre-2002. Then come the post 2002 players it looks like by year (2002-2009), but no alpha order. Again if your master file has 17,468 rows, all the players are there. __________________ Commish of the Home Nations Baseball Association Commish of the Baseball Association League Commish of the League of WAR Commish of the On-Line Dynasty League SIMBL2 - Westbury Cannons Great Lakes Baseball - Toledo Neptunes World Baseball - Guantanamo Marines OMLB - Cincinnati Reds

08-26-2010, 08:26 AM	#9
canadiancreed Hall Of Famer Join Date: Aug 2004 Posts: 11,660 Blog Entries: 1	AH yes the random ordering of things is what tripped me up. Ugh my apologies. __________________ PT21 PT22

08-25-2010, 05:30 PM	#4
actionjackson Hall Of Famer Join Date: Apr 2009 Location: Toronto, ON Posts: 6,123	The order is alphabetical for players that debuted in seasons prior to 2002. From 2002 through 2009 though, it is ordered by debut date. This can be fixed in Excel by sorting by the players Lahman ID numbers. David Aardsma vaults to the top of the list and Dutch Zwilling remains on the bottom, with everyone in between in the order of their Lahman IDs. I think there should be 17,293 players in your database. If not, then like Bristolduke said, you've got a bad download and you need to give it another go.

08-26-2010, 11:29 AM	#10
Bristolduke All Star Starter Join Date: May 2006 Posts: 1,404	No Problem. BTW I'll have an update on that file shortly you may be interested in. I'll be posting it on this board. Cheers __________________ Commish of the Home Nations Baseball Association Commish of the Baseball Association League Commish of the League of WAR Commish of the On-Line Dynasty League SIMBL2 - Westbury Cannons Great Lakes Baseball - Toledo Neptunes World Baseball - Guantanamo Marines OMLB - Cincinnati Reds

08-26-2010, 12:32 PM	#12
Bristolduke All Star Starter Join Date: May 2006 Posts: 1,404	Photos are the next step, master files are done. Covers all versions of OOTP from 2007 up. I'll post those today or tomorrow. __________________ Commish of the Home Nations Baseball Association Commish of the Baseball Association League Commish of the League of WAR Commish of the On-Line Dynasty League SIMBL2 - Westbury Cannons Great Lakes Baseball - Toledo Neptunes World Baseball - Guantanamo Marines OMLB - Cincinnati Reds