ICPC Import Files

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.

Deprecated CMS files

Still supported by pc2, but not by other Contest Control Systems.

Current CMS files

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.

Input:

• contest.tsv
• groups.tsv
• teams.tsv
• logos.tar.gz
• flags.tar.gz

Output:

• results.tsv

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 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
6. IBM
7. help@icpc.baylor.edu
8. http://icpc.baylor.edu/icpc/finals/
9. http://icpc.baylor.edu/icpc/finals/Standings.html
10. M
11. Finals03
12. icpc.baylor.edu/pc2/Finals02
13. 897
14. The 27th ACM International Collegiate
15. 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

• Load ICPC
• _PC2_Team.tab - file to assign ICPC Team Id to PC² Team account number
• pc2export.dat