3 Replies Latest reply on Oct 31, 2012 11:27 PM by Malcolm

    Running scripts in a different FM Pro 11 file

    gobbles

      Hi all,

       

      I have an odd issue. I have a very very old filemaker pro database, call it "dbOld", that I am absolutely not allowed to change internally in any significant way. I beleive it was written years before FM Pro 7.

       

      I need to regulalry import data from an external source (excel spreadsheet to be exact). The data needs to be validated - and modified - so as to confirm to the rather archaic internal logic of dbOld. And also to allow for changes to the type of data thta is no collected. Again, I am not allowed to change dbOld so I have to process all incoming data so that it adheres to dbOld's conventions.

       

      What I have done is create a small new FM11 DB, I'll call it dbNew, which imports the excel data and then validates and processes it so it is suitable for dbOld. A current working solution is to then import this data from dbnew into dbOld.

       

      Since end users with limited IT skills will be doing the imports I really want to avoid as much human interaction with what is happening as possible.

       

      What I would like, is to run a scrpt from dbOld, that:

       

      a) opens dbNew

      b) imports the data from excel to dbNew

      c) imports the resulting processed data from dbNew to dbOld

      d) cleans up and deletes what was left behind and closes dbNew

       

      Fundamentally, I guess I am asking if it is possible to run a script in a different FM data base from inside of the current one.

       

      Is there a sensible way for me to do this from dbOld?

       

      both DBs are on Filemaker pro 11 and server 11.

       

      Thanks for any suggestions.

        • 1. Re: Running scripts in a different FM Pro 11 file
          Malcolm

          What I would like, is to run a scrpt from dbOld, that:

           

          a) opens dbNew

           

          b) imports the data from excel to dbNew

           

          c) imports the resulting processed data from dbNew to dbOld

           

          d) cleans up and deletes what was left behind and closes dbNew

           

          That process is fine, you'll need two scripts in dbNew, one for the import, one for the delete.

           

          you'll need one script in dbOld which has at least three steps

           

          call the import script in dbNew

          import from dbNew

          call the delete script in dbNew

           

           

          Malcolm

          • 2. Re: Running scripts in a different FM Pro 11 file
            gobbles

            Malcolm wrote:

             

             

             

            you'll need one script in dbOld which has at least three steps

             

            call the import script in dbNew

            import from dbNew

            call the delete script in dbNew

             

             

            Malcolm

             

            Excuse my ignorance, but how exactly do I call a script in a different db?

             

            Thanks for the help bw the way.

             

            gosh nvm, never really looked closely enough at the "perform script" dialogue ><

             

             

            thanks again

             

            -rafael

            • 3. Re: Running scripts in a different FM Pro 11 file
              Malcolm

              Excuse my ignorance, but how exactly do I call a script in a different db?

               

               

              use the Perform Script step. When the dialog box appears the very top pop-up menu allows you to select another file.

               

              Malcolm