Importing sections allows you to set up many sections in one process. To import sections, 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.
Every course in BrainHoney has a System ID, which is a unique ID assigned by BrainHoney when the course is created. You will need to determine the course ID for the course related to the sections you are importing. This ID will be included in the batch file. To determine the System ID, find the course and view the course details.
We recommend that all batch imports of sections specify an external ID for sections 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 section's ID in another system at your institution.
Note: BrainHoney does not enforce uniqueness of the external ID. You should ensure that the IDs are unique in the import file.
Following are the supported fields for batch importing sections. See Domain Identifiers on how to specify different domains.
|Action||Add, Delete, or Edit. Defaults to Add.|
|Type||Range or Continuous|
|Start Date||Start date of a range section|
|End Date||End date of a range section|
|Days||Number of days in a continuous section|
|Term||Term for this section|
|Reference or External Id||External id (reference) for the Section.|
|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.|
|Section Id||BrainHoney id for the section.|
|Section Guid||Guid for the section.|
See the samples below for common file formats.
Creates five sections with the minimum required fields. Requires two courses with external id C1 and C2.
Course External Id,Title C1,Section 1 C1,Section 2 C2,Section 3 C2,Section 4 C2,Section 5
Creates five sections with all available fields. Requires two courses with external id C1 and C2.
Action,Course External Id,Section External Id,Title,Type,Start Date,End Date,Days,Term Add,C1,S1,Section 1,Range,2009/1/1,2009/4/30,,Winter 2009 Add,C1,S2,Section 2,Continuous,,,365 Add,C2,S3,Section 3,Range,2009/1/1,2009/4/30,,Winter 2009 Add,C2,S4,Section 4,Range,2009/1/1,2009/4/30,,Winter 2009 Add,C2,S5,Section 5,Continuous,,,180
Modifies different fields for two existing sections that were created with the "Add (All)" sample.
Action,Section External Id,Title,Days Edit,S1,Ms. Anderson's Section Edit,S2,,90
Deletes the five sections that were created with the "Add (All)" sample.
Action,Section External Id Delete,S1 Delete,S2 Delete,S3 Delete,S4 Delete,S5
Click the Administration tab.
Click the Sections link. The Sections view and Find window display. Click Close to close the Find window.
Click Import Sections. The Import Sections window displays.
From the Type menu, select Sections.
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.