New Major Version Release:
The All New MirrorSync 6: Optimized for FileMaker Developers
The moment you've been waiting for is here! 360Works is proud to announce the release of MirrorSync 6. The easy-to-use FileMaker data replication tool can quickly and seamlessly sync an offline database running on FileMaker Go or FileMaker Pro with a database hosted by FileMaker Server. It can sync various configurations of SQL databases, such as MySQL, Salesforce, Amazon DynamoDB or Redshift, and WordPress with FileMaker. This new version of MirrorSync also makes it very easy to synchronize two FileMaker Servers to handle mission critical tasks like server clustering for load balancing and data disaster recovery.
In this release, MirrorSync ships with many improvements for the synchronization setup and management process.
Jesse Barnum, President of 360Works, says “MirrorSync 6 is the most major change since version 3. One of the biggest features is that MirrorSync can now automatically detect all new fields and tables." In version 6, there is no need to re-configure or re-paste script steps when you have solution changes (for client-to-server sync, as well as server-to-server).
Overall, the MirrorSync configuration client and sync management has been greatly improved. Creating and editing configurations is much faster, especially for many tables. Sync status updates are more responsive, and configuration changes can be made without canceling active syncs. New fields and layouts are automatically detected and added to the sync. Auto-detection of primary keys, creation / modification timestamps, and writebacks has been greatly improved. In addition, the configuration client no longers requires Java to be pre-installed, and is signed and notarized for compatibility with the latest versions of Mac OS X without annoying security pop-ups.
Try or Buy MirrorSync 6
Automatic File Transfers Between Servers
When setting up a server-to-server sync for the first time, you no longer need to manually download, copy, and upload the databases between the servers. Just install MirrorSync 6 on both servers and click the ‘sync now’ button. MirrorSync will transfer the files (even for multi-file solutions) and run the initial sync.
Automatic Version Update Between Servers
If you’ve used MirrorSync 4 or 5, you’re familiar with the automatic update feature, which automatically sends database updates to users in the field. MirrorSync 6 now uses the same approach for server-to-server syncs. Just modify a single calculation field, and MirrorSync will replace the database on the spoke server with a new version after the next successful sync. You can even schedule this feature, so that it runs overnight without disrupting connected users.
MirrorSync 6 Makes Syncs Safer
Deletion scanning now runs two separate checks to ensure a record has been deleted before deleting on the other side of the sync. Checks have been added to make sure that no client record exists in the MirrorSync table before downloading a copy for the spoke to sync. Recover mode is now more discerning about which records to re-write after a previous failed sync which helps to prevent situations where recovery could cause a large number of records to be modified. Lastly, there have been multithreading improvements for storing and accessing the internal sync database for better reliability.
Robust Enough for the Largest of Files
For users with large databases, MirrorSync now utilizes streaming when reading from FileMaker Server and Pro/Go. This allows fetching data of unlimited size, while reducing RAM requirements.
A common problem in previous versions of MirrorSync was a limit on the number of tables. When the table count approached 60 tables, the MirrorSync script would often hit the limit on script size in FileMaker. This issue is now solved: MirrorSync 6 can sync any number of tables. We’ve successfully tested MirrorSync 6 with a server-to-server sync for a multi-file solution containing 26 files, 127 tables, and over 30 million records.
MirrorSync now supports custom location for temp files. This is particularly important when using the database download feature with very large databases; you can now store these temporary copies on an external volume with more free space than the boot drive.
After upgrading your existing MirrorSync 4 or 5 installation, existing offline databases in the field will continue to be able to sync with the new MirrorSync 6 server. You can utilize MirrorSync’s automatic version update feature to update these users to the latest version after completing a sync with their older version.
Try or Buy MirrorSync 6
New System Requirements:
Java is no longer required to be pre-installed for the installer, web application, or configuration client. FileMaker Pro, Go, and Server 17 or later is now required. Certain multithreading speed improvements will only apply when running Server 18v3 or later.
Notable Features in MirrorSync 6:
Automated deployment and version management for server-to-server syncs Now uses the Data API (instead of XML or xDBC) All new MirrorSync script, re-written to support new features in FileMaker 17 and later Unlimited tables Leverages new FileMaker features for much faster container field syncs Configuration client is now a standalone application that does not require Java to be installed Added support for Get( UUIDNumber ) primary keys Added support for the iPod Touch (which is a great and inexpensive option for offline data collection)
See the complete changelog here.
Pricing and Availability
MirrorSync 6 is available now. You can download the software instantly from mirrorsync.com and start syncing with the new improvements. MirrorSync is free for 1 FileMaker Pro/Go device, with additional devices priced at $8-$95 per device depending on quantity. This price is for a single FileMaker solution, with addition solutions priced at $200/each, and server-to-server syncs priced at $1,600 - $2,000 depending on the types of databases. All prices are one-time costs, not annual. Complete pricing is available at mirrorsync.com
Active maintenance subscribers for MirrorSync or the 360Works Portfolio Bundle will receive the new major version 6 at no additional cost. All purchases within the last 12 months are still under active maintenance.
We are also pleased to announce that we offer hosting services for MirrorSync for the low price of $29 per month. This is included free of charge for customers hosting FileMaker Server with us. Contact us to find out more and get started!
Try or Buy MirrorSync 6 Stay updated with 360Works
360Works FileMaker Plug-ins
Update available for the entire 360Works plug-in platform providing quality of life improvements
360Works plug-ins and products improve the capabilities of FileMaker by adding functionality to the FileMaker platform for sync, email management, web services, payment processing, image and file storage, FTP transfers, Apple/Google/Exchange calendar integration, Microsoft Office document manipulation, and much more.
The team at 360Works strives to provide the best possible service and support to their customers and to always keep their products compatible and flexible.
Quality of life improvements made to the 360Works plug-in platform include:
Startup and shutdown procedures have been greatly improved Fixed issues that caused PSOS calls to return "Host capacity exceeded" Fixed issues that prevented plug-ins from autoupdating using the Install Plugin script step Fixed an issue where multiple server side scripts would cause plugin functions to time out Fixed issues related to multi user environments (Server side scripts, WebDirect, Custom Web Publishing) Fixed issues where child processes would not be terminated on shutdown Reworked GUI framework, so that plug-in windows will stay in lock-step with FileMaker windows
While the new minor update for overall quality affects the entire 360Works plug-in platform, specific plug-ins have more improvements for their related technologies:
360Works Scribe Plug-in now compatible with Microsoft Office 2019 360Works FTPeek Plug-in supports TLS 1.2 standard encryption protocol 360Works ScriptMaster updated to use Groovy 2.4.10
Updated Versions of 360Works Plug-ins:
Updated Plug-in Plug-in Description 360Deploy 2.7 Automated, simple deployment of new database versions CloudMail 3.2 Send and track email marketing campaigns Plastic 3.1 Payment processing plug-in Scribe 3.1 Read and write PDF, Word, and Excel files ScriptMaster 5.2 Adds many new functions & create custom plug-ins Email 3.2 Send and receive text and HTML emails in FileMaker FTPeek 2.2 FTP upload and download from your FileMaker database WebAssistant 2.1 Access internet resources, URLs, and fill out web forms JDBC 2.1 SQL access with JDBC Compatibility Charts 2.1 Easy-to-use charting for FileMaker RemoteScripter 2.1 Trigger scripts on FileMaker Pro from the web or IWP SuperContainer 2.9513 A better container field for FileMaker Go and FileMaker Pro Installing the Update
Using the plug-in links above you can download the current updated version of the plug-in. Installing plug-in updates are easiest when using the Install Plugin File script step in all environments. For legacy systems, auto-update is supported as well. Find out more at 360works.com/autoupdate.
This is a free plug-in update if you own a valid license for the most recent major version, or are within your maintenance subscription for the license (maintenance applies to Scribe and CloudMail).
Active 360Works Portfolio Bundle holders with a current maintenance subscription can use all of the updates at no additional charge. The PDF Plug-in and Scribbler Plug-in, available only in the 360Works Portfolio Bundle, have the same platform update as well!
Please note: if you do not own the current major version or are outside of your maintenance window you will need to purchase the current major version of the license in order to use this update.
Custom Plug-in Users
If you have a 360Works custom plug-in, please contact us to get an updated version of our custom plug-in. In most cases, there will be no additional charge for this. (Charges may occur if additional development work is required. Rates will be billed at our hourly consulting rate of $185/hr. Please contact us for custom plug-in information.)
The 360Works Support Team is dedicated to your successful use of 360Works plug-ins and add-ons. With your purchase from 360Works, you receive 2 free hours of technical support Monday - Friday from 10:00 a.m. - 6:00 p.m. (ET). However, most questions can be answered at our documentation page. If you need to get in touch with us, requests for support team assistance can be sent to firstname.lastname@example.org.
Our database has properties and for each property there are multiple inspections per appliance, sometimes year to year sometimes quarterly. Anyway, we want the technicians in the field who are using iPads to view the history per property by swiping just to make it simple. Every swipe would be a different inspection for that property viewed in chronological order. Property part is "static" while they "page" or swipe through the inspections.
I was thinking a slide control would work nicely, and each slide would be a different record for that property. I'm looking for ideas to jumpstart my thought processes, apparently my brain is having a hard time functioning today (and it's only Tuesday!). Any ideas would be greatly appreciated!
HOW DO YOU MIGRATE? FileMaker Migration Assistant Tool vs. Manual: Best Practices to Migrate Changes to a Live FileMaker Server | 360WorksBy 360Works
FileMaker Migration Assistant Tool vs. Manual:
Best Practices to Migrate Changes to a Live FileMaker Server
Tips from 360Works Senior Developer and Product Manager, Joe Martin
In the past, FileMaker developers haven't had many options for rolling out new changes to their live databases. Even if you were cautious, and did your development in a separate Dev copy of your production file, it was difficult to migrate these changes to your production file.
You could roll your own deployment workflow, scripting FileMaker imports for each table in your solution, and update this workflow whenever you added new tables or fields. These imports are slow and tedious though, and most of us would simply make the changes directly in the live file.
With the release of FileMaker 17, FileMaker came out with the FMDataMigration tool, completely replacing the need for using FileMaker native imports to move your data around. Here at 360Works, we built 360Deploy around the FMDataMigration tool to streamline and completely automate its use, making development changes a tedium free experience.
In today's article, we will walk you through how to do both options so you can determine which is right for you.
See the Article Now
Stay updated with 360Works
General Questions: plugins@360Works.com
Need Support? Email: support@360Works.com
Just want to know more about 360Deploy? Skip the article. Product page here: https://www.360works.com/filemaker-deploy-versions/
Complete list of ALL the things 360Works has to help your FileMaker Development here: https://www.360works.com/products/