MirrorSync by 360Works

We had a problem with the spoke file on one of our spoke systems and had to run a recovery in FileMaker. Is it okay to use that recovered file (if it passes the recovery okay) or should we just start over again with a clean copy? Would rather not loose any data that hasn't been synced, but if it has to be that way so be it. Thanks, Craig

Hi, I have been using MirrorSync for a while & all was going well. Today I made a few changes to the configuration on one of the files I am beta testing. After changes were made and scripts updated, I tried to sync. I received the spoke file showing a status of 'Waiting for a response from MirrorSync' and the server itself showing 'Establishing Database Connections'. These haven't stopped despite restarting the MirrorSync console and the entire computer where MirrorSync (and FMS) is installed. I have since reverted the changes I made bu there is still the same problem. What's really odd is that I have 2 configurations, only 1 was modified but now both are e…

I'm upgrading from MirrorSync 2 to 3 in a development environment. I created new sync configurations and got everything up and running. The only thing that is not working is my MirrorSync customization script where you filter which records to be synced. I am using the same exact IF/ELSE IF statements i used in MirrorSync 2 and it's not working anymore. All records are being synced to the offline clients. My IF statement looks like the following. If [ Get ( LayoutName ) = "SYNC_Customer" ] Enter Find Mode [ Pause: Off] Set Field [ Customer::Sync_Assigned ; Get ( AccountName ) ] Constrain Found Set [] Else If [ Get ( LayoutName ) = "SYNC_Premise" ] Enter Find M…

Hello, We are running FileMaker Server 14 with a database for creating job tickets and managing production in a commercial printing company. We would like to have remote sales staff have the ability to enter new job tickets and review existing job tickets but only be able to see jobs for their clients. We also have several very large clients that have asked for the ability to enter their own jobs into the database themselves in order to ease our sales staff's workload transcribing data from received emails. However, the customer must not be able to see jobs from our other customers. Is it possible to setup a one way sync for data collection from the sa…

So all setup now on MS 3.v3 and using JDBC for the sync of 9 tables, some tables are hub > spoke the attachment tables are spoke > hub and things are pretty quick for initial sync. and even after an exam is synced up its pretty quick with the small overhead of any new pdf's or images from the ios device being uploaded. only one table is using the Custom SQL qualifier the logic is "WHERE doSync = 1" the field doSync is a calculation : Min ( arrayDate) ≥ (Get(CurrentDate) - 7 ) and Max ( arrayDate) ≤ (Get(CurrentDate) + 7 ) seems to be pulling the correct data because we are only pushing images to the hub there are cases where the inspector w…

I am using MirrorSync 3.02 My scenario has 2 teams each syncing to the same file on the server. We will have 2 Sync configs, 1 for each team. Team A Sync config using JDBC Team A will get an offline copy of the same file that is on the server, with ALL the data. Team A will sync ALL tables (2 way sync). No problem there. Team B Sync config using JDBC Team B will get an offline copy of the same file that is on the server, but with only a SUBSET of the data (we will take a full offline copy and then delete many of the records). Team B will sync a subset of the tables (2 way sync). When team B syncs, will Mirror…

I created a record on iPad and the examDate field is today, after it syncs the same field on the host version is yesterdays date. And yet subsequent sync says they are sync and no changes yet they are out of sync. I have fields set with auto enter and they are using $vars set in scripts is there some chance there is a name space issue or some problem with JDBC that does not respect auto enter $vars? And now all my records that were synced are now off by a day it modified the records in the hosted version

Hey Jesse So I have been playing with the new version and have discovered something that I do not see any documentation on. So I am curious if this is a good idea or not. It seems to be working very well but want your advice. The new mirror synch appends the name to the 3 script that are created and this got me thinking that perhaps I can set up different sync configurations for my one file. So I duplicated the configuration in the admin tool, modified my synch setup to be a different from the original. Finished the steps of setting up the file. Than i created a second button on my layout and pointed to the second mirror sync script. I reinstalled on…

I'd like to try the new MS3 before upgrading. I know the installation directions say it's possible to run both, and to change the install name to something like mirrorsync3. Do I need to change the install directory also? Thanks Mark

Just upgraded to MS3 but I cannot get it on one table to respect the custom find request to only find a subset of records date +- today - I've got the custom f it's trying to sync 15k records... If I do a constrain on this table it shows 209 records.

Hi, I have remote users syncing local copies of a database on their MacBooks to a server here at the office. The users come into the office from time-to-time. They may have the network version of the database open on their laptop. Is there any 'danger' in having the server version and the local version open simultaneously on a laptop and running sync on the local version? Thanks, ft.

Hi, When I create a link for my users to download a full copy of the database (multiple files), is the link good forever? Or are there any circumstances under which I should create a new link after, eg. changing schema in the database and re-pasting scripts, or upgrading MirrorSync, etc? The question is because I want to post the link with upgrade instructions on our intranet. Thanks, ft.

