Skip to Content

Updating the Database

Version 17.5 by David Muszynski on 2025/03/18 17:02

As you know, CheckIn is built using FileMaker and updating an intricate database like CheckIn is not that straight forward so in order to make it as easy as possible, we built a small FileMaker database to assist with this process.

Not all updates we push out will require all elements of the CheckIn database to be updated and therefore for each update we will have the proper check boxes already chosen for you when launching the Migration Tool. (at times we may indicated other instructions in the update email) We’ve made upgrading as easy to use as possible, but will still require a few steps. Please follow the steps outlined below slowly and carefully and you will be on your way to enjoying all the enhancements each CheckIn version provides!

Warning

IMPORTANT

#1 Confirm your current backup schedule is running successfully!

#2 Run a new FileMaker server backup before starting! Do this by going into the Backups tab in the FileMaker server console and at the left side panel select the blue text called “Back Up Now”

Step 1. On your FileMaker server, enter the FileMaker Server Admin Console through safari via the following Address:

http://127.0.0.1:16001/admin-console/signin
*link only works if you're viewing this document ON your server

*(During the FileMaker server installation, a link to this address is added to your desktop and during the setup of CheckIn we also place this link in the favorites bar of Safari)

Step 2. Go to the Databases tab and Close All the databases by clicking on the down arrow icon in the grey All Databases section as illustrated to the right and then chose Close All.

  • Once the databases close - the little blue circle icons with the triangle in the middle will no longer be blue (they go to red for a bit then to grey when the databases are finally closed.)
  • You can send a message or disconnect a user listed at the right in the Clients section if need be.

close-db.jpg

Step 3. Download the FileMaker file called “CheckIn Data Migration Tool for x.xx” *(Please note: version # at the end of the file name will change with each new update.)

Step 4. Move this “CheckIn Data Migration Tool” file into Databases folder (The image shows the path to get there): Which is: Mac HD>Library>FileMaker Server>Data>Databases

path.jpg

Step 5. Launch the CheckIn Data Migration Tool by double clicking on it.

Step 6. The CheckIn Data Migration Tool will bring up the window seen below and will have the appropriate checkboxes pre selected for you. *(At certain times we may tell you to also check off the printing files.)

Step 7. Click “Start Data Migration & Update” ( This will trigger the backup of your files, the installation of new files and it will also trigger the Terminal app to migrate your data to the new data file.)

*The check boxes will be pre-selected for you so please do not change what you see checked off unless otherwise instructed.

migration.jpg

Warning

IMPORTANT

Once started, please do not stop or quit out of the updater/data Migration Tool, this will cause the update not to work on the 2nd try and you will need to contact support!

Step 8. You will then see a small Notice window pop up. Before clicking on OK to close it, you will need to observe what is shown on the terminal window that opens up during this upgrade process.

 1 

term-output.jpg

 2 

Once you see that the Data migration is completed (where the last line of the terminal window says End:), you can then click OK on the Notice window:

notice.jpg

Please be patient and make sure you see the process End before moving forward!

Warning

IMPORTANT: If you do not see the Terminal window appear and go through it’s Start & End procedures as mentioned above, this means that the Migration tool failed for some reason and you need to quit it and relaunch and try again!