Sign in to follow this  
Followers 0

Can I use MirrorSync with Externally Stored container fields?

9 posts in this topic

Hi There,


I have a database that my company uses for inspections. It is running very successfully, syncing data between iPads and the main database using MirrorSync. All of the initial difficulties we experienced have been fixed and for the most part, we have a very smooth solution.


The problem I have now is the database size. During an inspection, we need to take photos of non compliant items. As the sites are quite large, there could be up to 700 tenancies in any one site, and in each of those tenancies, there may be anything up to 7 non compliant items. As you can imagine this makes the database expand very very quickly, and it is currently sitting at 5.5Gb  :hmm:


What I want to be able to do is move all of the container fields to external storage. The only problem is, if I do this, I am not sure that MirrorSync will still sync all of the data. How would i best handle this situation to make sure I can still sync the required images and still manage to keep the size of the actual database file down?



Share this post

Link to post
Share on other sites

There are a couple of general options, without knowing your specific use case


1) Start filing closed jobs to an external storage, that way you can run your operational database as pr today

2) Use super container, not sure how this will sync

3) Use web viewer with some selv made system, I have between 500GB - 1TB of data in such a repository, will require access

4) Others?

Share this post

Link to post
Share on other sites

On the server side, you can simply switch to externally stored containers, and everything will continue to work for all of your existing offline users - they won't be able to tell the difference, and MirrorSync doesn't care either way.


You may run into an issue when distributing new offline files, however. Let me ask a few questions:

1) Are your offline users running a copy of the server file, or have you created a separate mobile file for them to use?

2) If it's a copy of the server file, are you distributing an empty clone, or a full copy of the server file?

Share this post

Link to post
Share on other sites

Hi Jesse,


I am distributing a full clone of the database to the offline users.



Share this post

Link to post
Share on other sites

When you say a "full clone", can you clarify that? Do you mean a copy of the database will all records, or a copy of the database with no records?

Share this post

Link to post
Share on other sites

Hi Jesse,


I mean a full clone of the database at that present time with all records, including photos that are in containers. This is why it is such a big issue. the database is far too large to be used effectively on a regular basis from the iPad running a remote database.


I need a way to store the photos externally on the server, but I also need the ability to sync the photos that are taken on the iPad on site as these make up part of the inspection. 


does that make sense?

Share this post

Link to post
Share on other sites

Yes, I understand now. I was confused because typically the word "clone" implies that it's empty (no records).


There is an extra step that needs to happen any time you're copying a FileMaker database with externally stored container fields to an iOS device. This is a FileMaker requirement, not a MirrorSync one. We've documented the process here:

Share this post

Link to post
Share on other sites

Ahhh lol, I wasn't aware that a clone was an empty database. Apologies for the confusion.


I will go through the info in the link you provided and test it out. See how I go :-)



Share this post

Link to post
Share on other sites

Sorry Jesse, Just going through that info, and I have a question. If the self contained file has all data available to it, does this mean that the file will have all of the container field files written into the actual self contained database?


