ICPC Import Files

From PC2wiki
(Redirected from PC2 Contest.tab)
Jump to: navigation, search

The |ICPC Baylor site provides contest information via (import) data files. Site directors can download a zip file containing the files described below. These files contain data is used by PC² to load team names, site names and create the pc2export.dat file.

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.

Current CMS File Names

Input:

Output:

Old CMS Import File Names

The .tab file have been deprecated, they are still supported by pc2 but the new .tsv files are now be used to import and export CMS data.

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 site 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 for contest name string (no embedded spaces)
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 code char (see below)
7 Location string
8 Contest date/time 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
Site Type
Code Description
A Administrative site
M Multi-site
T Tiered site

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 char (see below)
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


Team Status
Code Description
A Accepted
C Canceled
P Pending

See Also