We’ve created an export scenario using a GI as the source. We need to add a trailer record to the end to sum up the number of payments and the total payment amount. Does anyone know how to do this?
Solved
Text/CSV Export: Add Trailer Record
Best answer by KrunalDoshi
Hi
I do not think there is any OOB solution to include the footer line in GI or export scenario. Maybe you can create a custom Data Provider to add that trailing record and use that to export.
Hey there,
I will be intrigued if others have an option for this.
Here is another post on community that confirms my suspicion, the export can’t include the sum of records as an additional “trailing” record
How to include the Aggregate Field like Sum in GI Export to Excel? | Community
As a workaround for the time being however, perhaps try exporting to excel, then have excel do the summation of records, then convert excel to CSV when saving.
It’s not an all in one workaround, but it would get the job done in the meantime while waiting for others to confirm if possible to have an export sum those records itself.
I was able to map everything out in the export scenario to the file except the trailing record. I can’t figure out how to map in a final line (if at all possible).
+7Hi
I do not think there is any OOB solution to include the footer line in GI or export scenario. Maybe you can create a custom Data Provider to add that trailing record and use that to export.
+1We also just had a request for the exact same thing and the only solution we could come up with was to create a SQL view that adds the trailer record. In our case they wanted the last row of the CSV to include the word ‘END’ and the total count of all the rows. We then used the sql view as the source of the data for the GI that feeds the export scenario. Below is an example of what the export scenario looks like and the resulting CSV file:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.