Sample XML mapping definitions

Time Code Table Import

<table-config>
  <table name="TIME_CODE" transaction-type="INSERT_UPDATE" 
    key-fields="TCODE_NAME" primary-key="TCODE_ID">
    <fields>
     <field index="1" db-field="TCODE_NAME" />
     <field index="2" db-field="TCODE_DESC" />
     <field index="3" db-field="TCODE_DOW" default-value="YYYYNN"/>
     <field index="4" db-field="TCODE_OWS" default-value="Y"/>
     <field index="5" db-field="COLR_ID" default-value="Black">
       <reference table-name="COLOUR" supplied-value="COLR_NAME" 
         resolve-tofield="COLR_ID"/>
      </field>
      <field index="6" db-field="HTYPE_ID">
        <reference table-name="HOUR_TYPE" 
          supplied-value="HTYPE_NAME" 
          resolve-to-field="HTYPE_ID"/>
      </field>
      <field index="7" db-field="TCODE_UNAUTHORIZE" 
        default-value="Y"/>
      <field index="8" db-field="TCODE_SORTORDER"/>
      <field index="9" db-field="TCODE_AFFECTS_BALANCES" 
        default-value="N"/>
      <field index="10" db-field="TCODE_SUMMARIZE"/>
      <field index="11" db-field="TCODE_FLAG1"/>
      <field index="12" db-field="TCODE_FLAG2"/>
      <field index="13" db-field="TCODE_FLAG3"/>
      <field index="14" db-field="TCODE_FLAG4"/>
      <field index="15" db-field="TCODE_FLAG5"/>
      <field index="16" db-field="TCODE_DEFAULT_RATE"/>
      <field index="17" db-field="LMS_ID" default-value="1" />
      <field index="18" db-field="*CUSTOM"/>
    </fields>
  </table>
</table-config>

Department Table Import

<table-config>
  <table name="DEPARTMENT" transaction-type="INSERT_UPDATE" 
    key-fields="DEPT_NAME" primary-key="DEPT_ID">
    <fields>
      <field index="1" db-field="DEPT_NAME" />
      <field index="2" db-field="DEPT_DESC" />
      <field index="3" db-field="DEPT_START_DATE" 
        date-format="yyyyMMdd" default-value="!SYSTEM_DATE"/>
      <field index="4" db-field="DEPT_END_DATE" 
        date-format="yyyyMMdd" default-value="30000101"/>
      <field index="5" db-field="DEPT_FLAG1" default-value="N"/>
      <field index="6" db-field="DEPT_FLAG2" default-value="N"/>
      <field index="7" db-field="DEPT_FLAG3" default-value="N"/>
      <field index="8" db-field="DEPT_FLAG4" default-value="N"/>
      <field index="9" db-field="DEPT_FLAG5" default-value="N"/>
      <field index="10" db-field="DEPT_VAL1"/>
      <field index="11" db-field="DEPT_VAL2"/>
      <field index="12" db-field="DEPT_VAL3"/>
      <field index="13" db-field="DEPT_VAL4"/>
      <field index="14" db-field="DEPT_VAL5"/>
      <field index="15" db-field="LMS_ID" default-value="1" />
      <field index="16" db-field="*CUSTOM"/>
    </fields>
  </table>
</table-config>

Docket Table Import

