There is a known issue in this Hotfix, and the Patcher has been removed until this issue is fixed. 15 May 2024.
Education Horizons Group has recently completed a hotfix to update the visa codes available to be loaded into Visa and Visa Sub-Class Lookup tables. These visa updates were originally released in Synergetic Suite v71.15 and are now being made available via hotfix.
When run against the Synergetic Database, this hotfix will:
- update the reference tables for Visa and Visa Subclass after which users (with access) will be able to load new visa information into these tables.
- update any changed descriptions for Visa and Visa Subclass in the Lookup tables.
Please Note:
- This solution is a data change only and does not include any front end changes within the Synergetic Application User Interface.
- Read this page carefully as there are instructions which must be followed.
Applying the SQL
1) Download the zip file to your system from the link below:
V71_15_1_10613_HotFixv71DSY24954DSY247672024Visa_DBPatcher.zip
2) Open the zip file and extract the included exe file to your SQL server (or to a location that is able to communicate with the SQL Server)
3) Run the hotfix exe program - this will run a database patcher wizard which will take you through the steps to apply the database changes.
4) Once the patcher has completed successfully, the reference data in your system will be updated and new rows able to be loaded into your lookup tables.
5) For each of the visa Lookup tables you wish to update hit the LOAD button in lookup table maintenance and select the AUSGOV code.
Requesting Assistance
As always, if you have any further questions or concerns, our Support team is available to assist:
- Service Desk: https://jira.synergetic.net.au/servicedesk/customer/portal/2
- Phone: 03 9803 8111
Please make sure to mention that your query is in relation to updating the AUSGOV visa list as per the Version 71.15 update so the support team can action your request as efficiently as possible.