I guess the script is written for backwards compatibility but if we could guarantee FMP15 Server/Client would the sync perform better if it was using the Truncate Table function? Even have it in a loop iterating thru table instead of having to switch context even, and reduce script steps.

Halfway through a Reset Sync the sync stopped with an "Error: java.io.EOFException" in the status area. Upon retrying and restarting MirrorSync, every action results in the "error unmarshalling return" error shown below. I can't create any new syncs. Redownloaded the config client but still the same error. Is there somewhere I can go to delete all config client related files and start over? I had set up a sync and everything went fine, syncing 100,000 records. I then modified the the Customization script in FM to constrain found records to some 2000. I then right-clicked my sync and made it Reset Sync Data, hoping it would get rid of the e…

Hi Jesse for one project I am getting specs on I am thinking of having custom server to server sync using their API's however the only option in MS is to have it run on a loop, in seconds can that number be set high enough to trigger once a day? Or is there or will there be a way to 'schedule' syncs M-F only because the service that were getting data from is Central time and at some point in the day they go offline as they do an EOD backup and an EOW backup and an EOM backup to alternate servers. Thanks.

Currently have sync bi directional - but plan to switch it from spoke > hub for one table , if I switch that in the configuration do I need to recopy scripts and have end users re-download a new version?

This is about a Filemaker Server <--> MySQL sync setup. I have two fields, serialNumber and writeBackNumber, and an altogether separate primaryKey that isn't used for this part. If I create a new record on Filemaker, everything is fine. the serialNumber is auto-incremented on record creation and synced successfully. However, If I create a new record in MySQL, I can leave both serialNumber and writeBackNumber blank, but when the sync happens, Filemaker does not auto-increment the serial number and put it in the field. It looks like it's just skipping the auto-enter part altogether and leaving serialNumber blank. This seems like what's going on: …

When trying to setup MirrorSync 3 on a 2 machine deployment with separate internal and external addresses, I get an error saying that "XXXXXX.coe.drexel.edu is not a valid address for MirrorSync Internal Address" (and this same thing happens for the Publishing Engine and the Database Server, but only the internal addresses). If I change the addresses to IP addresses instead I can get to the next screen but when I try to copy scripts I get an error saying that there is no MirrorSync layout on the server even though there definitely is. The best thing that I can think of is that this has to do with an SSL problem since the SSL certs that are installed on the serve…

On the setup screen where we specify primary keys in 2.6, there is a column labeled "Custom PK" that accepts a SQL statement. The help button for that column doesn't do anything and I was unable to find anything in your documentation. I'm thinking of using it to specify "SELECT xp_AssetID + '.US' FROM Assets" so that the primary key going from the spoke to the hub has the particular spoke's user code appended. Is this what the function does? And then when it if it comes back to the spoke it is just the original xp_AssetID (without the appended code)? Howard

Suppose I have my sync set up as two-way between FMS and MS-SQL.. I want all records/changes going from FMS to SQL, but I may not want all SQL changes/additions coming back to FMS.. It seems a couple filtering options I have are to either use the Custom SQL Qualifer in the setup or to modify the customization script in the database. But once I filter records out, they are filtered from both directions...right? Can I filter them just from going one way or the other? Thanks... Howard

I'm using the trial version. I tested it with a copy of the database and it works great on an iPad and on a MacBook Pro. I am now testing it with the live database. It works great on the MacBook, but I cannot get it working on the iPad. I have created new links, made sure the MacBook user has been deleted, re-created the database with new links, new scripts etc - but on the iPad it won't sync and gives error message saying, "Could not create record. Creating MirrorSync client record failed with error 6." I also cannot create or modify records on the iPad - an error message says the file is not modifiable. The exact same link works on the laptop. Wh…

Upgraded from 2.4 to 2.6 and MS has failed to sync again. It deleted all records in synced tables then it crashed my server. I restarted it but think I need to flush out records in a specific table in order to start the sync process over correctly? I don want to start MS again until I think it will complete. Large db - around 4m records, Oracle to FM Server 14. Thanks! Scott

Hi guys, We've noticed an issue with EasySync and was wondering how MirrorSync addresses this scenario. Basically, as you probably know, EasySync gathers data by looping through the tables. The issue is that during that loop, another client can push data. So, the original client will pull records potentially that are orphans (since it's already pulled from a parent). If that makes any sense at all, can you address how MirrorSync avoids what I've been told is called "Collision Detection." tia, Barbara

I see in the patch notes in 2.6 that fixes were put in for duplicates. I am still struggling with issues with this, though i have had issues before this patch as well. I just had a new user get an ipad. Gave him the most recent copy of the file, downloaded using the MirrorSync client. Hit sync, it goes through successfully, and somehow managed to duplicate records for about the last 30 customers entered. I know this sync caused it because it was fine before and I looked immediately after syncing to see this (see picture). Whats worse is it seems somehow some child records are attached to one, some to the other (different tables). This is going to take hours t…

