Sample XML and CSV files

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

Sample XML mapping definition

<table-config>
    <table name="WB_CUSTOM_DATA" transaction-type="INSERT" primary-key="WBCD_ID">
        <fields>
            <field index="1" db-field="WBCDT_ID">
                <reference table-name="WB_CUSTOM_DATA_TYPE" supplied-value="WBCDT_NAME" resolve-to-field="WBCDT_ID"/>
            </field>
            <field index="2" db-field="WBCD_TEXT1"/>
            <field index="3" db-field="WBCD_TEXT2"/>
            <field index="4" db-field="WBCD_TEXT3"/>
            <field index="5" db-field="WBCD_TEXT4"/>
            <field index="6" db-field="WBCD_TEXT5"/>
            <field index="7" db-field="WBCD_TEXT6"/>
            <field index="8" db-field="WBCD_TEXT7"/>
            <field index="9" db-field="WBCD_TEXT8"/>
            <field index="10" db-field="WBCD_TEXT9"/>
            <field index="11" db-field="WBCD_TEXT10"/>
            <field index="12" db-field="WBCD_CHAR1" allow-char-value="Y"/>
            <field index="13" db-field="WBCD_CHAR2" allow-char-value="Y"/>
            <field index="14" db-field="WBCD_CHAR3" allow-char-value="Y"/>
            <field index="15" db-field="WBCD_CHAR4" allow-char-value="Y"/>
            <field index="16" db-field="WBCD_CHAR5" allow-char-value="Y"/>
            <field index="17" db-field="WBCD_CHAR6" allow-char-value="Y"/>
            <field index="18" db-field="WBCD_CHAR7" allow-char-value="Y"/>
            <field index="19" db-field="WBCD_CHAR8" allow-char-value="Y"/>
            <field index="20" db-field="WBCD_CHAR9" allow-char-value="Y"/>
            <field index="21" db-field="WBCD_CHAR10" allow-char-value="Y"/>
            <field index="22" db-field="WBCD_DATE1" date-format="yyyyMMdd"/>
            <field index="23" db-field="WBCD_DATE2" date-format="yyyyMMdd"/>
            <field index="24" db-field="WBCD_DATE3" date-format="yyyyMMdd"/>
            <field index="25" db-field="WBCD_DATE4" date-format="yyyyMMdd"/>
            <field index="26" db-field="WBCD_DATE5" date-format="yyyyMMdd"/>
            <field index="27" db-field="WBCD_DATE6" date-format="yyyyMMdd"/>
            <field index="28" db-field="WBCD_DATE7" date-format="yyyyMMdd"/>
            <field index="29" db-field="WBCD_DATE8" date-format="yyyyMMdd"/>
            <field index="30" db-field="WBCD_DATE9" date-format="yyyyMMdd"/>
            <field index="31" db-field="WBCD_DATE10" date-format="yyyyMMdd"/>
            <field index="32" db-field="WBCD_NUM1"/>
            <field index="33" db-field="WBCD_NUM2"/>
            <field index="34" db-field="WBCD_NUM3"/>
            <field index="35" db-field="WBCD_NUM4"/>
            <field index="36" db-field="WBCD_NUM5"/>
            <field index="37" db-field="WBCD_NUM6"/>
            <field index="38" db-field="WBCD_NUM7"/>
            <field index="39" db-field="WBCD_NUM8"/>
            <field index="40" db-field="WBCD_NUM9"/>
            <field index="41" db-field="WBCD_NUM10"/>
            <field index="42" db-field="WBCD_DEC1"/>
            <field index="43" db-field="WBCD_DEC2"/>
            <field index="44" db-field="WBCD_DEC3"/>
            <field index="45" db-field="WBCD_DEC4"/>
            <field index="46" db-field="WBCD_DEC5"/>
            <field index="47" db-field="WBCD_DEC6"/>
            <field index="48" db-field="WBCD_DEC7"/>
            <field index="49" db-field="WBCD_DEC8"/>
            <field index="50" db-field="WBCD_DEC9"/>
            <field index="51" db-field="WBCD_DEC10"/>
        </fields>
    </table>
</table-config>

Sample CSV file

10001,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