Follow-On Topics

Related Topics

# About the Main Tab

The Main tab of the Convert Recordset to XML dialog box is used to select one or more recordsets, up to a maximum of 5, and configure how these recordsets are related as well as specifying which fields are to be included in the XML output. The tab contains the following:
|  | Input Recordsets — The area at the top of the tab provides a list of the Steps previously created in the Task that expose a King Task Centre recordset. You can select the recordsets that are to be combined into an XML document by clicking on the checkbox to the left of the Step name.
|  | Links — This tab contains the following:
|  | Recordset — For each Step selected in the Input Recordsets list above, a representation of that recordsets' columns appear in this area. Where more than one recordset has been selected, the links between those recordsets may be defined. To do this, simply drag a column name from one table in the Link tab to a column name in another table. This creates a link.
| Click the image to view full size.

|  | Remove Links — Clicking on this button removes any links set up between the tables.

|  | Auto Generate Output XML — If this option is selected, then the Tool automatically constructs an XML structure using all the columns in the selected recordsets, using the linked field information to determine the hierarchy of objects within the structure. This is displayed in the Output tab and provides a quick and easy way of creating a hierarchical data structure from the selected recordsets by simply defining the key field relationships.

Click the image to view full size.

|  | Custom XML — If it is required to create a customised XML structure then the Auto Generate Output XML checkbox should be cleared. In this case, the structure shown in the Output tab starts with only a root node. Right clicking on a node provides the option to create a child node.

This can be repeated to construct the "skeleton" of the XML structure required. To add columns from the input recordsets, drag the columns in from the Task Browser dialog box. You set the Scope to Task to display the required input Steps. For each level created in the XML structure, a key field must be set. Right click on a column name after it has been dragged in from the Task Browser dialog box and select Set As Key. To clear the key field designation on a column, right click and select Clear as Key.

For more information about how the link and key field settings affect the XML that is exposed by the tool, see Runtime Processing.

|  | Output — This tab displays the XML structure to be used for the Step output. This is automatically generated if the Auto Generate Output XML option has been selected in the Links tab.

## Configuring Output XML

Once the recordset(s) have been selected, the format of the XML to be output by the Step may be configured. Where more than one recordset has been selected, the links between those recordsets may be defined. You can do this simply by dragging a column name from one table in the Links tab to a column name in another table. This creates a link. You can use the Remove Links button to remove all links if required.

Right clicking on an individual link displays a menu with two options:

- Reverse Link — This option reverses the direction of the link between the fields.
- Remove Link — This option removes the link from the configuration.

Copyright © 2018 Quadrant Software B.V. All rights reserved.