Reports
From PC2wiki
PC² reports provide information about the contest data.
Contents
Location
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)
Reports
| 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. |
Usage
$ 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
pc2report Examples
Here are a list of examples of pc2report, all these example are for version 9.0 or greater.
For these examples the Contest password is foo.
TBD describe where reports are written to and the naming convention
The report number (use --list option to show the number of a report) can be used as a shorter way to specify the report.
A partial name can be used for the report as well, for example to show All reports can be listed using:
pc2report --contestPassword foo All
List all report and their report number
pc2report --list
Report 10 Fastest Solutions Per Problem
pc2report --contestPassword foo 10
or
pc2report --contestPassword foo "Fastest Solutions Per Problem"
