1 Reply Latest reply on May 6, 2014 2:09 PM by philmodjunk

    Merge database files from local offline DB to identical master online (hosted) DB

    jamesengwell

      Title

      Merge database files from local offline DB to identical master online (hosted) DB

      Post

           We have a DB hosted for us online. We have an identical DB on location. There is no internet connection on location, so we want to create records offline, then add them to the online DB so we have a master collection of records. I would have thought that this was a typical use case, but can't find a simple way to do it. If I import records I have to match up all the fields and its really complex, having to match each table at a time. Our plan is to upload new records to the master DB everyday for six weeks during the project! Any help is very much appreciated.
            
           Thanks
            
           James

        • 1. Re: Merge database files from local offline DB to identical master online (hosted) DB
          philmodjunk

               If the only thing that you need to do is add new records, this is relatively simple to do. But if you have records in the master database that need to be updated because values have been changed in the on location copy things get a bit more complex.

               And if one user might update a record in one fashion in the master copy at the same time that another user might update the same record in a different way in the "on location" copy, things can get very complex.

               If you just need to add new records or if you do not allow records to be edited in the master copy, only the single "on location" copy, then Import Records in a Script, is the best way to go. And matching up fields in the field mapping dialog should not be a major problem as long as you maintain identical names in the source and target tables of each import. That allows you to make a single selection: "Matching Names" from the arrange by drop down and all fields in the source table match to the target table by field name.

               For more on "synching" FileMaker database files, see: http://www.filemaker.com/solutions/ios/docs/fmi_guide_sync_en.pdf

               And you may want to evaluate a 3rd party tool specifically designed to facilitate synching two or more copies of a database. Both SeedCode and 360Works offer such products so you can google those two companies and see what they have to offer.