Auto-Uploads Core

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. Edit line 6, please see screenshot and save.

Step 3: Automating This Script (If the school recently upgraded KAMAR version, please see Ste 4)

KAMAR has provided instructions on how to run these custom scripts here:

https://www.kamar.nz/105744

Below is an edited version of these instructions specifically for assay.

  1. Log onto the Admin Console.
  2. Duplicate the Daily Script

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.

Click ‘Next.’

4. Set the Script Parameter

On the FileMaker Script step:

  • Select Custom_Script (List#) from the list of scripts.
  • Add details in the Script parameter field:
    The number of Custom Lists file that you uploaded.
    Script name in “Server Scripts”. Don’t put the quotes in… see screenshot below.

Click ‘Next.’

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).

Click ‘Next.’

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: Enabling Custom Scripts (New KAMAR Version)

After uploading the custom file, you need to enable the custom scripts.
To do this go to Setup –> Server –> Maintenance Scripts –> Custom -> Press the New Schedule button and “Create”
Put the details in as below. Make sure the Custom File(s) that you tick matches the “Assay Scripts” in the list on the right hand side. Set the time to somewhere between 3am and 4am.
Press the “Run Now” to confirm it is all working.

Step 5: 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.

Step 6: Setup Results auto-uploads

To set-up Results auto-uploads, see link here https://www.assay.co.nz/knowledgebase/auto-uploads-results-new-setup/