Folding Forum

Does anyone know how to capture folding stats from the stanford site into like an SQL based database for tracking?

Download your stats and then run a scheduled import query on the data, looking specifically for your user name and WUs, and bring it in that way.

Which parts do you need help with, getting the stats data files from Stanford, or the SQL side?

Joining the thread;

Where could I download stats files from?

Is it possible to get a list of which WU my ID submitted at which time etc?

Thanks!

Have you read the Stats page on the project site?

http://folding.stanford.edu/English/Stats Something to the affect...

Note that the donor and team lists are generated now every 3 hours, with bzip2 versions available as well (just add .bz2 to the url). However, downloads of the daily donor and team lists should be limited to no more than 10 downloads a day.

Please see the stats page

http://folding.stanford.edu/English/Stats

which links to these urls

http://fah-web.stanford.edu/daily_user_summary.txt
http://fah-web.stanford.edu/daily_team_summary.txt

adding .bz2 yields

http://fah-web.stanford.edu/daily_user_summary.txt.bz2
http://fah-web.stanford.edu/daily_team_summary.txt.bz2

dempaSD wrote: Is it possible to get a list of which WU my ID submitted at which time etc?

This is something I would also like to use via download or online.

Russ_64 wrote:

dempaSD wrote: Is it possible to get a list of which WU my ID submitted at which time etc?

This is something I would also like to use via download or online.

Only moderators currently have access to the database.

Thanks so much for the links!

I still wonder though, if it is possible to get access to data (at least for own user id) which could reveal at least time stamp, WU and ip per each submission. E.g. something like
2009-01-22 03:54:33, 5757 (R12, C123, G215), 164.12.33.255
2009-01-22 04:01:21, 2665 (R1, C705, G87), 83.167.3.255
...

Personal interest only.

EDIT: I see I waited too long before pushing submit...

Russ_64 wrote:

dempaSD wrote: Is it possible to get a list of which WU my ID submitted at which time etc?

This is something I would also like to use via download or online.

P5-133XL wrote:Only moderators currently have access to the database.

Even moderators do not have this capability. We can find (A) the last WU that you submitted and (B) Any WU if you provide the PRCG numbers. We have no way to search using your ID.

Although I don't know if this is true, I suspect that the database isn't organized in a way that would permit such a search (or, saying it another way, it would be very "expensive" in terms of computer resources). You can find a count of WUs by project number on the official UserStats page but the particular RCG, the points earned (e.g.-if there was an EUE), and the time-date is not there. Even so, the updates to the user-oriented portions of the database take a very long time even when all queries have been disabled, and the type of individual query that you're asking for might take a similar amount of time.