Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Call Log.

<table-config>
    <table name="ES_CALL_LOG" transaction-type="INSERT" primary-key="CLOG_ID">
        <fields>
            <field index="1" db-field="SHIFTSUM_ID">
                <reference table-name="ES_SHIFT_SUMMARY" supplied-value="SHIFTSUM_ID" resolve-to-field="SHIFTSUM_ID"/>
            </field>
            <field index="2" db-field="EMP_ID">
                <reference table-name="EMPLOYEE" supplied-value="EMP_NAME" resolve-to-field="EMP_ID"/>
            </field>
            <field index="3" db-field="WBU_ID">
                <reference table-name="WORKBRAIN_USER" supplied-value="WBU_NAME" resolve-to-field="WBU_ID"/>
            </field>
            <field index="4" db-field="REASON_ID">
                <reference table-name="ES_REASON" supplied-value="REASON_NAME" resolve-to-field="REASON_ID"/>
            </field>
            <field index="5" db-field="CLOG_ACTION"/>
            <field index="6" db-field="CLOG_SHIFTDTL_START_TIME" date-format="yyyy-MM-dd HH:mm:ss"/>
            <field index="7" db-field="CLOG_SHIFTDTL_END_TIME" date-format="yyyy-MM-dd HH:mm:ss"/>
            <field index="8" db-field="CLOG_FLAG1"/>
            <field index="9" db-field="CLOG_FLAG2"/>
            <field index="10" db-field="CLOG_FLAG3"/>
            <field index="11" db-field="CLOG_FLAG4"/>
            <field index="12" db-field="CLOG_FLAG5"/>
            <field index="13" db-field="CLOG_UDF1"/>
            <field index="14" db-field="CLOG_UDF2"/>
            <field index="15" db-field="CLOG_UDF3"/>
            <field index="16" db-field="CLOG_UDF4"/>
            <field index="17" db-field="CLOG_UDF5"/>
        </fields>
    </table>
</table-config>

-100001,1512,LUCTALL,2 Availability,TEST,2022-12-27 07:00:00,2022-12-27 17:00:00