CollegeSource Logo

Support Center
Formerly redLantern® Support Center

u.select Home

Popular Pages

u.select User Guide
u.select Connector
u.select Implementation
External Interfaces

Skip to end of metadata
Go to start of metadata

Demo

View the Manage Course Catalog demo


Adding Courses to Catalog

Import Method

Only interested in the import file schema? Click here.
  • Open a notepad file
  • Enter the courses in the following format as a comma, pipe or tab delimited file (pipe and tab delimited files are only available for Course Importing at this time):

Description Format Length Pattern Description Required?
Course Department
Variable Char
1-10
  The department abbreviation as it would appear on a transcript. Required
Course Number
Variable Char
1-5
  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 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 a student 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 (w/out memo): 

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

Example of a multiple type (w/out 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 u.select course bank:
  • 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

Tab Delimited File

Pipe Delimited File

How To Import:

  • Save the file to your desktop
  • Click the Import button the Manage Course Catalog page
  • Browse the file on your desktop
  • Delete Previous Entries
    • Select Yes or No
  • Fail on Duplicates - will display an error whenever a duplicate course is encountered. This will prevent your file from loading until all duplicates are removed.
    • Select Yes or No
  • Choose Delimiter Type - the type of import file you are about to import
    • Comma, Pipe or Tab
  • Click Import


Manual Method

On the Manage Course Catalog page, click the Add button

  • Course Department: Select to add a course to an existing department or to create a new department
    • If using an existing department, select the department
    • If creating a new department add the department abbreviation as it appears in your course catalog and enter the department title
  • Course Number: the course number
  • Course Title: the title of the course
  • First Year Term: the first year/term that the course was offered
  • Last Year Term: the last year/term that the course was offered
  • Course Hours: the number of credit hours for the course
  • Course Hours Hi: if the course has a range of hours enter the highest possible hours here, if the course does not have a range then enter the same value found in the course hours field
  • Pseudo Course: if this is a pseudo course, check the box. DARwin Only
  • Click Save

Unable to render embedded object: File (Add Course.png) not found.


Edit/Delete Courses

Export/Import Courses

  • Select how you want your export file formatted:
    • Comma delimited file (default)
    • Pipe delimited file
    • Tab delimited file
  • Click the Export button
  • Edit the entry in the comma/pipe/tab delimited file.  If a course has changed, you should date range the old course and add a new course to the file.
  • Save the file
  • Click the Import button
  • Browse to the file saved on your computer
  • Delete Previous Entries
    • Select Yes or No
  • Fail on Duplicates - will display an error whenever a duplicate course is encountered. This will prevent your file from loading until all duplicates are removed.
    • Select Yes or No
  • Choose Delimiter Type - the type of import file you are about to import
    • Comma, Pipe or Tab
  • Click Import

Manual Edit

To add a course from within the manage course catalog screens:

  • Find the course to edit by selecting the department it is in or entering the course title
  • Click the Edit button next to the course
  • Edit the necessary information
  • Click Save

Delete Courses

To delete a course:

  • Find the course to delete by selecting the department it is in or entering the course title
  • Click the Delete checkbox next to the course
  • Click the Delete button


Manually Add Memos

  • Search for the course where you want to add a memo
  • Click the Edit icon on the course
  • Click the Add Memo button
  • Enter the memo information associated with the course
  • Click Save
Enter labels to add to this page:
Please wait 
Tip: Looking for a label? Just start typing.