Project/Stats/Tables.xml

Message boards : Number crunching : Project/Stats/Tables.xml
Message board moderation

To post messages, you must log in.

AuthorMessage
G_UK
Avatar

Send message
Joined: 27 Aug 03
Posts: 1
Credit: 2,414,193
RAC: 69
United Kingdom
Message 1910763 - Posted: 5 Jan 2018, 4:54:00 UTC
Last modified: 5 Jan 2018, 4:56:36 UTC

I've been looking at pulling some statistics together across multiple projects involving the total awarded credit per project each day into a spreadsheet where I am then doing some other calculations on the data.

For most projects this information is contained within the project/stats/tables.xml file under /tables/total_credit.

However SETI seems to be missing this field in the xml. Is this intentional?

Edit: Most projects follow the Boinc Wiki structure
https://boinc.berkeley.edu/trac/wiki/XmlStats
https://gridcoin.ddns.net
SEGGV3rt2MqvpDHD9BBfF5hZ6p1eZnsb9U
ID: 1910763 · Report as offensive
Richard Haselgrove Project Donor
Volunteer tester

Send message
Joined: 4 Jul 99
Posts: 12100
Credit: 124,080,983
RAC: 44,591
United Kingdom
Message 1910783 - Posted: 5 Jan 2018, 9:45:03 UTC - in response to Message 1910763.  

Yes, I've had a look at the file, and that seems to be the case. I don't know the reason, but I suspect it may be because of the numbers involved - given the size of our database here at SETI, a SQL query (the obvious tool) may take too long to run.

You can get the information you're looking for from other sources: https://boincstats.com/en/stats/0/project/detail/lastDays might be useful.
ID: 1910783 · Report as offensive
Profile HAL9000
Volunteer tester
Avatar

Send message
Joined: 11 Sep 99
Posts: 6530
Credit: 189,516,773
RAC: 32,520
United States
Message 1910785 - Posted: 5 Jan 2018, 9:57:17 UTC

I wasn't sure if it was missing due recent server issues SEI@home has had, but that info is not present in any of the saved stat dumps I have going back to 2017-07.
It doesn't appear to be in the host, team, or user output files either.
SETI@home classic workunits: 93,865 CPU time: 863,447 hours
Join the BP6/VP6 User Group today!
ID: 1910785 · Report as offensive
Richard Haselgrove Project Donor
Volunteer tester

Send message
Joined: 4 Jul 99
Posts: 12100
Credit: 124,080,983
RAC: 44,591
United Kingdom
Message 1910789 - Posted: 5 Jan 2018, 10:20:37 UTC - in response to Message 1910785.  

The individual user/host/team credit values are being exported normally - that's where BOINCstats and the other similar sites get their data from - but it's the project aggregate values which are missing. BOINCstats obviously recover the aggregate total by summing the individual values as they process them.
ID: 1910789 · Report as offensive
Profile HAL9000
Volunteer tester
Avatar

Send message
Joined: 11 Sep 99
Posts: 6530
Credit: 189,516,773
RAC: 32,520
United States
Message 1910795 - Posted: 5 Jan 2018, 11:50:17 UTC - in response to Message 1910789.  

The individual user/host/team credit values are being exported normally - that's where BOINCstats and the other similar sites get their data from - but it's the project aggregate values which are missing. BOINCstats obviously recover the aggregate total by summing the individual values as they process them.

Yeah I was searching the other files to see if <nusers>, <nteams>, <nhosts>, and <total_credit> were moved to one of the other files.
Since SETI@home is often a test bed for BOINC changes it seemed reasonable that they might have been moved to a new location.
SETI@home classic workunits: 93,865 CPU time: 863,447 hours
Join the BP6/VP6 User Group today!
ID: 1910795 · Report as offensive

Message boards : Number crunching : Project/Stats/Tables.xml


 
©2018 University of California
 
SETI@home and Astropulse are funded by grants from the National Science Foundation, NASA, and donations from SETI@home volunteers. AstroPulse is funded in part by the NSF through grant AST-0307956.