Difference between revisions of "Reports"

From PC2wiki
Jump to: navigation, search
m (Reports: added Extract Replay Runs link)
m (List: changed title)
 
(5 intermediate revisions by the same user not shown)
Line 33: Line 33:
 
the [[server]] and [[admin]]
 
the [[server]] and [[admin]]
  
Use the [[Extract Replay Runs]] to extract run source files and
+
The 29 is from the <tt>--list</tt> option (see example below)
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)
+
See [[pc2report]] article for more information and examples
  
 
==Reports==
 
==Reports==
Line 105: Line 101:
 
|}
 
|}
  
===Usage===
+
==Reports --list option ==
  
$ bin/pc2report --help
+
For Version 9.3.2 20160608 (Wednesday, June 8th 2016 07:55 UTC) build 3443
Usage: [options] reportName|## [[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 1 Accounts
 
  Report 2 Balloons Summary
 
  Report 2 Balloons Summary
Line 173: Line 138:
 
  Report 32 Active Profile Clone Settings
 
  Report 32 Active Profile Clone Settings
 
  Report 33 Sites
 
  Report 33 Sites
  Report 34 Event Feed XML
+
  Report 34 Event Feed (CCS) XML
 
  Report 35 Notifications XML
 
  Report 35 Notifications XML
 
  Report 36 Finalize-Certify
 
  Report 36 Finalize-Certify
 
  Report 37 Internal Dump
 
  Report 37 Internal Dump
 
+
Report 38 Passwords
==pc2report Examples==
+
Report 39 accounts.tsv (team and judges)
 
+
Report 40 accounts.tsv (all accounts)
Here are a list of examples of pc2report, all these example are
+
Report 41 runs.tsv Report
for version 9.0 or greater.
+
Report 42 JSON Standings
 
+
Report 43 Event Feed 2013 XML
For these examples the [[Contest password]] is <tt>foo</tt>.
+
Report 44 userdata.tsv
 
+
Report 45 groups.tsv
[[TBD]] describe where reports are written to and the naming convention
+
  Report 46 teams.tsv
 
+
Report 47 scoreboard.tsv
The report number (use --list option to show the number of a report)
+
Report 48 submissions.tsv
can be used as a shorter way to specify the report.
+
Report 49 Event Feed XML for ICPC Tools Resolver
 
+
  Report 50 Auto Judging Settings
A partial name can be used for the report as well, for example
+
  Report 51 Judging Analysis
to show All reports can be listed using:
+
  Report 52 JSON 2016 Scoreboard
 
 
  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==
 
==See Also==

Latest revision as of 12:55, 11 September 2016

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

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

See pc2report article for more information and examples

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.

Reports --list option

For Version 9.3.2 20160608 (Wednesday, June 8th 2016 07:55 UTC) build 3443

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 (CCS) XML
Report 35 Notifications XML
Report 36 Finalize-Certify
Report 37 Internal Dump
Report 38 Passwords
Report 39 accounts.tsv (team and judges)
Report 40 accounts.tsv (all accounts)
Report 41 runs.tsv Report
Report 42 JSON Standings
Report 43 Event Feed 2013 XML
Report 44 userdata.tsv
Report 45 groups.tsv
Report 46 teams.tsv
Report 47 scoreboard.tsv
Report 48 submissions.tsv
Report 49 Event Feed XML for ICPC Tools Resolver
Report 50 Auto Judging Settings
Report 51 Judging Analysis
Report 52 JSON 2016 Scoreboard

See Also