QAD 2017 Enterprise Edition > User Guides > Lean Manufacturing > Using External Applications > Kanban Workbenches
  
Kanban Workbenches
This section describes how to export and import files. Using these features, you can:
• Perform many of the functions of the kanban workbenches using an external application. See Using Kanban Workbenches.
• Create new kanban loops and related records based on the content of external files.
Exporting Kanban Workbench Data
Use Kanban Workbench Export (17.2.16) to generate a data file containing records that you can use in an external application to size kanban loops, as well as analyze the effects of modifying several other aspects of loops and supplying processes. You can then format the updated values as an import file, import it into the system, update the associated loop records, and optionally reconcile the number of cards based on the updated values, as well as print new and activated cards.

Kanban Workbench Export (17.2.16)
Optionally enter ranges of selection criteria to identify the loop data to be exported. Use the following fields to control other aspects of export processing:
Option
Specify the types of kanban sources to be included in the export. Valid values are:
1: Export Only Supplier Sources
2: Export Only Inventory Sources
3: Export Only Process Sources
4: Export All Source Types (default)
Export Directory
Optionally enter the path to the directory where this program places the exported file. This value defaults from Kanban Control (17.24). See Control Program.
When the field is blank, the system uses the working directory.
File Name
Enter the name of the file that will contain the exported data.
Although the system generates a comma-delimited file, it does not add an extension. For example, if you want the file to be accessible to an external application that recognizes comma-separated value files, add .csv to the file name.
Export
Enter Yes to export selected data to a comma-delimited file. To review a report on which records will be selected without generating a file, run the program first with this field set to No and Report set to Yes. After reviewing the resulting report and adjusting the selection criteria as needed, run the program again with Export set to Yes.
Report
Enter Yes to generate a report identifying basic data about loops that will be selected for export.
Kanban Workbench Export File Definition shows the structure of the file created by Kanban Workbench Export. The values in the fields are the same as those the system loads into the kanban workbenches.
Important: This is not the same record structure required by Kanban Workbench Import. Importing a file with the export structure will fail. See Kanban Workbench Import File Definition.

Kanban Workbench Export File Definition
 
Field Name
Format
Description
knb_primary_key
decimal
Kanban Loop ID: internal keyid of knb_mstr record
part
character
Item
source_site
character
Source site
source
character
Source ID of the process, supermarket, or supplier
source_type
character
Source Type: Process, Supermarket, or Supplier
supermarket_site
character
Supermarket site
supermarket
character
Supermarket
daily_demand
decimal
Average daily demand
demand_um
character
Demand UM
demand_method
character
Demand method
demand_pct
decimal
Demand percent
replenishment_time
integer
Replenishment time (in seconds)
fifo_time
integer
Internal FIFO time (in seconds)
fifo_ext_time
integer
External FIFO time (in seconds)
fixed_interval
integer
Fixed interval time (in seconds)
setup_time
integer
Setup time (in seconds)
cycle_time
integer
Cycle time (in seconds)
safety_stock
decimal
Safety stock
safety_time
decimal
Safety days (in decimal days)
var_factor
decimal
Variability factor
epei_current
decimal
EPEI—Current
epei_revised
decimal
EPEI—Revised (Defaulted from EPEI Current)
epei_auto_calc
Yes/No
EPEI auto calculation
order_qty
decimal
Order quantity
order_qty_mult
decimal
Order quantity multiple
pack_qty
decimal
Pack quantity
packs_per_kanban
decimal
Packs per kanban
kanban_qty
decimal
Kanban quantity
number_of_cards
integer
Number of cards
pitch_um
character
Pitch UM
pitch_um_demand
decimal
Demand in pitch UM
time_available
integer
Time available (in seconds)
pct_uptime
decimal
Uptime percentage
step
character
Step
pitch_um_conv_factor
decimal
Pitch UM conversion factor
epei_conv_factor
decimal
EPEI conversion factor
epei_display
character
EPEI display: Hours, Days, Weeks, Months
pacemaker
Yes/No
Pacemaker process indicator
no_of_resources
decimal
Number of resources
min_process_epei
decimal
Minimum process EPEI
item_yield_pct
decimal
Item yield percent
lead_time_method
integer
Lead time method
load_limit
decimal
Load limit
min_process_item_epei
decimal
Minimum item EPEI
run_out_option
integer
Run-out option
fraction_kanban_percent
decimal
Fractional kanban
card_reporting
integer
Card reporting
cost_allocation
decimal
Cost allocation
run_out_setup
decimal
Run-out setup time
run_out_quantity
decimal
Run-out quantity
run_out_quantity_um
character
Run-out quantity UM
run_out_quantity_per
decimal
Run-out quantity per
run_out_quantity_per_um
character
Run-out quantity per UM
run_out_conv_factor
decimal
Run-out conversion factor