Using database tools to manage Rosters

dimjulskur · 03-31-2007, 04:12 PM

Please help!

I have attempted to utilize the available tools (CSV dumps, Roster Exports) to manage rosters and the data exported by these tools is just not sufficient for me to prioritize players by position, ML vs AAA, etc. For some reason the roster export provides ratings for the players but the formats are unclear... (my rating system is 20-80, yet some players have 144)... In addition, it is not clear which scout the ratings pertain to... I would like to be able evaluate players based on the ratings given by certain scouts, or group of scouts (by averaging the ratings), etc... Finally, the field list does not include the key ratings but rather show up as vL or vR. For example the contact rating is provided only as Contact v R or Contact v L... while I need to see just Contact... Ultimately I would like to utilize the available data that is present in the game and develop my own evaluation system, without having to manually input key data into Excel... was hoping the CSV dump would contain the data I need... Maybe there is a mod out there that does exactly what I am asking... any help is greatly appreciated...

tysok · 03-31-2007, 04:17 PM

I believe the dumps contain the REAL ratings of the player... so your scouts may be wrong about him, but the csv dump is not. The true ratings run on a 1-250 scale.

That's about all I can say. Contact vsR and vsL make a difference, you wouldn't want a guy in against righties when he can't hit them just because his overall contact rating is great... so not sure why that's a bad thing.

dimjulskur · 03-31-2007, 04:42 PM

ok.. appreciate it... didnt know the dump is actual ratings... here is what i am really trying to do and that is to manage my roster on the ml level and the minor league levels in terms of placing the right players at the right leves/positions, creating a depth chart, etc... and I would like to do this by creating my own set of analytics (basically a combination of ratings, stats, etc..). Of course this is impossible to do within the game itself... but i was hoping that if i could actually export the data into a spreadsheet then i can manipulate the data as I see fit... one feature that does come close is the write to disk option, however if only this wrote to a csv file or txt file... then I would be golden... but instead it writes to an html file... are there any mods/util out there that may help me accomplish this...

rasnell · 03-31-2007, 05:12 PM

Larry Anderson (Comedian) is our resident genius for writing utilities and really knows these csv files inside and out. See if you can reach him hanging out around the mod forum. He does all of the fantastic Anderson Utilities or AU stuff you see around here.

03-31-2007, 04:12 PM	#1
dimjulskur Minors (Single A) Join Date: May 2006 Location: Natick, MA Posts: 78	Using database tools to manage Rosters Please help! I have attempted to utilize the available tools (CSV dumps, Roster Exports) to manage rosters and the data exported by these tools is just not sufficient for me to prioritize players by position, ML vs AAA, etc. For some reason the roster export provides ratings for the players but the formats are unclear... (my rating system is 20-80, yet some players have 144)... In addition, it is not clear which scout the ratings pertain to... I would like to be able evaluate players based on the ratings given by certain scouts, or group of scouts (by averaging the ratings), etc... Finally, the field list does not include the key ratings but rather show up as vL or vR. For example the contact rating is provided only as Contact v R or Contact v L... while I need to see just Contact... Ultimately I would like to utilize the available data that is present in the game and develop my own evaluation system, without having to manually input key data into Excel... was hoping the CSV dump would contain the data I need... Maybe there is a mod out there that does exactly what I am asking... any help is greatly appreciated...

03-31-2007, 04:17 PM	#2
tysok Hall Of Famer Join Date: Aug 2003 Posts: 4,925	I believe the dumps contain the REAL ratings of the player... so your scouts may be wrong about him, but the csv dump is not. The true ratings run on a 1-250 scale. That's about all I can say. Contact vsR and vsL make a difference, you wouldn't want a guy in against righties when he can't hit them just because his overall contact rating is great... so not sure why that's a bad thing. __________________ I don't know about you, but as for me, the question has already been answered: Should we be here? Yes! Jack Buck, September 17, 2001 It's what you learn after you know it all that counts. I firmly believe that any man's finest hour... is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. (Vince Lombardi) I don't measure a man's success by how high he climbs but how high he bounces when he hits bottom. (George S. Patton)

03-31-2007, 05:12 PM	#4
rasnell Hall Of Famer Join Date: Jan 2003 Location: Frankfort, Kentucky Posts: 3,746	Larry Anderson (Comedian) is our resident genius for writing utilities and really knows these csv files inside and out. See if you can reach him hanging out around the mod forum. He does all of the fantastic Anderson Utilities or AU stuff you see around here. __________________ Charlie Root won more games for the Cubs than any pitcher (201), yet was remembered for one pitch to Babe Ruth. Find out more about the 1929 World Series in my book, "Root for the Cubs: Charlie Root and the 1929 Chicago Cubs." See the web site at www.rootforthecubs.com. The book is at http://www.amazon.com/Root-Cubs-Char...t+for+the+cubs. Beta tester, OOTP 2007-2023 and iOOTP 2011-2014.

03-31-2007, 04:42 PM	#3
dimjulskur Minors (Single A) Join Date: May 2006 Location: Natick, MA Posts: 78	ok.. appreciate it... didnt know the dump is actual ratings... here is what i am really trying to do and that is to manage my roster on the ml level and the minor league levels in terms of placing the right players at the right leves/positions, creating a depth chart, etc... and I would like to do this by creating my own set of analytics (basically a combination of ratings, stats, etc..). Of course this is impossible to do within the game itself... but i was hoping that if i could actually export the data into a spreadsheet then i can manipulate the data as I see fit... one feature that does come close is the write to disk option, however if only this wrote to a csv file or txt file... then I would be golden... but instead it writes to an html file... are there any mods/util out there that may help me accomplish this...