Is it possible to sync data in a Filemaker portal to an external MySQL database? For example, an invoice listing multiple products stored in another table (assuming I only want the information in the portal, such as qty, name, price). Or do we have to manually sync all related tables behind the scenes and then re-create the relationships using joins later? Thank you!

I hope someone can help me with an elegant solution on how to make my database MirrorSync aware. I will have users accessing our database through both direct on-line connection to it while in the office, and then using mirrorsync when leaving the office. The mirrorsync will be used on iPhones, iPads and Laptop computers. There is certain functionality I want for off-line users, but I am not sure how to detect when they are off-line/using the off-line version. Example: The "Sync" button. I do not want this to show on the live database, but do want it to show on the off-line version. What command would I type into the "Hide Object When " option so the …

With MirrorSync 3 set to come out at DevCon, what is going to happen to people who have existing MirrorSync 2 licenses? We're about to buy a MirrorSync license. Do we need to wait for 3 to be released first in order to avoid an immediate upgrade two weeks later? Thanks.

I am looking at taking on a project that has 143 tables. Ouch! Is there a limit to how many tables? Thanks, -Jeff

During the install of MirrorSync, I keep getting the following error: Installation Failed: Could not locate the /Users/....../Desktop/Installer data/MirrorSync.war file. When I looked into the Installer data folder, the only file that's in there is the Installer.jar file. I have the latest version of Java on the server.

Hello, when I setup MirrorSync 2.5 in April I had no problems to get things working. After a longer break I tried a very similar setup with MirrorSync 2.6, Build 8823 a few days ago and ran into problems. The Sync doesn't work, the program hangs. The clients debugger shows me that the script paused at one of the many occurances of the following lines: if [ not $$isServer ] Pause/Resume Script [ Duration (seconds): /*0.1*/ ] End If Though the documentation of Pause/Resume says: "...The For duration value must evaluate as a number, which is the duration of the pause in seconds. If you use the Specify Calculation dialog box to determine the d…

My client has not been able to update the files on her devices recently. The MirrorSync script currently on her devices was created with version 2.40510 (last updated 6/1/2015). The MirrorSync version on the server is 2.505 (running FM 14 Server). She is currently running the files in FileMaker 12 & the Go 12 app due to an issue last year with synchronizing from FileMaker 13. I see the current MirrorSync version is 2.6. What sequence would be best to avoid compatibility issues and to get her using at least the Go 14 App (or Go 15), the server to MirrorSync 2.6, and the files on her devices to have a MirrorSync script with the current version? Thank you!

Hello Is it possible to use MirrorSinc with an App built with iOs Development Kit?

On my first of two hub installs, everything went well with the MirrorSync config, but I haven't been able to get through an initial sync (going to an MS-SQL spoke). Each time, I get a java heap space memory error: Jun 19, 2016 1:03:24 AM com.prosc.mirror.config.server.SyncServer$3 call SEVERE: Sync between usp-bolt-01.us.xxxxxxxxxgroup.com / BOLT Media Manager (FileMaker Server) and USP-SQLRPRT-01 / GlobalBoltData (MS SQL Server) Last sync failed: java.lang.OutOfMemoryError: Java heap space Last night's attempt was immediately after a machine reboot, and with no other users in the database. The OS is Windows Server 2008 R2 Standard (SP1), with 12GB RAM installed,…

