How can we help?

[d] In the PowerSchool Learning Importer, what do the different error messages mean and how do I fix them?

Follow

Q. In the PowerSchool Learning Importer, what do the different error messages mean, and how do I fix them?

A. There are a large variety of blocking error messages and warnings the PowerSchool Learning import check tool generates, based on the content and quality of your CSV import files. Check out the examples listed below for more details.

Introduction

This article will list each type of error that exists with the PowerSchool Learning Import Tool as well as give a brief description of what the error means and how you can fix the data. Finally, the article will also provide a screenshot showing an example of each error.

These errors can be found under the Imports & Exports page in PowerSchool Learning. For data warnings, click on the "xx Warning(s)" link. Blocking errors will present themselves when you attempt to upload the file.

 

 

Please note: When you are viewing the screenshots of errors, the number on the left-hand side represents the row number in which the error occurred. The name of the file will be listed above the full set of errors.

As always, feel free to reach out to the Integrations team if you are unable to resolve an error or have any questions about the import process.

Key

Blocking error: the import will not run until this error is fixed

Warning: the import will still run, but you may want to fix the data prior to importing

File Level Errors

missing_required_file (blocking)

What does this mean?

  • This error occurs if you are using the Full Import and leave off one or more of the three required files: users.csv, roster.csv, or classes.csv.

How do I fix this?

  • You will need to make sure that at least all three of these required files are included in your zip file.

What does this error look like in PowerSchool Learning?

invalid_file_format (blocking)

What does this mean?

  • One of the CSV files cannot be parsed.

How do I fix this?

  • Open your users.csv file in the text editor of your choice (Notepad, Notepad++, TextMate, etc.). Select all of the data (Control/Command + A) in the file and copy it to your clipboard (Control/Command + C).
  • Open a brand new text file with nothing in it, and paste (Control/Command + V) the data previously copied into this new text file. Save this new text file as users.csv and overwrite the "bad" version of the users.csv file. Then, zip up the folder with the new users.csv file and try the upload again.
  • If the above steps do not resolve the issue, please contact
  • If the above steps do not resolve the issue, please contact the Integrations team.

 

missing_required_column (blocking)

What does this mean?

  • You are missing a required column in one of your CSV files.

How do I fix this?

  • Make sure that each of your CSV files has all columns per the specifications.

What does this error look like in PowerSchool Learning?

invalid_column (blocking)

What does this mean?

  • There is an unrecognized column name in one of the CSV files.

How do I fix this?

  • Make sure that every column in all of your CSV files has the same as the column headers in the specification.

What does this error look like in PowerSchool Learning?

Row Level Errors

missing_required_value (warning)

Specific Error Messages:

Missing required value for organization_id
Missing required value for name
Missing required value for user_id
Missing required value for first_name
Missing required value for last_name
Missing required value for login
Missing required value for password
Missing required value for user_type

What does this mean?

  • A row in your data set is missing a required value. Required values are marked with an R in the middle column of the import specification. The row in question will not be created/update in PowerSchool Learning.

How do I fix this?

  • Locate the missing data within your file set and add a value to that field. Alternatively, if you allow Administrators to edit imported data (under Manage Domain -> Settings), then you can manually edit the account or class as necessary.

What does this error look like in PowerSchool Learning?

invalid_value (warning)

What does this mean?

  • One of the values in your data set does not have a valid format. For example, there is an invalid email address or a username.

How do I fix this?

  • You will need to locate the offending value in your data set and correct it to be a valid format. Alternatively, if you allow Administrators to edit imported data (under Manage Domain -> Settings), then you can manually edit the account or class as necessary.

What does this error look like in PowerSchool Learning?

invalid_reference (warning)

Specific Error Messages:

Cannot find class_id
Cannot find user_id
Cannot find teacher_id
Cannot find organization_id
Cannot find parent_id
Cannot find child_id

What does this mean?

  • One of the ids you referenced in your data set does not match a record in the PowerSchool Learning database. This can include a teacher_id that does not point to any user in a classes.csv file and/or a user_id or class_id that do not point to any user in a roster.csv file.

How do I fix this?

  • Locate the id in your file and change it to match an existing id for the next import.

What does this error look like in PowerSchool Learning?

duplicate_row (warning)

What does this mean?

  • If you have multiple rows for a single user in the import where each row has a different user_type, the only row that will be imported is the one with the highest user_type: from highest to lowest, the order is Teacher, Student, and then Parent. For example, if you have 2 rows in your import for a single user with user_types of Student and Parent, respectively, and the user exists in your PowerSchool Learning domain with a user_type of Teacher, the import will change the user_type to Student as it is the highest in the file.

How do I fix this?

  • You will need to locate the id in your file and change it to be unique from other ids in the file, and ideally throughout the PowerSchool Learning domain as well.

What does this error look like in PowerSchool Learning?

duplicate_value (warning)

What does this mean?

  • A duplicate value was found on a column that must be unique (marked by a U) on the import specification. For example, if you use the same username for two users, you will receive this error.

How do I fix this?

  • You will need to locate the id in your file and change it to match an existing id for the next import.

What does this error look like in PowerSchool Learning?

Powered by Zendesk