Depending on how your data gets added to LaunchPad, it may be necessary to manually add schools and other organizations (such as regions). The fastest way to do this is with a bulk import. The very first organization that is imported will be treated as the highest-level org in the hierarchy. If this is a district or school data set, that highest org should be a district institution. If it is a state data set, that highest org should be the state. Users must be specifically permissioned to upload organizations in order to perform this function.
To import orgs:
- Sign in to LaunchPad.
- Click Data Import.
- Click the Single File Upload tab.
- Click Upload File.
- Leave File Type at the default value of 'Orgs.' if you do not have this option, is it not available for your user role.
- Adjust the School Year if needed.
- Download the Orgs Template CSV.
- Fill in the template. See Template Field Definitions below for details.
- Return to the File Upload page and upload the completed CSV file.
- Click Upload File.
Sample CSV File
In this example, note how the district 'SourceId' is used as the school 'parentSourceid.'
Template Field Definitions
Use the comma separated values format (CSV) for all Org file uploads. CSV files should contain field values separated by commas, with line breaks between rows. Double quotes around fields are optional.
A header row is required. Headers must match the header names in the specification exactly. The order of the columns does not matter. All column headers are required, but not all fields are required. For required fields, if a value is not present then the row will not be processed. All fields are required.
| Field | Field Definition and Notes | Valid Values |
|---|---|---|
| sourcedId | Unique identifier for the user. This could be generated from the Student Information System, or could be the same as the org identifier value. | Any consecutive character combination is supported. |
| status | This could be generated from the Student Information System, or could be the same as the org identifier value. | active Tobedeleted |
| name | Name of the organization. | All characters supported. |
| type | Type of organization. | school, district, local, state |
| identifier | Org ID that will be used for display purposes. For schools, this is often referred to as the “School ID”. | Any consecutive character combination is supported, though this is generally a numeric value. |
| parentSourcedId | SourcedId of an Org representing the Parent organization. For a district-only implementation, schools will have a parentSourcedId value of their district’s org sourcedId. The district org will be a unique row in the csv file. | Must be the sourcedId of a valid org record. |