Step 1: Upload the custom lists file
If custom lists file has already been uploaded, proceed to step 2. If not, on KAMAR go to Printing -> Progress Reports -> Global -> Custom Files. Click upload file and upload this file: Download k_Lists2.fmp12
Note: The list numbers vary from each school set-up. In the example below, it shows Lists2 (Custom Lists 2) is available > select Lists2 > Upload k_Lists2.fmp12
Step 2: Edit the Script
Then go to Printing -> Custom -> Assay Scripts and tick the “Edit Custom File” at the bottom of the popup
If no Assay Scripts, go to Printing>Progress Reports>Global>Custom Files>Select the Lists# (Custom list number where you uploaded the k_Lists file)>Open File>Scripts>Script Workspace>ServerScripts>Select “Assay_Core_Export”
This will bring up the script workspace. On the left scroll down until you find the “Server Scripts” folder and open “Assay_Core_Export” by double-clicking on it.
You need to edit line 6…
You need to replace the following:
Then save the script.
Step 3: Automating This Script
KAMAR has provided instructions on how to run these custom scripts here:
Below is an edited version of these instructions specifically for assay.
Select ‘Script – Daily’ from the Schedules on the Admin Console and duplicate it.
3. Edit the Duplicated Script
Select the duplicate and edit it “Edit a Schedule”.
On the Database step, leave the settings as they are.
4. Set the Script Parameter
On the FileMaker Script step:
On the Details step, we want it to run daily, and to run at 5:00 am so that it isn’t going to interfere with any other schedules on the Admin Console (ie, the Daily Script).
On the Options step, rename Schedule “Assay Core Export-CL”
Click ‘Next,’ and check the summarised information for obvious mistakes.
Click ‘Finish’ to complete the process.
Run the “Assy Core Export – CL” schedule to export data
Login to Assay, go to Admin > Check Upload / Proces > Check Last Result Upload date & time (latest)
Step 4: Disabling Old Scripts / Powershell Scripts
For Windows server with the old Core auto-upload set-up, you will then want to disable/delete the old Filemaker and Powershell scripts that you had for these files.
To set-up Results auto-uploads, see link here https://www.assay.co.nz/knowledgebase/auto-upload-scripts-update/