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 formats: 1-M3 Standard Document and 2-M3 Standard Report.

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

• Section status

  On 'XML Structure. Open Section' (CMS007/E), set the section status to active (meaning included in the printout) or inactive. Sections can be activated for XML, CSV or both.

  • 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), meaning it will be included in either the XML and CSV file. All other sections have status 20 (Active for XML), which means it will only be included in the XML output. LINE_MAIN is the only section type available for Open Format.

  You can have multiple section types that are active for both XML and CSV. 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

  Can only be changed or deleted for financial report functionality.

• Section attribute

  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 cannot be edited.

  • 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 toggle 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.

• 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 the label should be set:

  • 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.