Importing Level Mix 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 Level Mix Workbench Import (17.14.14) 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.
For the import to work correctly, the file structure must be the same as that created by Level Mix Workbench.
Level Mix Workbench Export and Import File Definition describes the required file structure. Fields updated in the external application are shown in
italics.
Important: The first record in the import file must contain only the literal string level mix workbench. Each subsequent record must include the fields shown in the table.
When you import data, the system makes the following updates based on data from the import file:
• From Record Type H: The system posts the updated takt time value to the process master record and updates the process pitch time accordingly. The Takt Time Calculation field in Kanban Process Maintenance is set to LvlMixWB.
• From Record Type P: Buffer adjustments are added to or subtracted from the maximum buffer size (knbism_max_buf) for kanban loops. The system also updates such things as safety stock and variability factor as needed.
• From Record Type D: Time adjustments made by the user are posted back to the Process Shift Maintenance record.
• From Record Type Q: Flow orders are generated from this record type. If the revised order quantity is different from the input order quantity, the system updates the corresponding flow orders. If the user enters a quantity of 0 (zero) for an item in the external application, any existing flow order is deleted. As needed, the system converts from the pitch UM back to the item UM.