Installing the Custom File

Download the new Custom File Here.

On KAMAR go to Setup -> Custom Files

Press the “Upload File” button

Choose which lists file to upload this into.

Then press upload.

Find the Lists.fmp12 that you downloaded and upload it here.

Then, with Lists file you uploaded the file to in the previous step selected, press the “Permissions” button and press “Reset Authentication” and “Reset Authorisation” one after the other. This will reset all the permissions on the file.

Then press the “Open File” button. This will bring up a screen that looks like this:

Click on File -> Manage -> Scripts

This will bring up a screen that looks like the one below. Double click on the option ‘Action_ServerScript’ located on the left side menu.

On line 16 double click where it says “https://hosted.assay.co.nz/school/”. This will bring up a little popup that looks like this:

Press on the specify button and change the url to match the one that you use to access assay. Be sure to keep the double quotes surrounding the url.

Once completed press “OK”

Repeat this for Line 17, replacing “authentication” with the authentication that is in Assay -> Admin -> Config. Again making sure to keep the double quotes.

Save the script (File -> Save or CTRL-S) and close out of the script editor,  and you’re done for this part.

Exporting Data for Previous Years

Please note, this can take a little while to run… so you may want to get it running and then go find something else to do.

On KAMAR go to Database Tools -> Assay Scripts

Click on Assay Previous Year Results and click OK, then a window will appear where you can specify which Year you want to export. Click OK on that and then another window will appear asking where to save the export. Choose where to export the data and name it (Specified Year)Results.csv, e.g 2022Results.csv. Click Save and the export will start.

Exporting Core Data

Copy the all the list in red text below:

