Exporting Student Details from CASES21

This looks like a little Excel spreadsheet with a magnifying glass on it.

Step 3 

Click Add Table (you may have to click Design mode first).

Step 4

Select the ST Students table.

1. Click Minor on the left of the table select window.
2. Scroll down to ST Students and select it.
3. Then click OK.

Step 5

Select the fields required.

Double click the fields required (listed below) in the 'ST' list.

The list below contains all fields required for SPAplatform template preparation.

1. SCHOOL_YEAR
2. SURNAME
3. FIRST_NAME
4. STKEY
5. MID_NAME or SECOND_NAME
6. PREF_NAME
7. GENDER
8. BIRTHDATE
9. KOORI
10. PSDREQ
11. ENG_SPEAK
12. HOME_GROUP
13. STATUS

Select only the active students.

IMPORTANT NOTE: You must enter the following =’ACTV’ in the criteria cell under STATUS or you will get all your past students, not just the active ones.

Step 7

Un-tick Show under the * field and Status Cells field.

Step 8

Click Apply.

Step 9

Select the data to export to Excel.

Click the box in the top left corner to select all the records.

Step 10

Click Export to Excel.

Click yes if prompted to trust the VB code.

This will open up Excel with your CASES21 data in it.

You're now ready to paste your data into your Student Import file.
Please go to Updating Student Details - Bulk for instructions on how to import this file into the SPAplatform.