Submit your feature requests for Therefore™!
Basically in the workflow where you export a document, we need the option to export the CSV not just XML files.
This feature has been shipped with Therefore Online v.22 and will be available for on-premise customers with Therefore 2020.
Wonderful! Thanks for knowledge sharing! Any feedback from the field for Josh?
For those that need the ability to export to CSV as part of existing or ongoing projects I had written the attached script a while a go to allow exporting of CSV files from a Therefore Workflow.
If the destination CSV file already exists the file will be appended and column headers will not be re-added. It is possible to use this function with a table by putting the CreateMultiLineCSV function within a For Loop looping through the items in the table.
To use the attached script first make sure that Scripting Safe Mode is turned off. To do this go to the Advanced Settings in the Therefore Solution Designer and change the following setting: Advanced > Security > Scripting Safe Mode = False.
All text in the attachment should be copied into the "Script" section of an "Update Index" task in Therefore 2015+ and the "Call CreateMultiLineCSV" be modified to suit your needs.
I'm sure there's a more elegant way of achieving this but this seems to work for us.
Subroutine: CreateMultiLineCSVParameters: filePath: The full file path of the destination CSV file, i.e. C:\MyCSV.csv. columns: Array of all of the column heading values or Array() for no column headings. values: Array of arrays containing all of the line column values, must be in the same order as columns.
qualifier: Text that should be used around the values and column headings. delimiter: Text that should be used to separate the columns and values.
Any feedback is much appreciated!
Josh, IT@Spectrum Ltd
You won't be notified about changes to this idea.