Sign in to follow this  
Followers 0
UltimateTech

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.

 

Cheers

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: 

 

http://docs.360works.com/index.php/MirrorSync_advanced_topics#Does_MirrorSync_sync_external_container_fields.3F

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 :-)

 

Thanks

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

    • Popout with image contents of a container field
      By Asu
      Hello Mavens, 
      I have a container field into which images can be pasted. I want to create a popout window run by a script, that displays the image in its full size. How do I get the size of the image that has been pasted into a container field?
      Muchas gracias.
    • FileMaker iOS App SDK and MirrorSync
      By 360Works
      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 client or company to use with iPhone or iPad distribute the application to users without the need to first download and install FileMaker Go distribute the application directly to user devices with Apple's Mobile Device Management (MDM) and TestFlight, used to distribute beta versions of the application There are a couple of things you will need to create your native iOS application: 
       
      FileMaker Developer subscription, which will give you access to the tool itself Apple Developer subscription, which allows you to set application identification and provisioning profile used to actually deploy the application onto an iOS device A Mac with the latest version of Xcode installed: Currently the process of putting the application together can be done only on a Mac Let us know if you'd like our assistance in turning your FileMaker solution into a native iOS application - we would be happy to help! Just send a message to infobox@360works.com
    • FileMaker iOS App SDK and MirrorSync
      By 360Works
      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 client or company to use with iPhone or iPad distribute the application to users without the need to first download and install FileMaker Go distribute the application directly to user devices with Apple's Mobile Device Management (MDM) and TestFlight, used to distribute beta versions of the application  
      There are a couple of things you will need to create your native iOS application: 
       
      FileMaker Developer subscription, which will give you access to the tool itself Apple Developer subscription, which allows you to set application identification and provisioning profile used to actually deploy the application onto an iOS device A Mac with the latest version of Xcode installed: Currently the process of putting the application together can be done only on a Mac  
      Let us know if you'd like our assistance in turning your FileMaker solution into a native iOS application - we would be happy to help! Just send a message to infobox@360works.com
    • adding product images in invoices and estimates
      By Markus64
      Hi
      I'm looking to add the picture from the products table to Invoices and Estimates tables.
      Not to successfully yet. 
      What am I missing?
      Thanks in advance for you insights. M.
    • calculation field (container) image not showing on FM GO
      By justakid
      Hi All,
      I created a calculation that resulted in a container image (see below). This is allows me to add/update images without doing anything in Filemaker.
      "imagemac:images/" & S_shot & ".png"
      This works perfectly on the my Mac, but doesn't work on FM go.
      The only way I could get the images to work in FM go was to import the images on a shot by shot basis. I imagine a script could be written to do this, but before doing so, I was wondering if anyone knew if there was a way to make the calculation work.
       
      Any ideas?