Background

In the latest update KAMAR introduced some new security changes. You can read more about these here: https://www.kamar.nz/105755/

To fix the exporting for the filemaker update 912.29 (Dec 2017) the following things need to be done….

Step 1: Setting Custom Password in KAMAR

On KAMAR go to Main Menu ⇒ Setup ⇒ KAMAR ⇒ KAMAR ⇒ Custom Security and create a password (can be anything you want… just make sure you know what it is)

Once you click out of the password field it will set this password in all the files

Step 2: Set Password in AssayExport Database

You then need to close the assayexport.fmp12 database on the Filemaker Admin Console…

Once closed download the new copy of the export database from https://hosted.assay.co.nz/demo/assayexport.fmp12

Replace the current assayexport.fmp12 file with the new one you have just downloaded wherever you store your databases for the Live KAMAR server.

Then re-open the database

You can then open the assayexport database.

The username for the assayexport database is “Admin” and the password is “Assay”

It may then give you another password prompt for the ko_StUnits database. The username for this is “kamarcustom” and the password is whatever you set earlier in step 1.

This will let you into the database so we can set the password. To set the password go to File ⇒ Manage ⇒ Security

This will again prompt you for a username and password… this is just “Admin” and “Assay” again, which will give you this screen:

You can then set the password by clicking on the kamarcustom on the left and pressing the change password on the right. Change the password to whatever you set in Step 1 and press Set Password.

Then press OK on the account window and then close the database by going File ⇒ Exit

Step 3: Editing the Filemaker Schedule

On the FileMaker Admin Console go to Schedules and edit the Assay Results Export.

You need to change the Account from “Guest Account” to use the account we have just set up as shown below.

You can then just press next through until the end as you shouldn’t need to change any other settings.

You can check if the script has worked the following day on Assay by going to Admin ⇒ Check Upload / Process