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