Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Custom Lookup Data.

<table-config>
    <table name="WB_CUSTOM_LOOKUP_DATA" transaction-type="INSERT_UPDATE" key-fields="WBCLD_NAME" primary-key="WBCLD_ID">
        <fields>
            <field index="1" db-field="WBCLDT_ID">
                <reference table-name="WB_CUSTOM_LOOKUP_DATA_TYPE" supplied-value="WBCLDT_NAME" resolve-to-field="WBCLDT_ID"/>
            </field>
            <field index="2" db-field="WBCLD_NAME"/>
            <field index="3" db-field="WBCLD_DESC"/>
            <field index="4" db-field="WBCLD_TEXT1"/>
            <field index="5" db-field="WBCLD_TEXT2"/>
            <field index="6" db-field="WBCLD_TEXT3"/>
            <field index="7" db-field="WBCLD_TEXT4"/>
            <field index="8" db-field="WBCLD_TEXT5"/>
            <field index="9" db-field="WBCLD_TEXT6"/>
            <field index="10" db-field="WBCLD_TEXT7"/>
            <field index="11" db-field="WBCLD_TEXT8"/>
            <field index="12" db-field="WBCLD_TEXT9"/>
            <field index="13" db-field="WBCLD_TEXT10"/>
            <field index="14" db-field="WBCLD_CHAR1"/>
            <field index="15" db-field="WBCLD_CHAR2"/>
            <field index="16" db-field="WBCLD_CHAR3"/>
            <field index="17" db-field="WBCLD_CHAR4"/>
            <field index="18" db-field="WBCLD_CHAR5"/>
            <field index="19" db-field="WBCLD_CHAR6"/>
            <field index="20" db-field="WBCLD_CHAR7"/>
            <field index="21" db-field="WBCLD_CHAR8"/>
            <field index="22" db-field="WBCLD_CHAR9"/>
            <field index="23" db-field="WBCLD_CHAR10"/>
            <field index="24" db-field="WBCLD_DATE1" date-format="yyyyMMdd"/>
            <field index="25" db-field="WBCLD_DATE2" date-format="yyyyMMdd"/>
            <field index="26" db-field="WBCLD_DATE3" date-format="yyyyMMdd"/>
            <field index="27" db-field="WBCLD_DATE4" date-format="yyyyMMdd"/>
            <field index="28" db-field="WBCLD_DATE5" date-format="yyyyMMdd"/>
            <field index="29" db-field="WBCLD_DATE6" date-format="yyyyMMdd"/>
            <field index="30" db-field="WBCLD_DATE7" date-format="yyyyMMdd"/>
            <field index="31" db-field="WBCLD_DATE8" date-format="yyyyMMdd"/>
            <field index="32" db-field="WBCLD_DATE9" date-format="yyyyMMdd"/>
            <field index="33" db-field="WBCLD_DATE10" date-format="yyyyMMdd"/>
            <field index="34" db-field="WBCLD_NUM1"/>
            <field index="35" db-field="WBCLD_NUM2"/>
            <field index="36" db-field="WBCLD_NUM3"/>
            <field index="37" db-field="WBCLD_NUM4"/>
            <field index="38" db-field="WBCLD_NUM5"/>
            <field index="39" db-field="WBCLD_NUM6"/>
            <field index="40" db-field="WBCLD_NUM7"/>
            <field index="41" db-field="WBCLD_NUM8"/>
            <field index="42" db-field="WBCLD_NUM9"/>
            <field index="43" db-field="WBCLD_NUM10"/>
            <field index="44" db-field="WBCLD_DEC1"/>
            <field index="45" db-field="WBCLD_DEC2"/>
            <field index="46" db-field="WBCLD_DEC3"/>
            <field index="47" db-field="WBCLD_DEC4"/>
            <field index="48" db-field="WBCLD_DEC5"/>
            <field index="49" db-field="WBCLD_DEC6"/>
            <field index="50" db-field="WBCLD_DEC7"/>
            <field index="51" db-field="WBCLD_DEC8"/>
            <field index="52" db-field="WBCLD_DEC9"/>
            <field index="53" db-field="WBCLD_DEC10"/>
        </fields>
    </table>
</table-config>

10001,TEST WB CUSTOM LOOKUP DATA,Test WB Custom Lookup Data Description,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