Importing course allows you to set up many course in one process. To import courses, you will first need to create a tab-delimited text file (.txt) or a comma separated (.csv) file that includes at least two key fields.
Often you want to start with another course, the base course. You need to specify how the new course relates to the base course with a Copy Action. You can also create a new, empty course by not specifying a base course.
We recommend that all batch imports of courses specify an external ID for courses in the import file. The external ID property is specified by the user and should contain a unique ID for the item. Typically, the external ID corresponds to the course's ID in another system at your institution.
Note: BrainHoney does not enforce uniqueness of the Course External ID.
Following are the supported fields for batch importing courses. See Domain Identifiers on how to specify different domains.
|Action||Add, Delete, or Edit. Defaults to Add.|
|Copy Action||For new courses with a base id, this values determines which copy action to take. See Virtual Courses and Chaining for more information. Valid values are Copy, Derivative, and DerivativeCopy. The default is Derivative.|
|Type||Range or Continuous|
|Start Date||Start date of a range course|
|End Date||End date of a range course|
|Days||Number of days in a continuous course|
|Term||Term for this course|
|Course Id||BrainHoney id for the course.|
|Course Guid||Guid for the course.|
|Course Reference or Course External Id||External id (reference) for the course.|
|Base Id||BrainHoney id for the base course. The add action requires an id for the base course, if you want to start with an existing course. The id can be either base id, base guid, or base reference.|
|Base Guid||Guid for the base course.|
|Base Reference or Base External Id||External id (reference) for the base course.|
|Base Domain Id or Base Domain Guid or Base Userspace or Base Login Prefix||Domain identifiers if the base course is in a different domain. See Domain Identifiers for more information.|
See the samples below for common file formats.
Creates five courses with the minimum required fields.
Title Algebra 1 Algebra 2 English Spanish History
Creates five course with all available fields. Requires two courses with external id C1 and C2.
Action,Copy Action,Base External Id,Course External Id,Title,Type,Start Date,End Date,Days,Term Add,Derivative,C1,Course_1,Course 1,Range,1/1/2009,4/30/2009,,Winter 2009 Add,Derivative,C1,Course_2,Course 2,Continuous,,,365 Add,Derivative,C2,Course_3,Course 3,Range,1/1/2009,4/30/2009,,Winter 2009 Add,Derivative,C2,Course_4,Course 4,Range,1/1/2009,4/30/2009,,Winter 2009 Add,Derivative,C2,Course_5,Course 5,Continuous,,,180
Creates two courses with base courses of external id C1 and C2 in a different domain with userspace D1.
Action,Copy Action,Base Userspace,Base External Id,Course External Id,Title,Type,Start Date,End Date,Days,Term Add,Derivative,D1,C1,Course_1,Course 1,Range,1/1/2009,4/30/2009,,Winter 2009 Add,Derivative,D1,C2,Course_2,Course 2,Continuous,,,365
Modifies different fields for two existing courses that were created with the "Add (All)" sample.
Action,Course External Id,Title,Days Edit,Course_1,Ms. Anderson's Course Edit,Course_2,,90
Deletes the five courses that were created with the "Add (All)" sample.
Action,Course External Id Delete,Course_1 Delete,Course_2 Delete,Course_3 Delete,Course_4 Delete,Course_5
Click the Administration tab.
Click the Batch import courses link
From the Type menu, select Courses.
Click Browse. The Open box displays. Browse and select the file and click Open.
A verification screen displays an analysis of the import file. If there are errors in the import file, a description of the error for each row will display in the verification screen. You should also review the data at this point to verify accuracy.
You may either click Submit to continue with the import or click Cancel to cancel out of the import process, revise the import file, and try again. If you click Submit, any rows marked with an error will not be imported.
Once you click Submit, the Import Complete screen displays the results of the import. Green checkmarks display by the rows that are imported, and a red X displays by each row that is not imported. The number of users imported displays at the bottom of the screen. Click Done to complete the import process.