XML Output
Description:
XML Output is a step in the Output Plugin for Process Studio Workflows. The XML Output step writes data rows from the source to one or more XML files.
Configurations:
| Field Name | Description |
|---|---|
| File Tab: | The file tab is where you set general properties for the XML output file format: |
| Step Name | Specify the unique step name for the workflow. |
| Filename | Specify the file name and location of the output text file Notes: - Do not add the file extension in this field if you want to optionally append the date and time, followed by the extension. - Refer to the Extension field below for more details. - If the Extension field is left blank, add the extension in this field. |
| Do not create file at start | Check Do not create file at start to avoid empty files when no rows are getting processed. |
| Pass output to servlet | Check Pass output to servlet this option to return the data via a web service instead writing into a file |
| Extension | Specify the extension to add a period and the extension to the end of the file name. Default value: xml |
| Include stepnr in filename? | Check Include stepnr in Filename? to append a copy number to the file name (for example, _0) when you run the step in several copies, such as launching several copies of a step simultaneously. |
| Include date in filename? | Check Include date in filename? to include the system date to the file name, for example__20041231 |
| Include time in filename? | Check Include time in filename? to include the system date in the file name, for example _235959 |
| Specify Date time format | Check Specify Date time format to select the format from the list. |
| Date time format | Select the date time format from the list. Note: Field is available if Specify Date time format is checked. |
| Show filename(s)… | Click Show filename(s)… to see the filename details. You can see filename with its extension and date-time in the selected format in the Output Files window. |
| Add filenames to result | Check Add filenames to result to add the output file to the result set and display the download link on AE, else uncheck. By default the option is unchecked. |
| Content Tab: | |
| Zipped | Check Zipped to stored XML file in a ZIP archive. |
| Encoding | Select the encoding to use. The step includes this encoding in the XML file header. |
| Namespace | Specify a default namespace URI for the root element. This adds an 'xmlns' attribute to the main element. |
| Parent XML element | Specify the name of the root element in the XML document. Default value: Rows |
| Row XML element | Specify the name of the row element to use in the XML document. Default value: Row |
| Split every ... rows | Specify the maximum number of rows of data to put in a single XML file before another is created Default value: 0 |
| Fields Tab: | |
| Fieldname | The name of the field. |
| Element name | Specify the name of the element in the XML file to use. Type: Type of the field can be either String, Date, or Number. |
| Content type | Select the content type form the list: - Element - Attribute |
| Type | Select type of the field. Format mask from which to convert; see Number formats for a complete description of format specifiers. |
| Format | Select the format of the selected field type from the list. |
| Length | Specify the length based on the selected field type: - Number - Total number of significant digits in the number - String - Total length of the string - Date - Length of printed output of the string, for example a value of 4 returns only the year. Note: The output string is padded to this length if it is specified. |
| Precision | Specify the precision based on the selected field type: - Number - Number of floating-point digits - String - unused - Date - unused |
| Currency | Symbol used to represent currencies such as $10,000.00 or E5.000,00 |
| Decimal | A decimal point can be a "." (10,000.00) or "," (5.000,00) |
| Group | A grouping can be a "," (10,000.00) or "." (5.000,00) |
| Null | If the value of the field is null, insert this string into the textfile |
| Get fields | Click to retrieve the list of fields from the input stream(s). |
| Minimal width | Alter the options in the fields tab in such a way that the resulting width of lines in the text file is minimal; for example, instead of save 0000001, "1" is written, and so on. String fields are not padded to their specified length. |