8 Replies Latest reply on Jun 24, 2014 5:17 AM by danims

    Server script import records question FMS 12

    danims

      Hi everyone,

       

      I'm running into a problem where a script would run fine when executed on a client but fails when scheduled on the server.

      No script step show as incompatible in the script editor.

       

      The error is 100 : file missing and it occurs when trying to perform an "Import Records" script step.

       

      What I'm trying to do is check a table against another within the same database and update/create records in the second using a selected numbers of fields from the found set in the first.

       

      After reading from different threads, it seems that Filemaker won't recognise the specified File if it is the same for both tables (the current DB file the script is running from).

       

      First of all, is this the problem here and am I right in my assumption? If so, is there a reason for this restriction?

       

      I'm going to try and perform the same action exporting my records from the first table to a file (.tab) first and then importing that file to the second table.

       

      Is this the best/recommended course of action to achieve what I am trying to do?

       

      Thanks a lot for your help,

       

      Best regards,

       

      Nils