Dashboard > Dashboard Guide > Aspen/MyEducationBC > Aspen/MyEducationBC Student Export

Aspen/MyEducationBC Student Export

• Overview
• Student List
• CSV File Review
• CSV File Export
• App Dashboard Import

See also:

• Aspen/MyEducationBC Index

Overview

In Aspen/MyEducationBC, you can export all of your parents and students for the purpose of Mass Notification using Appazur. Each school is a bit different, but you should be able to set up the export settings once and then use the same settings each time. After the Aspen/MyEducationBC export, you will upload the file to the Appazur dashboard using your desktop browser as described below: Appazur Dashboard Import.

Student List

• In Aspen/MyEducationBC, choose Student in the top tab.

If you do not have a saved Appazur Students field set from a previous export, you’ll need to customize the view and choose the required fields.

Choose the following fields:

Note: The quoted text in parentheses is how the column headings will appear in the csv export automatically. Please do not rename any column headings in the CSV file.

• Legal First Name (“LegalFirst”)*
• Legal Last Name (“LegalLast”)*
• Pupil #
• Primary email (“Email1”)*
• Cell phone (“CellPhone”)*
• Home phone (“HomePhone”)
• Grade
• School ID (required for some district-wide imports)
• Emergency contact 1 > Legal last name (“LegalLast”)*
• Emergency contact 1 > Legal first name (“LegalFirst”)*
• Emergency contact 1 > Parental Auth or Guardian (“Parent or Guardian?”)*
• Emergency contact 1 > Primary email (“Email1”)*
• Emergency contact 1 > Cell phone (“CellPhone”)
• Emergency contact 1 > Home phone (“HomePhone”)
• Emergency contact 2 > Legal last name (“LegalLast”)
• Emergency contact 2 > Legal first name (“LegalFirst”)
• Emergency contact 2 > Parental Auth or Guardian (“Parent or Guardian?”)
• Emergency contact 2 > Primary email (“Email1”)
• Emergency contact 2 > Cell phone (“CellPhone”)
• Emergency contact 2 > Home phone (“HomePhone”)
• Emergency contact 3 > Legal last name (“LegalLast”)
• Emergency contact 3 > Legal first name (“LegalFirst”)
• Emergency contact 3 > Parental Auth or Guardian (“Parent or Guardian?”)
• Emergency contact 3 > Primary email (“Email1”)
• Emergency contact 3 > Cell phone (“CellPhone”)
• Emergency contact 3 > Home phone (“HomePhone”)

The fields must be in the order specified above. Please do not omit any fields that are marked with a ‘*’. Both first and last name must be provided for each contact.

CSV File Export

• Click on Printer and select CSV.
  • Do NOT choose the default .txt or Excel format.
• Save the file. You’ll need to know where on your computer the file is saved (probably Downloads).
• If the file opens in Excel automatically, that is okay too.
• Then, import the saved file into your App Dashboard as described in the next section.

If you open the file in Excel to make changes, or because your computer opens Excel automatically, you will need an extra step. If you have a recent version of Excel, save in CSV (UTF-8) format. Otherwise, on the Dry Run screen of the Dashboard, pick Excel in the Encoding box. This will resolve errors with French accents and other special characters.

CSV File Review (optional)

• You may optionally open the CSV file in Microsoft Excel or Google Sheets.

• You may want to remove any records you do not want to use with Appazur.

• You may wish to ensure that only parents and guardians are included, not other emergency contacts.

App Dashboard Import

Instructions:

• From the Dashboard home page, go to App Users.
• Click the Import button (in the upper right corner).
• Click the Add Import Data button (in the upper right corner).
• Choose the CSV file that you exported from MyEdBC.
• Click Save. Note that this is just a “Dry Run” - nothing will actually take effect yet!
• After a short delay, you should see a screen that gives a bunch of INFO and WARNINGS.
• Scroll through, looking for ERRORs and WARNINGs.
• If you find you need to make changes in MyEdBC, go back to the Add Import Data step and repeat. Or, go back to the Import Data page, click on the link under Import Type in the first row, click Choose File, and choose the new export.
• If you cannot resolve all the ERRORS and WARNINGS, contact Support for review and assistance.
• If you have resolved any errors and warnings, click Import to complete

Finally, go to App Users in the App Dashboard and check that the parents and students are listed correctly.

If you see an ERROR like UnicodeDecodeError then please choose an Encoding from the drop down list:

Top of page