Hi everyone, i'm a newest user with MirrorSync.
I could install MirrorSync without problems and get records in my local database, but i had a problem when i try to get records that has the first letter of primary key starts with "0", MirrorSync show the message:
"Error from server: java.sql.SQLException: FileMaker numeric primary keys must not begin with a 0. Either remove the zero padding, or switch the primary key field and all related foreign keys to text. First error: 01234567-DACC-8DE7-58DD-2ASSDE474DCA from table TableName"
The field its auto-generate UUID of type text.
I try to find a way modified the script MirrorSync, but i dont know how to control this in the script, any solution for this? Thanks!
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
MirrorSync 5 is now available and with it ships a better user experience for your clients! Today, we want to share 3 ways you can optimize your FileMaker sync experience for your users with the lastest version of MirrorSync.
If you haven't heard...MirrorSync allows you to sync FileMaker Go, FileMaker Pro, FileMaker Servers, SQL databases, and virtually any datatbase you can think of!
Here are 3 ways you can sync FileMaker and provide a better user experience using MirrorSync 5:
1. Encrypted Password Storage
No user wants to repetitively enter their password before a sync! As a convenience to your users, MirrorSync 5 will now store encrypted passwords for your users on the server. Essentially, it stores an encrypted version of the last used password to sync an offline file. In MirrorSync 5, instead of picking between a shared, auto-entered password (less secure) or individual passwords that need to be entered on each sync (less convenient), everyone can use their own password with ease and optimal security.
2. Fast Initial Sync
MirrorSync now runs a server-side initial sync! It will save an empty clone of the file, and temporarily host the empty file copy on FileMaker Server where it runs a fast server to server sync of only the selected records you want to sync. This is especially helpful if you have a massive database and only want to sync a subset of records without draining the memory on the local device, such as an iPad or iPhone. Once the sync is complete, MirrorSync closes the file on the server and sends the pre-populated file down to your users.
3. Monitor Your Sync Statistics
MirrorSync now reports sync stats to AWS CloudWatch. You can get real-time updates on important metrics such as sync times, warnings, and other notifications. Having this insight at your fingertips will make you instantly aware of issues or difficulties your users may be running into.
Watch a Video on this Topic Now!
We enjoy meeting up with our fellow FileMaker Developers at DevCon. Each year, we like to catch up with Richard Carlton Consulting who offers educational and entertaining FileMaker training that will keep you engaged and leave you with the knowledge and tools you need to be an excellent FileMaker Developer.
Check out Richard's video below to see an in-depth explanation and interview on MirrorSync 5 with 360Works President, Jesse Barnum.
Download a free version of MirrroSync 5, upgrade, or purchase here.
Stay updated with 360Works:
By Richard Carlton
360Works' MirrorSync 5 - FileMaker Sync - FileMaker Training - FileMaker Experts - FileMaker Videos
360Works' Deploy: https://youtu.be/S45NwYX80Xs
360Works' MirrorSync 4: https://youtu.be/at9asdCJ5hU
360Works' Clustering & Replication: https://youtu.be/bQlGHrNtHCg
Get up to speed with the FileMaker 17 Video Training Course!
FileMaker is a cross-platform relational database application from FileMaker Inc. https://en.wikipedia.org/wiki/FileMaker
Top Rated Course by FileMaker Expert, Richard Carlton.
Customer relationship management, processes implemented to manage a company's interactions with customers and prospects
Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions.
The course is 50 hours of video content!
Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide.
Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers.
He has offices in California, Nevada, and Texas.
Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration.
Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.
Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development.
RCC, Filemaker Videos, and LearningFileMaker.com are headquartered in Santa Clara, CA.
Contact us at firstname.lastname@example.org
FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web
Transform your business with the FileMaker Platform
Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos
FileMaker 17 Training -FileMaker 17 Video Training Course-FileMaker 17 News-FileMaker Experts
FileMaker 17 What's New-Top Ten Things To Know About FileMaker 17-FileMaker 17 News
Sharing a FileMaker Solution-The Basics-Sharing FileMaker Database-FileMaker 17 Experts
A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data
Official site SDK, Developer's Guide, Reference, and Android Market for the open source project
Video introduction to iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw
Free FileMaker videos check out ...http://www.filemakervideos.com
Download the FileMaker Pro 17 & FileMaker GO 17 for mobile devices training videos at http://www.learningfilemaker.com
Download FileMaker Go 17 video training at http://learningfilemaker.com/FMGO-17/index.php
Download FileMaker 17 Full Video Training Bundle at http://learningfilemaker.com/subscription.php
Learn how to use FileMaker to create an app with the FileMaker Training Series
Comment, Like & Share All of Our Videos.
Feel Free to Embed any of Our Videos on Your Blog or Website.
Follow Us on Your Favorite Social Media