ICPC Import Files

From PC2wiki
Revision as of 12:39, 11 November 2009 by Doug Lane (talk | contribs) (added field definitions/description tables)
Jump to: navigation, search

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 Title string
3 TBD string
4 TBD string
5 Help email email
6 Sponsor Name string
7 ICPC help email email
8 Finals URL url
9 Finals Standings URL url
10 TBD string
11 TBD string
12 TBD string
13 TBD integer
14 TBD string
15 TBD 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 Region Id integer
2 Contest Id integer
3 Region Name string
4 Id email
5 Finals URL url
6 TBD integer
7 Finals location string
8 TBD 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 Team Id integer
2 Region Id integer
3 TBD string
4 Team Name string
5 University name (long) string
6 University name (short) string
7 University web url url
8 Country abbreviation string
9 TBD string

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

Fill in all TBD entries