Jump to content
Sign in to follow this  
UltimateTech

Can I use MirrorSync with Externally Stored container fields?

Recommended Posts

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
ggt667    8

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
Jesse Barnum    50

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
Jesse Barnum    50

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
Jesse Barnum    50

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  

  • Similar Content

    • By woz
      I've set up 2 previous clients with MirrorSync v3.x without problem but just trying to setup another client using v4.0.
      Setting a new config for Server to Pro/Go at step 2 of the hub config (Copy scripts) it does not recognise that the scripts have been pasted in when in fact they have - it refers to 3 scripts but copies 4 - obviously an update is needed. The version of MirrorSync from the java app is "4.0 build 9400" even thought the jnlp file was named MirrorSync3ConfigClient.
      I'm using FMS 16, FMPA 16
      Error message is "Validation Failed: You will not be able to successfully sync. There is no script called 'MirrorSync'. That must exist before proceeding......".
      I've tried from scratch multiple times. Anyone else had this problem with v4.0?
    • By wedgeman
      So i'm dealing with two tables.
       
      1.  VisitTable.
      2. GraphicsTable
       
      in a VisitTable layout, i have one or two portals related to the GraphicsTable, each related by a different factor.  One portal would be related by a Date field, the other would be a ClientName field..
      My desire is to click on a thumbnail in either one of these portals, and have that selected image be displayed in a separate/larger image window (which could be a container field in the current table, Or another portal?  I don't care how - i just need to have it show up) 
      I don't know the best method for doing this (ie., click thumbnail to have image fillin a separate location).  In this particular instance, I don't want this to be a separate window, but to display in a container field view on the current window/layout. 
       
      how do I accomplish this?
      thx
       
       

    • By Lewis Stairs
      Hello,
      I noticed that on the server in which MirrorSync is installed, one of the mirrorsync.data files was 12GB+ in size. It is in the filepath formula C://Program Files/360WOrks/SyncData3_MirrorSync/FileMaker Server_x.x.x.x_FileName/mirrorsync.data

      Is there any way to either reduce the size of this file, or stop it getting any bigger? 
      Thank you in advance for you help
      Lewis
    • By amallison
      Since going from version 2 to 3 of MirrorSync last year we have constantly had MirrorSync crashing the Web Publishing Engine. 
      Sometimes it says "Error from server: FileMaker XML WPE Web Publishing Engine is not running at <the hosted IP>. Ensure that the WPE is working correctly, and then try this operation again."
      But usually it is an Error 10 error. "Error 10 while connecting to http://<the hosted IP>/sync?ping=1&config..."
      Early on we made the documented suggested changes for this error, to the connectionTimeout Property in the IIS Manager application. With no noticeable effect.
      Most of the time MirrorSync works as expected and does a great job and then clients can't sync and all hell breaks loose.
      Do you have any other suggestions for what might be causing this issue?
    • By dataclip
      During the installation of MirrorSync I can not select the spoke database if I select the option to use a separate mobile file.
      I get an error message thta MirrorSync can not get the database names (image mirrosync2). However database names are available when I select the hub database (image mirrosync1). When I select the option sync with an emtpy clone or complete copy of the main file I can continue the installtion process.
      Any idea why Mirrosync can not find db names for the spoke database?


       
×

Important Information

By using this site, you agree to our Terms of Use.