Lightspeed Dashboard: Group Import

A groups data file will add or update your groups. You can use the groups.csv import file or groups-v2.csv import file to add or update groups in Mobile Manager and Classroom Orchestrator. Additionally, groups-v2.csv contains the option to enable and disable Apple Classroom in groups. Our system will initially search for the newer groups-v2.csv format, which accommodates associating subgroups to parent groups, and will then search for the older groups.csv format if it cannot locate a groups-v2.csv file. Files with any other name, case, or extension will be ignored.

Create the groups.csv file

Column Field Name Description Notes
A unique_sis_group_id Unique ID in your SIS for each virtual classroom group to create. Must be unique within the entire district required
B group_name Name of the group/class required
C unique_sis_user_id The Group Owner. Unique SIS ID of the group owner (normally a teacher or other staff level user) required
D unique_sis_school_id Each Group is associated with either a school (typical), or a district. Enter the SIS ID for the school or district that is “home” for this group required

Create the groups-v2.csv file

Column Field Name Description Notes
A unique_sis_group_id Unique ID in your SIS for each virtual classroom group to create. Must be unique within the entire district required
B group_name Name of the group/class required
C unique_sis_user_id The Group Owner. Unique SIS ID of the group owner (normally a teacher or other staff level user) required
D unique_sis_school_id Each Group is associated with either a school (typical), or a district. Enter the SIS ID for the school or district that is “home” for this group required
E sis_parent_group_id If the group is nested inside another group, i.e., a parent group, use this field to indicate that parent group’s SIS ID. optional
F apple_classroom Every group can have Apple Classroom enabled. Enter a value of ‘1’ in this field to enable it or a value of ‘0’ to disable it. Leaving this field blank will leave the status of Apple Classroom unchanged. optional

Format (groups.csv)

Column A Column B Column C Column D Column E
unique_sis_group_id group_name unique_sis_user_id unique_sis_school_id Not used

Format (groups-v2.csv)

Column A Column B Column C Column D Column E Column F
unique_sis_group_id group_name unique_sis_user_id unique_sis_school_id sis_parent_group_id apple_classroom

Note: The Groups-v2.csv file MUST  include a header row with the following information:

unique_sis_group_id,group_name,unique_sis_user_id,unique_sis_school_id,sis_parent_group_id,apple_classroom

Examples

groups-v2

groups

Note: The import files must be named correctly or they won’t be imported.
Note: CSV files must be encoded as “UTF-8 without BOM”. There can be no spaces between each line.

.