Sample XML and CSV files

Sample XML mapping definition

<table-config>
    <table name="SO_FCAST_EXTERNAL" transaction-type="INSERT_UPDATE" key-fields="SKDGRP_ID,FCSTEXT_DATE,FCSTEXT_TIME" primary-key="FCSTEXT_ID">
        <fields>
            <field index="1" db-field="SKDGRP_ID">
                <reference table-name="SO_SCHEDULE_GROUP" supplied-value="SKDGRP_NAME" resolve-to-field="SKDGRP_ID"/>
            </field>
            <field index="2" db-field="FCSTEXT_DATE" date-format="yyyyMMdd" default-value="!SYSTEM_DATE" />
            <field index="3" db-field="FCSTEXT_TIME" date-format="HH:mm:ss" />
            <field index="4" db-field="FCSTEXT_VALUE" default-value="0" />
            <field index="5" db-field="INVTYP_ID" default-value="Daily" >
                <reference table-name="SO_INTERVAL_TYPE" supplied-value="INVTYP_NAME" resolve-to-field="INVTYP_ID"/>
            </field>
            <field index="6" db-field="VOLTYP_ID">
                <reference table-name="SO_VOLUME_TYPE" supplied-value="VOLTYP_NAME" resolve-to-field="VOLTYP_ID"/>
            </field>
        </fields>
    </table>
</table-config>

Sample CSV file

REPORT STORE,20131011,2:00:00,600,Daily,UNIT

REPORT STORE,,00:00:00,600,Daily,UNIT