Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Billboard Group Team.

<table-config>
  <table name="OSB_GROUP_TEAM" transaction-type="INSERT_UPDATE" key-fields="OSBG_ID,WBT_ID" primary-key="OSBGT_ID">
    <fields>
      <field index="1" db-field="OSBG_ID">
        <reference table-name="OSB_GROUP" supplied-value="OSBG_ID" resolve-to-field="OSBG_ID"/>
      </field>
      <field index="2" db-field="WBT_ID">
        <reference table-name="WORKBRAIN_TEAM" supplied-value="WBT_ID" resolve-to-field="WBT_ID"/>
      </field>
      <field index="3" db-field="OSBGT_APPLY_TO_SUBTEAMS"/>
      <field index="4" db-field="OSBGT_FLAG1"/>
      <field index="5" db-field="OSBGT_FLAG2"/>
      <field index="6" db-field="OSBGT_FLAG3"/>
      <field index="7" db-field="OSBGT_FLAG4"/>
      <field index="8" db-field="OSBGT_FLAG5"/>
      <field index="9" db-field="OSBGT_UDF1"/>
      <field index="10" db-field="OSBGT_UDF2"/>
      <field index="11" db-field="OSBGT_UDF3"/>
      <field index="12" db-field="OSBGT_UDF4"/>
      <field index="13" db-field="OSBGT_UDF5"/>
    </fields>
  </table>
</table-config>

Sample CSV files

1001,1,Y
1001,9,Y,,N,Y,N,,UDF1,UDF2,,UDF4,UDF5