Work with Academic and Career Planner Data
Use the Data Import Manager and Data Export Manager to import or export data to and from PowerSchool.
General Import/Export File Rules
Import and export files do not support/include IDs (primary or foreign).
The order of the rows does not matter.
Flags (columns that begin with "is") are booleans and can be set as the following:
Positive: indicate as (case insensitive alphas): true, t, 1, yes, y, or blank
Negative: indicate as (case insensitive alphas): false, f, 0, no, or n
Column name localization is supported.
Import only supports insert, not update or delete. Any updates or deletions are completed within the UI.
Import is expected to be performed early in the school year as initial seeding.
Academic and Career Plan: Setup
Columns are specified (import)/selected (export) from the following tables:
Cluster (+ any extensions), ClusterType *,
Program (+ any extensions), ProgramType *,
Credential (+ any extensions) CredentialType *
Extensions are not supported for Types.
Import Business Rules
You can import:
Cluster/ClusterType only
Cluster/ClusterType & Program/ProgramType
Cluster/ClusterType, Program/ProgramType and Credential/CredentialType
Import is hierarchical:
Must have a Cluster to import a Program
Must have a Cluster and Program to import a Credential
You are responsible for creating appropriate data for the import.
There is column size limit validation for names (100 characters) and codes (5 characters).
Associations between tables are made based on each row in the file.
Types and their parents (For example, ClusterType and Cluster).
Association tables ClusterPrograms and ProgramCredentials are populated based upon the import row.
Export Business Rules
Export can be hierarchical depending on the columns selected.
It will be hierarchical if you export all columns,
It is not hierarchical if you only select ProgramName and ProgramCode,
YearID is the only built-In filter and is necessary to retrieve records.
YearID can be entered as the PowerSchool YearId (For example, 29) or 2019.
PowerSchool YearID is calculated starting at year 1990, so 1990 + 29 = 2019.
Example Import/Export File
YearId,ClusterName,ClusterCode,ClusterTypeName,ClusterTypeCode,ProgramName,ProgramCode,ProgramTypeName,ProgramTypeCode,CredentialName,CredentialCode,CredentialTypeName,CredentialTypeCode,isReimbursable
29,Cluster1,c1,ClusterType1,ct1,Program2,p2,ProgramType1,pt1,name2,code2,type1,t1,true
29,Cluster1,c1,ClusterType1,ct1,Program2,p2,ProgramType1,pt1,name3,code3,type1,t1,true
29,Cluster1,c1,ClusterType1,ct1,Program1,p1,ProgramType1,pt1,name1,code1,type1,t1,true
29,Cluster1,c1,ClusterType1,ct1,Program1,p1,ProgramType1,pt1,name2,code2,type1,t1,true
29,Cluster1,c1,ClusterType1,ct1,Program1,p1,ProgramType1,pt1,name3,code3,type1,t1,true
29,Cluster2,c2,ClusterType2,ct2,Program3,p3,ProgramType1,pt1,name3,code3,type1,t1,true
29,Cluster2,c2,ClusterType2,ct2,Program4,p4,ProgramType2,pt2,name5,code5,type1,t1,true
29,Cluster2,c2,ClusterType2,ct2,Program4,p4,ProgramType2,pt2,name6,code6,type1,t1,true
29,Cluster2,c2,ClusterType2,ct2,Program3,p3,ProgramType1,pt1,name1,code1,type1,t1,true
29,Cluster2,c2,ClusterType2,ct2,Program3,p3,ProgramType1,pt1,name2,code2,type1,t1,true
29,Cluster2,c2,ClusterType2,ct2,Program4,p4,ProgramType2,pt2,name7,code7,type1,t1,true
29,Cluster1,c1,ClusterType1,ct1,Program2,p2,ProgramType1,pt1,name1,code1,type1,t1,true
Academic and Career Plan: Location
Columns are selected from the following tables:
Locality
Sites
Import Business Rules
You have two import options.
Locality only
Locality and Site
When importing Site, Locality and SiteName is required.
Import files must contain records for a single year. If multiple years of data are being imported, separate import files must be used.
For locality, if isHomeDistrict is TRUE, then a LocalityName is not required because "home_district" (not internationalized) will be saved to the database.
Only one "isHomeDistrict" import row value can be set to true.
Rows that have a SchoolNumber column value are considered to be a home_district school.
SiteName is not required in this instance since the persisted SiteName will be "school_site_###", where ### is the DCID (the SchoolNumber is used to find SchoolDcid).
Address information is ignored.
If address columns are specified, only non-home_district column values will be added to the Site table. The value for State will be identified in the CodeSet table to get the StatesCodeSetId and CountryCodeSetId.
Export Business Rules
LocalityName
"home_district" is exported as District Office. This name is taken from a PowerSchool application cache built upon startup.
Non-home_district LocalityName is exported as it appears in the Site table.
When exporting columns for a "home_district" school (has a Site SchoolDcid column value):
SiteName is exported as the actual Schools.Name value.
SchoolNumber - SchoolDcid is exported as the Schools.School_Number value.
Street - Schools.SchoolAddress
City - Schools.SchoolCity
PostalCode - Schools.SchoolZipCode
State - Schools.SchoolState
Example Import/Export File
YearId,LocalityName,isHomeDistrict, SiteName,isActive,SchoolNumber,Street,LineTwo,Unit,City,PostalCode,State
28,Penryn,false,Acme Auto,true,,123 Main Street,,100,Penryn,95663,CA
28,Penryn,false,Will's Beekeeping,true,,1000 Stinger Way,,250,Loomis,95650,CA
28,District Office,true,Castle Grayskull,true,130,150 Parkshore Dr,,,Folsom,95630,CA,,
28,District Office,true,Beowulf High,true,899020,,,,,,
28,District Office,true,Attendance,true,900000001,,,,,,
Import Academic and Career Plan Data
Use the Data Import Manager to import Academic and Career Plan data into Academic and Career Plan: Setup or Academic and Career Plan: Location.
Export Academic and Career Plan Data
Use the Data Export Manager to export Academic and Career Plan data from PowerSchool Data Sets or Academic and Career Plan. If exporting from Academic and Career Plan, you can export from:
Academic and Career Plan Get* are the Power Queries used by the UI to display values. What is selectable is depends on how the PowerQuery is constructed. Extensions are supported.
Academic and Career Plan* are the tables you can export. IDs and extensions are included.
Academic and Career Plan table extensions.
Populate Setup and Location
After setting up Academic and Career Plan, you can use the Data Export Manager and Data Import Manager functions to populate Setup and Location data for the next year. Export all Academic and Career Plan: Setup, manually change the YearID, and then import the file.