XML sections

Use 'XML Structure. Open Section' (CMS007) to define the XML sections.

The XML structure is divided into logical parts which take the form of XML sections. There are predefined XML sections for each printer file and variant, which are automatically created when a new XML structure is created. Predefined XML sections cannot be deleted. This is applicable for these formats:
  • 1-M3 Standard Document
  • 2-M3 Standard Report

However, in Format 3-Open, you can create a section directly in (CMS007) through the Section type field. The newly created section is named as Grouping Section (GRP_SEC).

  • Status

    On 'XML Structure. Open Section' (CMS007/E), set the section status to active (meaning included in the printout) or inactive. These are the sections you can activate: XML and CSV.

    • A section with status 10 is not included in either the XML or CSV files.
    • A section with status 20 is included only in the XML file.
    • A section with status 30 is included only in the CSV file.
    • A section with status 80 is included both for XML and CSV files.
    Note: On 'XML Structure. Open Section' (CMS007/B), section type LINE_MAIN is by default set to status 80-'Active', indicating that they are included in XML or CSV file. All other sections have status 20-'Active for XML', indicating they are included in the XML output.

    You can have multiple section types that are active for both XML, CSV, Flat file or both formats. Use option 2='Change' to update the section status.

  • Table name

    The table name field only becomes visible once section status on 'XML Structure. Open Section' (CMS007/E) is updated to 30-'Active for CSV' or 80-'Active'. The value is matched with a table name in the Excel template to locate where to insert the CSV data.

  • Sheet name

    The sheet name field only becomes visible together with the table name once section status on 'XML Structure. Open Section' (CMS007/E) is updated to 30-'Active for CSV' or 80-'Active'. This field is matched with a sheet name in the Excel template to locate where to insert the CSV data.

  • Element name

    You can only change or delete Element name for financial report functionality.

  • Grp by element

    This field indicates the ID of the element which groups the XML Section. A blank value indicates that the section is not grouped. A grouped section indicates that all XML sections printed sequentially are grouped together by the 'Grp by element' field. It also indicates that all element labels are moved to the grouping section.

    Leave this field blank for financial report functionality.

  • Label

    Labels are included on 'XML Structure. Open' (CMS007/E).

    These ways are used to decide how you should set the label:
    • Alternative 1: No label is included.
    • Alternative 2: The standard M3 BE message ID is used from the table were the field originates. Translation is taken from Message file MVXCON.
    • Alternative 3: An overriding M3 BE message ID and message file can be specified. If no Message file is specified, MVXCON is used.
    • Alternative 4: An overriding text can be specified. The overriding text can be 1-15 characters long. Translation is specified using the language button.

      A check box 'Fallback to standard msg' is used when language set for the printer file is not specified by using the language button. Is the check box is activated, 'Standard message ID' is used as a label in the XML for a field, section, and variant. If the check box is not activated, the XML label of a field, section, or variant will have no label.

    • Alternative 5: Text for the label is taken from another field. Normally used if the label is set dynamically by the output function, for example, accounting dimension 1-7.
  • Attributes

    The F panel is used to display and define the attributes. A maximum of seven attributes per section can be defined.

    Attributes 1-3 depend on parameter 'Section attributes' and not editable.

    • Attribute 1: Holds the value for Label
    • Attribute 2: Holds the value for Type
    • Attribute 3: Holds the value for Subtype.
    Attributes 4-7 are considered as custom attributes wherein you can specify or modify a label. A custom attribute is added on the XML structure of the section labels.
    Note: Duplicate attribute name is not allowed.

    If new predefined sections are delivered, they can be added to existing structures using option 20='Update XML sections' in (CMS006).

  • Extend section

    The purpose of this extend section field is to switch on or off the extension point logic of the current section.

    When the field is selected, all field values are stored in a HashMap. Together with the other parameters such as printer file, batch job number, XML structure, variant, and section number, these are passed on to a batch program and made available in the XtendM3 script.

Related topics