Format for Tab-Delimited Files
The EMS Campus Web Service can import your course data into EMS Campus via tab-delimited files outputted from your SIS. The following tables outline the specifications for this option. A separate file is required for each of these tables. By default, the EMS Campus Web Service looks to C:\Inetpub\wwwroot\EMSCampusWebService\CustomConfig\ on your web server for your tab-delimited files.
Buildings.txt
|
Column |
Data Type |
Max. Characters |
Example |
Notes |
|---|---|---|---|---|
|
ID |
text |
255 |
WASH |
must be unique |
|
BuildingCode |
text |
20 |
WASH |
|
|
Description |
text |
50 |
Washington |
|
RoomTypes.txt
|
Column |
Data Type |
Max. Characters |
Example |
Notes |
|---|---|---|---|---|
|
ID |
text |
255 |
C |
must be unique |
|
Description |
text |
30 |
C |
e.g. Classroom |
Rooms.txt
|
Column |
Data Type |
Max. Characters |
Example |
Notes |
|---|---|---|---|---|
|
ID |
text |
255 |
WA300 |
must be unique |
|
RoomCode |
text |
20 |
WA300 |
|
|
Description |
text |
50 |
WASHINGTON ROOM 300 |
|
|
BuildingID |
text |
255 |
WASH |
|
|
RoomTypeID |
text |
255 |
C |
|
|
Capacity |
number |
|
30 |
|
Instructors.txt
|
Column |
Data Type |
Max. Characters |
Example |
Notes |
|---|---|---|---|---|
|
ID |
text |
255 |
123456 |
must be unique |
|
Description |
text |
255 |
Terry Jones |
|
Subjects.txt
|
Column |
Data Type |
Max. Characters |
Example |
Notes |
|---|---|---|---|---|
|
ID |
text |
255 |
WH |
must be unique |
|
SubjectCode |
text |
10 |
WH |
|
|
Description |
text |
50 |
World History |
|
|
CampusCode |
text |
30 |
MAIN |
blank if N/A |
|
DepartmentCode |
text |
50 |
|
optional, blank if N/A |
|
DivisionCode |
text |
50 |
|
optional, blank if N/A |
|
LevelCode |
text |
50 |
|
optional, blank if N/A |
|
CustomCode1 |
text |
50 |
|
optional, blank if N/A |
|
CustomCode2 |
text |
50 |
|
optional, blank if N/A |
CourseTypes.txt
|
Column |
Data Type |
Max. Characters |
Example |
Notes |
|---|---|---|---|---|
|
ID |
text |
255 |
L |
must be unique |
|
Description |
text |
255 |
L |
e.g. Lecture |
Terms.txt
|
Column |
Data Type |
Max. Characters |
Example |
Notes |
|---|---|---|---|---|
|
ID |
text |
255 |
07FALL |
must be unique |
|
TermCode |
text |
10 |
07FALL |
|
|
Description |
text |
100 |
2007 FALL TERM |
|
|
StartDate |
date |
|
9/12/2007 |
must be in m/d/yyyy format |
|
EndDate |
date |
|
12/15/2007 |
must be in m/d/yyyy format |
Courses.txt
|
Column |
Data Type |
Max. Characters |
Example |
Notes |
|---|---|---|---|---|
|
ID |
text |
255 |
100001 |
must be unique |
|
CRN |
text |
255 |
100001 |
must be unique |
|
CourseTitle |
text |
100 |
World History |
|
|
TermID |
text |
255 |
07FALL |
|
|
EstimatedEnrollment |
number |
|
30 |
|
|
ActualEnrollment |
number |
|
0 |
|
|
InstructorID |
text |
255 |
123456 |
|
|
SubjectID |
text |
255 |
WH |
|
|
CrossListParentID |
text |
255 |
0 |
relates to ID, zero or blank if N/A |
|
Course |
text |
10 |
101 |
|
|
CampusCode |
text |
30 |
MAIN |
optional, blank if N/A |
|
Section |
text |
10 |
01 |
|
|
Credit Hours |
number |
|
3.0 |
|
|
DepartmentCode |
text |
50 |
|
optional, blank if N/A |
|
DivisonCode |
text |
50 |
|
optional, blank if N/A |
|
LevelCode |
text |
50 |
|
optional, blank if N/A |
|
CustomCode1 |
text |
50 |
|
optional, blank if N/A |
|
CustomCode2 |
text |
50 |
|
optional, blank if N/A |
CourseDates.txt
|
Column |
Data Type |
Max. Characters |
Example |
Notes |
|---|---|---|---|---|
|
CourseID |
text |
255 |
100001 |
|
|
ID |
text |
255 |
100001 |
must be unique |
|
CourseTypeID |
text |
255 |
L |
|
|
StartDate |
date |
|
9/11/2007 |
must be in m/d/yyyy format |
|
EndDate |
date |
|
12/15/2007 |
must be in m/d/yyyy format |
|
BuildingID |
text |
255 |
WASH |
|
|
RoomID |
text |
255 |
WA300 |
|
|
StartTime |
time |
|
0900 |
HHMM format, no colon |
|
EndTime |
time |
|
1300 |
HHMM format, no colon |
|
Sunday |
0 or 1 |
|
0 |
|
|
Monday |
0 or 1 |
|
1 |
|
|
Tuesday |
0 or 1 |
|
0 |
|
|
Wednesday |
0 or 1 |
|
1 |
|
|
Thursday |
0 or 1 |
|
0 |
|
|
Friday |
0 or 1 |
|
1 |
|
|
Saturday |
0 or 1 |
|
0 |
|
