Sample XML and CSV files
This section contains sample XML mapping definition and sample CSV files for SO Activity.
Sample XML mapping definition
<table-config>
<table name="SO_ACTIVITY" transaction-type="INSERT_UPDATE" key-fields="ACT_NAME,SKDGRP_ID" primary-key="ACT_ID">
<fields>
<field index="1" db-field="ACT_NAME"/>
<field index="2" db-field="SKDGRP_ID">
<reference table-name="SO_SCHEDULE_GROUP" supplied-value="SKDGRP_NAME" resolve-to-field="SKDGRP_ID"/>
</field>
<field index="3" db-field="COLR_ID">
<reference table-name="COLOUR" supplied-value="COLR_NAME" resolve-to-field="COLR_ID"/>
</field>
<field index="4" db-field="TCODE_ID">
<reference table-name="TIME_CODE" supplied-value="TCODE_NAME" resolve-to-field="TCODE_ID"/>
</field>
<field index="5" db-field="ACT_FLAG1"/>
<field index="6" db-field="ACT_FLAG2"/>
<field index="7" db-field="ACT_FLAG3"/>
<field index="8" db-field="ACT_FLAG4"/>
<field index="9" db-field="ACT_FLAG5"/>
<field index="10" db-field="ACT_UDF1"/>
<field index="11" db-field="ACT_UDF2"/>
<field index="12" db-field="ACT_UDF3"/>
<field index="13" db-field="ACT_UDF4"/>
<field index="14" db-field="ACT_UDF5"/>
</fields>
</table>
</table-config>
Sample CSV file
TEST ACTIVITY,PARENT,RED,WRK
ACTIVITY TEST,PARENT,BLACK,WRK,,N,Y,N,,UDF1,UDF2,,UDF4,UDF5