Importing Supermarket Workbench Data
After loading the data into an external application, updating it as needed, and saving it to a comma-separated values (.csv) file, use Supermarket Workbench Import (17.2.19) to load data from the file into the system.
The user interface for this program is identical to Kanban Workbench Import. See
Importing Kanban Workbench Data.
Supermarket Workbench Import File Definition shows the structure of the import file that Supermarket Workbench Import requires to work properly. The Buffer Maximum field is the same one you can update using Supermarket Workbench.
Important: The first record in the import file must contain only the literal string supermarket workbench. Each subsequent record must include the fields shown in the table.
Supermarket Workbench Import File Definition
|
Field Name
|
Format
|
Description
|
|
knb_primary_key
|
decimal
|
Kanban Loop ID: Internal keyid of knb_mstr record exported from the system
|
|
buffer_maximum_revised
|
decimal
|
Buffer maximum
|