I am setting up an FMS hub, using mod timestamps that reflect the server time, but I am unable to get past this window where we designate primary keys and timestamp fields for each table. This is the second hub I am setting up and I had no problems at all in setting up the first hub with the same exact tables and fields. I've tried selecting both the zz_modified_TS and the zz_modifiedTS_server fields, but it doesn't seem to like either one. I even tried removing the original fields, adding new ones, and refreshing this mapping screen, but it made no difference. What can I be doing wrong? (And the real bummer is that there is no "save" for all the work I've done so…

How does mirrorsync handle the modification date/time stamp for record modification if users are all over the world with their computers set to local time? Mark

for the sync status messages that flash by, when it says adding / deleting data it would be nice to state where this action is taking place on the users device or the server. when you do a sync and it says deleting 3000k records it's a bit un-nerving.

Hello there, I installed today mirror sync as a trial on a filemaker server to give it a try. After Installation and reboot of the server (basically it wasn't responding) I logged in on mirror sync and start creating a new configuration, but It gives me an error when I try to access to the database server. What am I missing?

We have made big modification (add field) on a table… More than 200 000 records. It’s run fine on FileMaker server to FileMaker server less than 5 hour. But on FileMaker to MySql the update is very very slow only 5 records / Minutes we need 29 day to finish the sync !! I try to truncate table to only insert data (more efficient) but there is no change. he want to modifie first… I have already increase the memory to 2 Go because the first time it’s increase the processor… i have an error : out of memory… Thank for your help

Have a system setup that sync a half dozen databases - we now have a 2 more tables that are a separate task for different or at least same people doing specific task on alternate days. Is it possible to setup a sync routine that sync task A or task B and associated tables, based on that users need? debating this option and also just getting a separate connection and build a separate file for Task B.

I used the Customization script to constrain records in my ELEMENTS table. When I ran the sync, the ELEMENT records were constrained and none of the ELEMENT records were deleted on the server. HOWEVER, ALL of the related INSPECTION records NOT in the found set of ELEMENT records WERE deleted from the server. This was NOT supposed to happen. Fortunately I had just downloaded a full copy of the database so I was able to recover the deleted INSPECTION records. Note that I did have one ELEMENT - INSPECTION relationship set to delete the child record when the parent record is deleted. Why did this happen?

Whenever I Edit a configuration (i.e. generate a new MirrorSync Script), do my remote clients have to download a new copy of the database before they can sync, or does it not matter?

We are trying to use MirrorSync 1) for two way synchronization of FileMaker tables with tables in Oracle server, 2) for one way synchronization from a view in SQL Server to a table in FileMaker. Trouble is, MirrorSync will not connect by JDBC to either Oracle or SQL Server. We are beginners in JDBC, and we sorely miss documentation for the topic: What conditions have to be met by Oracle and by SQL Server for MirrorSync to be able to connect? We are trying what we believe is the correct connect string(s) towards Oracle. SQL Server is set up to use Windows authentication (that is, accepting a login based on AD entities). What documentation or other advic…

I have a table that gets written a few hundreds records on an initial sync and for some reasons the screen goes completely white on the device while it's writing on this table. Any way to avoid this ?

"Sync Failed: Field names pasted from MirrorSync script generation do not match the actual field names for table Sync_Inspection (3). Please re-run the MirrorSync configuration utility and re-paste the script steps." I have re-run the configuration SEVERAL TIMES. I keep getting the same error. Everything else works fine. Is there a limit on the number of fields in a table? I have 2305 fields in the Inspection table.

Suddenly I get a login request (from fmgo to connect to my server db) when Mirrorsync is about to write data on the server. If I chose cancel it seems like the data is written anyway. Any idea?

