Difference between revisions of "Reports"

From PC2wiki
Jump to: navigation, search
m (added report table)
m (Version 9 Reports: added example)
Line 35: Line 35:
Use the [[Extract Replay Runs]] to extract run source files and
Use the [[Extract Replay Runs]] to extract run source files and
a summary of the runs.
a summary of the runs.
Example, note that you can use the report number 29 for Extract Replay Runs report)
pc2report --contestPassword foo 29
The 29 is from the <tt>--list</tt> option (see example below)

Revision as of 12:05, 12 November 2012

PC² reports provide information about the contest data.


Server module, Reports Tab

Administrator module, Reports Tab

pc2report script

Version 8 Reports

Reports for Version 8 show a variety of information about the contest data/submissions. The Reports are:

-runs - dump run database
-all - dump all probs, team names, langs and run info
-complete - adds more reports than just all
-prob - dump prob info
-clars - dump all clarification info 
-1 - submissions by language
-3 - number of teams that solved each problem 
-4 - number of correct and incorrect solutions by problem 
-5 - print summary of who should have balloons
-6 - summary submissions, solutions, times by team/problem 
-7 - run listing per team by problem 
-8 - run summary grid
-9 - fastest to solve problem
-10 - account data file

Version 9 Reports

The following reports are available on Version 9 on both the server and admin

Use the Extract Replay Runs to extract run source files and a summary of the runs.

Example, note that you can use the report number 29 for Extract Replay Runs report)

pc2report --contestPassword foo 29

The 29 is from the --list option (see example below)


Report Description
Account Permissions Report For each client list their Permissions/Abilities
Accounts List summary of accounts per site, and individual accounts sites, logins, passwords.
All Reports List contents of all reports
Balloons Delivery List of all balloon deliveries by team, by problem and time of delivery
Balloons Summary List summary of which teams should have which color balloons.
Clarifications List all clarifications
Client Settings Various settings like Notification settings
Contest Contest settings in XML (work in progress)
Contest Analysis Summary of submissions, unjudged runs, various checks on runs.
Evaluations One line per judgement output
Extract Replay Runs Extract run info and submitted files
Fastest Solved by Problem List all run solving problems by fastest, by problem, and fastest solution showing rank, elapsed, team name
Groups List of Groups (Regions)
Internal Dump An internal dump of a bunch of config settings
Judgement Notifications Judgement Notifications
Judgements List of judgments
Languages List Languages
Logins List who is logged in
Notification Settings Notification Settings
Problems List problems
Run 5 field List of runs: run #, team #, problem letter, elapsed time, judgement
Run Notifications Sent Run Notifications Sent
Runs List of runs, with run#, run state, team #, team name, whether judgement sent to team and details on each judgement
Runs (Version 8 content and format ) List of runs with detail (see below)
Runs grouped by team List of runs, grouped by team, then by problem, helpful in calculating scoring.
Solutions By Problem For each problem show number of run with No, Yes, and percentage correct
Standings XML Standings in XML format
Submissions by Language A summary of how many teams used which languages.


$ bin/pc2report --help
Usage: [options] reportName|## ##][...

--profile name - profile name, default uses current profile.  name may be a ## from --listp listing
--contestPassword padd  - password needed to decrypt pc2 data
--list         - list names of reports (and the report numbers)
--dir name     - alternate base directory name, by default uses profile dir name
--site ##      - specify the site number
--listp        - list all profile names with numbers
--noProfile - do not use profile directory use pre version 9.2 location

reportName - name of report to print (or report number)
##         - number of report to print (numbers found using --list)

$ pc2reports --listp
1 - Id: Contest-1526060434834405723 description: Real Contest name: Contest
2 - Id: Contest 3--613094433664018852 description: Real Contest 3 name: Contest 3

Default name  : Contest
  Profile ID  : Contest-1526060434834405723
  Description : Real Contest
  Path        : profiles\Pdf812e23-4234-46ee-ad3c-4011c8cb885e

Each of these will print the same report:
$ pc2report --contestPassword newpass --profile Contest 3--613094433664018852 'Fastest Solution Summary'
$ pc2report --contestPassword newpass --profile 2 'Fastest Solution Summary'
$ pc2report --contestPassword newpass --profile Contest 3--613094433664018852 9
$ pc2report --contestPassword newpass --profile 2 9

Precedence for directory: --dir, --profile, then default profile dir
$ bin\pc2report --list
Version 9.2.3 20120910 (Monday, September 10th 2012 16:20 UTC) Java ver 1.6.0_22 build 2565 Windows 7 6.1 (x86) 
Report 1 Accounts
Report 2 Balloons Summary
Report 3 All Reports
Report 4 Contest Settings
Report 5 Contest XML
Report 6 Contest Analysis
Report 7 Solutions By Problem
Report 8 Submissions by Language
Report 9 Fastest Solutions Summary
Report 10 Fastest Solutions Per Problem
Report 11 Standings XML 
Report 12 Logins
Report 13 Profiles
Report 14 Plugins
Report 15 Runs
Report 16 Clarifications
Report 17 Problems
Report 18 Languages
Report 19 Judgements
Report 20 Runs grouped by team
Report 21 Notification Settings
Report 22 Client Settings
Report 23 Groups
Report 24 Evaluations
Report 25 Runs (Version 8 content and format)
Report 26 Run 5 field
Report 27 Account Permissions Report
Report 28 Balloons Delivery
Report 29 Extract Replay Runs
Report 30 Run Notifications Sent
Report 31 Judgement Notifications
Report 32 Active Profile Clone Settings
Report 33 Sites
Report 34 Event Feed XML
Report 35 Notifications XML
Report 36 Finalize-Certify
Report 37 Internal Dump

See Also