AnsweredAssumed Answered

Import Records script step not updating matching records

Question asked by deactivated_0001 on Aug 27, 2009
Latest reply on Feb 2, 2010 by thomasseidler


Import Records script step not updating matching records

Description of the issue

FileMaker Product(s) involved:FileMaker Pro Advanced 10.0v3 Operating System(s) involved:Mac OS X 10.5.8This does not happen in v2.  Detailed description of the issue:In a scrip, when I try to use Import Records to update a matching record, the first time I press OK and then Import, the step turns to Add and not Update matching. Exact steps to reproduce the issue:1.  Create two tables related with a key field.2.  Create a script to update the second table using the key field as a matching field, using the Import Records script step.3.  Click OK and then Import.4.  You will notice that the script step appears like this:Import Records [No dialog; "filename"; Add; Mac Roman]5.  Again, click "Specify import order". The matching field signal has gone and the "Import Action" shows "Add new records" marked. Expected Result:Should be:Import Records [No dialog; "filename"; Update matching; Mac Roman] Actual Result:No matching records are updated. Exact text of any error message(s) that appeared:N/A Any additional configuration information/troubleshooting that is relevant to the issue:1.  Used to work fine before updating to version v3.2. Did not check to see whether it happens with FileMaker Pro 10. Workaround:Click "Specify import order" once more. In "Import Action" mark again "Update matching records in found set". In the field mapping, change again the signal of the two matching fields to show an equal sign. Then click OK and Import.