XML structure

Use 'XML Structure. Open' (CMS006) to define the XML structure. This includes the element tree from the root element and how it branches out to the child elements. Modifying the XML structure affects the content in the XML file.

Standard XML structures are delivered for every printer file variant using naming standard M3_STD_0y-0x (y=variant, x=sequence no). XML structures starting with M3 are reserved for standard and cannot be created or deleted.

Format

The format determines the structure of the XML file, and limitations and rules when configuring the XML file.

Split XML file

Select the check box if the result from an output job should split into several smaller XML files. The split is done per document (for example, one XML file per invoice or per purchase order). Note that if using Interface 3-'IDM Output management' in (MNS216), the check box must be selected.

CSV File Control

This indicates how many CSV files will be created. Each CSV file can have a specific table name and sheet name. These field refers to the table name and sheet name of the Excel template where the CSV file data is inserted. An Excel template can be uploaded in IDM, and is selected for the output according to the priority list specified in Alternative 1 – Single CSV file, all active sections (status 30 or 80) in 'Output Service. Open' (MNS216).

Table name

This field is matched with a table name in the Excel template to locate where to insert the CSV data.

Sheet name

This field is matched with a sheet name in the Excel template to figure out where to insert the CSV data. 'Sheet name' becomes a required field after a table name is specified. For single CSV, the sheet name also becomes required if 'Column Format' is equal to 1 or 2 on 'XML Structure Section. Open Element' (CMS009/E).

Note: If both the table name and sheet name fields are blank, any template uploaded will be ignored since it will not have any matches for where to insert the CSV data. This will result in a simple Excel output without any formatting. This field is matched with a sheet name in the Excel template to locate where to insert the CSV data. Sheet name will become a mandatory field once a table name is specified.

Heading section

This field indicates the sections in 'XML Structure. Open Section' (CMS007) to be printed on the topmost row of the CSV file. The topmost row or rows will only contain the text element labels indicated in 'XML Structure Section. Open Element' (CMS009).
Note: Only sections with status 30 and 80 can be selected as a heading section.

Multiple headers

Select this check box to display the additional label on the row above the field labels. If cleared, the CSV output will not display the additional message in 'XML Structure Section. Open Element' (CMS009).

Multiple rows

Select this check box to split the section according to each row grouping element in 'XML Structure Section. Open Element' (CMS009). If cleared, the CSV output will not take the row grouping elements into account and the fields will be displayed in just one row.
Note: Multiple headers and rows feature is only applicable for reports.

Display UTC offset

Select this check box to display the UTC information in the XML structure. If cleared, UTC information is not available in the XML structure.Multiple headers and rows is a feature that is only applicable for reports.

Archive information

Panels F and G in (CMS006) contain information regarding document archive. The information is designed to match the information needed in IDM but can also be used for other archiving application. A media of type *ARCHIVE must be included in the output media selection for the archive information to be included in the XML file.

User-defined fields

Panel H in (CMS006) covers the hard-coded values, predefined, and user-defined constants that are specified which then can be used as parameters in the 'Subject' and 'Email Text' fields in 'Output Media Selection. Open' (MNS205) and 'Doc Media Control Object. Connect Media' (CRS949).

The values are extracted from the output XML file then stored in user-defined and predefined constants.

This table shows the available user-defined constants:

Constants Description
<UF01> User-def fld 1 value
<UF02> User-def fld 2 value
<UF03> User-def fld 3 value
<UF04> User-def fld 4 value
<UF05> User-def fld 5 value
<UF06> User-def fld 6 value
<UF07> User-def fld 7 value
<UF08> User-def fld 8 value
<UF09> User-def fld 9 value
<UF10> User-def fld 10 value
<UL01> User-def fld 1 label
<UL02> User-def fld 2 label
<UL03> User-def fld 3 label
<UL04> User-def fld 4 label
<UL05> User-def fld 5 label
<UL06> User-def fld 6 label
<UL07> User-def fld 7 label
<UL08> User-def fld 8 label
<UL09> User-def fld 9 label
<UL10> User-def fld 10 label
Related topics