2 Replies Latest reply on Feb 21, 2017 8:13 AM by jasonsanders42

    Relative Path for Import script steps breaking in FMP 15

    jasonsanders42

      Hello All,

       

      I have a script that does several imports from and to tables within the same file using the relative file path "file:FileName" in the Specify Data Source [File...] dialog. The script was written using FMPA 13, in a file built in FMPA12, and worked as expected through upgrading to FMP14. It's worth mentioning that the FMS deployment where the solution is hosted was upgraded to the corresponding versions at the same times as the clients. Additionally, the whole solution has been moved to a couple of different networks and been deployed on two different servers, all without affecting imports via relative path.

       

      With the upgrade to FMS/FMP 15, the import script step apparently cannot "find" the data source (itself) at the relative path. As a test, running FMPA 14 and 15 on the server machine, I can open the script step and view the same import dialog in FMPA 14 and see the source table and field mapping as expected. When opening the same step in FMPA 15, the source file (on the left side of the dialog) is totally missing.

       

      As a workaround, I can hard code the FileMaker Network path into the data source like this: "fmnet:/local.server.I.P/FileName" and that seems to allow the file to "see" itself, but it comes with a sh'load of undesirable implications.

       

      Furthermore, this problem seems to be intermittent (really, I just haven't nailed down the pattern yet). So far, it "seems" like once I edit any one of the Specify Data Source paths to use a hard coded address, other existing import script steps that HAVE NOT BEEN UPDATED and still use the relative path, seem to function correctly...until they don't.

       

      Anyone seen anything like this? Solutions? Ideas?

       

      Thanks,

       

      jasonsanders42

      www.extensitech.com

        • 1. Re: Relative Path for Import script steps breaking in FMP 15
          user19752

          Does the server have 2 or more IP addresses?

          • 2. Re: Relative Path for Import script steps breaking in FMP 15
            jasonsanders42

            Interesting question. Only has a single NIC at the moment, and so, one IPv4 address. I think this is a really interesting question, though, because I have a hunch that FMP/FMS may be using the IPv6 protocol as well as IPv4 to do that network "sniffing" thing it does to find available servers on the network.

             

            On another FMS 15 server, with FMP 15 v1, the Open dialog would automatically display three instances of the same server. I eventually worked out that there was one for each of the two NIC cards as well as an IPv6 connection.

             

            If that's happening in this scenario as well, it's plausible that a user who picks one of the servers listed in the Open dialog they could be getting into some weird connection state where the bad import behavior is occurring. Again, I haven't tried to verify this yet, mostly because of behavior like I mentioned in the original post where things don't work, then they work, then they don't work again.

             

            It certainly "feels" like there's something going on with this, but I haven't come up with a reliable way to test it. Anyone aware of a way to control those automated servers listed in the Open dialog?

             

            Thanks,

             

            Jason

            www.extensitech.com