Skip to main content
CollegeSource Support

Course Import Schema

Describes the record format of the course catalog import
Field Format Length Pattern Description Required?

Course Department

Variable Char

1-15

 

The department abbreviation as it would appear on a transcript.

Required

Course Number

Variable Char

1-15

 

The course number.

Required

Course FYT

Character

6

CCYYMM

The first year/term the course is available.

Required

Course LYT

Character

6

CCYYMM

The last year/term the course is available.

Required

Course Title

Variable Char

1-50*

 

The title of the course.

Required

Hours Low

Numeric

2

No Leading Zeros

The least number of credit hours a student could earn taking this course.

Required

Hours High

Numeric

2

No Leading Zeros

The maximum number of credit hours a student could earn taking this course. Could be the same value as the "Hours Low" field.

Required

Department Name

Variable Char

1-30

 

The written name of the department.

Required

Pseudo Course Flag

Character

1

P if pseudo, 
blank if not used

DARwin/uAchieve Only Marks a course as a pseudo course.

Optional

Delivery Types

Variable Character

1-4

see below**

Select one or more of these delivery types: 
C (On Campus), 
O (Online), 
X (Other) - a course that is taught by a method that is neither on campus nor online, 
M (Multiple) - a course taught by some combination of delivery methods

Required

Memo FYT

Character

6

CCYYMM

The first year/term the memo is applicable.

Required (if using memo)

Memo LYT

Character

6

CCYYMM

The last year/term the memo is applicable.

Required (if using memo)

Memo Description

Variable Char

1-20

 

A unique identifier for the memo (a single course can have more than one memo).

Required (if using memo)

Memo Text

Variable Char

See below***

 

The text of the memo. Memos can be anything from a course description to a list of prerequisites or just a special note about the course.

Required (if using memo)

*The 50 character title will get trimmed to 29 characters when students adds it to their My Courses profile.

**Delivery type: You can select multiple values in this field. If you opt to set more than one delivery type per course do not place commas/pipes/tabs between entries. 
 

Example of a single type (without memo):

ENG,101,000000,999999,English Comp I,3,3,English, ,C,


Example of a multiple type (without memo):

ENG,101,000000,999999,English Comp I,3,3,English, ,COXM,

***Course Memos are no longer restricted to 250 characters. There will be no limit to the number of characters you can have, now the limit will depend on the text editor that you use. The course memo text must fit on the same line as the rest of the course information (in other words, the memo field cannot wrap to the next line).

Course Memos
When NOT ADDING a memo
  • Don't include the memo field separators
When ADDING a memo
  • One or more memos can be associated with a course
  • Each memo must have the Memo FYT, LYT, Description and Text fields
  • When adding multiple memos keep in mind that the text in the memo field must fit on one single line, it cannot wrap.

 

An example of a course bank PIPE delimited file with a change in course hours and without memos looks like:

ENGR|321|000000|200707|Kinematics of Machines|3|3|Mechanical Engineering| |C|

ENGR|321|200708|999999|Kinematics of Machines|2|2|Mechanical Engineering| |C|

 

An example of a course bank PIPE delimited file with one memo looks like:

ENG|101|000000|999999|English Comp I|3|3|English| |COXM|200110|999999|Grd|Must get a C or better|

 

An example of a course bank PIPE delimited file with multiple memos looks like:

ENG|101|000000|999999|English Comp I|3|3|English| |COXM|200110|999999|Grd|Must get a C or better|000000|999999|Req|This class is required.|

Duplicate Courses?

Courses are considered identical (i.e., duplicate) when their primary keys are the same. The following fields comprise the primary key for the Transferology courses:

  • Course Department
  • Course Number
  • Course FYT

If you must show a the same course with different course hours or description, you must use different Course FYT and LYT values.

Import File Examples

Click the file type below to view the examples:

Comma Delimited File

Without Memo

ENG,101,000000,999999,English Comp I,3,3,English, ,COXM,

With Memo

ENG,101,000000,999999,English Comp I,3,3,English, ,COXM,200110,999999,Grd,Must get a C or better,

 

Tab Delimited File

Without Memo

ENG     101      000000      999999     English Comp I     3     3     English           COXM

With Memo

ENG     101      000000      999999     English Comp I     3     3     English           COXM      200110     999999     Grd      Must get a C or better

 

Pipe Delimited File

Without Memo

ENG|101|000000|999999|English Comp I|3|3|English| |COXM|

With Memo

ENG|101|000000|999999|English Comp I|3|3|English| |COXM|200110|999999|Grd|Must get a C or better|

 

  • Was this article helpful?