Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Job Set.

Sample XML mapping definition

<table-config>
    <table name="SO_POSN_SET_ELMTS" transaction-type="INSERT" primary-key="POSNSE_ID">
        <fields>
            <field index="1" db-field="JOB_ID">
                <reference table-name="JOB" supplied-value="JOB_NAME" resolve-to-field="JOB_ID"/>
            </field>
            <field index="2" db-field="JOB_ID_CHILD">
                <reference table-name="JOB" supplied-value="JOB_NAME" resolve-to-field="JOB_ID"/>
            </field>
        </fields>
    </table>
</table-config>

Sample CSV file

COMPUTER TECHNICIAN,INSPECTOR
CLERK,OPERATOR