Scope
Steps to export a CSV file with student and parent data from ScholarPack.
Instructions
-
In ScholarPack, go to Admin > Config > Data Exports.
-
Scroll down the drop-down menu to the section for Teachers2Parents.
-
Select the SP_T2P_ParentsEvening_Students option.
-
Click Generate Report download the CSV file.
-
Once downloaded, open the CSV file in Microsoft Excel.
-
In the Parental Responsibility column, you will need to change every cell with the number 1 to Y for Yes. If you do not, none of your parents will import into ParentsEvening.
-
To do this in bulk, highlight the Parental Responsibility column.
-
Hold the CTRL key and press F to open the Find and Replace window.
-
Click on the Replace tab.
-
In Find what, type 1.
-
In Replace with, type Y.
-
Click Replace All.
-
This will automatically every instance of 1 in that column with Y. Click OK in the confirmation window and Close the Find and Replace window.
-
-
Click Save and rename the file to include the school name.
-
Read our guide to continue: ParentsEvening: Import Students and Parents.