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

    • Container export to IOS Photo app?
      By 34South
      I have developed a solution for IOS devices which also utilizes scripts that facilitate importing of GPS coordinates and especially photos from the device, i.e. iPhone or iPad, within FMGo. Although I have scripted the possibility of emailing images originally captured by the solution outside of the solution, there does not seem to be a possibility for exporting the captured image to the Photos app and thus pushing them to the iCloud. I know one could first capture the image in the Camera app and then import it into a container within the solution, but this distracts from the all-in-one nature of my solution, where quick image capture is paramount. Ideally, the user would use the solution to capture the image and related contextual data, but also elect to save such an image in the Photo app at a later stage to permit sharing it to social media apps, for example.
       I'm fairly advanced, having used FM since the Claris days.
    • PDF on FileMaker Server 14 (Windows) generating security error
      By typewriter
      I am experiencing a nasty problem with a Filemaker Server 14.0.4.412 on Windows Server 2012R2. PDF s in a container field don't display, but instead either one of two things happen:
      1 on FMPA14 running on Terminal Server (Windows), an error displays 'Security settings do not allow downloading this file' (or something similar, the message is in Dutch). the dialog doesn't display a FileMaker icon, only a yellow warning sign (Windows?). The Terminal server has Acrobat Reader DC installed, which can open the PDF locally. Opening the FMP database with the FMPA locally displays the PDF, both stroed 'in file' and as Remote Container.
      2 on FMP14 running on a normal Windows workstation, the PDF is opened in Adobe Acrobat in a separate window instead of being displayed in the container field.
      We checked ports 80, 443, 16000 and 16001 being blocked on the Firewall (clients and server are within the same LAN). PNG and JPG will display OK, and the PDFs are stored properly, so it seems.
      Where is this security error coming from? 
      Could it be a problem with Windows Server 2012 not allowing Tomcat Server to run? And if so, what can I do to fix this?
    • Signature in FilemakerPro 14
      By muskee
      Hi everyone!
      I'm currently using filemaker pro advanced 14, and I'm making some layouts for the Ipad platform. Is there a way to set up a container field to capture signatures via this method? how?
    • Insert PDF is greyed out on my container field
      By Brad Mathews
      The Insert PDF context menu item is greyed out on my container field when I have my database open locally. My Google Fu has failed me on solving this.
      My container field is on a layout, not in a portal. I have Interactive Content checked. I have a PDF viewer working in IE. (Zeon - I do not know where I got this plugin - I very rarely use IE.). I also have an older version of NitroPDF Pro which I use daily, but no IE plugin at the moment. The container field Storage settings are "Store container data externally" and using Open storage option. I also tried the secure storage option which was the default. I have FM Pro 14.0.4 and this database is not converted from earlier version. I am using Windows 10 I can drag and drop a PDF into the container and I get the PDF icon, but it is not interactive However it is interactive (both native and WebDirect) when I upload the database to FM Server - which is also my local computer for now.  But in all cases Insert PDF is greyed out. The only other solution that the web has coughed up it to use the newest version of Adobe Acrobat Reader which is not an option - I refuse to use that piece of #$@&.
      What else can I try?
      Thanks, Brad
    • Is there a flag or indicator that the sync completed successfully from a client?
      By echocron
      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!