Sample XML and CSV files

Sample XML mapping definition

<table-config>
    <table name="WB_CUSTOM_LOOKUP_DATA_TYPE" transaction-type="INSERT_UPDATE" key-fields="WBCLDT_NAME" primary-key="WBCLDT_ID">
        <fields>
            <field index="1" db-field="WBCLDT_NAME"/>
            <field index="2" db-field="WBCLDT_DESC"/>
            <field index="3" db-field="WBCLDT_FLAG1"/>
            <field index="4" db-field="WBCLDT_FLAG2"/>
            <field index="5" db-field="WBCLDT_FLAG3"/>
            <field index="6" db-field="WBCLDT_FLAG4"/>
            <field index="7" db-field="WBCLDT_FLAG5"/>
            <field index="8" db-field="WBCLDT_UDF1"/>
            <field index="9" db-field="WBCLDT_UDF2"/>
            <field index="10" db-field="WBCLDT_UDF3"/>
            <field index="11" db-field="WBCLDT_UDF4"/>
            <field index="12" db-field="WBCLDT_UDF5"/>
            <field index="13" db-field="WBCLDT_TEXT1NAME"/>
            <field index="14" db-field="WBCLDT_TEXT2NAME"/>
            <field index="15" db-field="WBCLDT_TEXT3NAME"/>
            <field index="16" db-field="WBCLDT_TEXT4NAME"/>
            <field index="17" db-field="WBCLDT_TEXT5NAME"/>
            <field index="18" db-field="WBCLDT_TEXT6NAME"/>
            <field index="19" db-field="WBCLDT_TEXT7NAME"/>
            <field index="20" db-field="WBCLDT_TEXT8NAME"/>
            <field index="21" db-field="WBCLDT_TEXT9NAME"/>
            <field index="22" db-field="WBCLDT_TEXT10NAME"/>
            <field index="23" db-field="WBCLDT_CHAR1NAME"/>
            <field index="24" db-field="WBCLDT_CHAR2NAME"/>
            <field index="25" db-field="WBCLDT_CHAR3NAME"/>
            <field index="26" db-field="WBCLDT_CHAR4NAME"/>
            <field index="27" db-field="WBCLDT_CHAR5NAME"/>
            <field index="28" db-field="WBCLDT_CHAR6NAME"/>
            <field index="29" db-field="WBCLDT_CHAR7NAME"/>
            <field index="30" db-field="WBCLDT_CHAR8NAME"/>
            <field index="31" db-field="WBCLDT_CHAR9NAME"/>
            <field index="32" db-field="WBCLDT_CHAR10NAME"/>
            <field index="33" db-field="WBCLDT_DATE1NAME"/>
            <field index="34" db-field="WBCLDT_DATE2NAME"/>
            <field index="35" db-field="WBCLDT_DATE3NAME"/>
            <field index="36" db-field="WBCLDT_DATE4NAME"/>
            <field index="37" db-field="WBCLDT_DATE5NAME"/>
            <field index="38" db-field="WBCLDT_DATE6NAME"/>
            <field index="39" db-field="WBCLDT_DATE7NAME"/>
            <field index="40" db-field="WBCLDT_DATE8NAME"/>
            <field index="41" db-field="WBCLDT_DATE9NAME"/>
            <field index="42" db-field="WBCLDT_DATE10NAME"/>
            <field index="43" db-field="WBCLDT_NUM1NAME"/>
            <field index="44" db-field="WBCLDT_NUM2NAME"/>
            <field index="45" db-field="WBCLDT_NUM3NAME"/>
            <field index="46" db-field="WBCLDT_NUM4NAME"/>
            <field index="47" db-field="WBCLDT_NUM5NAME"/>
            <field index="48" db-field="WBCLDT_NUM6NAME"/>
            <field index="49" db-field="WBCLDT_NUM7NAME"/>
            <field index="50" db-field="WBCLDT_NUM8NAME"/>
            <field index="51" db-field="WBCLDT_NUM9NAME"/>
            <field index="52" db-field="WBCLDT_NUM10NAME"/>
            <field index="53" db-field="WBCLDT_DEC1NAME"/>
            <field index="54" db-field="WBCLDT_DEC2NAME"/>
            <field index="55" db-field="WBCLDT_DEC3NAME"/>
            <field index="56" db-field="WBCLDT_DEC4NAME"/>
            <field index="57" db-field="WBCLDT_DEC5NAME"/>
            <field index="58" db-field="WBCLDT_DEC6NAME"/>
            <field index="59" db-field="WBCLDT_DEC7NAME"/>
            <field index="60" db-field="WBCLDT_DEC8NAME"/>
            <field index="61" db-field="WBCLDT_DEC9NAME"/>
            <field index="62" db-field="WBCLDT_DEC10NAME"/>
        </fields>
    </table>
</table-config>

Sample CSV file

TEST WB CUSTOM LOOKUP DATA TYPE,Test WB Custom Lookup Data Type Description,Y,Y,Y,Y,Y,UDF1,UDF2,UDF3,UDF4,UDF5,This is a sample text,THIS IS TO TEST UPPERCASE,Text3,Text4,Text5,Text6,Text7,Text8,Text9,Text10,Y,Y,Y,Y,Y,N,N,N,N,N,2022-12-01 00:00:00,2022-12-02 00:00:00,2022-12-03 00:00:00,2022-12-04 00:00:00,2022-12-05 00:00:00,2022-12-06 00:00:00,2022-12-07 00:00:00,2022-12-08 00:00:00,2022-12-09 00:00:00,2022-12-10 00:00:00,1,2,3,4,5,6,7,8,9,10,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,0.11

TEST FIELDS,Test Description,,N,Y,N,,UDF1,UDF2,,UDF4,UDF5