Well I noticed there hasn't been any new feature requests for mirror synch, and that prompted me to start a new post (we got to keep you guys on your toes over there at 360works) So, I have 2 request that I would like you to consider, When mirror synch is setup using the config client, and using mirror synch managed id's, one of the things the tool does is test the ability to write,delete, modify etc back and forth to the database. This causes the id fields to incrementally increase, ( we struggled with trying to find out why this was happening and it should also be documented in the wiki, Thanks to support for helping understand the process, and it mad…

Hello, MirrorSync is quite new to me. Is it possible to configure MirrorSync in a way that allows to create an on-the-fly download link that doesn't include the files of the external container storage? I am only interested in download the single .fmp12-file. Thank you in advance.

Hello, I have an SSL Certificate successfully installed on the server where MirrorSync is also installed. In the advanced documentation it says " After doing so or if FileMaker Server is already is SSL enabled, check the SSL checkbox when configuring MirrorSync. ". Is there any way to get at this checkbox post MirrorSync installation? I would like to know whether I already selected SSL or not, and currently cannot see a way of finding out. Thank you in advance. Lewis

Hi Do I install MirrorSync (Mac Installer.pkg) on my iMac or on the Mac Mini Server? The hosted solution is on FM Server 13 on the Mac Mini Server. What it is now is I installed on my iMac, when I run MirrorSync and tried to create a New configuration. I login to and enter the IP address of the Mac mini server with the Mirror admin. After login, I tried to create the new configuration. It pointed to the server IP address but I can list the database although I have the Admin granted to cmxml privilege.

Just started an installation of 2.507 build on Mac Mini server, FileMaker 14 server. Got to screen to select keys, mod and create fields. Starts to process and then stop with: java.lang.illegalStateException: Can't overwrite cause with java.net.SocketTimeoutException: Read timed out Can't continue. Thanks Dave

I'm sure this is covered somewhere but my search didn't turn anything up. Is there a flag in MirrorSync that I can use to trigger a script if there is a successful sync? I believe I saw this somewhere but can't locate it. In particular I'm looking to trigger a script on FM Go. Thanks!

I am running Mirror Sync 2 on my developer macbook. Everything works fine when I'm at the office where I first installed FMServer 14 and Mirrorsync 2. However, when I change locations and get a different IP address things go south. FMServer still works, however I can no longer sync to Mirror Sync (even when changing the custom URL variables in the client). More importantly - I can no longer run the Mirrorsync Configuration java client to modify the configuration. I can navigate to http://myserver/MirrorSync/ and re-download the client - but it fails with a “Could not parse the launch file. Error at line 0.” when trying to run it. Everything reverts to normal when…

In case you haven't heard, FileMaker Inc. has released a new tool which allows you to create a native iOS application from a FileMaker solution. To learn more about the FileMaker iOS App SDK, read this FileMaker help article. We're pleased to announce that we have tested MirrorSync with FileMaker iOS App SDK and it is fully compatible! MirrorSync is already the easiest way to add sync to your FileMaker solution, and the process of integrating MirrorSync is no different with the FileMaker iOS App SDK. We are really excited about this new tool from FileMaker, which now allows you to: build a custom native iOS application for your …

Hi, I have a user who is now consistently getting this error message: "No table properties were provided by the client for synckitItem(duplicate)" - and I am lost as to what that means. Client and server are windows on FM14, latest version of mirrorSync. Any ideas anybody? Thanks!

What are the ramifications of using MirrorSync with the new iOS SDK? It sounds like it would work fine to me, but has anyone tried it?

Hi I have a few questions as an existing MirrorSync user: On my mobile file, to keep my size down I would like to get rid of all the layouts that are for the computer. Can I delete all those in my mobile file if I keep the sync layouts? The tables would all be the same, I just want to delete the layouts I am not using for mobile. Is there a way to only keep certain records on the mobile device to reduce the size? For example, I would like to only keep records that are within the last 30 days. Can I add this to my customization script? I dont want to delete them on the server, only the mobile file. Lets say I want to have mutliple clients of mine…

http://fmforums.com/forum/topic/88324-running-fm-server-in-ad-hoc-network-no-internet/ Hello, great people of 360works. Thanks again for making mirrorsync awesome. I posted to the FM Server forum about using FM on a Mac ad hoc network, but thought I'd cross post here because it's really about mirror sync, or my desire to setup asynchronous sync without internet. This seems to be square with what would make mirrorsync even more awesome - being able to work completely offline in field environments (archaeology, for example) - and that's exactly what we're doing. I am sure you've dealt with this before, so I thought reaching out to the source would be worth a sh…

Hi, I'm just working through MirrorSync configuration walkthrough at http://docs.360works.com/index.php/MirrorSync_configuration_walkthrough The document states: "Be sure to remove any summary fields, related fields, global fields, and calculations unless they are read only while implementing a one-way sync. An easy way to tell would be looking for a green hourglass in layout mode- if it doesn’t have one; it’s a summary field." Perhaps this should this read (at least for FileMaker 14): "Be sure to remove any summary fields, related fields, global fields, and calculations unless they are read only while implementing a one-way sync. An easy w…

I noticed that our FMS 14 windows server 12r2 installation uses IIS server - ports 80 and 443 for web direct. I also already have Apache running on port 8080 for a different PHP application. Before I begin the Mirrorsync 2 installation - I would like to know what problems I will be running into. Its my understanding that Mirrorsync will be installing Apache on ports 80 and 443. This of course will conflict with the FMS 14 installation. I appreciate any community wisdom offered before I begin this process.

I'm getting ready to move a FileMaker / MirrorSync installation from a Mac system to a Windows Server. In reading the documentation on moving from one server to another it states that I need to: Run the MirrorSync admin utility. Edit the configuration and modify the IP addresses of the servers as necessary. In the last step of the process where you copy and paste the script steps into the MirrorSync script, be sure to first delete the 'MirrorSync_internal' and 'MirrorSync_external' items from the list of external data sources. They will be recreated with updated values when you paste the script steps. We are running a different database for the spoke from the h…

Hi, I have posted a ticket but thought I would post here too just in case anyone has any advice. We are using the $$MIRRORSYNC_USERTOKEN to pass through information to the Hub to constrain the records brought to the hub. We have 2 configurations on the server, both FM Server to FM Go. On the first one, this is working fine without problems and has been for some time. However, on the second configuration, the variable is getting unset somewhere along the line - but I can't find where. I have some screenshots of the variable in both Spoke and Hub below if you could take a look at where I am going wrong, please. I have been looking for endless hours with no luck! …

Hi, I am looking to setup a sync process between iPads in the field with a single table registration form that is synchronised back (one way) to a central database when they come back online. I've started looking at MirrorSync but (embarrassingly) I cannot get to the installation stage. I have read the 360Works "wikipedia-looking" basic and advanced setup, but to no avail. In short, this is my setup: Windows 2008 R2 running FMS 12 (with plans to move to FMS 14 soon) 1 iPad (at this stage) that is running the solution on it. My development environment is a Mac. Am I correct in assuming that I run the WindowsInstaller.exe on the FMS? When I do, I get an error straight a…

I am having difficulty getting repeating fields to sync. According to the documentation, both spoke and hub layouts should be identical with the maximum number of repetitions rendered for each field, e.g. a field with a maximum of 20 repetitions should display with 20 repetitions on the sync layout. The sync works fine with all fields and tables except on repeating fields - all 20 repetition values from field on the the hub are showing in the first repetition of the spoke, e.g. in repetition 1 its showing 'value1, value2, value3 etc." with nothing in repetitions 2-20. My setup is FMS14 Mac Server with MirrorSync 2.505 speaking to iPad FM Go 14 clients. Any …

Hi all, What could be the reason of the following error: java.util.concurrent.ExecutionException: java.lang.IllegalArgumentException: Illegal character(s) in message header value: Basic ... This occurs when I try to read the list of files from the server or (when I enter the file name manually) when I try to go to the next screen. What is (probably) unusual about the setup is that the FM web server is located on a non-standard port, but the message suggests something is wrong with the login or password. Those are relatively long and contain spaces, but otherwise there's nothing unusual about them. Kind regards, Mikhail

The reason is that the built-in form doesn't let me file a bug and raises a NullPointer exception. Then it courteously invites me to file this as a bug Found it, it's on the MirrorSync starting page

Hi First of all I have only just started experimenting with MirrorSync and overall it's a pretty slick product. One issue I have come across is that my spoke database (on ipad) is showing time fields with values 1 hour ahead of the values in the hub database. When I connect directly to the hub from the same iPad or from a PC then the time values are as expected. As far as I can tell the server, PC and iPad are all configured to be in the same timezone (UTC / London). Any advice please? Tim

I'm new to Mirrorsync and have a question about what setting up primary key relationships does during configuration. When setting up a new sync and matching primary keys, if I am unsure of all of the table relationships is it ok to just ignore those relationships and then add them later in Filemaker Manage Database? Does setting it up at the mirrosync config level change any scripts or anything else I should worry about if I later add relationships between tables in Filemaker?

I encountered a “problem” (maybe not a problem) with MirrorSync. I followed the steps to configure and the file is downloaded and sent to the iPad. When the iPad is connected to the network, I click on the “self-made” Sync button, data is synchronised and all processed smoothly. But when the iPad is not connected to the network and if I press the self-made Sync button, the MirrorSync will try indefinitely and nothing will happen. The screen remains as the MirrorSync (purple) screen with 5 tabs on it. If I manage (with luck) to cancel the process, I am stuck in this MirrorSync screen and unable to return to my original layout before the sync button is pressed…

For whatever reason I still run into issues with duplicate records every so often. My question is, if I get an error message saying one of my offline users on an iPad has a duplicate record and I go in and change the primary key to something different in my online database, will mirrorsync update that record for the offline user during the sync, thereby clearing the duplicate? Or will it skip that table completely when it detects the duplicate in the offline database? Thanks.

I am trying to set up the program and when I click choose database I get an error saying "Couold not get names for filemaker server. XML web publishing not enabled." I have it enabled on my server...not sure what to do.

Does anyone have a link to a short reference on updating MirrorSync settings after making changes to the Filemaker solution (other than the original MirrorSync documentation)?

I have reported this through the bug reporting system ( ticket number: 13920 ) but wanted to add the screenshot of the error that I received running an incremental backup this morning Everything had worked perfectly until this morning and then we got the duplicate record error I understand the problem and how to remedy it but wonder if there are any reasons why the duplication would exist and whether I need to test for errors like this as part of a maintenance routine of some description ? Cheers Harry

Built a new solution. Reset sync from scratch only syncing 5 tables 3 are bi-directional the latter are references and only push from HUB. On initial sync I am getting an error that one record couldn't be created in SPOKE because the UUID is not unique. The file SPOKE has one less record then the host. However the UUID field is unique - for giggles I cleared the UUID on the records and replaced them with a new UUID (and also reset any foreign keys in child records that were related) however even after initial sync on new clone the error persists, on different devices. insert operation for table Client node sync_customer on Gregg's iPad's Go_iPad 14.0.2 failed for sour…

Reported a sync error and have ticket: 13886 issued and following that up with the screenshot from my remote device when sync was run Apologies as I think that one of my colleagues reported a similar error a while back but he is on holiday at moment until next Monday Cheers Harry

We have a sync configuration that has been in use for a year or more and I'd like to remove a couple of container fields from syncing. These fields are in a preferences table which in only synced from hub to spoke systems, it is not bidirectional. The spoke database is different than the hub database, tailored specifically for the remote users. Can this be done without having the spoke systems download a new copy of the remote file? I can remove the fields from the sync layouts, rebuild the configuration, and copy and paste new sync scripts in the server copy of the files, but will that cause problems for users still syncing with files created under the previous confi…

Hi I have reported this error to 360Works on tickets: 13763 & 13801 but in the interim wondered whether anybody else had ever seen the error shown on the attachment and typed below: 'Communication Error With Server' 'Error from server: problem with log file: - file check mismatch - 26318877' Any help or response much appreciated whilst I wait for the wonderful people at 360Works to reply Cheers Harry

Hi Jesse I did not want to leave this on the other thread regarding the initial sync errors so thought that I would continue to ask questions on here as I do not seem to getting any replies via the ticket system responses as you remarked You answered regarding the removal of the AuditLog directory: It's a database of all every change made to every record on the hub - so it's inevitable that it will grow over time. We don't periodically clear it out, because we have no way of knowing whether somebody might try to sync a very old record and get a conflict, and we can only auto-merge those conflicting records if we have the audit log. If you're not worried about users n…

In the HUB or hosted file I have several fields setup to auto enter a calculation This is required so that when user changes values in one field these fields are updated. The calculation references data tables that are not being synced. Now after sync this fields are all blank, on the SPOKE file. I just spent hours removing the need for these reference tables to be synced to speed up sync process, since the data was cached in the table that is being synced.

Is it possible to sync, on file open, a single table, then based on some user feedback, sync the balance of the tables? I'd like to sync the remaining tables based on values selected from the first table. Thanks Scott

Hello, I am trying to migrate to a new server. I followed the documentation (showing to copy over the mirrorsync file from the old server) and have done that, but when I go to the mirrorsync client on the new installation and put in my licensing information, it says my license is only valid for one user, and there is already a user connected. Is there any other steps I need to take in order to get MirrorSync to recognize my license key? Thanks!

I'd like to change the admin email address on our MirrorSync installation. Can I make that change without a re-install? I don't see it anywhere in the admin console. Thanks, Craig

just fyi - probably not much you can do about this but there doesn't seem to be a way to download a clone from the server via the URL because safari on iOS9 (beta) just never loads or present the "open in" sheet.

Hi, I have changed my sync settings from read and write to try and resolve some issues we have been having caused by the end users, so I am now using on many tables a "Read from Hub and Write to Spoke" sync with the Hub always resolving conflicts. Spoke is FileMakerGO 14 in this instance. My question is about the behaviour of this method of sync. Is it normal that when a user deletes a record on the spoke, it is not then deleted on the hub after the sync? Changes are updated, but deletions are not. Also applies to the read from hub and write to spoke I guess in reverse also.

I have a client with several iPads in the field. One today failed to sync, though the others have been syncing fine. I had him close the FileMaker file, quit Go and all other apps, and restart his iPad before syncing again. Same error. I restarted the WPE and the Tomcat server. Same error. Had him restart again while I restarted WPE and Tomcat. Same error. Others had since synced fine. Below is the error we are getting. I redacted the domain and client's IP address. I told him to click "Report Bug" so you should have that.

We have just upgraded server to FMS 14 and updated MS on to the latest version 2.406 i have noticed that we have had a few times white / blank layout while syncing. And on a few different iPads occasionally on initial sync FMGO just closes. And trying to open the clone file it reports the file is damaged. not sure if you've seen this happening in 14?

Hi There, Apologies for posting this on the forum as well as a bug report (ticket #13182) but we currently have an unusable solution & server!! On our clients server, I have just upgraded to the newest 2.503 MirrorSync version. At the same time, I had to update the Java version. Now, as I make my way through the configuration to update the MirrorSync scripts, I cannot get past the field mapping. It just seems to be constantly attempting to communicate with the server but does not give an error (see screenshot). Once I received the error and checked the Java version out, I then sent a bug report (as indicated above) and reverted back to my original 2.40615 version …

In the docshttp://docs.360works.com/index.php/MirrorSync_advanced_topics You indicate that: there is a configuration that causes a substantial slowdown when syncing with FileMaker Server 13 (this is not an issue with FileMaker Server 10, 11, or 12). This adds about a second onto every XML request, so requests that would normally take about 20 milliseconds wind up taking around 1,100 - 1,200 milliseconds. To fix this, open up the file at FileMaker Server/Web Publishing/publishing engine/jwpc-tomcat/conf/server.xml Is this still recommended for Filemaker Server 14 ?

Hi again, I have submitted a bug report this morning, but have not yet received a ticket number confirmation email? Perhaps I mistyped the email address. While on this topic, the bug I reported does need a few screen shots to explain, and these are attached to this post. It incorporates 2 errors. One is that our client received an 'Error 10' while doing an initial sync. They have received some data, so it seems the problem may be with the data at the hub database, somewhere between tables Booking and Service File in the import order. If possible, please could someone check the logs to see if it gives any more indication of where the problem lies? Also, the report bug …

Our client has asked whether there could be any cosmetic or branding changes made to the bug reporting web page to make it less obvious that it was a 360Works page ? Their reasoning is that remote users are unaware of the connection to 360Works and may find it confusing to be using a branded FileMaker solution and then be taken, on the rare occasion that any error requires a bug report, to a page showing another supplier name I said, that I would post the request :-) Cheers Harry

Hi, Referencing ticket #12788 we have received several reports of sync timing errors, where the overall time to sync seems to be out of the norm. It seems that it occurs while syncing image data. Hopefully the data in the log may help you to guide us on what the problem may be. Please see attached screen shots of the admin emails we have received when the syncs were aborted by users. Thank you Lewis

Several times - for various reasons - there have been communication errors received from the server during a sync process The error dialogues always have the 'Report Bug' button available and when you click on that report bug button it tries to open the MirrorSync Server Bug Report mechanism so you can send the report However this process errors on the basis that it cannot open the page [this happens on all platforms - desktop and iPad - see screenshot attached] The reason is that the IP address being used to open that page is the internal network IP address which cannot be reached by a remote device So the bug reporting option tries to open: 192.168.12.23/MirrorSync/…

Over last 36 hours several users have received the following error when trying to sync from iPads: Failed to open "http://192.168.12.23/MirrorSync/bugreport.jsp?sessionId=4:07:50x58145792176946997643&error=Errorfrom server: This license key is only valid for up to 1 devices. You must upgrade your license key or delete devices before you can synchronize more." I have sent a report back via MirrorSync server with the ticket ID: 12576 An unlimited license was installed several weeks ago and has been fine until now Any feedback gratefully received and I am happy to provide any other info needed Harry

A client has reported that the time to run an initial sync has increased from 9 minutes to 14 minutes Outside of the obvious reason of 'more data' could there be any contributing factors that could cause this? There have been: No changes in schema to be synced No major increase in total record footprint No changes to the FM Server Interestingly, this has happened since I reported a licensing error on ticket ID 12576 (which has been resolved) Any advice for things to check and review gratefully accepted Cheers Harry

Using the following configuration: * FileMaker Server 13 on Mac Mini, FileMaker Pro v13 on remote MacBook Pro, MirrorSync 2.406 build 8009 We are seeing the following message when trying to sync using MirrorSync. 'You will not be able to successfully sync. MirrorSync is out of date or missing some script steps. Would you like to save changes anyway?' I have deleted the configuration and started over, then repasted the script steps into the MirrorSync script. I have not been able to repaste the layout as MirrorSync does not request it second time over - does this contain some reference to the original configuration and if so, how do I reset it. Any ideas?

Hi, On a couple of occasions, a user (different users before you ask :-) has clicked the URL link provided to download a spoke file to an iPad and when choosing to open the downloaded file in FileMaker Go is given the FileMaker error that the file is corrupt This is straight after the download and at the point that it has tried to be opened on the iPad On investigation, the file received is approx half the size of the actual spoke (roughly 8.5 MB instead of 17MB) so it is obviously 'missing' something or a portion of its whole - perhaps at point of compression - although the download file does have a 'fmp12' extension and shows the FM file icon Has anyone come across …

We have just finished setting up a test server for a client MirrorSync is installed using the 'free' version inclusive of a single client We foresee multiple device licenses being purchased once testing has proven it so, when extra devices are purchased would we simply need to update the current 'free' license key for MirrorSync in order to activate the extra devices or would we need to perform a new install ? Cheers Harry

We have MirrorSync setup to send an email on sync error Having offered the solution to a remote user for testing, that user had a number of small issues when running a sync The remote user was on an iPad at home using their wifi connection Although nothing was directly reported to us specifically concerning this sync error issue, I received two emails containing the following error - obfuscated where necessary: <snip> subject: Sync failed for config 'TAG_host' running on 192.168.xx.xx May 22, 2015 8:54:13 PM com.prosc.mirror.config.server.SyncServer$4 callSEVERE: Sync between 192.168.xx.xx / TAG_host (FileMaker Server) and xxxxxxx's iPad's Go_iPad 13.0.8( use…

Client has asked for the time to sync to be displayed as Minutes :: Seconds Is it possible to override this result as it is being passed back from the main MirrorSync script as seconds ? Cheers Harry

We have just finished setting up a test server for a client MirrorSync now sits on one of their servers which is in a DMZ but has an outward facing DNS name and uses NAT to get the traffic through to FM Server (and MirrorSync, of course) We have also setup MirrorSync to use separate internal and external IP addresses From the server, we have the MirrorSync Client Config tool open and choose to Download database and create a link and the link has the internal IP address embedded in it as follows: http://192.168.12.23/MirrorSync/dbDownload/a3d34edd-0805-49e4-929c-f5847931f893 This fails locally as the mobile client cannot see the internal IP address of the server If I…

We passed out a link to our solution to a remote user who downloaded onto their iPad, launched and then received an error when syncing as per the screenshot attached showing: 'Empty Response From Server' I assume that this is due to a network issue but would value any other potential causes for it That said, the second and perhaps more important issue was that the user clicked on the 'Report Bug' option and was just presented with a blank white screen which obviously could not allow the user to report the potential bug Is this a known problem and, if so, do we have a workaround or is a solution being worked on ? Cheers Harry