Table of Contents
Overview of changes included in this hotfix package
NZQA have recently included Assessment Opportunities in their Standards Import file
An update to the Synergetic NZQA Standards Import functionality to handle this change was released recently and has been found to have an issue.
This issue is fixed by running the below SQL which needs to be run against NZ instances of Synergetic.
NZQA require that where a Standard does not have an Assessment Opportunity, that this is indicated by the value being a Null. Currently these are being set to 0 and this is causing errors to be reported.
Obtaining and applying the hotfix
We have created a SQL patch for v70 release of Synergetic.
1) Download the .sql file from the link below :
- sp_spiSubjectAssessmentNCEAStandards.sql
- Save to a location of your choosing, that you can access from your SQL Server
2) Open and run the .sql file against your Synergetic Database.
3) Once the SQL has completed successfully, your system should be updated and ready to re-import the latest NZQA Standards file.
4) Re-import the latest NZQA Standards file via the NZQA tab of Students > Student Data Import/Export...
5) The issue should now be resolved.
6) You can run this SQL to confirm the issue is repaired:
select AssessmentOpportunities, count(*) from SubjectAssessmentNCEAStandards where fileyear = 2023 group by AssessmentOpportunities
There should be no AssessmentOpportunities counted for 0.
Requesting Assistance
As always, if you have any further questions or concerns, our Support team is available to assist:
- Service Desk: https://help.synergetic.net.au
- Phone: 1300 498 642
Please make sure to mention that your query is in relation to the ‘NZQA Standards Assessment Opportunity not Null' fix as appropriate’ to help our support team action your request as efficiently as possible.