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!
I have always developed with FileMaker for windows. I have bought myself a MacBook Air and love it. So now I am using FileMaker 16 Pro advance for MAC. I know that MAC does not label their directories like windows does. So I am having problems figuring out to get the right coding to access my photos. I have a folder called "Photos" that reside on the C: drive in windows. Then I reference that folder so pictures will populate automatically when I put in a record. Here is what I have on the windows fileMaker:
Let ( [ // Transform the contents of a container field named Images to text ImageRef = GetAsText ( ImagePath); Photos = Position ( ImageRef; "/"; 1; PatternCount ( ImageRef; "/")) ]; Middle ( ImageRef; Photos + 1; Length ( ImageRef ) - Photos ) ) images:
"imagewin:/C:/Photos/" & Film::title & ".jpg" Then I go into Import folder and point to the folder all the photos are in. The problem I have now is how to point to that folder in "imagewin", is their an alternative called imagemac, then I could put in Macintosh HD/Users/patricks/Documents. The folder is in the Document folder, called Photos. Thank you for any help.
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:
Who Viewed the Topic