4 Replies Latest reply on Dec 7, 2016 2:43 PM by wimdecorte

    Can FMP15 trigger a script on an FMP11 file?

    StephenWonfor

      Hi

       

      Client has just migrated from FMP11 to FMP15.  They access and use ESS data to populate their website.  This was done using PyFilemaker. (GitHub - aeguana/PyFileMaker: PyFileMaker - Integrating FileMaker and Python)  We note that that site makes a lot of ref's to Filemaker 6 etc.  The plan is to remove this ESS to Filemaker linkage and write directly to ESS from Filemaker.  But there are reams of PHP code that refer to and get data from the FMP11 db we are trying to retire.

      In the meantime, we a looking for a QAD° patch of some sort.

      The current best option is to use Send Event to open an FMP11 database on one user machine.  This db has a script that runs on open that would open the FMP11 hosted file and have it import the data we need to update.

      Any better options that we have missed?

       

      Stephen

       

      "Simplicity is hard to build, easy to use, and hard to charge for.  Complexity is easy to build, hard to use, and easy to charge for." — Chris Sacca

        • 1. Re: Can FMP15 trigger a script on an FMP11 file?
          planteg

          Hi Stephen,

           

          I made a test running a Python program on a Raspberry Pi trying to create records in an FM15 database located on an FMS15 server as a proof of concept. I was wondering if that would work since PyFileMaker seems to be quite old asn you noticed. But that worked ! The only thing is that it's not compatible with Python 3 (I get a syntax error with a print statement not using ()).

           

          Looks like the XML interface has not changed for a long time. So my guess is that you may still use PyFileMaker for some time.

           

          HTH

          • 2. Re: Can FMP15 trigger a script on an FMP11 file?
            gdurniak

            I think there was a way to run a script at another IP,  with a URL,  using Instant Web Publishing

             

            greg

             

            > Any better options that we have missed ?

            • 3. Re: Can FMP15 trigger a script on an FMP11 file?
              StephenWonfor

              Greg

               

              It is working at "kludge level 4" - FMP15 exports csv files then opens the FMP11 file that autoruns a routine that hits the server 11 hosted file and calls a script that imports the csv files.  A method that is fraught with peril and imminent failure but - it works until we replace it with something more solid.

               

              Stephen

               

              ---

               

              “Socialism never took root in America because the poor see themselves not as an exploited proletariat but as temporarily embarrassed millionaires.” - John Steinbeck

              • 4. Re: Can FMP15 trigger a script on an FMP11 file?
                wimdecorte

                gdurniak wrote:

                 

                I think there was a way to run a script at another IP, with a URL, using Instant Web Publishing

                 

                greg

                 

                > Any better options that we have missed ?

                 

                If the file is hosted on FMS11 then you can use the XML API to construct a URL and fire a script.  The script has to be web compatible.