Jump to content

Search the Community

Showing results for tags 'sync'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
    • FileMaker Videos
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Proof+Geist
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting

Categories

  • White Papers
  • Infographics
  • Samples
  • Add-ons
  • FMGo
  • Solutions
  • Tutorials
  • Plug-Ins

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development
  • FileMaker Hosting

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

  1. How to Build FileMaker Web Apps for High Traffic using MySQL Backend and 360Works MirrorSync Why Sync FileMaker and MySQL? FileMaker is the best tool for rapid application development, but it is not the most reliable or scalable option for high traffic web sites. MySQL provides that reliability and scalability, but can't compare to FileMaker for development productivity and user friendliness. 360Works MirrorSync bridges this gap, letting you use each tool for its best purpose. Quickly create layouts, scripts, and schema in FileMaker Pro, test and refine them, then use MirrorSync to publish all your record data to MySQL and keep both databases in sync moving forward. You can use industry-standard tools and frameworks (or hire from a vast talent pool) to create highly reliable and scalable web apps. In the event that FileMaker Server is down or rebooted for any reason (such as software upgrades), your MySQL web app will continue running and serving users. MirrorSync will detect when FileMaker Server comes back online and bring both databases back in sync. Video Demonstration This video, narrated by Junior Perez of 360Works, takes you on a step-by-step walk-through of how to sync between FileMaker Server and MySQL. Junior demonstrates how to start with a completely empty MySQL Server, create the database and tables, and set up an auto-scheduled sync to run every 60 seconds. The process is the same for any other JDBC-compatible database such as SQL Server, Oracle, or PostgreSQL. The license price for syncing one FileMaker Server with any one of these databases is $1,800, with discounts available for educational and non-profit organizations. If you would like to involve 360Works in configuring your sync, or in creating a web application backed by MySQL, please contact us for consulting and development assistance. Read More on MirrorSync or Download Now! 360Works MirrorSync Stay updated with 360Works
  2. New MirrorSync Update Now Available 50 Improvements Made in MirrorSync 6.1 360Works releases new point update for MirrorSync with 50 improvements and fixes to optimize FileMaker synchronization. 360Works MirrorSync is the fastest and easiest synchronization tool for FileMaker. It allows everyday FileMaker users the power to synchronize their FileMaker Server files with FileMaker Pro, FileMaker Go, other FileMaker Servers, SQL databases, Salesforce, WordPress, Amazon Web Services Databases (DynamoDB and Redshift). MirrorSync was awarded FileMaker Solution of the Year in previous years and the product continues to be known for its scalability, reliability, speed, and ease of use. The latest update, MirrorSync 6.1, ships with 50 improvements and fixes. Here are some of the newest improvements by category: Container Fields and Large Data Improvements Optimized conflict resolution field merging; now about 100x faster for large tables! Now supports streaming for container uploads, so that you can sync any size container data (such as large video files) without running out of memory in MirrorSync Improved performance when syncing large numbers of fields (>500) Now truncates extremely long container filenames (converting a text field to container fields causes the text contents to also be used as the container filename, which can be too long to be practical) Performance improvements for configuration client Important fix: removed a deadlock that could occur when inserting large number of records that contained unusually large text data as well as container data Syncing with Non-FileMaker Databases Improvements No need to do any time zone conversions when writing time and date values to Salesforce, you can now send them unmodified Improvements were made to SQL generation for syncing to a non-FileMaker SQL spoke database, such as MySQL or SQL Server Performance improvements for DynamoDB; prevented unnecessary update operations if fields are added or removed from a configuration FileMaker Server to FileMaker Server Sync Improvements Improvements for externally stored container fields that have an .fmp12 file in them when transferring from hub to spoke during server-to-server syncs Much faster transfer of large multi-file solutions between servers for initial server-to-server syncs Configuration Improvements Improved responsiveness on the configuration screen where tables, scripts, and layouts are copied and pasted Added extra information at the top of the sync status that always shows the name of the configuration and a description of both the hub and spoke databases Exporting a configuration from server A and importing to server B will now automatically change the configured MirrorSync URL to server B Smarter switching between using the internal and external IP addresses on the sync. This should make it so that syncing from outside the LAN is about 5 seconds faster, if there is a separate internal and external address configured. We now keep a history of all configuration changes, in case any issues arise Improvements for Keys If you're using UUID primary keys with unique validation enabled, and if you change validation to 'always' (this is not set by default), then MirrorSync will automatically re-write inserts as updates to avoid duplicate records, or error messages about duplicates. Improvements to detection for foreign keys, as well as skipping over any foreign keys referencing tables or columns that are not part of the sync. Improved validation for foreign key configuration Fixed a problem when using custom text primary keys of varying lengths (not UUIDs or serial numbers, which work fine without this fix). If the column that a foreign key is based on is excluded from the sync, the foreign key is now removed from the configuration and skipped Improved Error Reporting Improved error reporting to users if the sync fails due to a permission error or timeout [Worker script] Many improvements to automatically handle and retry network problems; better logging to identify problems caused by slow networks [Worker script] When the offline file has external data sources pointing to non-existent files, MirrorSync responds with better error reporting. More Improvements Additionally, we have added support for configurations and synchronization with FileMaker Cloud 2 (Please note: due to the limitations of FileMaker Cloud 2, it is not ideal for synchronization. Contact support@360works.com for additional details if you plan to use FileMaker Cloud 2). Visit the MirrorSync changelog for the complete list of all 50 improvements and fixes available in 6.1! Why MirrorSync? MirrorSync allows users to work on their own offline copy of a database on their iPad, iPhone, or laptop computer, even when they have slow or no connection to the internet when working from home or out in the field. It can also be used for server-to-server syncing between servers in different locations and with other distributed server models (i.e., clustering, load balancing). MirrorSync documentation for further information is available at the 360Works Documentation Wiki. MirrorSync Hosting and Consulting We offer both FileMaker Hosting and MirrorSync Hosting. If you host FileMaker with us, you get MirrorSync hosting free! *Purchase of MirrorSync licensing is required. MirrorSync is completely free to sync FileMaker Server with FileMaker Pro or FileMaker Go with one device. Any additional configurations or seats are purchased as needed. Users running regular FileMaker Server on a Mac or Windows computer can install MirrorSync 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. Simply contact us to get started! Purchasing and Upgrading Existing MirrorSync 6 users can now upgrade to MirrorSync 6.1 at no additional cost. For users new to MirrorSync or past users with expired maintenance (maintenance expires one year after purchase date if not renewed), now is a great time to purchase a new MirrorSync license. If you need to check your maintenance on your MirrorSync license, visit the 360Works License Portal page. If you need to renew your maintenance or buy a new license, visit the MirrorSync product page. As always, MirrorSync is completely free to sync FileMaker Server with FileMaker Pro or FileMaker Go with one device. Free 14-day MirrorSync server-to-server configuration trials are available upon request. Please contact us to request your free trial today. -- Get New Licensing, Upgrade, or Learn More: MirrorSync Product Page Existing MirrorSync 6/Active Maintenance Users: Download the 6.1 Update Now More questions? Email support@360works.com
  3. FileMaker DevCon Playlist and Products from 360Works to Help You Work Better Tune into Popular FileMaker DevCon Sessions from 360Works With more time at home, now is a great time to catch up on past recordings. Did you miss any of the FileMaker DevCon sessions from 360Works? We put together a playlist of our most popular sessions from the past two years so you can learn about FileMaker tools for sync and Amazon Web Services (AWS) tips all in one place. Watch the Videos About the featured products... 360Works MirrorSync MirrorSync is an elegant synchronization product that can sync between any combination of FileMaker Pro, FileMaker Go, FileMaker Server, SQL database (MySQL, Oracle, SQL Server, or any database that supports JDBC), Salesforce, WordPress and Amazon RedShift and DynamoDB. For mobile devices, users can sync the hosted file with their FMGo or Pro clients, go off network to make changes, and sync again when a connection is available. For FileMaker Servers, MirrorSync allows a database to run in multiple locations, or to integrate different databases and make sure that changes to each server are reflected in the other server. MirrorSync 6 introduced tremendous improvements for FileMaker Developers such as automatic file transfers between servers, automatic version updates between servers, safer synchronization process, better handling of large files, and easier migration. 360Works Zulu Zulu is an application that keeps your calendar events in sync with FileMaker records. It is able to sync with Apple Calendar, Google Calendar, and Exchange Outlook Calendar. You can manipulate the events in your calendar, and Zulu will write these changes to FileMaker records. The opposite is also true, updates to FileMaker records will be written to your calendar's events. Zulu 4 introduced improvements specifically for business workflows such as new support for Apple Reminders within FileMaker, one-click URL calendar subscriptions and improved publishing page for user-friendliness, better event handling, and improved filtering. You May Also be Interested in: 360Works Scribe While there was not a session for Scribe, we thought it was worth mentioning because of the overwhelming positive response we received for Scribe 4, which introduced OCR to easily scan documents in FileMaker and merge or splice PDF files in container fields. Scribe has always been able to automate processing of Microsoft Office and PDF files. It continues to allow you to populate forms, insert images, highlight changes between versions of documents, manipulate Microsoft Word and Excel tables, retrieve metadata from Excel table cells, and secure PDF files. Interested in more than one of the tools mentioned? Get the 360Works Portfolio Bundle Deal For less than the cost of 3 of our most popular plug-ins, you can get the entire 360Works product portfolio, all upgrades and most new releases for a year, and a single license key that works for all covered products. See exactly what is included in the Portfolio Bundle Deal. 360Works Product List: Product Name Product Description Portfolio Bundle All of our FileMaker Plug-ins for one discounted price Charts Easy-to-use charting for FileMaker CloudMail Send and track email marketing campaigns Email Send and receive emails, plus send SMS/Text Messages from FileMaker 360Deploy Automated, simple deployment of new database versions 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, WordPress, Salesforce, or AWS 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, plus OCR functionality and PDF Merge/Splice in Scribe 4! 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 - integrate with Google Calendar, Apple Calendar, and Exchange Calendar You can get a free fully-functional demo, learn more, or buy the product that meets your needs at any of the links above. If you need AWS consulting, custom FileMaker Plug-ins, or have any questions. Please email us at infobox@360works.com Watch the Videos Stay updated with 360Works Sincerely, 360Works plugins@360Works.com
  4. Case Study: FileMaker Clinical Data Capture Software Uses 360Works MirrorSync Learn how MirrorSync is being used in the ConnEDCt app built with FileMaker for medical research and healthcare improvements across the world “We have used MirrorSync from versions 3 to 6 for FileMaker Pro/Go to FileMaker Server. In our experience it is the most reliable technology for syncing FileMaker databases over inconsistent and slow connections.” 
