8 Replies Latest reply on Jun 9, 2015 5:01 AM by Fred(CH)

    Copy/Paste Export script step with Grouping comes broken

    Fred(CH)

      Summary

      Copy/Paste Export script step with Grouping comes broken

      Product

      FileMaker Pro

      Version

      11.0v2 ... 13.0v1

      Operating system version

      All

      Description of the issue

      I have two script steps :
      1. Sort Records with one field defined
      2. Exports Records grouped by the sort order above and export only two fields : the grouping field and one summary fields, only grouped instance choosen (see screenshot).

      And they works fine !

      But copying these two steps and pasting them on the same script or another one, and they come broken to destination.

      ==================================
      PREVIOUSLY REPORTED on October 19 2010 by mzarin :
      http://forums.filemaker.com/posts/9517134af9
      NOT Acknowledged
      ==================================

      Steps to reproduce the problem

      STEP 1
      ====
      Create a new simple file
      Define one table and three fields :
      GroupedField (Text)
      AmountField (Number)
      SummaryField (Summary, Sum of AmountField)

      STEP 2
      ====
      Create few records to have many occurrences of the same value on the GoupedField and each time a numeric value on AmountField.

      STEP 3
      ====
      Create a simple script that contain the two steps
      1. Sort Records
      2. Export Records (configured as i said on description above and as you can see on screenshot below)

      STEP 4
      ====
      Run your script and verify the file (i tested with a .tab one).
      You must have only a unique line for each different value of GroupedField.
      The result of SummaryField must reflect correct results.
      If all OK, go to step 5.

      STEP 5
      ====
      Copy the two script steps.
      Create a brand new script.
      On it, just paste the two steps of your original script.

      STEP 6
      ====
      Run your second script and verify the file (i tested with .tab one).

      Expected result

      As on the tab file of step 4, you should get only one line for each different value of GroupedField.
      The result of SummaryField must reflect correct results.

      Actual result

      The different records are well sorted BUT not grouped
      The SummaryField have no result (empty)

      Exact text of any error message(s) that appear

      None

      Configuration information

      None

      Workaround

      Go to your broken script.
      Select the broken Export Records step
      Open the "Specify Export Order…" dialog.
      Press [OK], without any change.
      Save your repaired script.

      Exportdialog-2.png