Extra Scripts (eg: ESOL / Assessment Schedule)

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: Checking Custom Password in KAMAR

Note: Most schools will have done this already…. don’t change it if you already have set this up.

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: Get new AssayExport Database and Set Password

This may or may not need to be done… if you try Step 3 and the scripts are not there, then you need to do this. If they are you can skip this step.

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: Creating the Filemaker Schedule

On the FileMaker Admin Console we need to set up the script so it exports the file automatically. Go to schedules, and the click on the button in the top right and “Create a Schedule”

Choose FileMaker Script and then press Next:

Choose the assayexport database and set the Account Name and Password as above.

Choose the script you want to run set the time limit to 120 and then press Next

Set the start time to 5:05am and press Next

Give the script a name to make it easily identifiable, make sure it is enabled and press next

Press Finish

This should give you the new schedule showing up in the list.

Run the schedule now by clicking on the schedule and then on the “Run Schedule Now” option. It will show in the scheduler when finished.

It should then have created a file at:

C:\Program Files\FileMaker\FileMaker Server\Data\Documents\assay{description}.csv

Where the description varies depending on the script chosen. Check to make sure this exists.

Step 4: The Upload Script

The upload scripts can be download from here:

These need to be edited and scheduled to run in the same way as the script at the bottom of the auto upload scripts page

Checking

You can check if the script has worked on Assay by going to Admin ⇒ Download Files and seeing the modified time of the file.

The files that are created are:

  • esol.csv for the ESOL script
  • YYYYSchedule.csv eg: 2018Schedule.csv for the Assessment Schedule Script

Data Sources

The ESOL Data comes from Overseas Students -> ESOL:

The Assessment Schedule Data Comes From Markbook -> Setup -> Assessment Statement: