How to Export large lists of players

[jarmenia]

Often I want to do analysis on a large list of players, for example all players at the major league level. Normally I would do this by doing a data dump but that function isn't available for online leagues. I can do the write report option but that requires me to hit write report 56 times as I click the next page button on the list of players and then copy and paste from each of those into a spreadsheet.

Is there a better way I am missing?

[NoOne]

not through the game it seems... if you can't avoid the paging problem.

maybe a smaller list of more relevant players using a custom view avoids teh paging? may need to leave page and come back... if it switches to the paging method i don't believe it will switch back.. but if you start wiht a small # of players when you get to the screen it should use the other settings choice (assumed in use).

if not, you can do somethign outside the game.

you can use a spreadsheet program to automatically look for certain file names in a particular folder/location. you can then setup worksheetA to link to the important parts of these exported files.

essentially a 1-time setup for X-number of files exported. it would be a pain but you'd never have to do it again. it would essentially use those files info and put it inot a more easily read and continous table on worksheet A (while the individual files will be their own worksheet)

you create first row, only -- a1=a1 from the exported sheets. worksheet a is a skeleton outline that will be filled by the exported data = endlessly re-useable... then highight and use 'fill' function for rest of that table rows... rinse and repeat for each file... 50 would be too much, but 90% of the list is probably ignorable in many contexts. i would think you can avoid a large list of 50 pages with a little common sense filtering. so, use filters and views to make the list a bit more particular aobut the players included and the context of what you are looking for.

anyway, after initial setup, simply dump new exported files into the folder previously used and overwrite old files, then load up excel or calc. it will ask to update links to files, say yes, and it's all done. that's all you'd have to do in future. completely updated table the very moment it's visible.

a bit more knowledge to make it universal as far as # of sheets to import etc. in this context more is okay, it will just be empty rows in the worksheet A table at end. uses file space may make pringint a hassle to select an area to avoid empty rows, but minor stuff. so, more is better during the setup... set it up for more exported files than you willl likely use.

[jarmenia]

Originally Posted by NoOne

not through the game it seems... if you can't avoid the paging problem.

maybe a smaller list of more relevant players using a custom view avoids teh paging? may need to leave page and come back... if it switches to the paging method i don't believe it will switch back.. but if you start wiht a small # of players when you get to the screen it should use the other settings choice (assumed in use).

if not, you can do somethign outside the game.

you can use a spreadsheet program to automatically look for certain file names in a particular folder/location. you can then setup worksheetA to link to the important parts of these exported files.

essentially a 1-time setup for X-number of files exported. it would be a pain but you'd never have to do it again. it would essentially use those files info and put it inot a more easily read and continous table on worksheet A (while the individual files will be their own worksheet)

you create first row, only -- a1=a1 from the exported sheets. worksheet a is a skeleton outline that will be filled by the exported data = endlessly re-useable... then highight and use 'fill' function for rest of that table rows... rinse and repeat for each file... 50 would be too much, but 90% of the list is probably ignorable in many contexts. i would think you can avoid a large list of 50 pages with a little common sense filtering. so, use filters and views to make the list a bit more particular aobut the players included and the context of what you are looking for.

anyway, after initial setup, simply dump new exported files into the folder previously used and overwrite old files, then load up excel or calc. it will ask to update links to files, say yes, and it's all done. that's all you'd have to do in future. completely updated table the very moment it's visible.

a bit more knowledge to make it universal as far as # of sheets to import etc. in this context more is okay, it will just be empty rows in the worksheet A table at end. uses file space may make pringint a hassle to select an area to avoid empty rows, but minor stuff. so, more is better during the setup... set it up for more exported files than you willl likely use.

Thanks, it was easier to just write a node script to parse the temp html files and output a csv. I still have to click the write report button a ton of times but its better than nothing Someday we will get a "write all the data" to the report button...