Mapping definition XML tags

Each <row-match> consists of multiple field matches that match individual fields by name or index number within the row. If the <field-match> elements match a given row, the <output-field> elements describe the output records that are created, including the field structure.

Field matches are based on constant values in the matchvalue attribute in the XML. All values are strings. Multiple field matches are logically ANDed together. If no <field-match> elements exist for a <row-match>, the row match uses any row.

<output-row> elements are also optional. If a <row-match> with no <output-row> elements matches a row, no output is generated. Output rows may either specify a constant value as the output, or they may use the copyvalue attribute to copy column data from the input row.

These XML tags are used in the application mapping framework:

Note: The Payroll Export Interface uses specific XML tags.
<mapping>
Definition
Defines the mapping definition.
Attributes
None
Inner Tags
<row-match> (required)
<row-match>
Definition
Defines the mapping for each row (record).
Attributes
None
Inner Tags
<field-match> (optional)

A <row-match> element without a <field-match> element matches all rows.

<output-row> (required)

No errors are produced when this tag is not present, but no data is outputted for the row.

<field-match>
Definition
Matches (or filters) a row based on a field.
Attributes
Fieldname: The field name or column to match (which is dependent on the interface implementation).

For Employee Import factor string fields, this is the index of the field value. For example, if a field value contains HOURLY_FULLTIME~A, then fieldname=1 for HOURLY_FULLTIME and fieldname=2 for A.

matchvalue: The value to match the field. For example:
<field-match fieldname="1" matchvalue="HOURLY_PARTTIME"/>

This means that if the first field is HOURLY_PARTIME, a match is found (that is, keeps the entry for output).

Inner Tags
None
<output-row>
Definition
Defines the data to be for the output row.
Attributes
None
Inner Tags
<output-field> (required)
<output-field>
Definition
Defines how the field is outputted.
Attributes
Name: The field name or column to output as specified by the interface implementation. For example, if the Employee Export Interface has fields from A - CG, then fieldname="A" is for the first exported field, fieldname="B" is the second exported field, and so on until all fieldnames are used.
copyfield: Specify the name of the field for which the field’s value is copied directly to output.
value: Specify the output value for this field name
Inner Tags
None