Help
Import Sections from a Batch File

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.

Column HeaderDescription
ActionAdd, Delete, or Edit. Defaults to Add.
TitleSection title
TypeRange or Continuous
Start DateStart date of a range section
End DateEnd date of a range section
DaysNumber of days in a continuous section
TermTerm for this section
Reference or External IdExternal id (reference) for the Section.
Course IdBrainHoney id for the course.
Course GuidGuid for the course.
Course Reference or Course External IdExternal id (reference) for the course.
Section IdBrainHoney id for the section.
Section GuidGuid for the section.
Examples

See the samples below for common file formats.

Add (Simple)

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
Add (All)

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
Edit

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
Delete

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
Steps
1.

Click the Administration tab.

2a.

Click the Sections link. The Sections view and Find window display. Click Close to close the Find window.

2b.

Click Import Sections. The Import Sections window displays.

3.

From the Type menu, select Sections.

4.

Click Browse. The Open box displays. Browse and select the file and click Open.

5.

Click Continue.

6.

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.

7.

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.