2k7 transactions

[liveandletdie]

I have been working on a file with all the transactions of every player in the lahman id (that can be found). What the game can do is read this file first and judge where the player will go, and if there isn't a transaction for that given year, it can take it from their stats and then put that player on the team. Here is an example of what I have in mind for the file:

lahmanid,transaction,year,month,day,team,round,overall,minorgameyear
abbotpa01,drafted,1985,06,03,MIN,3,67,1985
abbotpa01,released,1993,03,02,MIN,,,
abbotpa01,signed,1993,03,27,CLE,,,
abbotpa01,released,1993,08,15,CLE,,,
abbotpa01,signed,1993,11,21,KCR,,,
abbotpa01,released,1994,06,30,KCR,,,
abbotpa01,signed,1995,03,17,CHC,,,
abbotpa01,released,1995,10,16,CHC,,,
abbotpa01,signed,1995,11,29,SDP,,,
abbotpa01,released,1996,10,15,SDP,,,
abbotpa01,signed,1997,01,10,SEA,,,
abbotpa01,released,1998,12,14,SEA,,,
abbotpa01,signed,1999,01,04,SEA,,,
abbotpa01,released,2002,11,18,SEA,,,
abbotpa01,signed,2003,02,21,ARI,,,
abbotpa01,traded,2003,08,08,KCR,,,
abbotpa01,signed,2003,11,14,TBD,,,
abbotpa01,released,2004,06,03,TBD,,,
abbotpa01,signed,2004,06,09,PHI,,,
acevejo01,signed,1996,12,07,CIN,,,1997
acevejo01,traded,2005,04,09,COL,,,
adamsmi03,signed,2001,05,15,MIL,,,2001
adamsru01,drafted,2002,06,04,TOR,1,14,2002
adamste01,drafted,1991,06,03,CHC,4,112,1991
adamste01,traded,1999,12,12,LAD,,,
adamste01,released,2001,11,05,LAD,,,
adamste01,signed,2002,01,15,PHI,,,
adamste01,signed,2004,01,07,TOR,,,
adamste01,traded,2004,07,24,BOS,,,
adamste01,released,2004,12,08,BOS,,,
adamste01,signed,2005,01,11,PHI,,,
adkinjo01,drafted,1998,06,02,OAK,9,255,1999
adkinjo01,traded,2002,06,25,CHW,,,
alfonan01,signed,1989,06,03,MON,,,
alfonan01,expansion,1993,12,13,FLA,,,
alfonan01,traded,2002,03,27,CHC,,,
alfonan01,signed,2003,12,19,ATL,,,
alfonan01,released,2004,11,02,ATL,,,
alfonan01,signed,2004,12,06,FLA,,,

hopefully Clay will insert this in 2k7...if he ever sees it.

[Scorey1974]

This is quite an impressive undertaking...I have NO idea how you find the time! Great job :)

[Clay Dreslough]

That format should work well, although I can't be 100% sure until we start adding code for BB2K7.

If you have salary and contract length data for 'signed' transactions, that would be good to add.

Clay

[adam]

The transactions are in baseball-reference.com from Retrosheet up to 2002, as well as accurate salaries since 1985 or so.