Sample XML and CSV files

Sample XML mapping definition

<table-config>
 <table name="SO_PLAN_WORKLOAD" transaction-type="INSERT" primary-key="PLNWRKLD_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="PLNWRKLD_DATE" date-format="MM/dd/yyyy" default-value="!SYSTEM_DATE"/>
    <field index="3" db-field="PLNWRKLD_TIME" date-format="HH:mm"/>
    <field index="4" db-field="PLNWRKLD_HOURS"/>
    <field index="5" db-field="INVTYP_ID" default-value="1"/>
  </fields>
 </table>
</table-config>

Sample CSV file

This text is an example of a CSV file for the SO Plan Workload Import:

REPORT DEPT 2,10/23/2019,16:04:00,23.344,4

Where:

• REPORT DEPT 2: Name of a location/so_schedule_group, resolving to a SKDGRP_ID for column SKDGRP_ID.
• 10/23/2019: Value for column PLNWRKLD_DATE.
• 16:04:00: Value for column PLNWRKLD_TIME.
• 23.344: Value for column PLNWRKLD_HOURS.
• 4: Value for column INVTYP_ID.

For more information on configuring this type of forecast method, see Infor Workforce Management LFSO Implementation and Administration Guide.