OOTP Developments Forums - View Single Post

Cobby · 09-01-2017, 04:15 PM

I like to get player data into external spreadsheets where I can manipulate the data to my heart's content. To do this, I set up various custom views and filters, then use the "Report" dropdown to "Write Report to Disk". This puts the data into a browser window and from there I can easily copy and paste into a spreadsheet. Very easy and simple.

But, I've recently hit a snag doing this and I wonder if anyone has any ideas how to get around it.

It appears that when the source data grows to a certain point, the player screen gets broken down into pages. Now when I "Write Report to Disk" I only get 19 players at a time. If I'm examining a list of say 4000 or so players it's no longer practical to write the report to disk and pop it into a spreadsheet. (I'd have to do it over 200 times to get all the data 19 players at a time)

The thing is, this happens based on the size of the *source* data, not what it gets filtered down to. So even if I use filters to get the list whittled down to say 200 players, if the source data is large enough (not sure what the limit is) it will still break the 200 players down into pages and I'd still have to write, copy and paste over 10 times to get the data into the spreadsheet.

My first thought as a work-around would be to break the source data into a couple of chunks - then I could do the copy and paste operation twice. Not ideal, but I could live with it. However, I only have two checkboxes to manipulate the size of the source data. One is "Include Retired Players" and the other is "Include Minor Leaguers". In both cases I still get active major leaguers, so there's no way to break the source data into two mutually exclusive chunks. We would need a third check box "include active major leaguers", instead of having them always included my default.

I think we really do need that third checkbox anyway regardless of my particular problem so that we can easily exclude active major leaguers look at minor leaguers only or retired players only.

By the way, another way I thought of to get around my problem was to go to the league history - retired players section. That way I could get retired players from there and the rest from the normal players list. (my two mutually exclusive chunks) But, that doesn't work either. This is because, oddly, there are more retired players showing up on that list than there are when I check the retired players checkbox on the normal player's screen. By quite a bit - I assume it must be including retired players that never made the majors on that list or something. Whatever the case, the source limit is exceeded and that screen is always broken up into pages, making it useless for exporting.

Any suggestions?

09-01-2017, 04:15 PM	#1
Cobby Minors (Triple A) Join Date: May 2016 Posts: 252	Write Report to Disk Problems I like to get player data into external spreadsheets where I can manipulate the data to my heart's content. To do this, I set up various custom views and filters, then use the "Report" dropdown to "Write Report to Disk". This puts the data into a browser window and from there I can easily copy and paste into a spreadsheet. Very easy and simple. But, I've recently hit a snag doing this and I wonder if anyone has any ideas how to get around it. It appears that when the source data grows to a certain point, the player screen gets broken down into pages. Now when I "Write Report to Disk" I only get 19 players at a time. If I'm examining a list of say 4000 or so players it's no longer practical to write the report to disk and pop it into a spreadsheet. (I'd have to do it over 200 times to get all the data 19 players at a time) The thing is, this happens based on the size of the source data, not what it gets filtered down to. So even if I use filters to get the list whittled down to say 200 players, if the source data is large enough (not sure what the limit is) it will still break the 200 players down into pages and I'd still have to write, copy and paste over 10 times to get the data into the spreadsheet. My first thought as a work-around would be to break the source data into a couple of chunks - then I could do the copy and paste operation twice. Not ideal, but I could live with it. However, I only have two checkboxes to manipulate the size of the source data. One is "Include Retired Players" and the other is "Include Minor Leaguers". In both cases I still get active major leaguers, so there's no way to break the source data into two mutually exclusive chunks. We would need a third check box "include active major leaguers", instead of having them always included my default. I think we really do need that third checkbox anyway regardless of my particular problem so that we can easily exclude active major leaguers look at minor leaguers only or retired players only. By the way, another way I thought of to get around my problem was to go to the league history - retired players section. That way I could get retired players from there and the rest from the normal players list. (my two mutually exclusive chunks) But, that doesn't work either. This is because, oddly, there are more retired players showing up on that list than there are when I check the retired players checkbox on the normal player's screen. By quite a bit - I assume it must be including retired players that never made the majors on that list or something. Whatever the case, the source limit is exceeded and that screen is always broken up into pages, making it useless for exporting. Any suggestions?