Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Department Reader Group.

Sample XML mapping definition

<table-config>
    <table name="DEPARTMENT_RDR_GRP" transaction-type="INSERT_UPDATE" key-fields="DEPT_ID,RDRGRP_ID" primary-key="DEPTRDRGRP_ID">
        <fields>
            <field index="1" db-field="DEPT_ID">
                  <reference table-name="DEPARTMENT" supplied-value="DEPT_NAME" resolve-to-field="DEPT_ID"/>
            </field>
            <field index="2" db-field="RDRGRP_ID">
                  <reference table-name="READER_GROUP" supplied-value="RDRGRP_NAME" resolve-to-field="RDRGRP_ID"/>
            </field>
        </fields>
    </table>
</table-config>

Sample CSV file

DEPT A,WB8000_GROUP2
DEPT B,WB8000_GROUP2
DEPT C,WB8000_GROUP2
DEPT A,WBCS_GROUP2
DEPT B,WBCS_GROUP2
DEPT C,WBCS_GROUP2
TSSOCCER,WBCS_GROUP2
tshockey,pb_group1