If this file will have all of the data stored internally, would it not work out to be the same size on the iPad?

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0

  • Similar Content

    • By jbante
      I'm working on a function to extract text from a .txt.gz file in a container field:
      //SM_TextFromGZIP ( containerFieldName ) import; import*; GZIPInputStream gunzip = new GZIPInputStream(fmpro.getContainerStream(containerFieldName)); InputStreamReader reader = new InputStreamReader(gunzip); BufferedReader pr = new BufferedReader(reader); String line; String finalOutput = \"\"; while ((line = pr.readLine()) != null)     finalOutput += line; return finalOutput; When I run this, I get this from the SMLastStackTrace function: com.prosc.fmkit.types.FMBinary$ returned value out of range -1..255: -117     at     at     at     at<init>(     at<init>(     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)     ... Any thoughts on a fix or alternative solution?
    • By naio
      My old fp7 solution had some fields that store the path to external pdf files, the files were stored in the same server machine and the path were like "file://oldserver/folder/file", the pdf files are shown in the solution through a webviewer field. The solution is developed under the 'separation model'.
      I just converted the solution to FM15 and I moved into a new server, at present I have both servers up and running, so the fmp12 database with fields pointing to "file://oldserver/folder/file" still shows pdf files as expected.
      Given that I want the paths to point to a certain folder into the new server I'm trying to find the right path to the new location of files but so far I haven't been able even thought I made sure that users fmserver and fmsadmin have full permissions on the folder that stores the pdf files.
      On the other hand I've seen that FMS15 creates a folder named "RC_Data_FMS" with a subfolder for each fmp12 file where the external container data is meant to be stored. Am I forced to store my pdf files in there OR somewhere else in the network?
      Thank you in advance.
    • By Roger Tuan
      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!
    • By Roger Tuan
      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?
    • By 360Works
      ATLANTA, GA – July 6, 2016 – 360Works will be attending the 2016 FileMaker Developer Conference beginning July 17, 2016 in Las Vegas with a brand new version of 360Works MirrorSync, a FileMaker synchronization tool, being unveiled. This is a fun time of the year for the 360Works team, as they are always excited to meet up with FileMaker Developers from around the world and share what new tools have been in the works!


      MirrorSync 3 is the newest version of 360Works award-winning synchronization tool. It is packed with improvements to speed and usability and will be available at DevCon this year. Attendees are encouraged to stop by the 360Works booth in the Exhibitor Showcase to watch a live demonstration and receive valuable information on MirrorSync 3 as well as over 17 other plug-ins and sync tools available from 360Works.


      The 360Works booth will be a must on to-do lists at DevCon this year, as their booth will have a complimentary MirrorSync Setup Station to help attendees keep all of their data in sync while on the go with sessions and seminars. The MirrorSync Setup Station is brand new this year and will offer the opportunity to have MirrorSync set up at no cost, a service that is typically billed at consulting rates. Additionally, there will be complimentary phone wallets at the 360Works booth to help attendees keep personal belongings in sync as well!


      Finally, Wednesday, July 20th at 3:45 p.m. in Nolita 1, 360Works hosts a session entitled “Do the UnSYNCable” which will demystify how MirrorSync can synchronize data in ways never thought possible! To celebrate the occasion they will be running a DevCon discount- 15% off all 360Works products from July 17th to the 22nd. Look for a post at next week with the 15% off discount code. Browse some of the 360Works featured products below, or view the entire product line, to see how 360Works helps FileMaker’s aptitude for apps!



      Mobile and Desktop Solutions


      FileMaker synchronization tool that links FileMaker Server to FileMaker Go and FileMaker Pro. With MirrorSync, users can make changes offline and simply sync their data to and from FileMaker Server when connected.


      Administer FileMaker Server from a browser or smartphone.


      Messaging Solutions

      Email Plug-in

      Send and receive HTML or plain text e-mail with SMTP, POP, and IMAP from your FileMaker solution

      CloudMail Plug-in

      Designed for outbound e-mail marketing and e-mail blast sending in FileMaker. Monitors e-mail interactions and automates data sending to analytics platforms, such as Google Analytics.



      Document and Digital Asset Management Tools


      With a simple, intuitive user interface, version controls, multi-user edit locking, and flexible query controls, DocuBin is a complete FileMaker solution that allows you to manage your documents and digital assets from a single, structured location.


      SuperContainer is most configurable and powerful way to store files and images in FileMaker Pro, including uploads from the web. Utilize the storage engine behind DocuBin to store files in your own solutions.


      Scribe is the ultimate text processing plugin for FileMaker. Read and write text from Word, Excel and PDF files, find what changed in a text field, and highlight text matching any criteria.


      Developer Tools

      ScriptMaster Advanced

      Generate custom plugins! Perform SQL, read/write clipboard data.

      Portfolio Bundle

      For one low price this Portfolio Bundle includes many 360Works products including the brand new MirrorSync! Save almost $300 during the DevCon sale.


      And much more!

      Browse our catalog of products to view over a dozen plugins, developer tools, and much more.


      About 360Works

      Located in metro Atlanta, 360Works, a FileMaker Platinum Business Alliance member, has been providing FileMaker-based solutions for 20 years. The company is a leading developer of both shrink-wrapped and custom database design solutions for clients such as NASA, Pixar, US Marines, Make-A-Wish foundation and others. The company is credited for its forward-thinking solutions, dedication and unparalleled client service.


      Contact Info

      Charis Booker

      Marketing Coordinator