ID Number
Last Name  (Preferred)
First Name  (Preferred)
Student email - School
All Subjects with Teachers (semi-colon)
Ethnicity - Level 1 Group
Gender
Year Level
NZQA - Credits Level 1 - Achieved
NZQA - Credits Level 1 - Merit
NZQA - Credits Level 1 - Excellence
NZQA - Level 1 NCEA (Short)
NZQA Results - L1 NCEA Endorsement
NZQA - Credits Level 2 - Achieved
NZQA - Credits Level 2 - Merit
NZQA - Credits Level 2 - Excellence
NZQA - Level 2 NCEA (Short)
NZQA Results - L2 NCEA Endorsement
NZQA - Credits Level 3 - Achieved
NZQA - Credits Level 3 - Merit
NZQA - Credits Level 3 - Excellence
NZQA - Level 3 NCEA (Short)
NZQA Results - L3 NCEA Endorsement
NZQA - Numeracy
NZQA - L1 Literacy
NZQA - UE Literacy
NZQA Results - UE Num
Attendance - Percentage  (Half-Days)
Enrollment Status
NZQA - Credits Level 1 - Not Achieved
NZQA - Credits Level 2 - Not Achieved
NZQA - Credits Level 3 - Not Achieved
House
Type
Leaving Date
Tutor
Ethnicity - Level 2 Group
Pastoral Attendance Item Count
Pastoral Classroom Item Count
Pastoral Demerits Total All
Pastoral Demerits Total Current
Pastoral Discipline Item Count
Pastoral Guidance Item Count
Pastoral Other Item Count
Pastoral Points Total All
Pastoral Points Total Current
Pastoral Total Item Count
Pastoral Uniform Item Count
Recognitions - Item Count
Periods - Absent (Year)
Periods - Justified (Year)
Periods - Unjustified (Year)
Attendance - Total Periods (Year)
Previous School 1 Name
National Student Number (NSN)
Timetable Class (Bottom 3)
Timetable Class (Top 4)
Timetable Class
Attendance by Code - ? (Year)
Attendance by Code - A (Year)
Attendance by Code - C (Year)
Attendance by Code - D (Year)
Attendance by Code - E (Year)
Attendance by Code - F (Year)
Attendance by Code - G (Year)
Attendance by Code - H (Year)
Attendance by Code - I (Year)
Attendance by Code - J (Year)
Attendance by Code - K (Year)
Attendance by Code - L (Year)
Attendance by Code - M (Year)
Attendance by Code - N (Year)
Attendance by Code - O (Year)
Attendance by Code - P (Year)
Attendance by Code - Q (Year)
Attendance by Code - R (Year)
Attendance by Code - S (Year)
Attendance by Code - T (Year)
Attendance by Code - U (Year)
Attendance by Code - V (Year)
Attendance by Code - W (Year)
Attendance by Code - X (Year)
Attendance by Code - Y (Year)
Attendance by Code - Z (Year)
Attendance by Code - Term 1 - ?
Attendance by Code - Term 1 - A
Attendance by Code - Term 1 - C
Attendance by Code - Term 1 - D
Attendance by Code - Term 1 - E
Attendance by Code - Term 1 - F
Attendance by Code - Term 1 - G
Attendance by Code - Term 1 - H
Attendance by Code - Term 1 - I
Attendance by Code - Term 1 - J
Attendance by Code - Term 1 - K
Attendance by Code - Term 1 - L
Attendance by Code - Term 1 - M
Attendance by Code - Term 1 - N
Attendance by Code - Term 1 - O
Attendance by Code - Term 1 - P
Attendance by Code - Term 1 - Q
Attendance by Code - Term 1 - R
Attendance by Code - Term 1 - S
Attendance by Code - Term 1 - T
Attendance by Code - Term 1 - U
Attendance by Code - Term 1 - V
Attendance by Code - Term 1 - W
Attendance by Code - Term 1 - X
Attendance by Code - Term 1 - Y
Attendance by Code - Term 1 - Z
Attendance by Code - Term 2 - ?
Attendance by Code - Term 2 - A
Attendance by Code - Term 2 - C
Attendance by Code - Term 2 - D
Attendance by Code - Term 2 - E
Attendance by Code - Term 2 - F
Attendance by Code - Term 2 - G
Attendance by Code - Term 2 - H
Attendance by Code - Term 2 - I
Attendance by Code - Term 2 - J
Attendance by Code - Term 2 - K
Attendance by Code - Term 2 - L
Attendance by Code - Term 2 - M
Attendance by Code - Term 2 - N
Attendance by Code - Term 2 - O
Attendance by Code - Term 2 - P
Attendance by Code - Term 2 - Q
Attendance by Code - Term 2 - R
Attendance by Code - Term 2 - S
Attendance by Code - Term 2 - T
Attendance by Code - Term 2 - U
Attendance by Code - Term 2 - V
Attendance by Code - Term 2 - W
Attendance by Code - Term 2 - X
Attendance by Code - Term 2 - Y
Attendance by Code - Term 2 - Z
Attendance by Code - Term 3 - ?
Attendance by Code - Term 3 - A
Attendance by Code - Term 3 - C
Attendance by Code - Term 3 - D
Attendance by Code - Term 3 - E
Attendance by Code - Term 3 - F
Attendance by Code - Term 3 - G
Attendance by Code - Term 3 - H
Attendance by Code - Term 3 - I
Attendance by Code - Term 3 - J
Attendance by Code - Term 3 - K
Attendance by Code - Term 3 - L
Attendance by Code - Term 3 - M
Attendance by Code - Term 3 - N
Attendance by Code - Term 3 - O
Attendance by Code - Term 3 - P
Attendance by Code - Term 3 - Q
Attendance by Code - Term 3 - R
Attendance by Code - Term 3 - S
Attendance by Code - Term 3 - T
Attendance by Code - Term 3 - U
Attendance by Code - Term 3 - V
Attendance by Code - Term 3 - W
Attendance by Code - Term 3 - X
Attendance by Code - Term 3 - Y
Attendance by Code - Term 3 - Z
Attendance by Code - Term 4 - ?
Attendance by Code - Term 4 - A
Attendance by Code - Term 4 - C
Attendance by Code - Term 4 - D
Attendance by Code - Term 4 - E
Attendance by Code - Term 4 - F
Attendance by Code - Term 4 - G
Attendance by Code - Term 4 - H
Attendance by Code - Term 4 - I
Attendance by Code - Term 4 - J
Attendance by Code - Term 4 - K
Attendance by Code - Term 4 - L
Attendance by Code - Term 4 - M
Attendance by Code - Term 4 - N
Attendance by Code - Term 4 - O
Attendance by Code - Term 4 - P
Attendance by Code - Term 4 - Q
Attendance by Code - Term 4 - R
Attendance by Code - Term 4 - S
Attendance by Code - Term 4 - T
Attendance by Code - Term 4 - U
Attendance by Code - Term 4 - V
Attendance by Code - Term 4 - W
Attendance by Code - Term 4 - X
Attendance by Code - Term 4 - Y
Attendance by Code - Term 4 - Z

On KAMAR in the top right change the year to the year you want to export the results for (eg: 2020)

Then go to Reporting -> Student Lists

And then click on “Student List – Custom Fields” and press the magnifying glass in the Student Search

Filter

Change the “Find” to “All” and press continue

Then press the “OK” button under the list of students

Click the “Field List” button, and paste in the list we copied earlier, and press the “Apply” button.

This will update the display. Depending on the number of students, this could take a little bit of time.

Then press Actions -> Export, making sure the settings are the same as below.

Then press “OK” This will then ask you where you want to save it. Choose your location and name the file the year you have exported, e.g 2022.csv, then click Save.

This will bring up a slider showing the export process:

Once it has finished make sure the file is created where you were expecting it.

Uploading to Assay

On Assay go to Admin -> Upload Data. Change the year at the top to the year you want to load the data for. Press the two chosen file buttons… the first one you want to upload the Core Data, the second one the Results data. After choosing the file you need to press the “Upload” button and it will tell you if it has been successful.

Then scroll right to the bottom of that window and press the “Process” button. This will show the process on the screen and tell you when it has finished.