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

 

 

(missing or bad snippet)