The developers are tormenting me

[Cobby]

So, I've complained about this before:

http://www.ootpdevelopments.com/boar...d.php?t=281182

Basically, I play the game via spreadsheet. All of my decision-making is based on spreadsheet analysis. I've spent a lot effort developing my spreadsheet.

What I typically do is set up a custom view and use the "report" dropdown, then "write report to disk". This opens a browser window with the data which I then copy and paste into my spreadsheet. It's beautiful. It takes just 5 seconds:

Select the custom view
Report dropdown
Write report to disk
Browser opens- Control A
Control C
Select spreadsheet
Control V

It's great. Until I hit the dreaded page view limit. If the underlying dataset exceeds a certain number, the display changes from scroll-based to page-based. Now when I try to get the data into the spreadsheet, I just get the first page. Often the data is broken into 100's of pages and it then becomes completely impractical to get the data into excel using this method. (I'd have to to the copy-paste thing for each page).

So, I complained about this in the last version - but it really wasn't that critical since the dreaded page-view limit was 8192. Even with my 32-team league and complete minors I could stay under 8192 most of the time (only when I included retired players did I exceed it) so, all was more-or-less well.

But now, in OOTP19 the limit has been reduced to 4096 for some reason. Right now my league is 16 teams and already I'm hitting the limit occasionally. It'll be untenable once I start expanding my league.

Now, I know that some will suggest that I just use the database dump and link into my spreadsheet that way. But it's not that simple. For one thing, I don't have a database program, I just have Excel. It awkward to link all of those different tables up with Excel. What I'm interested in much of the time is the ratings of players by my own scout. So I'd have to tell the program my team, have it seach through a table to find out what scout belongs to my team, find the scout ID, look through the scout ratings table and extract just those players scouted by my scout.

I'm not saying it's not possible, just that I'm facing a lot of work when I'd rather be playing the game. Not to mention, all the work I'd have to do to re-create WAR or the other advanced statistics that don't come out directly. And when I do hall-of-fame evaluations I have to sum up career totals myself too and calculate JAWS or whatever. It's an awful lot of personal torture just because some limit in the game got changed from 8192 to 4096...

So, anyway. I don't know what I've done to anger the developers but I must now beg for mercy. Any of the these things would help:

Change the limit back to 8192 like it was with OOTP18. I would smile and cheer and jump up and down with joy...

Or that option box in settings that allows you to select Scroll or page - just let that be the final say! If you select scroll, it stays at scroll no matter what the size of the data set. Oh what a joyous world it would be to never have to face the dreaded page limit!

Or. For purposes of "write to disk" just always write the whole data set regardless of whether it has been broken into pages. What happiness throughout the land!

Or. Don't base the decision to scroll or page based on the size of the underlying data set but on the resulting set after filters are applied. Yay! That would be wonderful. Rarely do I ever want to look at more that 2000 or so players - I usually filter my results, but dang, they're still broken into pages based on the pre-filter size.

Or. Add another checkbox. Right now there are two checkboxes: "include retired players" and "include minor league players'. If only there were one more checkbox for "include major league players". Then, I could often accomplish what I needed with only two copy-paste operations. One for major leaguers and one for minor leaguers. That I could live with. Plus, this would be useful for everyone out there that wanted to look at only retired players or only minor-leaguers....

Yes. Dear developers - I beseech thee - accomplish just one of these suggestions in the next patch and I would be ever so grateful!

[NoOne]

what are you exporting? there's probably a better way to get that data to disk... and defintiely shouldn't have to copy and paste anything with ctrlc/ctrlv.

peruse the database settings page. (global/game settings -> sub tab is "Database")

available actions -- setup export, first. uncheck all the junk you don't need.

you can set up automatic data dumps too.

look into how to link to a csv or any other text file... your spreadsheet program can auto-update any links when it opens or even with a little vb code macro button. (or just go into files, view links, update each manually)

you should never have to go through a repetitive process with a spreadhseet. it can do it all for you.

in future it will be:

open spreadsheet, click yes to update links as you open file and voila! it's done. all formulas use cell addresses from the data and all those formulas will auto-update based on your settings, but usually immediately. it is ready the moment you open the file...

i'm fairly certain the game can do what you need. that feature you are using isn't meant for what you are doing, which is why it may not have the capabilities you are looking for. it could very well be a limitation of the browser or even the copy/paste function, or the game too. there may be a very good reason why that 'write report to disk' has a limitation.... or maybe not, lol.

[jarmenia]

Originally Posted by NoOne

defintiely shouldn't have to copy and paste anything with ctrlc/ctrlv.

peruse the database settings page. (global/game settings -> sub tab is "Database")

available actions -- setup export, first. uncheck all the junk you don't need.

you can set up automatic data dumps too.

You can't do any of that in an online league or challenge mode.

[jarmenia]

Originally Posted by NoOne

what are you exporting? there's probably a better way to get that data to disk... and defintiely shouldn't have to copy and paste anything with ctrlc/ctrlv.

peruse the database settings page. (global/game settings -> sub tab is "Database")

available actions -- setup export, first. uncheck all the junk you don't need.

you can set up automatic data dumps too.

look into how to link to a csv or any other text file... your spreadsheet program can auto-update any links when it opens or even with a little vb code macro button. (or just go into files, view links, update each manually)

you should never have to go through a repetitive process with a spreadhseet. it can do it all for you.

in future it will be:

open spreadsheet, click yes to update links as you open file and voila! it's done. all formulas use cell addresses from the data and all those formulas will auto-update based on your settings, but usually immediately. it is ready the moment you open the file...

i'm fairly certain the game can do what you need. that feature you are using isn't meant for what you are doing, which is why it may not have the capabilities you are looking for. it could very well be a limitation of the browser or even the copy/paste function, or the game too. there may be a very good reason why that 'write report to disk' has a limitation.... or maybe not, lol.

Markus said it would be tweaked in "tomorrow's" patch in this thread http://www.ootpdevelopments.com/boar...d.php?t=287204. Unfortunately "tomorrow" was 3/28/18 and it still hasn't been fixed.