Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Hours of Operation Day.

<table-config>
    <table name="HRSOP_DAY" transaction-type="INSERT_UPDATE" key-fields="HRSOP_ID,HRSOPD_DAY" primary-key="HRSOPD_ID">
        <fields>
            <field index="1" db-field="HRSOP_ID">
                <reference table-name="HOURS_OF_OPERATION" supplied-value="HRSOP_ID" resolve-to-field="HRSOP_ID"/>
            </field>
            <field index="2" db-field="HRSOPD_DAY"/>
            <field index="3" db-field="HRSOPD_OPEN_TIME" date-format="yyyy-MM-dd HH:mm:ss"/>
            <field index="4" db-field="HRSOPD_CLOSE_TIME" date-format="yyyy-MM-dd HH:mm:ss"/>
        </fields>
    </table>
</table-config>

20001,1,2022-08-25 09:00:00,2022-08-25 17:00:00
20001,2,2022-08-25 09:00:00,2022-08-25 17:00:00
20001,3,2022-08-25 09:00:00,2022-08-25 17:00:00
20001,4,2022-08-25 09:00:00,2022-08-25 17:00:00
20001,5,2022-08-25 09:00:00,2022-08-25 17:00:00
20001,6,2022-08-25 09:00:00,2022-08-25 17:00:00
20001,7,2022-08-25 09:00:00,2022-08-25 17:00:00