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.

You need to edit line 6…

You need to replace the following:

  1. with the URL you use to access assay
  2. 12345 with the authentication on assay under Admin -> Config.

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.

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

New scripts

To set-up Results auto-uploads, see link here