Import Data
Last updated
Last updated
The data import node is used to import data into a specified list. The data that is imported is either in CSV, Excel, JSON or XML format. To use this node, simply drag it onto you flowchart and choose the right file format, JSON, XML or CSV/ Excel. Next thing you have to do is change.
Property | Description |
---|---|
This node has two exits:
Error
- this exit is used when the import produces an error;
Default exit
- this exit is used when the data import does not produce any errors.
The Edit Mappings
screen is used to map fields from a source (like a CSV, Excel, Json or XML file) to fields that exist in WEM. Depending on the file format the mapping tool works differently.
Map CSV or Excel fields
The easiest way to create the mapping, is to hit the Create mapping from example
button on the right hand side of the toolbar.
You can now select the CSV or Excel file you want to import, so WEM can learn which columns exist. Once the file is selected, WEM will show a list of all columns from the source file. You can now specify per column to which target field in WEM the data should be mapped / imported. Simply double click on the target field column for the specific CSV/Excel column and WEM will bring up the popup so you can select the actual target field. If needed you can also specify whether this should be a mandatory field and what do do when WEM encounters an invalid value in the source file.
Map Json or XML
To map Json or XML to WEM data, hit the Create mapping from example
button on the right hand side of the toolbar to open the mapping tool.
When you do this the first time you will get an emtpy screen: no mapping is available. You can create your own mapping by add
ing your own entities and map these to WEM fields. But it is far easier to use some sample Json or XML and let the WEM modeler do a lot of the work for you. Click on the Create mapping from example
button in the toolbar en paste your sample Json on XML into this form. You can verify if you are using correct XML or Json and then click on Ok
to let the system create the basic mapping.
When you use Json, you get something that looks like this:
For every array
, object
, text field
, numeric field
and boolean
you can now specify:
Is this a mandatory component;
Do you want to skip an object if the data is invalid.
You can specify this by simply clicking on the component in the tree on the left hand side. You will then see the properties on the right hand side (see ths picture above).
Te map a component to a WEM field, simply select the Json field, and in the properties area on the right click on the button of the Map to
field. You will get a popup where you can select the WEM field to which you want the map the Json component.
Once you have done this for the entire Json message, you are done with the mapping: click on Save
and your mapping is ready to use.
If you want to import XML, you get something that looks like the screen below, after you have created the mapping from an example:
The actual mapping works very similar to the Json mapping described above. The main difference is that the various XML elements can have different properties, based on the value of other properties of the same element. But in essence it works like Json mapping: you can create the entire mapping manually, or you simple import an XML example of the XML you want to import, so you can let the system create the basic mapping. Next, you go over each element and specify:
The Name
(you usually don't change what the system created);
The Namespace
of the XML element. If you use namespaces, you can select them here or create a new namespace;
Is it a repeating element? If so, you will get another property:
You can now specify the Target collection
Specify whether the element contains:
a single value. In this case you can specify where you want to Map the content to
. You can select a field that is defined in WEM;
nested values (<catalog>
or <book>
in the example above). When this element contains nested values, you can't specify a mapping, because you should specify the mapping of the elements that are contained in this element.
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:
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.
Property
Options
Description
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.
Name
The name of the node. This cannot be changed .
Data source
When you click the button on the right hand side, you can select either a file or a text field from which the data has to be imported. This can be a field from another list, a field you access trough OData or through a Webservice.
Destination
Here you select the list into which the data has to be imported. When you click the list button, you can select the target list. This only applies to the CSV or Excel
format.
Edit Mappings
When you click the Edit Mappings
button, a new popup appears where you can define the mapping of the source to the target