Skip to main content
All CollectionsBulk Imports
Bulk Import of Units
Bulk Import of Units

Pre-populate Collaboratory with your institution's internal units

Updated over 2 months ago

Administrators can efficiently add Units to their institution’s Collaboratory using the bulk import feature. Units are a critical organizing framework for your Collaboratory reports. It is important to take the time to enter them, and the unit reporting hierarchy comprehensively and correctly.

REMINDER: Units must be imported first, before adding courses or sections. While you can import Units in stages, it’s recommended to complete the bulk import of units during onboarding to establish a comprehensive organizational structure and reporting hierarchy.

Keep in Mind

  • Units may be nested to reflect hierarchical relationships (for example, 9 departments, 3 offices, and 1 center report to a college/school; or 1 center reports to a department).

  • Once a unit is created (entered as a line in the import .csv), it may then have other campus units report to it. Be sure to list units from the top-most levels of your institution's hierarchy down.

  • All units (including colleges/schools, which are likely created as divisions) will have a public landing page created for them (see image, below).

    • A unit's landing page will only appear publicly once that unit has been affiliated with an active, published activity. Blank unit pages are not displayed publicly.

  • The activities that appear on a unit landing page will reflect where a member has identified that unit specifically as a unit collaborator on step 2 of the Activity Entry form.

How It Works

  1. Administrators should work with their institution to complete the Units Bulk Import Template. We suggest starting with the institutional research, budget, or planning offices).

  2. Once the .csv template has been completed, email it to your Customer Specialist.

  3. Our development team will handle the import, and your Customer Specialist will keep you updated on the timeline and any further details.

  4. Once the bulk import process is complete, your Units will be available in your Collaboratory Portal.

NOTE: It is helpful to find a copy of your institution's organizational hierarchy to assist with the hierarchical reporting structure. These are often housed within the Offices of the Chancellor or Provost.

Formatting Guidelines for .csv Import

Complete the ​Units Bulk Import Template with the following fields. During the import process, we will match each column in your file to a field in our database. We've provided example data to help you communicate field formats to your campus data managers who are helping you generate your Unit export file. Follow these guidelines to format each column in your file to get the best import results. Please maintain the column labels and order of columns. This is critical to a successful upload.

The following table defines each data point requested in the .csv template file (unless otherwise noted all fields are alphanumeric with no character number limitations):

Field

Definition

Formatting Requirements

Required or Optional

Publicly Visible

Unit Name

Name of unit

Alphanumeric string, up to 125 characters

Required

Yes

Unit Type ID

Type of unit

Integer, one of these allowed values:

4 = Academic Dept. or Prog.

5 = Office

6 = Center or Institute

7 = Division

8 = Museum

9 = Clinic

10 = Network or Coalition

11 = Co-Curricular

12 = College or School

Required

Yes

Reports To

External ID (column J) of the unit an individual unit reports to

Alphanumeric string

Required

No

Description

Description of the unit, often in an engaged context

Free form

Optional

Yes

Website

Unit's website

http:// or https://

Optional

Yes

Contact First Name

Person a Collaboratory admin might communicate with about data entry and sharing

Alphanumeric string

Optional

No

Contact Last Name

Alphanumeric string

Optional

No

Contact Email

Must validate as email (e.g., [email protected])

Optional

No

Contact Phone

Must validate as phone number (e.g., xxx-xxx-xxxx)

Optional

No

External ID

Copy Unit Name (column A) and paste here

Alphanumeric string

Required

No

Course Codes

Course codes assigned to this unit

(e.g., BIO; LIT; HIST-A)

A semicolon-delimited list of alphanumeric strings; can only be connected to one unit.

Not required, but critical to import courses

No

Unit and Course Code Connection

Data entered into the Unit course code field is an important precedent for creating courses and sections. The unit course code represents the prefix or abbreviation that your institution typically uses in the Course Bulletin.

Courses are nested within institutional units and are connected to the unit via the course code. In order to bulk import or manually create courses/sections, the course code must be assigned to a specific unit in your Collaboratory.

REMEMBER! A unit may house multiple course codes. However, a course code may only be connected to one unit.

Video Tutorial: How to Bulk Import Units

Did this answer your question?