5 Replies Latest reply on Apr 5, 2012 9:35 AM by Oliver_Reid

    I can't understand this

    Oliver_Reid

      I have table (T1) and a script does table to table import into T1 from T2.The TO for T2 is a remotely hosted table.

       

      Everything works fine running on Mac.

       

      Other scripts that funtion similarly on FM Go work fine

       

      This one works until the ipmort seto. The correct rrcords are the fs in T2.

       

      The import step runs but the import does not happen on the Ipad, (but does happen a mac.)

       

      Moreover I end up in the T1 layout with no records displayed and the screen seems to be frozen : all the commands on the records/find menu are greyed out so I can't even show all records or enter find mode. Using the latetest versions of everything on an Ipad3. Doesn't work on an Ipad2 either.

       

      But works on Mac so it's not a settings or scripting error.

        • 1. Re: I can't understand this
          Stephen Huston

          Assuming everything in the script is correct to run this import, based on it working on Mac, how much data is to be imported for each record?

           

          Importing over a WAN connection can appear to grind to a halt due to network speeds. I've seen record creation with a WAN connection take over 60 seconds per record, depending on the field count and data in fields.

           

          Also, does the iPad client have import permissions for the table in the FM file's permission group?

          • 2. Re: I can't understand this
            Malcolm

            The import step runs but the import does not happen on the Ipad, (but does happen a mac.)

             

            This is from the Go documentation:

            Importing records is supported in a scripted process when using the Import Records script step to import from another FileMaker file. Using the Import Records script step, you can:

            •     Import records from a hosted file (FileMaker Server or shared using peer to peer sharing with FileMaker Pro and FileMaker Pro Advanced) into a local database. Although FileMaker Go cannot import directly from an ODBC source, it can import from an ODBC source through ESS.

            •     Import records stored in a local database into a hosted file

            •     Import records from a hosted file into another hosted file

            •     Import records from a local database into another local database

            •     Import records between tables in the same file (local or hosted)

             

            Does that help?

             

            malcolm

            • 3. Re: I can't understand this
              Oliver_Reid

              Its importing a couple of records. All permissions are fine.

              • 4. Re: I can't understand this
                Oliver_Reid

                No, but thanks.

                 

                I am doing this

                 

                "Import records between tables in the same file (local or hosted),"

                 

                One table is native, the source table refences a hosted table. This works well in other scripts and is supported by FM.

                • 5. Re: I can't understand this
                  Oliver_Reid

                  I removed and reconfigure the "Import" steps in the script.  No changes in they way they were specified, but now they work in IOS as well as OS X.