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