Course Catalog Import and Export Record Format

This page details the record format for the Course Catalog Import/Export functionality in the Transferology® Lab. For further information, see Related Articles.

Record Format

Field Format Length Pattern Description
Course Department Variable Char 1-15

The department abbreviation as it would appear on a transcript.

Required field.

Course Number Variable Char 1-15

The course number.

Required field.

Course FYT Character 6 CCYYMM

The first year/term the course is available.

Required field.

Course LYT Character 6 CCYYMM

The last year/term the course is available.

Required field.

Course Title Variable Char

1-50



The title of the course.

Required field.

Hours Low Numeric 2 No Leading Zeros

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

Required field.

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 field.

Department Name Variable Char 1-30

The written name of the department.

Required field.

Pseudo Course Flag Character 1 P if pseudo; blank if not used.

uAchieve Only 

Marks a course as a pseudo course.

Required field.

Delivery Types Variable Character 1-4 See Note 1 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 field.

Memo FYT Character 6 CCYYMM

The first year/term the memo is applicable.

Required field if using the memo.

Memo LYT Character 6 CCYYMM

The last year/term the memo is applicable.

Required field if using the memo.

Memo Description Variable Char 1-20

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

Required field if using the memo.

Memo Text Variable Char See Note 2.

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 field if using the memo.






Notes

  1. If multiple delivery type values are selected, do not insert commas/pipes/tabs between entries. 

Example of a single type (without memo):

Example of a multiple type (without memo):

  1. The character limit will depend on the editor being used. The course memo text must fit on the same line as the rest of the course information (i.e., the memo field cannot wrap to the next line).

Course Memos

When adding a course memo:

  • Do not include the memo field separators.
  • One or more memos can be associated with a course.
  • The Memo FYT, LYT, Description, and Text fields must be filled out for each memo.
  • When adding multiple memos, 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:

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

Example pipe delimited file with one memo. English Comp I.
Select to see a larger version

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

Example pipe delimited file with multiple memos.
Select to see a larger version

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 two instances of the same course must be shown with two different hours or descriptions, different Course FYT and Course LYT values must be used.

Import File Examples

Comma Delimited File - Without Memo

Comma Delimited File - With Memo

Example comma delimited file with one memo. English Comp I.
Select to see a larger version

Tab Delimited File - Without Memo

Example tab delimited file without memo. English Comp I.

Tab Delimited File - With Memo

Example tab delimited file with one memo. English Comp I.
Select to see a larger version

Pipe Delimited File - Without Memo

Pipe Delimited File - With Memo

Example pipe delimited file with memo. English Comp I.
Select to see a larger version
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us