New Major Version Release:
360Works, is proud to announce MirrorSync 5, a new major version of the easy-to-use data replication tool that quickly and seamlessly syncs an offline database running on FileMaker Go or FileMaker Pro with a database hosted by FileMaker Server and syncs various configurations of SQL databases. MirrorSync 5 will greatly improve convenience for your end users by making the sync process faster and more secure. We have added features to improve the initial sync making all subsequent syncs more seamless and we have reduced the amount of password requests needed to access the database for syncing. Additionally, there have been over 40 new improvements made to enhance reliability, speed, and stability overall!
Powerful New Features Added:
Faster Speeds: Run the Initial Sync on the Server
With large databases, initial syncs can take a long time when filtering a subset of records for each user. MirrorSync 5 now has a feature to drastically improve this initial sync time, by hosting a temporary copy of the file on FileMaker Server, running the initial sync entirely on the server, and sending the pre-synced file to the user's iPad, laptop, or iPhone. The performance improvement is especially noticeable when syncing with filtered record sets for large databases, and syncing over cellular networks. If you are syncing a custom/personalized set of records from a table with more than 10,000 records, this update is critical for improving the speed of your syncs.
During our testing, we found that initial syncs are now 3 times faster. For example, doing an initial sync of 10,000 records into an empty clone on an iPad Mini over WiFI took 9:13 using traditional client-side initial sync, and 3:43 using the new server-side initial sync feature of MirrorSync 5.
More Convenient: Encrypts and Remembers User Passwords
MirrorSync will now remember user passwords, so that they don't need to be re-entered on each sync after an offline file is opened. It encrypts and saves the initial password on the MirrorSync server, preventing users from repetitively entering their passwords for better security and end user convenience. If the password is changed on the server file, the user will be re-prompted for a new password. If you've been using a shared password for all users to avoid the hassle of password double-entry, you can now switch to the more secure option to use individual accounts, without making extra work for your users.
More Reliable: New Sync Auditing Feature to Monitor Sync Progress
We have added an advanced notifications feature in MirrorSync 5, which posts CloudWatch metrics and SNS notifications when a sync completes or fails. While this feature is optional and can be turned on or off, it is very beneficial for those who wish to receive updates on sync statistics or receive alarms for sync behaviors (e.g. number of records inserted, sync duration, number of sync warnings). You will need an AWS account to use this feature.
Improvements for MirrorSync Hosting Providers
Log files are now separated by the MirrorSync application name. This is important for hosting providers to be able to see each customers log files separately.
New Support for Syncing with DynamoDB, the Back-end Database of Amazon.com
We have added support for syncing with DynamoDB, a database under Amazon Web Services that is simple, serverless, scalable, and provides low-latency data access. DynamoDB is used by Amazon with their retail site (Amazon.com) where it handles 13.9 million requests per second! Give us a call if you'd like to hear more about how we synced a government FileMaker solution with DynamoDB to handle huge web traffic loads.
More Convenient with FileMaker Server 17
If you are considering switching to FileMaker Server 17, now is the perfect time. MirrorSync will now automatically enable XML Web Publishing on FileMaker Server 17, so that you don't have to do in the command line or data API.
There are over 40 new improvements in MirrorSync 5, giving you more unbelievable new ways to do the unSYNCable! See the complete changelog here.
MirrorSync Map: Speed and Reliability
We analyzed a month of syncing data to show its speed and reliability. The following map shows MirrorSync users who performed syncs in 45 countries around the world across different cities and countries (does not include installations with statistics gathering disabled).
99.4% of 269,000 Syncs completed with no errors 133,465 FileMaker Server to MySQL Syncs with a median sync time of 5.3 seconds 79,961 FileMaker Server to FileMaker Server Syncs with a median sync time of 12.4 seconds 27,085 FileMaker Server to FileMaker Pro/Go Syncs with a median sync time of 22.9 seconds 19,249 FileMaker Server to DynamoDB Syncs with a median sync time of 20.5 seconds 14,279 FileMaker Server to other SQL Databases with a median sync time of 65.3 seconds Longest sync distance of 1,184 Miles Licensing and Hosting
You can download MirrorSync 5 instantly and start syncing with the new improvements. MirrorSync 5 is compatible with MirrorSync 4 offline files - no need to reset sync data or recreate configurations (although some new features, like password saving, will not function until the script is updated).
Active maintenance subscribers for MirrorSync or the 360Works Portfolio Bundle will receive the new major version 5 at no additional cost.
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!
For adding new devices onto a MirrorSync license, prices range from $40-$95 per device depending on the quantity of devices ordered. With our 2018 FileMaker DevCon Discount, you can take 15% off of your order by using promo code DEVCON18 at checkout, now through August 10, 2018. If you are attending the FileMaker Developer Conference this year, please visit us at our booth and we would be happy to answer any questions you may have.
Never tried MirrorSync? You can download a free license which allows for syncing between FileMaker Pro or FileMaker Go with FileMaker Server for one device. Sync an offline database with the hosted server file, completely free of charge.
Try or Buy MirrorSync 5 Stay updated with 360Works
At 360Works, we are focused on helping FileMaker Developers build what works best for their clients by providing products that extend the functionality of the FileMaker platform.
If you need to add features or customize your database, now is the perfect time. The 360Works DevCon discount is available to receive 15% off of your online order using promo code DEVCON18 during checkout, now through August 10, 2018.
Click on any of the product links below to learn more or place your discounted order!
Products and Updates
This year, we are excited to showcase major improvements in 360Deploy and MirrorSync. Our Email and FTPeek Plugins have also received added features that leverage powerful technology found in Amazon Web Services. We are able to demo in more detail the following NEW updates for you at our DevCon booth:
360Deploy - now uses the FileMaker Data Migration Tool, experience faster and easier FileMaker data migration and solution version management MirrorSync - more details coming soon, you will want to ensure your maintenance is up to date to receive the newest features when they are released. If you are eligible for a maintenance renewal (still within 1 year of your last maintenance activation), you can renew your maintenance here. Email Plugin - now uses AWS for sending SMS/Text Messages, send texts to subscribers from your FileMaker solution and receive the additional benefits of a complete email plugin with formatted inbound and outbound email sending capabilities. It's a 2-for-1 deal. FTPeek Plugin - now uses AWS S3 for file storage, FileMaker FTP Plugin that is easy to implement and supports SFTP and FTPS
Current Suite of FileMaker Plugins and Tools:
Product Name Product Description 360Deploy Automated, simple deployment of new database versions Charts Easy-to-use charting for FileMaker CloudMail Send and track email marketing campaigns Email Send and receive text and HTML emails in FileMaker DocuBin Document and digital asset management FTPeek FTP upload and download from your FileMaker database JDBC SQL access with JDBC Compatibility MirrorSync Sync FileMaker Go and Pro on a device without network connection, sync FileMaker Servers, and sync FileMaker with SQL databases Plastic Payment processing plugin RemoteScripter Trigger scripts on FileMaker Pro from the web or IWP SafetyNet FileMaker Server offsite backup Scribe Read and write PDF, Word, and Excel files ScriptMaster Adds many new functions & create custom plug-ins SuperContainer A better container field Web Assistant Access internet resources, URLs, and fill out web forms Web Services Manager Publish FileMaker scripts as XML Web Services Zulu FileMaker calendar sync Stop by Our Booth: Free MirrorSync Consulting, FileMaker 17 Books, and More!
Our booth will be by the entrance of the Longhorn "F" Hall
Free Consulting - MirrorSync Setup Station:
Heard about MirrorSync and just haven't found the time to get it set up? At DevCon, we are taking care of the setup up for you! That's right, a service which we typically provide at our hourly consulting rate, we are providing to you, completely free at the 360Works booth during DevCon 2018 (reply to this email for information on limitations).
Once one of our experienced developers sets up MirrorSync for you, the syncing possibilities will be endless. With MirrorSync, you can sync any combination of FileMaker Pro, FileMaker Go, FileMaker Server, and SQL databases such as MySQL, SQL Server, WordPress, Salesforce, and more! You can even test it out by using it to sync your data while on the go at DevCon. If you need more people or databases to start syncing with a particular database, adding additional configurations and devices is a cinch!
Spots are filling up fast! Please email us at firstname.lastname@example.org if you are interested in setting up time or to learn more about limitations and preparation.
Free FileMaker 17 Book from Richard Carlton Consulting:
Are you a fan of the FileMaker Training Videos? Richard Carlton will have free copies of his new FileMaker 17 book available at our booth. Please note, the books will be available on a first come, first serve basis. Be sure to stop by our booth to secure a copy of the book.
Sessions - NEW UPDATED TIMES
The 360Works team will be presenting at two sessions during DevCon 2018, both are now on WEDNESDAY morning:
1.) 360Works Session: Wednesday, August 8th at 9:00 a.m. - 10:00 a.m.
Room Location: Dallas 5 - 7
360Deploy: The Solution for FileMaker Version Management
Introducing 360Deploy 2, now leveraging the FileMaker Data Migration Tool released with FileMaker 17 and supporting remote deployment to multiple servers! 360Deploy makes it easier and faster than ever to deploy your development database to production. With just one button, 360Deploy clones, transfers, imports, archives, renames, and resumes... while preserving all of your production data. Come see how simple 360Deploy can make your FileMaker development changes.
This session will also include a short presentation of new features added to 360Works MirrorSync. For a more detailed syncing demonstration, please stop by the 360Works booth (#1).
2.) Integration Session: Wednesday, August 8th at 10:30 a.m. - 11:30 a.m.
Room Location: Texas C
Beyond Virtual Machines: Tapping into the AWS Universe of Services
This session is NOT about how to run FileMaker Server or FileMaker Cloud using Amazon Web Services (AWS). Instead, we will embark on a one hour tour of the incredibly powerful software as a service (SaaS) offerings from AWS. AWS is the largest cloud computing vendor in the world, with services such as real-time message queues, machine learning, and massive on-demand general computing services. You'll learn how to interact directly with any of these services by sending AWS requests using the FileMaker Platforms Insert from URL, JSON, and encryption features. Recommended Background: Experience with the Insert from URL script step, REST APIs, cURL, and JSON.
Stay updated with 360Works
Goal - use MirrorSync with database hosted on FileMaker Cloud, using MirrorSync hosted on a Windows Server.
Error - filemaker mirrorsync jdbc error cloud requires version 16.0 or later
MirrorSync version 3.17
FileMaker Cloud 126.96.36.199
Steps to reproduce
1. run mirrorsync
2. create filemaker client to server config
3. configure mirrorsync to use hosted version
4. configure publishing engine / database server to use cloud
5. put any database user, pass or name - it doesn't matter what you put - real or not real
6. you will error - filemaker mirrorsync jdbc error cloud requires version 16.0 or later
By Jason Mundok
Is there a way to customize the language in the dialog box that appears after a successful sync when there's a new database version available?
"There is a new database version available named 'x.xx'. Would you like to replace your current offline file with this version?"
How to Sync with FileMaker Cloud Using 360Works MirrorSync Today we want to let you know that it is completely possible to sync a FileMaker solution hosted on FileMaker Cloud! MirrorSync has been able to handle this task since the release of 3.1. The current version is 4.0 and it remains compatible with FileMaker Cloud.
FileMaker Cloud leverages Amazon Web Services (AWS) to host your FileMaker solutions in the cloud. Many people are moving to the cloud to cut back on server maintenance time and money. Here at 360Works, we are big fans of AWS - we actually moved all of our hosting to AWS and couldn't be happier. (Jesse Barnum, president of 360Works, presented on the topic of deploying FileMaker Server with AWS at last year?s FileMaker Developers conference.)
Getting started with MirrorSync for FileMaker Cloud is extremely simple: There's nothing to install and only a couple of steps to get up and running!
Step 1: Host MirrorSync Elsewhere
You will need to run MirrorSync on a separate computer from your FileMaker Server, because FileMaker Cloud does not allow the installation of 3rd party software other than plug-ins (MirrorSync is not a plug-in).
Once you've launched your FileMaker Cloud instance, 360Works can host MirrorSync on a managed AWS server for just $29 a month. There are several other approved hosting providers willing to host MirrorSync as well (see documentation). Alternatively, knowledgeable Linux administrators can host on their own Linux instance with Amazon Web Services.
Step 2: Enable xDBC
Because there is no XML Web Publishing Engine with FileMaker Cloud, you must enable incoming access (to port 2399) on your FileMaker Cloud instance in order for MirrorSync to communicate with it using xDBC. You can do this in the AWS console, follow along with this short video:
A Few Final Notes
*You will want to reference our MirrorSync and FileMaker Cloud documentation for complete technical guidelines.
*Users running regular FileMaker Server on a Mac or Windows computer can install MirrorSync 4 on their own server.
*We've designed MirrorSync to be something that even a novice user can integrate, but we're standing by when you need more advanced help. If you just want your sync integration to be completed as quickly as possible, we're available to do the work for you directly at our hourly consulting rates. Fill out our message form for advanced help!
Download MirrorSync 4