Truncate the MySQL staging table: “aa_ach_collegeboards”. The College Board export is a CSV file but must be saved as an XLSX file to better handle the importing of date fields.

The column names for the SAT verson of the file needs to be renamed: _SAT_ to _PSAT_ to better match the MySQL staging table.

Open the PSAT/SAT csv file and save it as an XLSX file.

If this is an SAT file rename the column header globally by finding _SAT_ and replacing with _PSAT_.

Insert one column to the left of A and name it: TestPeriod. Populate the column like: “Spring 2019 PSAT”.

Run the SQL scripts: “SE AA College Boards”.