2 Replies Latest reply on Apr 22, 2015 2:18 PM by siplus

    Problems merging data in FMP13

    vedder9

      I apologize in advance if this has already been answered and I just didn't see it when I searched for it. Also, I will mention that I, myself, am not a FileMaker user. I provide IT service and one of our clients is a heavy FMP user that has been experiencing these issues since updating to FMP13 (previously on FMP12).

       

      The client has two working files. One is a template used to send bids to their clients (often multiple bids per project) and once their clients have gone through and selected what they want from the various bids, individual data from those bids is imported into their main working file. For some reason after upgrading to FMP13, when they go to merge data from one of their numerous 'bid' files into their 'main' file, they often run into an issue where instead of FMP saying 'merging 1 of 1' it will pull from every single 'bid' file from the company's history. So if they aren't paying attention to the 'merging 1 or 1' field, it may say 'merging 1 of 12000' and will import everything from those ~12000 files.

       

      They are working off of FMP files on their server. Each person has their own machine on the same network that has access to these FMP files. It should be mentioned that this importing problem does not occur when working directly on the Mac Mini server. Everything seems to work just fine there. All three of their personal machines on the network experience the problem and it is random, so I know the problem is not machine or user specific.

       

      I'm sorry if I'm not describing the issue clearly. Not being a FMP user myself, I'm just kind of playing the 'man in the middle' in hopes that someone on these forums has seen such behavior and hopefully has a fix for it.

       

      Thanks in advance for any potential help.

        • 1. Re: Problems merging data in FMP13
          wimdecorte

          You will need to provide more detail.

           

          Is the solution hosted on FileMaker Server and everyone uses "Open Remote" to connect to the hosted file?

           

          Where is the data that is getting merged?  Is that imported from somewhere?

          • 2. Re: Problems merging data in FMP13
            siplus

            Hello vedder9,

             

            you did a lot of searching and into-FM-translation for not being a FM user, which is something that has to be corrected asap - the FM community needs homework-doing people like you and I can't start a reply without taking my hat off to that.

             

            Beyond the above, this "merging" or importing looks like working on the - as we FM users call it - "found set".

            One (1) record against 12000 records seems being a find which does take place and succeeds (when run on server), or does not, eventually failing by finding all the records (equivalent to not finding at all), on a client.

             

            It can be a global, it can be anything - we need a bit more info, as already posted by wimdecorte.