Import data using the Data Import Manager
Once you have prepared your import file, you can import the data using the Data Import Manager.
Verify that you are signed in to the appropriate school.
Navigate to the Data Import Manager page.
Use the following table to enter information in the Select Source and Target fields:
Field | Description |
|---|---|
Source | 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. |
Import Into | Indicate which data set you want to import the data into by choosing one of the following: Custom tables only appear if your district allows importing into custom tables at the school level. |
Field Delimiter | Choose which delimiter to use to separate the fields in the exported data:
Adjacent field only appears editable if Other is selected. Only one character may be entered. A double-quote character is not allowed. This field only appears if applicable to the Import Into selection. |
Character Set | Choose the character set for the import file. This selection is specific to the operating system where the import file was created:
This field only appears if applicable to the Import Into selection. |
Click Next or the Map Columns header.
The Next button and the Map Columns header appear shaded until the Source and Import Into are populated.Use the following table to enter information in the Map Columns fields:
Field | Description |
|---|---|
Select Template | To apply a template:
To delete a template:
If no templates have been saved, this button appears disabled. Click column headings to sort templates in ascending order. Click again to sort in descending order. |
Import File Column | This section displays the fields from the import file. |
PowerSchool Field | This section displays the suggested PowerSchool field for each field from the import file. To map a field from the import file, choose a PowerSchool field. Student Email For Student Email, only Student Number and Email appear mapped. Student Number is required for importing Student Emails. All other imported fields appear blank. Incident Primary fields in the Incident data set may only be mapped once. Secondary fields may be mapped one or more times. For more information, refer to Importing Incidents. |
Save Template | If you import the same fields of data frequently, you can create a template so that you don't have to define the field import map every time you perform an import. To create a new template:
To edit a template:
|
Click Next or the Select Options header.
The Next button and the Select Options header appear shaded until at least one column is mapped, an identifier (required field) is mapped, and the same primary column is not mapped more than once.Use the following table to enter information in the Select Options fields:
Field | Description |
|---|---|
Check to exclude the first row. | Do one of the following:
If one or more columns are auto-mapped, the checkbox is automatically selected. If no columns are auto-mapped, the checkbox is not automatically selected. |
If a record in the import file matches an existing record in the database, how would you like that record processed? | If you are importing to the Student Email table, select one of the following options to determine what you want the system to do when a student record in the import file contains a student ID number that already exists in PowerSchool:
This field does not appear if you are importing to the Incident table. |
Check to confirm that records should be deleted if blank rows exist in the import file. All columns in a table must be present in the import file. | Check to confirm that all data in a given column should be deleted if blank records exist for all rows in the import file for that column. All columns in a table must be present in the import file. Do one of the following:
|
Click Import. The Import Results page displays a summary of the processed records:
Field | Description |
|---|---|
Refresh | Click to update the status of the report. To set the automatic page refresh:
|
Processed # out of # records | The first number represents the number of records processed. The second number represents the total number of records in the import file including the header row. |
Failed | Incident If a record could not be imported due to an error, the row number of the record along with one of the following reasons appear:
The <code type> portion of the message will be replace by the applicable code type that had the error. In addition to the above errors, a record may not be imported due to a data validation error. If a data validation error occurs, "[field name]: " appears along with one or more of the following explanations:
Student Email If a record could not be imported due to an error, the row number of the record along with one of the following reasons appear:
Click column heading to sort in ascending order. Click again to sort in descending order. |
Imported | If a record was successfully imported, the row number of the record along with one of the following results appears indicating whether an imported record was cleared, added, ignored, or updated during the import:
Click column heading to sort in ascending order. Click again to sort in descending order. |
Download Failed Records | Click to download the failed records. Downloaded file appears in the format of the original import file. This can be used to easily identify which records had problems during import so that corrections can be made and the import can be reattempted. This button is only available once the import process has completed. |