OneRoster 1.1 orgs File

Note: HMH is aware of ongoing standards upgrades in the IMS workspace related to LTI and OneRoster. At this time, IMS has not released OneRoster 1.2 openly to the public. Once it is officially released, HMH will look to prioritize development work and certification to be supported in a future build. Communications will be provided when that occurs.

The orgs file contains the identification numbers of the organizations accessing Ed, The HMH Learning Platform; ThinkCentral; and/or Holt McDougal Online.

The OneRoster files that you prepare and submit must be:

● saved as .csv (comma delimited) files with quoted identifiers (HMH strongly recommends that you use quoted identifiers.)

● named to match the original file names (orgs.csv, users.csv, classes.csv, enrollments.csv, manifest.csv, courses.csv, academicSessions.csv, demographics.csv)

● combined and compressed into a single zipped file, which includes all CSV files, prior to upload and named according to the following rules:

– Valid values: alphanumeric (A–Z, a–z, 0–9), dashes ( - ), underscores ( _ )

– Must not contain special characters (except dashes and underscores)

– For SFTP site file submissions (automated imports), spaces are not allowed (Import Management accepts zipped files with spaces, but the SFTP site does not.)

● complete snapshots of your organization's data

Note: HMH supports BULK rostering, which is full files every run. Imports using the OneRoster templates require that all data be included at the time of the import. Your submitted import files are considered full year-to-date data files, so every import file replaces the last one imported. For example, if you import 500 users today and 15 tomorrow, then that triggers the removal of 485 users. Always submit full files for all locations if using OneRoster.

➔ Open a printable version of the OneRoster 1.1 orgs File Details by clicking the link below.

Note: When populating the orgs.csv import template file, required fields must be populated and columns must appear in the proper order. Fields that are not required may remain empty, but even empty fields must be retained using commas. Do not use a space for an empty field. The header row must always be included exactly as it appears in the downloaded template; the header row field names are case sensitive. HMH strongly recommends that you use quoted identifiers.

Details for each of the orgs template fields are provided in the table below. (Fields that appear in gray are optional.)

*Supported Symbols: !#$%&'()*+,-./:;<=>?@[]_` {|}~\¡¢£¤¥¦§¨©ª«¬-®¯°±²³´¶¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþ

Quoted identifiers are strongly recommended for characters such as commas (",").

**While 255 characters are allowed for certain fields, HMH may truncate values if necessary to align with platform size requirements.

Column	Field Name	Required	Instruction	Max. Field Length	Valid Values	Sample Entries
A	sourcedId	Y	Enter the unique ID for the organization. Note: ● Must be unique across all organizations; for example, schools in your district. ● If the local building ID from the SIS is unique across all schools, then you can use that for sourcedId.	255 **See details regarding truncated values.	A–Z, a–z, 0–9, spaces, and symbols acceptable See Supported Symbols for complete list.	A_1234567
B	status	N Not required by HMH despite being required on OneRoster spec	Leave this field blank. HMH supports bulk rostering; delta processing (as required for this field) is not available at this time.	255
C	dateLastModified	N Not required by HMH despite being required on OneRoster spec	Leave this field blank. HMH supports bulk rostering; delta processing (as required for this field) is not available at this time.	10
D	name	Y	Enter the name of the organization.	255	A–Z, a–z, 0–9, spaces, and symbols acceptable See Supported Symbols for complete list.	County School District
E	type	Y	Enter the type of organization. ("district" or "school")	255	A–Z, a–z, 0–9, spaces, and symbols acceptable See Supported Symbols for complete list.	district
F	identifier	N		255
G	parentSourcedId	N	Enter the SourcedId of the parent organization.	255