Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Billboard Group Employee.

<table-config>
    <table name="OSB_GROUP_EMPLOYEE" transaction-type="INSERT_UPDATE" key-fields="OSBG_ID,EMP_ID,OSBGE_START_DATE,OSBGE_END_DATE" primary-key="OSBGE_ID">
        <fields>
            <field index="1" db-field="OSBG_ID">
                <reference table-name="OSB_GROUP" supplied-value="OSBG_ID" resolve-to-field="OSBG_ID"/>
            </field>
            <field index="2" db-field="EMP_ID">
                <reference table-name="EMPLOYEE" supplied-value="EMP_ID" resolve-to-field="EMP_ID"/>
            </field>
            <field index="3" db-field="OSBGE_START_DATE" date-format="yyyy-MM-dd HH:mm:ss" default-value="!SYSTEM_DATE"/>
            <field index="4" db-field="OSBGE_END_DATE" date-format="yyyy-MM-dd HH:mm:ss" default-value="30000101"/>
            <field index="5" db-field="OSBGE_FLAG1"/>
            <field index="6" db-field="OSBGE_FLAG2"/>
            <field index="7" db-field="OSBGE_FLAG3"/>
            <field index="8" db-field="OSBGE_FLAG4"/>
            <field index="9" db-field="OSBGE_FLAG5"/>
            <field index="10" db-field="OSBGE_UDF1"/>
            <field index="11" db-field="OSBGE_UDF2"/>
            <field index="12" db-field="OSBGE_UDF3"/>
            <field index="13" db-field="OSBGE_UDF4"/>
            <field index="14" db-field="OSBGE_UDF5"/>
        </fields>
    </table>
</table-config>

Sample CSV files

1001,5516,2022-10-20 00:00:00,2022-10-30 00:00:00
1001,5515,2022-10-20 00:00:00,2022-10-30 00:00:00,Y,N,Y,N,Y,UDF1,UDF2,UDF3,UDF4,UDF5