5 Replies Latest reply on Nov 22, 2016 1:17 PM by philmodjunk

    Importing records to multiple tables

    dsimonson

      I am creating a script for a "new version" file, so that it can import records the user has entered in the old version before opening up.  This is for an iPad only app, so no FM Server stuff allowed.

       

      This script is in the Startup Script process.  If the "is_update" flag on the file is set to 1 upon opening, it looks for the old version in the FM

      Go File Area.  If it finds it, it starts importing the various tables that might have user data in it. 

       

      Here's my problem: there are about 10 tables that need updating, and so I repeat the following:

       

      Go to layout

      Import records from ($$PathToOldVersion)

       

      Go to layout

      Import records from ($$PathToOldVersion)

      etc...

       

      This works, but requires that my user re-enter their credentials for each import script step - 10 times!  That ain't gonna cut it. 

       

      Is there any way to keep the old file open so I can do these multiple imports?  Could I add an ESS or something to the Manage Database that points to the old version, and then they would only have to open it once?

       

      TIA