Auto-Uploads Results

This guide steps through how to replace the current ‘assayexport.fmp12’ database with a custom list file after recent security changes to KAMAR that stopped the kamarcustom account from working.

These new scripts handle both the export and the upload for the Results, ESOL, and Assessment Schedule exports from KAMAR.

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_Results_Export” by double-clicking on it.

 

You need to edit line 6…

You need to replace the following:

  1. https://hosted.assay.co.nz/demo/ with the URL you use to access assay
  2. 12345 with the authentication on assay under Admin -> Config.

Then save the script.

Step 3: Editing the other Scripts

If you use the ESOL or Assessment schedule exports these need to be edited in the same way as the result script (see step 2).

Step 4: Automating This Script

File Maker Server 17 Guide here

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.

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:10 am so that it isn’t going to interfere with any other schedules on the Admin Console (ie, the Daily Script). All Schedules (Core, Results, ESOL, Assessment Schedule) should be scheduled at least 10mins apart.

Click ‘Next.’

On the Options step, rename Schedule “Assay Results Export-CL”

Click ‘Next,’ and check the summarised information for obvious mistakes.

Click ‘Finish’ to complete the process.

Run the “Assay Results Export – CL” schedule to export data

 

 

Login to Assay, go to Admin > Check Upload / Proces > Check Last Result Upload date & time (latest)

Step 6: Disabling Old Scripts / Powershell Scripts 

For Windows server with the old Results auto-upload set-up, you will then want to disable/delete the old Filemaker and Powershell scripts that you had for these files.

 

If there are issues with Core auto-uploads, see instruction links below:

Windows Server: https://www.assay.co.nz/knowledgebase/auto-upload-scripts-update/

Windows (optional, if the previous set-up doesn’t work) and Other Environments: https://www.assay.co.nz/knowledgebase/core-auto-uploads/