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 email@example.com
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
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
Am I righting in thinking I can use a case statement to evaluate two fields and return an answer into a third field ie: Field A has the number 27 in it. Field B has the number 32 in it. Could the case statement look at the difference and put the difference in Field 3.The difference being 5?
I’m also trying to get this to do the math on data entry, so the figure in Field A is 27 but when the user enters the new figure in Field B (i.e 32), it looks at that difference between A and B, copies the difference of 5 to Field 3 and then also copies the figure 32 from Field B into Field A thereby updating Field A to the new value.
Help, suggestions or thoughts will be greatly appreciated.