Difference between revisions of "ICPC Import Files"

From PC2wiki
Jump to: navigation, search
m (added field definitions/description tables)
m (filled in all TBDs)
Line 35: Line 35:
 
|1||Contest Id||integer
 
|1||Contest Id||integer
 
|-
 
|-
|2||Contest Title||string
+
|2||Contest name||string
 
|-
 
|-
|3||TBD||string
+
|3||Contest short name||string
 
|-
 
|-
|4||TBD||string
+
|4||Geographic area||string
 
|-
 
|-
|5||Help email||email
+
|5||Host email||email
 
|-
 
|-
 
|6||Sponsor Name||string
 
|6||Sponsor Name||string
 
|-
 
|-
|7||ICPC help email||email
+
|7||Contest email||email
 
|-
 
|-
|8||Finals URL||url
+
|8||Contest URL||url
 
|-
 
|-
|9||Finals Standings URL||url
+
|9||Standings URL||url
 
|-
 
|-
|10||TBD||string
+
|10||Report URL||url
 
|-
 
|-
|11||TBD||string
+
|11||Site Method||string
 
|-
 
|-
|12||TBD||string
+
|12||Abbreviation||string
 
|-
 
|-
|13||TBD||integer
+
|13||Primary Site Id||integer
 
|-
 
|-
|14||TBD||string
+
|14||Certificate Line 1||string
 
|-
 
|-
|15||TBD||string
+
|15||Certificate Line 2||string
 
|-
 
|-
 
|}
 
|}
Line 95: Line 95:
 
! Number !! Description !! Type
 
! Number !! Description !! Type
 
|-
 
|-
|1||Region Id||integer
+
|1||Site Id||integer
 
|-
 
|-
 
|2||Contest Id||integer
 
|2||Contest Id||integer
 
|-
 
|-
|3||Region Name||string
+
|3||Site Name||string
 
|-
 
|-
|4||Id||email
+
|4||Site email||email
 
|-
 
|-
|5||Finals URL||url
+
|5||Site homepage URL||url
 
|-
 
|-
|6||TBD||integer
+
|6||Site type||integer
 
|-
 
|-
|7||Finals location||string
+
|7||Location||string
 
|-
 
|-
|8||TBD||YYYY-MM-DD hh:mm:ss
+
|8||Site date||YYYY-MM-DD hh:mm:ss
 
|}
 
|}
  
Line 135: Line 135:
 
! Number !! Description !! Type
 
! Number !! Description !! Type
 
|-
 
|-
|1||Team Id||integer
+
|1||Reservation Id||integer
 
|-
 
|-
|2||Region Id||integer
+
|2||Site Id||integer
 
|-
 
|-
|3||TBD||string
+
|3||Team status||string
 
|-
 
|-
 
|4||Team Name||string
 
|4||Team Name||string
 
|-
 
|-
|5||University name (long)||string
+
|5||Institution name ||string
 
|-
 
|-
|6||University name (short)||string
+
|6||Institution short name||string
 
|-
 
|-
 
|7||University web url||url
 
|7||University web url||url
Line 151: Line 151:
 
|8||Country abbreviation||string
 
|8||Country abbreviation||string
 
|-
 
|-
|9||TBD||string
+
|9||Institution has graduate programs ||Y or N
 
|}
 
|}
  
Line 172: Line 172:
 
* [[Load ICPC]]
 
* [[Load ICPC]]
 
* [[_PC2_Team.tab]]
 
* [[_PC2_Team.tab]]
 
[[Category:todo]]
 
Fill in all TBD entries
 

Revision as of 13:32, 11 November 2009

The ICPC site at Baylor University provides contest information via (import) data files.

PC² imports these files (See Load ICPC) and can create a export (See pc2export.dat)

The [|ICPC Baylor site] hosts a per region set of contest information.

There are 3 files present in the ZIP archive (ex name: CI689.ZIP). The data from these files can be imported using the Load ICPC feature.

Import File Names

Each ZIP archive contains these files.

Table of ICPC (import) files
Name Description
PC2_Contest.tab Contest information like contest title
PC2_Site.tab Contest site data
PC2_Team.tab Contest account data

PC2_Contest.tab

The Contest tab file contains general contest information.

Fields are tab (ASCII 8) delimited.

PC_Contest tab field definitions
Number Description Type
1 Contest Id integer
2 Contest name string
3 Contest short name string
4 Geographic area string
5 Host email email
6 Sponsor Name string
7 Contest email email
8 Contest URL url
9 Standings URL url
10 Report URL url
11 Site Method string
12 Abbreviation string
13 Primary Site Id integer
14 Certificate Line 1 string
15 Certificate Line 2 string
532	The 2003 ACM Programming Contest World Finals	The 2003 ACM Programming Contest World Finals	the finalists of regional contests held in six continents throughout the world	 	IBM	help@icpc.baylor.edu	http://icpc.baylor.edu/icpc/finals/	http://icpc.baylor.edu/icpc/finals/Standings.html	M	Finals03	icpc.baylor.edu/pc2/Finals02	 897	The 27th ACM International Collegiate	World Finals 2003

Fields for sample line:

  1. 532
  2. The 2003 ACM Programming Contest World Finals
  3. The 2003 ACM Programming Contest World Finals
  4. the finalists of regional contests held in six continents throughout the world
  5. IBM
  6. help@icpc.baylor.edu
  7. http://icpc.baylor.edu/icpc/finals/
  8. http://icpc.baylor.edu/icpc/finals/Standings.html
  9. M
  10. Finals03
  11. icpc.baylor.edu/pc2/Finals02
  12. 897
  13. The 27th ACM International Collegiate
  14. World Finals 2003


PC2_Site.tab

The Site tab file contains a list of site and region information.

Fields are tab (ASCII 8) delimited.

PC_Site tab field definitions
Number Description Type
1 Site Id integer
2 Contest Id integer
3 Site Name string
4 Site email email
5 Site homepage URL url
6 Site type integer
7 Location string
8 Site date YYYY-MM-DD hh:mm:ss
902	532	North America	help@icpc.baylor.edu	http://icpc.baylor.edu/icpc/finals	C	Beverly Hills, California	2003-03-25 00:00:00

Fields for sample line:

  1. 902
  2. 532
  3. North America
  4. help@icpc.baylor.edu
  5. http://icpc.baylor.edu/icpc/finals
  6. C
  7. Beverly Hills, California
  8. 2003-03-25 00:00:00

PC2_Team.tab

The Team tab file contains team information.


Fields are tab (ASCII 8) delimited.

PC_Team tab field definitions
Number Description Type
1 Reservation Id integer
2 Site Id integer
3 Team status string
4 Team Name string
5 Institution name string
6 Institution short name string
7 University web url url
8 Country abbreviation string
9 Institution has graduate programs Y or N

A sample team tab line:

24314	902	A	Hoos	University of Virginia	U Virginia	http://www.cs.virginia.edu	USA	Y

Fields for sample line:

  1. 24314
  2. 902
  3. A
  4. Hoos
  5. University of Virginia
  6. U Virginia
  7. http://www.cs.virginia.edu
  8. USA
  9. Y

See Also