Export Data

The data export node is used to export data. When this node is dragged onto the workflow, you will automatically get a popup window where you have to select a list or list filter as the source from which you want to export the data. Next you edit the properties, so you can control the data export. The following properties are available:
The name of the node. The name is automatically set and cannot be changed.
There are five options: – CSVExcel (*.xlsx) – this is for the most recent Excel versions – Excel 97-2003 (*.xls) – this is for the older Excel versions – JsonXML
Select how you want to export the data
Source list
Specify the list that is the source for the data export. This does not apply to XMLor Jsonexports.
Filter by
If you need to filter the data that wil be exported, you can add an expression that defines that filter.
Target field
Here you select the field where you want to store the exported data. This field has to be of the type File or Text (in case of XMLor Json).
There are four delimiters you can use: – CommaColonSemicolonTab
This property is only available (and needed) when the format of the export is CSV. This property defines which delimiter should be used to separate the data.
You can choose between 6 different character encodings: – ASCIIWindows-1252Latin 1ISO 8859-1UTF-8UTF-16 LEUTF-16 BE
This property is only available (and needed) when the format of the export is CSV. The property makes it possible to select the character encoding you want to use for the data export
Include BOM
Sort by
When you click on this button you get to the Sorting popup where you can add expressions that make it possible to sort the exported data.
Edit Columns
The Edit Columns button takes you to the Data Export Maps editor.
This node has two exits:
  • Error– this exit is used when the export produces an error;
  • Default exit – this exit is used when the data export does not produce any errors.

Edit mapping

When you want to export to Json or XML, you need to specify a mapping to map the exported data to either Json or XML. This works the same as specifying the mappong for data import (see above for a description of how to create a mapping). The only difference is that the mapping will now be used to export data from your WEM application to Jsonor XML instead of importing data into your WEM application.