Admin Portal: Batch Upload FAQ for Third-Party Enrollment Sources

Answers to common questions about Batch Upload for third-party enrollment sources.

Updated over a week ago

Can I batch upload data?

If you’re using a third-party enrollment source, you can upload additional staff, such as reading specialists, literacy coaches, volunteers, or substitute teachers with Batch Upload to assign them to schools and classes. All students and permanent staff should be uploaded via your third-party enrollment method.

If you have System access, you can manually add and edit data through the Admin Portal.

See Batch Upload for third-party enrollment sources for more information.

Can I download my data?

You can choose which organization to download your data from and what data you want to download. You can download:

  • All staff only

  • All admins only

Learn how to download your data from Batch Upload here.

I received an error when batch uploading. What happened?

After processing is complete, a report, and, if necessary an error report, is provided that shows a count of created, updated, no changes, and errors for every school, staff, class, and enrollment.

⚠️If a required or conditional header is missing, misspelled, or improperly capitalized, or if you add column headers not present in this table, the upload will fail. Review the error message, revise the file, and click Select file to upload the revised file.

⚠️ If the file has missing, invalid, or additional data, download the provided error report. The report contains a notation of each error per row of the file along with instructions for how to resolve the error. Correct each error in your file and upload the file again.

To learn more about the columns, the data requirements, and the accepted values for each field in this CSV file, you can view the users.csv data dictionary.

How can I resolve Batch Upload errors?

The following is a list of errors you may encounter during Batch Upload and how to resolve those errors. A row may include multiple errors.

Use Ctrl+F or Cmd+F to search for the error provided in your users-errors.csv file.

ERROR: action must be one of add-update, remove-user, remove-class, unassign

Example data causing this error:

Resolution: Replace with add-update, remove-user, remove-class, or unassign.

ERROR: classGrade must be one of IT, PR, PK, TK, KG, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, PS, UG, Other

Example data causing this error:

Resolution: classGrades must be in this format: IT, PR, PK, TK, KG, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, PS, UG, Other. In the CSV file, grades 1-9 must have a leading "0", such as: "05" and not "5".

If the class has multiple grades, wrap the grades in quotes in the CSV: "05, 06"

Follow these instructions for Microsoft Excel or Google Sheets on how to format columns as Text or Plain Text, so that the leading “0” remains.

ERROR: org_sis_id must be an already existing school

You must create all schools in your upstream enrollment source (Clever, ClassLink, OneRosterCSV Upload, or GG4L) and sync them to Amplify before adding staff via Batch Upload.

Example data causing this error:

Compared to list of schools present in the ORGANIZATIONS list:

Resolution: the school must be present in Admin Portal > Organizations list with a matching Primary ID (schoolId).

  • The schoolId for Shelfie Elementary in Admin Portal is 303. To resolve, replace 800 in the CSV file with 303, or replace 303 in the Admin Portal with 800.

  • The school Dogear ES is not displayed in Admin Portal yet. The school must be added in your upstream data source.

ERROR: userGrade must not be present

Example data causing this error:

Resolution: If the row is for a teacher, leave the userGrade field blank. The userGrade only applies to students.

ERROR: className does not match section’s className

Example data causing this error:

Resolution: There is more than one unique value for className indicated for the classId 303S-A1 and the Admin Portal does not know if the desired name is SHIRLEY PERIOD A1 or NEWTON PERIOD B1. There are two ways to resolve this issue, depending on the desired end result:

  • Option 1: If all rows with 303S-A1 are intended to reference SHIRLEY PERIOD A1, replace the className with that matching value.

  • Option 2: If the conflicting row is intended to reference NEWTON PERIOD B1, replace the classId with the unique identifier of that class.

Sort your data by classId to check that all className values match the intended classId.

ERROR: classGrade does not match section's classGrade

Example data causing this error:

Resolution: There is more than one unique value for classGrade indicated for the classId 303S-A1. Assign a matching classGrade value for all rows.

Sort your data by classId to check that all classGrade values match the intended classId.

ERROR: primaryTeacher must be one of true, false, 1, 0, yes, no

Example data causing this error:

Resolution: The primaryTeacher field is only required if the fields classId**, className**, and classGrade** are filled out, to indicate this teacher is a primaryTeacher in the class. If so, the acceptable values are true, false, 1, 0, yes, or no. If the field is left blank, then it defaults to false.

In this example, the teacher is the primaryTeacher for the classes (not pictured) in row 2 and not the primaryTeacher in row 3.

Sort your data by classId to check that values for primaryTeacher are consistent per teacher.

ERROR: userEmail must be a valid email

Example data causing this error:

Resolution: Please provide a valid email address (e.g., staffname@example.com). Common errors include emails with spaces (pictured previously) or special characters in them.

ERROR: Failed to process users for district: [id value], batch: [id value]

Resolution: Check the email address and userId of the staff member to confirm they match your district's records. If you do not see an error, please contact your Amplify Customer Care and Support Specialist for further investigation.

ERROR: Failed to process enrollments for district: [id value], batch: [id value]

Resolution: Please contact your Amplify Customer Care and Support Specialist for further investigation.

ERROR: Failed because this user is already associated with multiple IDPs.

Resolution: This user's email is associated with multiple authentication methods. Please contact Amplify Support to resolve.

Did this answer your question?