Assign Roles to Staff for Schoolnet

Once Schoolnet single sign-on is configured and enabled, you can then mass assign Schoolnet roles at the staff level for existing PowerSchool users, which allows PowerSchool users to launch Schoolnet from within PowerSchool and PowerTeacher Pro based on their user roles.

To mass assign Schoolnet roles:

1. Generate a tab delimited text file for a selected group of PowerSchool staff members within a specified school or district.
2. Update the tab delimited text file to include the appropriate Schoolnet roles for each PowerSchool staff member.
   
   Single school and role can also be assigned per user. This is done by listing the school number followed by a colon followed by the role. For example, 2125 Amy Bailey 3300401 0 3300401:Teacher. In this example, user Amy Bailey is assigned a Schoolnet Teacher role at school 3300401.
   
   Multiple schools and roles can also be assigned per user. This is done by listing multiple school number role combinations separated by a semicolon. For example, 2125 Amy Bailey 3300401 0 3300402:Teacher;3300402:Leadership;3300401:Teacher;3300401:Leadership;3300400:Teacher. In this example, user Amy Bailey is assigned a Schoolnet Teacher and Leadership role at school 3300402, a Schoolnet Teacher and Leadership role at school 3300401, and a Schoolnet Teacher role at school 300400.
3. Import the updated tab delimited text file back into PowerSchool.
   
   Notes:

• • The schoolnetroles field is now available when using Quick Export or Export Using Template with the Teachers table.
  • Mass assigning Schoolnet roles can only be used for updating existing PowerSchool staff members. To import new PowerSchool staff members, contact PowerSchool Technical Support.
  • The import matches PowerSchool staff members by first name and last name. Therefore, it is recommended that PowerSchool staff members' names be unique. Otherwise, only the first record will be imported and any successive staff members with the same name will be rejected.
  • A maximum of 50 Schoolnet roles may be assigned to a PowerSchool staff member. Exceeding 50 Schoolnet roles per PowerSchool staff member may cause the import to fail.
  • For more information about importing and exporting, refer to the Import and Export User Guide available on the Community.

Generate a Tab Delimited Text File

To start, generate a tab delimited text file for a selected group of PowerSchool staff members within a specified school or district.

1. Navigate to the Export Using Template page. 
2. Choose Schoolnet Staff Roles Export from the Export template pop-up menu.
3. Click Submit. The following exported, tab delimited data appears:
   • teachers.id
   • teachers.first_name
   • teachers.last_name
   • teachers.schoolid
   • teachers.psaccess
   • teachers.canchangeschool
   • schoolnetroles

Update the File to Include Schoolnet Roles

Once you have generated the text file, you can then update the file to include the appropriate Schoolnet roles for each PowerSchool staff member.

1. Open the tab delimited text file.
2. For each existing staff member, enter the appropriate Schoolnet roles using the following format: schoolid:role;schoolid:role. Note that a colon separates schoolid and role and a semicolon separates each pair of schoolid and roles.
   PowerSchool currently supports the following four predefined Schoolnet staff level roles: Employee, Leadership, Staff, and Teacher. At least one of these roles must be included for each staff member.
3. Save the export file.

Import Schoolnet Roles Using Quick Import

Once you have updated the file, you can then import the updated file back into PowerSchool.

When importing the file into PowerSchool, staff IDs included in the file are updated with their associated Schoolnet roles.

If any of the staff included in the file have existing Schoolnet roles associated to them, the values in the file override any existing Schoolnet roles in PowerSchool.

You can also use the Import Using a Template function to import Schoolnet roles.

While this procedure can be performed at the district level, it is recommended that you import Schoolnet roles at the school level. Upon signing in to PowerSchool, the name of your default school (or district) appears. Before beginning this procedure, be sure you have selected the school in which you want to work.

1. Navigate to the Quick Import page. 

2. Use the following table to enter information in the fields:

   Field	Description
   Table	Choose Teachers.
   Field delimiter	Use the default setting of Tab.
   End-of-line marker	Use the default setting of CR for carriage return.
   Character Set	Use the default setting of Mac Roman.
   File to import	Enter the file path and name of the file to import or click Choose File (or Browse), navigate to the data file, and click Open.
   Suggest field map	Use the default setting (checkbox selected).
   School	Verify you have selected the school you want to import into.

3. Click Import. 
4. Select the Check to exclude first row checkbox.
5. Select the Update teacher records if an imported teacher number matches an existing teacher record checkbox.

6. Click Submit. 

7. Verify that the imported Schoolnet roles appear correctly for each staff member on the Manage Schoolnet Roles for [Name] page. For detailed information, refer to Assign Roles to Individual Staff Members for Schoolnet.

Import Schoolnet Roles Using a Template

You can also use the Quick Import function to import Schoolnet roles.

While this procedure can be performed at the district level, it is recommended that you import Schoolnet roles at the school level. Upon signing in to PowerSchool, the name of your default school (or district) appears. Before beginning this procedure, be sure you have selected the school in which you want to work.

1. Navigate to the Import Using Template page. 

2. Use the following table to enter information in the fields:

   Field	Description
   Import template	Choose Schoolnet Staff Roles Import. Click template to link to the Templates for Importing page, where you can view, create, edit, and remove templates used for importing.
   File to import	Either enter the data file path and name in the field, or click Browse... to select the data file.

3. Click Submit. 
4. Select the Skip This Row checkbox.
5. Verify that the data correlates to the fields from the template. If it doesn't, click the link to modify the template. For more information, see Edit an Import Template. Otherwise, click Import. The Importing: [data file name] page appears, and the data is imported