Creating CSV files

Multiple import interfaces use the Generic Table Import Interface. Each interface requires a specific CSV file. You must create each CSV file according to the CSV file’s field specifications.

Skill Import

The CSV file for the Skill Import Interface includes these field-column specifications:

Note: Fields with the asterisk symbol (*) are required.
Col. Field Name Type Size/Format Description
1 STSKL_NAME* VARCHAR 40 Skill name
2 STSKL_DESC VARCHAR 100 Skill description
3 STSKLTYP_NAME* VARCHAR 40 Skill type
4 STSKL_FLAG1-5 VARCHAR 1 Skill flag fields, 1 through 5
5 STSKL_UDF1-5 VARCHAR 40 Skill UDF fields, 1 through 5
Note: The STSKLTYP_NAME (foreign key to the ST_SKILL table) gets translated into an appropriate STSKLTYP_ID that the ST_SKILL table is expecting as part of the import.

This text is an example of a CSV file for Skill Import: 

Cashier, Store Cashier, Skill (skill name, skill description, skill type)

SO Budget Pay Cost Import

The CSV file for the SO Budget Pay Cost Import Interface includes this field-column specifications:

Note: Fields with the asterisk symbol (*) are required.
Col. Field Name Type Size/Format Description
1 SKDGRP_ID* Number 22 Location ID of the location for which the budget is set
2 BDGPAY_DATE* Date 7

yyyyMMdd

Date of the budget
3 BDGPAY_AMOUNT* Number 12 Amount of the budget

This text is an example of a CSV file for SO Budget Pay Cost Import: 

1234, 06/22/2008, 1000.00 (skdgrp_id, bdgpay_date, bdgpay_amount)

SO Plan Workload Import

The CSV file for the SO Plan Workload Import Interface includes these field-column specifications.

For more information on using this table, see External Workload Feed and the SO_PLAN_WORKLOAD database table.

Note: Fields with the asterisk symbol (*) are required.
Col. Field Name Type Size/Format Description
1 SKDGRP_ID* Number Location ID of the schedule.
2 PLNWRKLD_DATE* Date

MM/dd/yyyy

 The workload date.
3 PLNWRKLD_TIME* Date HH:mm The workload time.
4 PLNWRKLD_HOURS* Decimal (10,3) XXXXX.XXX The workload hours.
5 INVTYP_ID Integer Number Takes the following values:
  • 1: Daily
  • 2: 60 Minutes
  • 3: 30 Minutes
  • 4: 15 Minutes
  • 5: Weekly

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 LFSO Implementation and Administration Guide.