Difference between revisions of "Reports"

From PC2wiki
Jump to: navigation, search
m (See Also: added cat)
m (Reports: added Extract Replay Runs link)
Line 68: Line 68:
 
|Evaluations||One line per judgement output
 
|Evaluations||One line per judgement output
 
|-
 
|-
|Extract Replay Runs||Extract run info and submitted files
+
|[[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
 
|Fastest Solved by Problem||List all run solving problems by fastest, by problem, and fastest solution showing rank, elapsed, team name

Revision as of 14:47, 20 April 2015

PC² reports provide information about the contest data.

Location

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)

Reports

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"

See Also