Exporting Data to an XML File
The Export to Xml File task exports datasets or other Rulex structures to an Xml file.
Prerequisites
the required datasets have been imported into the process.
Additional tabs
The following additional tabs are provided:
Remote connections tab where you can configure the connection to the remote location where the file will be exported.
Documentation tab where you can document your task
Parametric options tab where you can configure process variables instead of fixed values. Parametric equivalents are expressed in italics in this page (PO).
File format where you can configure the exact format of the output file.
Procedure
Drag and drop the Export to Xml File task onto the stage.
Connect a task, which contains the data you want to export, to the new task.
Double click the Export to Xml File task.
Configure the task options as described in the table below in the Options and File format tabs.
Save and compute the task.
Export to Xml File options | ||
Parameter Name | PO | Description |
---|---|---|
Data to be exported | reflist | Select what type data you want to export from the list of options. Possible options are:
|
Mode | mode | Select how you want to save the file, either by storing it in a location you will then specify, by sending the file as an e-mail or both ways. If you select to send the file by e-mail, you must then specify the e-mail address in the Recipients for export via email edit box. |
Export URI | uri | Select whether the file will be saved locally (Local File System) or remotely (Http Remote API, SharePoint, HDFS, AWS S3, FTP, Azure Storage). From version 4.7 of Rulex, API responses from HTTP calls can be redirected to external sources, such as SharePoint and S3. The response path corresponds to the filename, with the complete path for local file systems, and the remote directory for external sources. Note: if you chose to save the file remotely you must also configure the Remote Connection parameters in the Remote Connections tab. |
Directory | dirname | Enter or browse to the directory where the file will be saved. If you are exporting to a Azure Storage repository you can either:
|
File basename | basename | Enter a name for the file that will be exported. |
Tag name that includes the dataset | dataname | The tag name that includes the dataset. |
Add current date and time as prefix | timestampprefix | If selected, the date and timestamp will be added to the start of the file basename as a prefix |
Add current date and time as suffix | timestampsuffix | If selected, the date and timestamp will be added to the end of the file basename as a suffix |
Recipients for export via email (use comma as separator) | recipients | Specify the email addresses where the exported file will be sent, separated by commas. This option will only be valid if you have selected Send via email or Both in the Mode option. |
File Format options | ||
File format | fileformat | Select the format in which you want to export the file: flat, nested or according to the group column. If you select the group option, you must have selected the Group Column option when importing the Json file, in order to create a column which identifies the group of each tag. If you did not select this option in import, Rulex will not be able to identify which group each tag belongs to, and consequently a single group will be created in export. |
Key for types | Specify the attribute which defines the data type. | |
Remove missing values | removemiss | If selected, missing records are removed from the exported file. |