Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Holiday Calendar Team.

<table-config>
    <table name="ES_HOLIDAY_CAL_TEAM" transaction-type="INSERT_UPDATE" key-fields="WBT_ID,HCAL_ID" primary-key="HCALWBT_ID">
    <fields>
        <field index="1" db-field="WBT_ID">
            <reference table-name="WORKBRAIN_TEAM" supplied-value="WBT_ID" resolve-to-field="WBT_ID"/>
        </field>
        <field index="2" db-field="HCAL_ID">
            <reference table-name="HOLIDAY_CALENDAR" supplied-value="HCAL_ID" resolve-to-field="HCAL_ID"/>
        </field>
        <field index="3" db-field="HCALWBT_FLAG1"/>
        <field index="4" db-field="HCALWBT_FLAG2"/>
        <field index="5" db-field="HCALWBT_FLAG3"/>
        <field index="6" db-field="HCALWBT_FLAG4"/>
        <field index="7" db-field="HCALWBT_FLAG5"/>
        <field index="8" db-field="HCALWBT_UDF1"/>
        <field index="9" db-field="HCALWBT_UDF2"/>
        <field index="10" db-field="HCALWBT_UDF3"/>
        <field index="11" db-field="HCALWBT_UDF4"/>
        <field index="12" db-field="HCALWBT_UDF5"/>
    </fields>
    </table>
</table-config>

Sample CSV files

1,30
1,29,Y,N,,N,,,UDF2,,UDF4,UDF5