ICPC Import Files

From PC2wiki
Revision as of 13:51, 11 November 2009 by Doug Lane (talk | contribs) (small edits/cleanup)
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.

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