SimpleQ Integration Exercise

SimpleQ is a lightweight messaging service that implements the publish-subscribe (pub/sub) pattern in FileMaker, allowing applications to work together in a loosely-coupled fashion.

Exercise Overview

In this exercise, you'll learn how to:

• Set up SimpleQ to handle data synchronization between multiple FileMaker files
• Publish Customer changes from SimpleLedger as they sync from QuickBooks Online
• Subscribe to Customer changes in Contacts.fmp12

Implementation Steps

1. SimpleQ Setup

   • Open the SimpleQ file
   • Expore the Channel AND Subscriber views.
   • remove the Comments from the block at the bottom of the script.

2. Publisher Setup (SimpleLedger)

   • Open the SimpleLedger file
   • Edit the script 'Pull A QBO Record Into FileMaker (entity, qbo_id)'
   • remove the Comments from the block at the bottom of the script.
   • explore the script 'Publish Customer Change'

3. Subscriber Setup

   • Open the SimpleCRM file
   • Explore the script 'CreateOrUpdateContact'

4. Create a Script Schedule

   • Launch FileMaker Server Admin Console
   • Create a new schedule
   • Set the schedule to run every 1 minutes
   • Set the schedule to run the script 'flush message queue'

5. Testing the Integration

   • Test the full workflow from QBO → SimpleLedger → Contacts
   • Verify real-time updates updates

Benefits

This implementation demonstrates:

• Loose coupling between FileMaker applications
• Real-time data synchronization
• Scalable integration patterns