Records to Excel section

This refers to the Tririga to Excel section in the Tririga Object Map on the offline form. This section defines field mapping from IBM® TRIRIGA® form fields to the offline form. The following describes the tags used for mapping from records to an Excel spreadsheet:
Tririga to Excel
This tag is the root of the record to Excel spreadsheet mapping and encloses all other tags in the map.
Properties:
None
End tag:
End
Selector

The Selector tag finds existing records associated to the parent so that their data can be copied to the Excel spreadsheet.

Optionally, the Selector can specify a filter that compares a field value in the records to a value in the map. It also can filter by record type.

Sub-tags of this tag are applied to the records found.
Properties:
  • Association Name - The name on the parent side of the association.
  • Field Name - The name of the field in the child record to use in the comparison.
Optional Properties:
  • Module Name - If this is specified, only records created by business objects in the named module are included. If present, the value must be in the fifth cell to the right of the Selector tag.
  • Object Type Name - Only records created by the specified business object are included. If present, the value must be in the sixth cell to the right of the Selector tag.
  • Query Section Name - Specifies the query section from which to populate data. If present, the value must be in the seventh cell to the right of the Selector tag, or the next to last column of the Selector row. If specified, you must provide a Tab Name property. Query Section Name and Tab Name maintain the order of data in a query section. If specified, the populate retrieves from the query defined in the query section using the current record as the context record.
  • Tab Name - Specifies the name of the tab on the form that contains the query section identified in Query Section Name. If present, the value must be in the eighth cell to the right of the Selector tag, or the last column of the Selector row. Query Section Name and Tab Name maintain the order of data in a query section. If specified, the populate retrieves from the query defined in the query section using the current record as the context record.
End tag:
End Selector
Field

This tag defines how fields in records are mapped to cells in the Excel spreadsheet. This tag can appear anywhere in the mapping hierarchy. The field mapping is applied to the records that correspond to that level in the hierarchy.

If there is more than one current record because the previous Selector tag found multiple records, this tag will duplicate the row of the referenced cell for each record and map the field from each record into a cell in the copied row.

This action is coordinated with the sibling Field tags in the mapping. For example: Suppose the previous Selector tag found three records. Also suppose there are two Field tags below the Selector that reference cells in the same row of the document. The first Field tag maps field x to cell G4 and the second Field tag maps field y to cell H4.

The mapping engine will make two copies of row 4 (plus the original row makes three rows total) and insert them into the document as rows 5 and 6. It will then map fields x and y from the first record into cells G4 and H4, fields x and y from the second record into cells G5 and H5, and fields x and y from the third record into cells G6 and H6. Use this mechanism to create line items in the Excel spreadsheets from line items in records.
Properties:
  • Section Name - The name of the section that contains the field to be mapped. For smart section fields, specify the BO smart section name, for example, triParkingClause.
  • Field Name - The name of the field in the current record(s) from which data will be mapped.
  • Cell Reference 1 - A reference to the cell to which the data will be copied.
End tag:
None