Jump to content
Sign in to follow this  
GisMo

New Install - how to seed the server file so there is no initial sync?

Recommended Posts

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?

Share this post


Link to post
Share on other sites

Hey, I'm going from memory here, but to avoid an initial sync, before you deploy the local copy, set ES_Last_Push_UTC_Time, and ES_Last_Pull_UTC_Time to the current UTC using Get ( CurrentTimeUTCMilliseconds ). That will trick the local file into thinking it just synced and it will consider itself up to date (until a record changes on the server or locally).

I think there is also a "last full sync" field somewhere that you may want to set to the current timestamp. But that one should automatically update after your next sync. 

Share this post


Link to post
Share on other sites

Hey @Joshua Willing Halpern  

Thanks. That's correct. I ended up digging through the sync code and found that to be true. The record time stamps are compared to push and pull time stamps. I just changed LAST PUSH and LAST PULL To my current timestamp before deploying. 

Thanks!

Share this post


Link to post
Share on other sites

Hi,

I am working to implement Easy Sync into a solution that may have 300K records or so.  I am running a test with 225K records and cannot get the initial sync to complete - even when running it on the same LAN as the server (so the fastest possible connection). I tried the suggestions listed in this post to no avail.

There are 5 tables total.  4 of them have 15 records each and the 5th has the 225K records.  There are 10 fields max in each table.

Any suggestions? Am I at the limit of Easy Sync?

Share this post


Link to post
Share on other sites

If you set es last push and last pull time stamps correctly then it should jump over those two sections super quickly, So confirm that. 

 

Is is it getting stuck on the “sync check” part?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By 360Works
      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
                       
       
       
           
    • By 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 FM_Newbie
      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
       
       
    • By 360Works
      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
       
    • By davidsilverthornsoftware
      I'm seeing a "FileMaker Script Engine process has terminated abnormally" error when I attempt to register modules on Filemaker Cloud 1.17 using Scriptmaster 5.1 Unfortunately, the database stops responding when it encounters this error, forcing me to close the database. I noticed a similar issue on the forum related to Filemaker Server 17 that was fixed in 5.1. Could there still be an issue for Filemaker Cloud 1.17?
      EDIT: 5.09 works, as mentioned in my post below. I suggest that people use Scriptmaster 5.09 on Filemaker Cloud until this is fixed.
      EDIT 2: There is potential to corrupt data if we attempt to close the database when it is not responding after attempting to register a module with Scriptmaster 5.1. It takes a while before Filemaker will close the database, and it warned me of possible corruption when I re-opened it and attempted to register another module. In testing, I wasn't able to replicate the issue after I sent a disconnect request for the Client thread running the module registration step and turned off Script Engine plugins until I saw the thread had been disconnected. I was able to install 5.09 afterward and confirm that scriptmaster was working once installed.
  • Who Viewed the Topic

    9 members have viewed this topic:
    H  melmitts707  Steve Martino  Lee Smith  doughemi  dpwilton  fmsavey  BruceR  Spidey 
×
×
  • Create New...

Important Information

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