
Adapter XML - Processing of XML files
General tab
XML file nameHere you identify the XML file to be processed. The path specified can be relative or absolute. There is no support for wildcards such as *.xml here. If you want to process several XML files in a folder you need to use the Batch Module with the option “/ReadFileName *.xml”.
After you have selected an XML file on the READ side, an attempt will be made to read in the structure and the XML elements detected will be shown under the “Fields / Data types” tab. The following XML types are supported.
- Nodes
- Attributes
- CDATA
- Comments
By adjusting “XML Version / Encoding / Standalone” you can influence the XML Declaration.
Note: The “Standalone” attribute is only written to the XML file, DTD is no longer supported.
XML versions 1.0 and 1.1 are supported. With Encoding you determine the Codepage with which the XML file is to be interpreted or for which Codepage the XML file is to be written.
Options
Overwrite if file already exists: If you activate this option, any existing XML file will be deleted before processing and recreated.
Append data (insert): If this option is enabled, the pending data records are appended to the specified XML file.
Override data (update): If you activate this option, the system will attempt to update existing data records based on the defined key fields. The key fields can be selected on the “Fields/Data Types” tab.
Ignore existing data: If you activate this option, any existing data records in the XML file will be ignored. The key fields can be selected on the “Fields/Data Types” tab.
Skip empty fields: This prevents empty fields from being output to the XML file.
Write UTF-8 without BOM (byte order mark): Some applications have problems when a “byte order mark” (abbreviated BOM) is written for UTF-8. If you enable this option, writing the BOM is suppressed.
Fields / Data types tab
XML nodes and attributesNote: This tab is being adapted specially for the XML Adapter. The aim is to completely read in the XML file and by simple referencing to select which part of the XML structure should be processed. At present only the structure of the first available node is recognized and displayed for the associated record. However, by manually entry of XPath, other nodes in the XML file can be read in for processing.
For an XML export you can also specify XML subnodes. Mark the field in the field list and then click the “new” button.
Attribute tab
This tab is only available on the WRITE side. With this tab you specify details of the XML Namespace to use. Using the “Fields / Data types” tab you can allocate the individual fields of the XML Namespace defined here. All namespaces defined are written as XML output regardless of whether or not their fields are used.