AnsweredAssumed Answered

Copy/Paste Export script step with Grouping comes broken

Question asked by Fred(CH) on Feb 8, 2014
Latest reply on Jun 9, 2015 by 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

Outcomes