Difference between revisions of "Runs.tsv"

From PC2wiki
Jump to: navigation, search
m (File Format: added 2nd field)
m (File Format: add lang name to definition)
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
A runs tsv is a interchange file that describes each run from a contest.
+
A [[CCS]] standard file that describes each run from a contest.
  
 
==File Format==
 
==File Format==
  
The file is a TSV file.  The first line is a list of heading titles
+
The file is a 5-field TSV file.
for each column.
 
  
The remainder of the lines have 5 fields, which are:
 
 
A text file consisting of a version line and one line for each account in the contest. Each line has tab separated fields as defined below.
 
 
The first line has the following format
 
 
{| class="wikitable"
 
{| class="wikitable"
 
! Field
 
! Field
Line 17: Line 11:
 
! Type
 
! Type
 
|-
 
|-
| 1 || run id|| 97 || xsd:int
+
| 1 || run id|| 7 || integer
 
|-
 
|-
| 2 || team number|| 97 || xsd:int
+
| 2 || team number|| 12 || integer
 
|-
 
|-
| 3 || short problem name|| railway || xsd:string
+
| 3 || CCS short problem name|| railway || string
 
|-
 
|-
| 4 || submission time in MS id|| 2033497 || xsd:int
+
| 4 || submission time in MS|| 2033497 || long integer
 +
|-
 +
| 5 || result/[[Judgement Acronym]] || AC|| string
 +
|-
 +
|}
 +
 
 +
submission time is the elapsed MS since the start of the contest.
 +
 
 +
===Extended file format===
 +
 
 +
A 6th optional field contains the language name.
 +
 
 +
{| class="wikitable"
 +
! Field
 +
! Description
 +
! Example
 +
! Type
 
|-
 
|-
| 5 || result/judgement acronym || AC|| xsd:string, \w{2}
+
| 6 || language|| Java || string
 
|-
 
|-
 
|}
 
|}
Line 35: Line 45:
 
  run-id user problem time result
 
  run-id user problem time result
 
  1 97 railway 200297 CE
 
  1 97 railway 200297 CE
  2 97 railway 587584 CE
+
  2 97 railway 587584 AC
 +
 
 +
==Other Notes==
 +
 
 +
Some runs.tsv files may contain a header line (first line) with the names
 +
of the fields, for example:
 +
 
 +
run-id  user  problem time  result
 +
 
 +
[[Category:CLICS]]
 +
[[Category:Version 9.3]]
 +
[[Category:Import and Export]]

Latest revision as of 08:06, 20 October 2019

A CCS standard file that describes each run from a contest.

File Format

The file is a 5-field TSV file.

Field Description Example Type
1 run id 7 integer
2 team number 12 integer
3 CCS short problem name railway string
4 submission time in MS 2033497 long integer
5 result/Judgement Acronym AC string

submission time is the elapsed MS since the start of the contest.

Extended file format

A 6th optional field contains the language name.

Field Description Example Type
6 language Java string

Example

A sample is below.

run-id	user	problem	time	result
1	97	railway	200297	CE
2	97	railway	587584	AC

Other Notes

Some runs.tsv files may contain a header line (first line) with the names of the fields, for example:

run-id  user  problem time  result