Export Data
Last updated
Last updated
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:
Name
The name of the node. The name is automatically set and cannot be changed.
Format
There are five options:
– CSV
– Excel (*.xlsx)
– this is for the most recent Excel versions
– Excel 97-2003 (*.xls)
– this is for the older Excel versions
– Json
– XML
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 XML
or Json
exports.
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 XML
or Json
).
Delimiter
There are four delimiters you can use:
– Comma
– Colon
– Semicolon
– Tab
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.
Encoding
You can choose between 6 different character encodings:
– ASCII
– Windows-1252
– Latin 1
– ISO 8859-1
– UTF-8
– UTF-16 LE
– UTF-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.
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 Json
or XML
instead of importing data into your WEM application.