<table-config>
  <table name="DOCKET" transaction-type="INSERT_UPDATE" 
    key-fields="DOCK_NAME" primary-key="DOCK_ID">
    <fields>
      <field index="1" db-field="DOCK_NAME" />
      <field index="2" db-field="DOCK_DESC" />
      <field index="3" db-field="DOCK_QTY" default-value="0"/>
      <field index="4" db-field="DOCK_STANDARD_QTY"/>
      <field index="5" db-field="DOCK_STANDARD_DUR"/>
      <field index="6" db-field="MACH_ID" default-value="NULL">
        <reference table-name="MACHINE" supplied-value="MACH_NAME" 
          resolveto-field="MACH_ID"/>
      </field>
      <field index="7" db-field="PART_ID" default-value="NULL">
        <reference table-name="PART" supplied-value="PART_NAME" 
          resolve-tofield="PART_ID"/>
      </field>
      <field index="8" db-field="PROJ_ID" default-value="0">
        <reference table-name="PROJECT" supplied-value="PROJ_NAME" 
          resolve-to-field="PROJ_ID"/>
      </field>
      <field index="9" db-field="DOCK_PIECE_RATE" 
        default-value="0"/>
      <field index="10" db-field ="ACTVSET_ID" default-value="NULL">
        <reference table-name="ACTIVITY_SET" suppliedvalue=" 
          ACTVSET_NAME" resolve-to-field="ACTVSET_ID"/>
      </field>
      <field index="11" db-field="DOCK_START_DATE" 
        date-format="yyyyMMdd" default-value="!SYSTEM_DATE"/>
      <field index="12" db-field="DOCK_END_DATE" 
        date-format="yyyyMMdd" default-value="30000101"/>
      <field index="13" db-field="DOCK_FLAG1" default-value="N"/>
      <field index="14" db-field="DOCK_FLAG2" default-value="N"/>
      <field index="15" db-field="DOCK_FLAG3" default-value="N"/>
      <field index="16" db-field="DOCK_FLAG4" default-value="N"/>
      <field index="17" db-field="DOCK_FLAG5" default-value="N"/>
      <field index="18" db-field="DOCK_UDF1"/>
      <field index="19" db-field="DOCK_UDF2"/>
      <field index="20" db-field="DOCK_UDF3"/>
      <field index="21" db-field="DOCK_UDF4"/>
      <field index="22" db-field="DOCK_UDF5"/>
      <field index="23" db-field="LMS_ID" default-value="1" />
      <field index="24" db-field="*CUSTOM"/>
    </fields>
  </table>
</table-config>

Project Table Import

<table-config>
  <table name="PROJECT" transaction-type="INSERT_UPDATE" 
    key-fields="PROJ_NAME" primary-key="PROJ_ID">
    <fields>
      <field index="1" db-field="PROJ_NAME" />
      <field index="2" db-field="PROJ_DESC" />
      <field index="3" db-field="PROJ_START_DATE" 
        date-format="yyyyMMdd" default-value="!SYSTEM_DATE"/>
      <field index="4" db-field="PROJ_END_DATE" 
        date-format="yyyyMMdd" default-value="30000101"/>
      <field index="5" db-field="PROJ_FLAG1" default-value="N"/>
      <field index="6" db-field="PROJ_FLAG2" default-value="N"/>
      <field index="7" db-field="PROJ_FLAG3" default-value="N"/>
      <field index="8" db-field="PROJ_FLAG4" default-value="N"/>
      <field index="9" db-field="PROJ_FLAG5" default-value="N"/>
      <field index="10" db-field="PROJ_VAL1"/>
      <field index="11" db-field="PROJ_VAL2"/>
      <field index="12" db-field="PROJ_VAL3"/>
      <field index="13" db-field="PROJ_VAL4"/>
      <field index="14" db-field="PROJ_VAL5"/>
      <field index="15" db-field="LMS_ID" default-value="1" />
      <field index="16" db-field="*CUSTOM"/>
    </fields>
  </table>
</table-config>

Skill Table Import

<table-config>
  <table name="ST_SKILL" transaction-type="INSERT_UPDATE" 
    key-fields="STSKL_NAME,STSKLTYP_ID" primary-key="STSKL_ID">
    <fields>
      <field index="1" db-field="STSKL_NAME" />
      <field index="2" db-field="STSKL_DESC" />
      <field index="3" db-field="STSKLTYP_ID" >
        <reference table-name="ST_SKILL_TYPE" 
          supplied-value="STSKLTYP_NAME" 
          resolve-to-field="STSKLTYP_ID"/>
      </field>
      <field index="4" db-field="STSKL_FLAG1" default-value="N"/>
      <field index="5" db-field="STSKL_FLAG2" default-value="N"/>
      <field index="6" db-field="STSKL_FLAG3" default-value="N"/>
      <field index="7" db-field="STSKL_FLAG4" default-value="N"/>
      <field index="8" db-field="STSKL_FLAG5" default-value="N"/>
      <field index="9" db-field="STSKL_UDF1"/>
      <field index="10" db-field="STSKL_UDF2"/>
      <field index="11" db-field="STSKL_UDF3"/>
      <field index="12" db-field="STSKL_UDF4"/>
      <field index="13" db-field="STSKL_UDF5"/>
    </fields>
  </table>
</table-config>