- Caleb Ruth, Data Performance LLC At 360Works, we believe in making FileMaker plug-ins and tools with outside-of-the-box thinking to help FileMaker Developers build what works best by extending the functionality of their FileMaker solution to solve real-world problems. FileMaker Developer and Business Owner, Caleb Ruth, was generous enough to spend time sharing with us some of the aspects of his work with health information systems which leverage 360Works MirrorSync. Read the Full Story Stay updated with 360Works
  5. Fireside FileMaker Podcast: 'Keeping it in Sync' featuring Jesse Barnum on MirrorSync and more! We have the perfect FileMaker podcast for your listening pleasure as you ease back into the office and start the new year! Fireside FileMaker is a podcast collaboration between John Mark Osborne and Michael Rocharde discussing FileMaker related topics in a friendly and informative space. Today, we wanted to share the 'Keeping it in Sync' episode of the podcast with you, featuring Jesse Barnum, President of 360Works, for a conversation on MirrorSync, plugins, FileMaker Cloud, Claris Connect and other interesting FileMaker subjects! LISTEN HERE *Learn more about the NEW MirrorSync 6 and download here *Follow Fireside FileMaker on iTunes or Podbean Stay updated with 360Works
  6. 360Works Case Study: Sightlines Group Integrates FileMaker and Salesforce using MirrorSync About Sightlines Group - Improving Organizational Systems and Processes Sightlines Group, founded by Chris Barber, works with foundations, community-based organizations, and global technology and banking firms by helping them develop custom software, and by designing and delivering leadership development programs. Sightlines Group works with technical teams or with entire organizations who need to build better relationships with their constituents, track outcomes, research their impact, and tell their story. Furthermore, they provide leadership development and coaching work, including the design and delivery of hundreds of courses to clients including HSBC Bank, Hitachi Vantara, and The Cities for Financial Empowerment Fund. FileMaker - The Flexible CRM Early on, Chris and his team developed some opinions about the role of customer relationship management (CRM) software, especially for foundations and nonprofits. “Often CRMs box people in and get in the way of adaptation,” says Chris Barber. Sightlines Group works most often with the FileMaker and Salesforce platforms to experience greater flexibility and scalability. FileMaker allows high flexibility, rapid prototyping, and rapid development. Salesforce allows out-of-the-box integration and enterprise scalability. The Use Case - Syncing Data Between FileMaker and Salesforce The CFE Fund (The Cities for Financial Empowerment Fund: cfefund.org) is a national foundation that helps cities integrate financial empowerment into local government services. Their organization chose the Salesforce platform for its Case Management system which supports Financial Counselors located in cities across the country. First, however, the CFE Fund needed to transform and migrate several years worth of data from a legacy system into Salesforce. Sightlines Group used FileMaker’s rapid development tools to extract data from the legacy system and transform it into Salesforce’s data model. Rather than using traditional migration tools, they reached out to 360Works to see if MirrorSync could allow them to “sync” the data into Salesforce rather than performing a tricky one-time migration. This would allow the migration to happen over time, since data could be migrated to Salesforce, then inspected, and then further transformed from FileMaker, and then synced again to Salesforce. The Solution - Using MirrorSync for FileMaker and Salesforce Integration Upon first using MirrorSync, Chris and his team at Sightlines Group were pleased to find that they could trust MirrorSync to work reliably under the hood. “MirrorSync worked very well in the background, it has a lot of logic built in. Anyone who has worked with sync, knows that is usually not the case,” recalled Chris. The Sightlines Group team was able to be an important contributor to the use of this Salesforce configuration in MirrorSync for other FileMaker developers by providing helpful experiences they had while working. Chris shared that he was grateful for ongoing efforts from the 360Works team in always taking feedback and turning it around for improvements. MirrorSync Provides Seamless Integration MirrorSync was able to significantly improve the speed and efficiency in their workflow while accessing data between FileMaker and Salesforce. “Now, we can do this in a snap. We’ll work in FileMaker and watch it sync, using MirrorSync, to Salesforce a moment later. MirrorSync has made a big impact on our work. It's allowed us to merge the best that Salesforce has to offer with the best that FileMaker has to offer," shares Chris. He is very pleased with their new tight integration between FileMaker and Salesforce, he enjoys being able to hook in a variety of web services and have the choice of having them hook to FileMaker or hook to Salesforce. Sightlines Group has configured their custom application for The CFE Fund to report back to FileMaker so they can take various actions based on the results in Salesforce, automatically. For example, they now have logic built in for posting to a Slack channel if there is any unexpected behavior within their application. It made their lives so much easier to receive clear information about what's happening back in FileMaker, without it feeling like a bulky add-on. MirrorSync Manages Keys The feature they enjoy the most is the way MirrorSync manages keys. “It automatically inserts, edits, and deletes child or parent records depending on your architecture. Salesforce keeps its own primary keys, so MirrorSync will take a new record in FileMaker, create a new record in Salesforce, get the Salesforce Id, and write that back to FileMaker, all automatically. If it did not work this way with managed keys, Salesforce would error out as Salesforce has strict key requirements,” reports Chris. Final Result: A Complete, Synchronized Custom Application MirrorSync is known amongst FileMaker developers to be an automated, customizable, and a fast-working tool. You can set it to sync just certain tables, fields, and records as needed - creating the most customizable synchronization solution. It even does bi-directional synchronization. It's a set-it-and-forget-it solution, and it's very fast. We can enter our data in FileMaker and 30 seconds later it propagates to Salesforce,” says Chris. Chris and his team at Sightlines Group are experts in innovation. They work with millions of records in a single solution for The CFE Fund. The technology they choose must be robust enough to handle financial data at a large scale, at all times. Using MirrorSync allowed them to continue building the best possible, most reliable technology solutions for their clientele. “MirrorSync was a lifesaver! We have been using it for about a year now syncing a few million records and 10 tables. It is nearly bulletproof, Chris reports. ”It allows us to get our hands into the data in ways you normally cannot when working with nonprofits. With MirrorSync being bulletproof, we don't have to worry about the syncing, we can step back and treat the application as one: Salesforce and FileMaker.” --- Contact 360Works for questions or a free 14-day trial of MirrorSync's FileMaker and Salesforce (SQL database) configuration at plugins@360works.com Visit the MirrorSync product page!
  7. 360Works Portfolio Bundle: Build a complete solution in FileMaker at a fraction of the cost. Save Money The 360Works Portfolio Bundle offers the best FileMaker plug-in deal around. You receive all of the 360Works plug-ins and tools for FileMaker at 75% off the cost of the entire product suite from 360Works, saving you a great deal of money in the long run. Save Time Additionally, it saves you time by providing one, single license key to register all plug-ins and add-ons in your FileMaker solution. You even save time with updates! The Portfolio Bundle is on our Maintenance model for licensing, this means that your purchase includes 12 months of maintenance, which gives you all new products and upgrades released up to a year after your Portfolio Bundle purchase. At the end of 12 months, you may choose to renew your maintenance subscription for each additional year, for a cost of $695 (or auto-renew at $625.50). The Portfolio Bundle includes over 18 FileMaker products, some of which are exclusive to Portfolio Bundle license holders only. Here is a friendly reminder about all that it has to offer: Download products and learn more today at 360works.com/portfolio. 360Works Support Our 360Works Support Team is dedicated to your successful use of 360Works plug-ins and add-ons. If you run into issues we offer 2 free hours of technical support Monday - Friday from 10:00 a.m. - 6:00 p.m. (ET). Most questions can be answered at our documentation/help page and requests for support team assistance can be sent to support@360works.com Stay updated with 360Works
  8. 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:
  9. Hi All, Just saw on the FM website for the FM17, it doesn't support client version 14. If I want to setup a Server - Server Sync solution, Is it possible to do that between FM server 14 and FM server 17?? thanks
  10. 360Works at DevCon 2018: Discount Extended! We had a great time at the 2018 FileMaker Developer Conference in Grapevine, Texas. Nothing gets the 360Works team more excited than demonstrating our products and meeting other FileMaker Developers! We are pleased to announce that we will be extending our DevCon discount until Friday, August 17, 2018. Enter code DEVCON18 at checkout and receive 15% off of your purchase! Use the product table below to learn more about your favorite products and take advantage of the discount. At DevCon this year, Joe Martin demonstrated the brand new 360Deploy 2 for completely automating deployment of development changes to a production server and Jesse Barnum demonstrated a new version of MirrorSync, version 5, which has more convenience for end users and over 40 improvements to reliability, speed, and stability. At our booth, the MirrorSync Setup Station allowed many DevCon attendees to return home with a fully functional sync setup and Richard Carlton Consulting gave out free FileMaker 17 training books at our booth this year! Click on any of our product links below to learn more or use the discount: 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 Stay updated with 360Works
  11. 360Works Products Tested for FileMaker 17 FileMaker 17 is here, and we are excited for the update. At 360Works, we strive to provide the best possible service and support to our customers and to always keep our products compatible and flexible. Testing our plug-ins with FileMaker 17 has been completed with each current version available on our online store. We are happy to report that we do not need to release any new versions of our plug-ins listed below, as the current versions you already have will continue to work. Other products we offer have also been tested, and will work with FileMaker 17. Last year, we released a major update to our plug-in framework. If you haven't caught up with our big framework change, be sure to check out this article. Easy Installation Install plug-ins with ease 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. Compatibility with the FileMaker Platform 360Works products are compatible with the following deployment options: FileMaker Pro Advanced FileMaker Cloud FileMaker Server: scheduled scripts FileMaker Server: Perform Script on Server from FileMaker Client FileMaker Server: Perform Script on Server with WebDirect, Data API, and XML Web Publishing We are delighted with the continued development and innovation of the FileMaker platform and in the FileMaker community. We are proud to be a partner and trusted resource in the FileMaker ecosystem. "We use 360Works plug-ins with our clients without hesitation. They're easy to implement, and work dependably, and KEEP working dependably. Their excellent support is just the icing on the cake." —Scott Love, Soliant Consulting Current Products and Versions Product Name Product Description 360Deploy 1.01 Automated, simple deployment of new database versions Charts 2.08 Easy-to-use charting for FileMaker CloudMail 3.08 Send and track email marketing campaigns Email 3.08 Send and receive text and HTML emails in FileMaker FTPeek 2.08 FTP upload and download from your FileMaker database JDBC 2.08 SQL access with JDBC Compatibility MirrorSync 4.0 Sync FileMaker Go and Pro on a device without network connection, sync FileMaker Servers, and sync FileMaker with SQL databases Plastic 3.08 Payment processing plug-in RemoteScripter 2.08 Trigger scripts on FileMaker Pro from the web or IWP SafetyNet 2.01 FileMaker Server offsite backup Scribe 3.08 Read and write PDF, Word, and Excel files ScriptMaster 5.09 Adds many new functions & create custom plug-ins SuperContainer 2.9511 A better container field Web Assistant 2.08 Access internet resources, URLs, and fill out web forms Web Services Manager 1.7 Publish FileMaker scripts as XML Web Services Zulu 2.1 FileMaker calendar sync If you find a couple of these products to be helpful, you may want to look into the 360Works Portfolio Bundle, where you can obtain the entire suite of plug-ins and add-ons with a savings of 75% off of the full price! Stay updated with 360Works
  12. I think there was some instructions somewhere, but I cannot find them . I have a created local file and server file. Both contain the exact same data. I want to deploy this solution, but I want to avoid a massive first-time sync. How can I avoid a massive first-time sync?
  13. 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
  14. When using MirrorSync, backend development doesn't stop and it can be tedious to get the word out to inform all users that a new version of your solution is available to download. Here is a technique to do just so: Step 1: Create a table in your solution VERSION this table will have the minimum fields of a UID | version | URL | Time Stamp Create | Time Stamp Modify Step 2: Add this layout to your existing mirror sync layouts sync_version and put all fields on the layout as required by MS, and configure the table to sync hub to spoke ignoring changes in spoke and hub always wins conflicts. Step 3: Add a record to this table and start the version number at 1 and copy and paste the download link url provided by the MS config tool. Step 4: Make a cartesian join between this table your your main interface table where your users naturally perform the sync operation. Step 5: Add a Script: Version ( Check | Update ) the two parameters will either check the version and inform you of a new update, and a way to copy and download the URL. Step 6: On your main layout add a button that will hide when the variable $$version_update ≠ 1 (and also you can test to see if your not on the live version by testing of host name) Step 7: Button passes the "update" parameter to the script that simply copies the URL from off the side of the layout and presents a dialog box to the user to close the file and paste the URL into Safari where it will download the file and replace the original. How it works is fairly simple. When you have a new build ready, you go to the version table (single record table) and increment the version number, then open the script and update the version number there. When the user performs a sync they will be given the newest value from the version table - then you can run this "check" portion of the script to compare the value against local value from their script version which would be out of sync. The end result will light up a button informing them that a new build is ready to download.
  15. So I am new to EasySync, and trying to get the best from it. I am using it more to replicate a subset of a live database for external clients to access, but they will not be changing anything, so my only requirement is to pull data to my 'Mobile' dataset from my 'Hosted' dataset. At the moment the live database is approx. 120k records, but this grows daily between 100 and 300 records for the main customer view, and possible 3 times that for associated activity. I seem to have a serious speed issue, in that trying to sync the mobile version just locks everything up, trying to do an initial sync. I can manually pull the data over at the end of a day, then mark all of these as EX_Exclude 1 and import them manually into my new portal Set a OnCommit on the maincustomer view, so any changes will make the ES_Exclude to 0, thus marking these for sync Question 1: How do I set these back to 1 once the sync is done? Question 2: Is there a way to Schedule the sync to happen every 15 minutes so it has lessto sysnc, meaning less traffic? Question 3: If I cannot schedule it, how do I prevent the 2 database's from appearing to lock, preventing users from working on either side, or slowing everything down? Any help with this would be very appreciated as I am totally stumped at the moment.
  16. Hi, in which order are the tables synced when MirrorSync starts? Is this done in the order how they occur in the "sync" Layout folder? We are syncing quite a few tables and use filters in the customization script to reduce the amount of records to be synced. We want to start syncing the relevant projects, then only the relevant phases of these projects and then only the relevant tasks of these phases ... That is why we need to synchronize in this order ... project-phase-task If we start the customization script (MirrorSync Customization) from the different sync Layouts in the "right" order of the tables all filters work fine. My question from the beginning is one of my first steps to look for my mistake :-) Kind regards from Germany Carsten
  17. I have already posted here: https://community.filemaker.com/thread/170677 and have some thoughts in mind, but I will copy what I put in there, here. Avoid FMGo Connection Interrupted Server Timeout Disconnect In the attached links, it goes back to questions that I had that dealt with a file on an iOs device, making sure it stays live and up to date. So what I have done is worked on a local file that syncs to the one on the server. That seemingly works, however there is a problem that just recently came up when I was testing. When the local file tries to reach the file on the server, it doesn't always connect. In talking with others there is two consensus of what might be the cause: The Wireless access point is blocking access File security permissions are not working (File Access tab in Security) "Reset All" temporarily works (on the server file) Deauthorizing and Authorizing sometimes works (on the server file) Turning off the File Access requirement doesn't seem to help (on the server file) I do have File Access on the local file, but I haven't tried turning that off. Since I can't debug exactly what is going on, on the iPad this makes it harder. (I have put in some custom dialogs to see some things.) The local file with the syncing to the server file works on my desktop, but that is a wired connection. (I could try the same wireless connection.) It could be that I'm making a duplicate of the local file and putting that on the iPad, which makes the file not work. (I put on the duplicate file on the iPad newly each time for testing, because I need a file without certain info on it, which will be filled later [dealing with Get(PersistentID)].) Is there something I'm not thinking of? To my knowledge, it had been working until recently. I'll try a few more things, but hopefully get answers in the meantime. Thank you
  18. We have recently released versions 3.14 - 3.16 of MirrorSync with improvements for recovery mode, high-volume syncs, and rebuilding sync data. Overall, the reliability of MirrorSync has greatly improved, and the speed of SQL and server-to-server syncs have increased significantly! Immediately after the release of 3.14 and 3.15, we were able to identify and fix a few quirks resulting in an even more reliable version with 3.16. In 3.16, we even added a few additional features including the ability to pre-populate databases for server-to-server syncs with non-FileMaker databases, faster initial syncs, and new support for re-importing a new configuration over an existing one, which is very useful in a vertical market solution deployment. This is a free update for current users. For those new to MirrorSync, the server license is free and ships with one free configuration of FileMaker Pro or FileMaker Go syncing with FileMaker Server and one free device allowance. All additional configurations and devices are available for purchase. MirrorSync can sync between any combination of FileMaker Pro, FileMaker Go, FileMaker Server, SQL database (MySQL, Oracle, SQL Server, or any database that supports JDBC), Salesforce, and Amazon RedShift. To download the current version, please visit the MirrorSync product page For a complete list of changes, please visit our MirrorSync changelog
  19. We have recently released versions 3.14 - 3.16 of MirrorSync with improvements for recovery mode, high-volume syncs, and rebuilding sync data. Overall, the reliability of MirrorSync has greatly improved, and the speed of SQL and server-to-server syncs have increased significantly! Immediately after the release of 3.14 and 3.15, we were able to identify and fix a few quirks resulting in an even more reliable version with 3.16. In 3.16, we even added a few additional features including the ability to pre-populate databases for server-to-server syncs with non-FileMaker databases, faster initial syncs, and new support for re-importing a new configuration over an existing one, which is very useful in a vertical market solution deployment. This is a free update for current users. For those new to MirrorSync, the server license is free and ships with one free configuration of FileMaker Pro or FileMaker Go syncing with FileMaker Server and one free device allowance. All additional configurations and devices are available for purchase. MirrorSync can sync between any combination of FileMaker Pro, FileMaker Go, FileMaker Server, SQL database (MySQL, Oracle, SQL Server, or any database that supports JDBC), Salesforce, and Amazon RedShift. To download the current version, please visit the MirrorSync product page For a complete list of changes, please visit our MirrorSync changelog
  20. What is the best practice for retrieving the last sync timestamp? I want GO users to be aware of how much time has elapsed since their last sync as a reminder to sync often. I know the timestamp lives on the MirrorSync table, but I would have to make a new occurrence of the MirrorSync table and relate it to all the tables that have layouts that contain the timestamp which seems awkward. If I can get a timestamp of the last sync in a global field, I can run it through a custom function that outputs the time ago in words (e.g. 3 hours ago, or 5 minutes ago, etc.), and put it on my interfaces.
  21. Hello there, I'm just investigating on 2 issue I have on sync 2 DB, 1 on the server and 1 on the iPad that are set to use a Spoke Db in the middle tier. Basically the sync is set to copy ALL the data from some tables on the server to the local db and send some data from the local db to the end server db. For some reason, on a large table, called Articles, with more than 130k records, the sync does not copy all the record for some users. There is no 'filter' based on user on the end db, and I run a pre-populate sync on the spoke db that copied all 130k records. When the sync is run for that specific user, the final result on the iPad is that the sync DELETES 12k records for no apparent reason. In addition, there is a Global table that has always 1 records and is get from the server to the client. But I found some times that there are several records on that table (more than 10) on the server, even if the sync is set to write on the spoke and not viceversa for that table. I have the suspect that are written from the sync. Is it possible? Thanks in advance, Gianluca
  22. After upgrading to MirrorSync 3 from 2, I can no longer sync container fields. During the reconfiguration process, I get the tooltip in the uploaded image below. The tooltip says "Neither field is writable. This could be because they are calculation or summary fields. It could also be caused by field-level validation or custom access privileges.". These container fields are not calc or summary fields. There is no field level validation or custom access privileges that I know if. They are full access, and the fields have not changed since my last MirrorSync 2 configuration. Please help!
  23. Hello, We are running FileMaker Server 14 with a database for creating job tickets and managing production in a commercial printing company. We would like to have remote sales staff have the ability to enter new job tickets and review existing job tickets but only be able to see jobs for their clients. We also have several very large clients that have asked for the ability to enter their own jobs into the database themselves in order to ease our sales staff's workload transcribing data from received emails. However, the customer must not be able to see jobs from our other customers. Is it possible to setup a one way sync for data collection from the sales staff and our customers remote machines AND sync back to their machines only the records that match certain critieria? This would be: 1. SALES STAFF - Jobs where the salesperson has been assigned to the customers master record or the job tickets record. 2. CUSTOMERS - Jobs where the company name on the job ticket matches their company name. Both would be using either filemaker pro desktop or filemaker go. Jerry Bernard DSJ Printing, Inc.
  24. Hey fellow syncers, stepping back from any method, I was wondering if there's an issue that all sync solutions have. The issue is this: Client A pushes a payload, and it's processed and ready for ClientB to receive...all nice and transactional. However, ClientB gathers records to pull a table at a time. Couldn't ClientB gather Orders - ClientA's processing completes - and ClientB gathers Order Line Items (thus, missing the parent record of some of those Order Lines since ClientB has already pulled Orders for his payload?). We're seeing this and wondering if it's a design flaw in EasySync or indicative of any sync solution that allow multiple users to sync at a time.
  25. Hi guys! First post please go easy on me if I ask silly questions haha! So I'm developing a FM Go app for one of my friends, now he sells things at roadshows, conventions so on and so forth. My question is, if for example, he has no Wifi/3G. How does he go about "syncing" or "uploading" the new data he has collected offline, to the database on the network in the office? Sorry if it seems unclear, I'm relatively new to this sort of thing. Thanks in advance, Sean.
Ă—
Ă—
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.