Quick Import

Table

Choose the table to which the data will be imported from the menu.

When importing multiple section records, the expressions of the sections defined by your school are required. An expression is the combination of the periods and days in which the section meets. Though PowerSchool creates internal values for periods and days, you should import the actual values that you want to appear when the system displays expressions. An invalid expression causes an error for that record, which results in the failed import of that record.

• If you choose the Student Schedules (CC table), be sure to include data in the import file for the required fields:

• 
  

  • Student_Number

  • Course Number

  • Section Number

  • DateEnrolled

  • Dateleft

  • TermID (Import Term File # value provided on the Edit Term page)

  • SchoolID

If you include the Dropped column in your import file, any record with a value of True will be imported as a dropped enrollment.

If you want to choose the Courses table, but it does not appear in the selection menu, then the district may only allow new courses to be created at the district office.

If you select Test Results, the import file should not have data in the first row. This row is treated as a header and is skipped in importing.

Field Delimiter

Choose the field delimiter from the menu. This refers to the item that will separate the fields in the exported data.

• Tab: Separates fields with a tab

• Other: Enter a field delimiter in the blank field, such as a comma

End-of-Line Marker

Choose the end-of-line marker from the menu. This refers to the item that will separate the records in the exported data.

• CR: Carriage return

• CRLF: Carriage return line feed

• LF: Line feed

• Other: Enter a delimiter in the blank field

Suggest Field Map

Select to have the system suggest into which PowerSchool field each piece of data in the data file is saved. These are just suggestions and can be changed before saving.

From Your File

The fields of the first record from the import file appear.

To PowerSchool

If you select Suggest field map on the Quick Import page, the PowerSchool fields suggested for each piece of data imported appear.

If you do not select Suggest field map or you need to change the fields, choose the PowerSchool field into which the system imports the data from the import file.

Check to exclude first row

Select to prevent importing the header row.

The lines below can be used to assign a constant value to field(s) in all of the imported records.

To enter a new value in a PowerSchool field for all records from the import file, such as entering the same city for all student records in an import file:

1. Enter the value you want to import for all records.

2. Choose the PowerSchool field into which the system imports the value.

Attendance

Select Overwrite existing attendance with the imported attendance if you want the system to use the imported attendance data in cases where attendance codes already exist for that day or class.

Comment Bank

Select Update comment bank records if you want the system to use the imported comment bank comments in cases where there are already comment bank comments with the same code.

Courses

Select Update course records if you want the system to add course-related information to existing course records in cases where the course numbers are the same.

Historical Grades

Do the following:

• If you want the system to include more than one score for a student only when the term and storecode are the same, select Allow multiple grades for a student to be stored.

• If the courses in the import file have unrecognized names and you want to specify the course number range for the imported courses, select If a course name is imported that is not recognized and enter the range for the new course numbers in the range fields. If selected, the system will assign a random course number in the 90000 range if the range values are left blank.

  When no course number is defined for a row in the import file, the course number will be derived from the district course list by course name.

• To store grades that include neither a letter grade nor any earned credit, select Allow grades to be stored which contain both.

Immunizations

Do the following:

• If you do not want the system to import immunization data that already exists for a student, select Where values exist in the import file and in PowerSchool, DO NOT IMPORT the values.

• If you do want the system to import immunization data that already exists for a student, select Where values exist in the import file and in PowerSchool, OVERWRITE the values in PowerSchool with the values in the import file.

Meal Transactions

Select Use PowerSchool's internal student id numbers if you want the system to reference the ID field versus the student_number field.

Sections

Do the following:

• Select Update section records if you want the system to add section-related information to existing section records in cases where the course and section numbers are the same.

• If your school uses AutoComm to synchronize your data in PowerSchool with data in another system, select Synchronize Mode to perform an AutoComm import. Check with your PowerSchool administrator before using this option.

  Do not use this option unless you are an advanced PowerSchool SIS user. Check with your PowerSchool administrator before selecting this option.

  Synchronize mode should only be used when PowerSchool SIS data is synced from another student data source. PowerSchool SIS records not included in the import file will be dropped, transferred out, or removed.

  
  

Students

• If the file you are importing contains a student number that matches an existing PowerSchool student number:

  • Select Do not process that line from the file being imported if you do not want the system to import any record with a student number that already exists.

  • Select Update the student's record with the information from the file being imported if you want the system to update the matching student's record with the data in the import file.

  • Select Generate a new, unique student number for the student (from the range specified below) if you want the system to create a new record if a student ID number is in the import file.

• If the file you are importing contains a student number of zero or Generate a new, unique student number for the student is selected:

  • Select Generate new student numbers at random from within this range and enter the number range within which you want the system to generate and assign the new student ID numbers

  • Otherwise, leave blank.

• If your school uses AutoComm to synchronize your data in PowerSchool with data in another system, select Synchronize Mode to perform an AutoComm import.

  Do not use this option unless you are an advanced PowerSchool SIS user. Check with your PowerSchool administrator before selecting this option.

  Synchronize mode should only be used when PowerSchool SIS data is synced from another student data source. PowerSchool SIS records not included in the import file will be dropped, transferred out, or removed.

  It is a system requirement that you must import at least 20 student records.

• If the file being imported contains a student number that matches an existing PowerSchool student number and Update the student's record with the information from the file being imported or Generate a new, unique student number for the student (from the range specified below) is selected, you can select Allow Update of Enroll Status to update students' enrollment status.

  For advanced users only. For valid values, refer to the Students table in the PowerSchool Data Dictionary Tables. If the value is left blank, it is treated as a zero, which equates to currently enrolled.

Student Schedules

Do the following:

• Select Normal Mode to import records for the active terms of the current school. If no SchoolID is included in the import file, the system defaults to this mode.

• Select Synchronize Mode if your school uses AutoComm to synchronize your data in PowerSchool with data in another system. When selected, all other Advanced Import Options are unavailable and the system defaults to Normal Mode.

  Synchronize Mode drops existing section enrollments and imports new enrollments from your import file. For example, if a student is currently enrolled in English during second period and the import file contains a record for that student for Science second period, the system will drop the student's section enrollment for English and import the Science section enrollment.

  Do not use this option unless you are an advanced PowerSchool SIS user. Check with your PowerSchool administrator before selecting this option.

  Synchronize mode should only be used when PowerSchool SIS data is synced from another student data source. PowerSchool SIS records not included in the import file will be dropped, transferred out, or removed.

  
  

  If the course and section numbers are shared across multiple schools, it is recommended that you include the SchoolID in the import file. If the course and section numbers are shared across multiple schools and the SchoolID is not included in the import file, the system will not import the records, and the following alert appears, "Not Imported: The import school: ( ) does not match the current school. Skipping Record."

• Select Historical Mode to import records for any term for the current school. This option is only available when the import files include SchoolID data.

• Select District Mode to import records for active terms at any school. This option is only available when signed in to the district office.

• Select Historical and District Modes to import records for any terms at any school. This option is only available when signed in to the district office.

Teachers

Select Update teacher records if you want the system to add teacher-related information to existing teacher records in cases where the teacher numbers are the same.

Test Scores

Import PowerSchool test scores.