Import Data into PowerSchool ERP
Import Wizard
Click Import on a page's action bar to launch a wizard that will guide you through the following steps:
- Upload a file.
- Map the columns on the file to the fields in the database table.
- Map static columns that are required but not defined in the file.
- Save the mapping that was created for future file imports.
- Generate a list of warnings and error messages found during the data validation.
File Requirements
Your ability to import a file depends on the following:
- The data in the file fields must comply with the field requirements of the page to which you are importing. For example, if a field requires numeric data and the file contains characters, the system cannot import the file.
- The file must be formatted as XML Spreadsheet 2003, Comma Separated (CSV), Tab-Delimited (TXT), or Pipe-Delimited ( I ).
- The extension on the file to be imported must be *.xml, *.exml, *.csv,*.txt, or *.unl.
- You must have the appropriate security resource to access the Import item.
Import a File
- Click Import to display the File to Import Data and Selection page.
- Click Choose File or Browse in the File to Import field to locate the file to import from your computer or network.
- Select the desired file, and click Open to display the path and file name in the File to Import field. Depending on the software version, you may be able to drag and drop the file.
- Click Load to load the data from the file.
In the Import File Data section, select the line to use for column titles and click Set Column Titles. The data selected will appear in the section's column headings.
If you select an incorrect line, click Reset Column Titles to reinstate the line in the list, and repeat the step with the correct line selected.- After the column titles are set, select the lines to import from the file.
- To select a range of lines, hold down the Shift key, click the first line in the range, and then click the last line.
- To select multiple lines individually, hold down the Ctrl key, and click each line.
- To select all lines, click Select All.
- After selecting the lines, click Next.
- On the Define Column Mapping page:
Select a mapping in the Saved Import Mapping field.
or
Tab into the Table Field column for the first Import File Column, and select the file column from the database table to map to the column listed in the Import File Column field on the left. The Field Description column displays the column's user-friendly name and cannot be changed. Map the additional fields accordingly. - Click Next.
- If the data in the file does not meet the requirements of the database table, the Import Errors page will display. You cannot proceed until either the file or the mapping is corrected.
- If there are no errors but some required fields from the database are not mapped, the Static Column Value Mapping page displays. Complete Steps 10-11.
- If there are no errors and all required fields are mapped, proceed to Step 12.
The Static Column Value Mapping page displays required fields from the database table that were not mapped on the Define Column Mapping page. Add values as needed. Click Append Row to add other fields that have not been mapped if needed.
The values you enter on the Static Column Mapping page apply to all lines of the file being imported.- After the static mapping is complete, click Next.
Optionally, you can save the mapping that you set up to be used for a future import.
Mapping Name
Assign a unique mapping name. Character/38
Owner
User name of the person importing the file. Read-only.
Public
Select the checkbox to enable others to use the mapping file.
Restricted
Select the checkbox to prevent others from changing the mapping file.
Save Options
Select:
- Create new mapping - to create a new mapping file under the name assigned.
- Update existing mapping - to save changes to an existing mapping file. Not available when you create a new mapping file or if changing the file is restricted.
- Do not save mapping - to only use the mapping for the current file.
On the Save Import Mapping page, enter a unique name to identify the mapping, and then complete the following fields:
The ability to add and update an import mapping on the Save Import Mapping page is dependent on security.- Click Finish to exit the Import wizard.
- If any errors or warnings are encountered during data validation when the file is imported, the Import Status page displays. The page lists the errors and warning messages.
- The Display Results field provides options for controlling the display: Warnings Only, Errors Only, Warnings/Errors Only, or Show All.
- The page's Line # column lists the line numbers in the import file for finding the data that must be corrected.
- The Summary Information section displays the number of Errors, Warnings, and Successes.
At this point, you can:
- Click Print to print the list of errors.
- Click Import on the action bar to import any successes. If there are no successes, this item will not display.
- Click Back to exit, correct the file, and then re-run the import procedure.
- If there are no errors or you clicked the Import item in the last step, a Confirmation dialog will display. Click Yes to import the file and generate a final Confirmation.
Fields
File Import And Data Selection Page
Initiate the Import wizard and select the file and records to import.
Field | Description |
---|---|
File to Import | Location and name of the file on your computer or network server. |
Line # | Identifies the line in the file to be imported. |
Column 1 to Column 100 | Identifies the column headings for the file to be imported. |
Define Column Mapping Page
Map the columns in the import file to the fields in the database table.
Field | Description |
---|---|
Saved Import Mapping | Lists the mapping you created or mappings set to public. When a saved mapping is selected, the table field mapping displays in the Column Mapping section of the page. |
Import File Column | Lists the Column Titles set on the File to Import Data Selection page. |
Table Field | Lists the table and field names from the database table. Select the field you want to map to the Import File Column. |
Field Description | User-friendly name for the value in the Table Field column. Read-only. |
Import Errors Page
Generate a list of errors when the data in the file does not match the requirements of the fields on the selected page. These are the same messages you receive when you manually add a record to the page.
Field | Description |
---|---|
Line # | Identifies the line in the file to be imported. |
Import File Column | Lists the Column Titles set on the File to Import Data Selection page. |
Table Field | Lists the table and field names from the database table. |
Value | Displays the data in the field generating the error. |
Error Message | Error message explaining why the value does not meet the database's requirements. |
Static Column Mapping Page
Statically map required fields in the database table to a value.
Field | Description |
---|---|
Table Field | Lists the table and field names from the database table that have not been mapped on the Define Column Mapping page. Required fields default in this field. Add non-required fields by selecting Append Row. |
Field Description | User-friendly name for the value in the Table Field column. Read-only. |
Value | Displays the value that will be used for all rows in the file being imported. |
Save Import Mapping Page
Save the mapping created for future imports (optional).
Field | Description |
---|---|
Mapping Name | Accepts a unique name for identifying the mapping. Character/38 |
Owner | Identifies the user who created the mapping. When a user updates the mapping, the user's ID, as well as the date and time, will display next to the field. Read-only. |
Public | Checkbox for allowing all users to access the mapping. The mapping will appear in the Saved Import Mapping field of the Define Column Mapping page. If the checkbox is blank, only the owner can access the mapping. |
Restricted | Checkbox for preventing all users except the owner from updating the mapping. If the checkbox is blank, all users will be able to enter updates. |
Save Options | Indicates how the mapping should be saved. Select:
|
Import Status Page
This page displays errors and warning messages generated during the validation of the imported data.
Field | Description |
---|---|
Number of Errors | Displays the count of errors found during validation that will prevent the data from being imported. Read-only. |
Number of Warnings | Displays the count of warnings found during the data validation. Warnings will not prevent the data from being imported. Read-only. |
Number of Successes | Displays the count of successes found during the data validation. Read-only. |
Display Results | Allows you to specify the records to display in the page's list, as well as on the Import Status report. Select:
|
Indicator | Displays symbols for identifying warnings, errors, and successes. |
Line # | Identifies the lines in the file to be imported. |
Status | Displays the errors and warning messages generated during data validation. Also displays successes if Show All is selected in the Display Results section. |