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)