How to Sync with FileMaker Cloud Using 360Works MirrorSync Today we want to let you know that it is completely possible to sync a FileMaker solution hosted on FileMaker Cloud! MirrorSync has been able to handle this task since the release of 3.1. The current version is 4.0 and it remains compatible with FileMaker Cloud.
FileMaker Cloud leverages Amazon Web Services (AWS) to host your FileMaker solutions in the cloud. Many people are moving to the cloud to cut back on server maintenance time and money. Here at 360Works, we are big fans of AWS - we actually moved all of our hosting to AWS and couldn't be happier. (Jesse Barnum, president of 360Works, presented on the topic of deploying FileMaker Server with AWS at last year?s FileMaker Developers conference.)
Getting started with MirrorSync for FileMaker Cloud is extremely simple: There's nothing to install and only a couple of steps to get up and running!
Step 1: Host MirrorSync Elsewhere
You will need to run MirrorSync on a separate computer from your FileMaker Server, because FileMaker Cloud does not allow the installation of 3rd party software other than plug-ins (MirrorSync is not a plug-in).
Once you've launched your FileMaker Cloud instance, 360Works can host MirrorSync on a managed AWS server for just $29 a month. There are several other approved hosting providers willing to host MirrorSync as well (see documentation). Alternatively, knowledgeable Linux administrators can host on their own Linux instance with Amazon Web Services.
Step 2: Enable xDBC
Because there is no XML Web Publishing Engine with FileMaker Cloud, you must enable incoming access (to port 2399) on your FileMaker Cloud instance in order for MirrorSync to communicate with it using xDBC. You can do this in the AWS console, follow along with this short video:
A Few Final Notes
*You will want to reference our MirrorSync and FileMaker Cloud documentation for complete technical guidelines.
*Users running regular FileMaker Server on a Mac or Windows computer can install MirrorSync 4 on their own server.
*We've designed MirrorSync to be something that even a novice user can integrate, but we're standing by when you need more advanced help. If you just want your sync integration to be completed as quickly as possible, we're available to do the work for you directly at our hourly consulting rates. Fill out our message form for advanced help!
Download MirrorSync 4
Connect with us on Social Media for news and updates:
I think there was some instructions somewhere, but I cannot find them .
I have a created local file and server file. Both contain the exact same data. I want to deploy this solution, but I want to avoid a massive first-time sync.
How can I avoid a massive first-time sync?
So I am new to EasySync, and trying to get the best from it.
I am using it more to replicate a subset of a live database for external clients to access, but they will not be changing anything, so my only requirement is to pull data to my 'Mobile' dataset from my 'Hosted' dataset.
At the moment the live database is approx. 120k records, but this grows daily between 100 and 300 records for the main customer view, and possible 3 times that for associated activity.
I seem to have a serious speed issue, in that trying to sync the mobile version just locks everything up, trying to do an initial sync.
I can manually pull the data over at the end of a day, then mark all of these as EX_Exclude 1 and import them manually into my new portal
Set a OnCommit on the maincustomer view, so any changes will make the ES_Exclude to 0, thus marking these for sync
Question 1: How do I set these back to 1 once the sync is done?
Question 2: Is there a way to Schedule the sync to happen every 15 minutes so it has lessto sysnc, meaning less traffic?
Question 3: If I cannot schedule it, how do I prevent the 2 database's from appearing to lock, preventing users from working on either side, or slowing everything down?
Any help with this would be very appreciated as I am totally stumped at the moment.
in which order are the tables synced when MirrorSync starts?
Is this done in the order how they occur in the "sync" Layout folder?
We are syncing quite a few tables and use filters in the customization script to reduce the amount of records to be synced.
We want to start syncing the relevant projects, then only the relevant phases of these projects and then only the relevant tasks of these phases ...
That is why we need to synchronize in this order ...
If we start the customization script (MirrorSync Customization) from the different sync Layouts in the "right" order of the tables all filters work fine.
My question from the beginning is one of my first steps to look for my mistake :-)
Kind regards from Germany
I have already posted here:
and have some thoughts in mind, but I will copy what I put in there, here.
Avoid FMGo Connection Interrupted
Server Timeout Disconnect
In the attached links, it goes back to questions that I had that dealt with a file on an iOs device, making sure it stays live and up to date.
So what I have done is worked on a local file that syncs to the one on the server.
That seemingly works, however there is a problem that just recently came up when I was testing. When the local file tries to reach the file on the server, it doesn't always connect.
In talking with others there is two consensus of what might be the cause:
The Wireless access point is blocking access File security permissions are not working (File Access tab in Security) "Reset All" temporarily works (on the server file) Deauthorizing and Authorizing sometimes works (on the server file) Turning off the File Access requirement doesn't seem to help (on the server file) I do have File Access on the local file, but I haven't tried turning that off.
Since I can't debug exactly what is going on, on the iPad this makes it harder. (I have put in some custom dialogs to see some things.)
The local file with the syncing to the server file works on my desktop, but that is a wired connection. (I could try the same wireless connection.)
It could be that I'm making a duplicate of the local file and putting that on the iPad, which makes the file not work.
(I put on the duplicate file on the iPad newly each time for testing, because I need a file without certain info on it, which will be filled later [dealing with Get(PersistentID)].)
Is there something I'm not thinking of?
To my knowledge, it had been working until recently.
I'll try a few more things, but hopefully get answers in the meantime.