Product data / process / import excel or cvs

Initial situation.

There is a work queue

2 different product types

Each product’s data is unique

Each product consists of two components

How can I create a feeder that releases jobs from the queue in order. And the product would contain data about the duration of the process steps.

Difficulties arise from the logic where the same product has two components that should be linked at a later stage.

type; ID; Compenent 1 process step1; Component 2 process step 1; ( C1+C2 )Prosess step2
x;KK1;10;36;68
x;KK2;5;36;82
x;KK3;50;36;40
y;KK4;324,2;97,4;162
y;KK5;216,1;84,2;230
x;KK6;10;36;68
x;KK7;5;36;72
x;KK8;50;36;73
x;KK9;61;36;64
x;KK10;97;127;171
y;KK11;232,2;88;103
x;KK12;6;36;67
x;KK13;50;36;82
x;KK14;60;36;64
y;KK15;58,5;149,2;88
y;KK16;227,8;58;155
y;KK17;169,5;86,6;123
x;KK18;50;36;68
x;KK19;50;36;73
y;KK20;194,2;119,6;255

To create the products in the right order you can either use a standard Feeder with the “Table” FeedMode to read which product needs to be created when. Or you could use the component “ExcelReader” in the Misc file in the eCat or the AddOn “VariableCache” with an If or switch statement to create different products and assign them different properties (there is an example of that in the Automatic Warehouse System layout, in the Layouts file of the eCatalog).

You’ll need to create some properties in your products, to assign the different process times : Different Processing Time for each Part on same Machine - #13 by Tilma

When both products are assembled, you can either choose one of them as a “parent” where the data will be stored or replace them by a 3rd product. You could use an Assign statement to add the process time contained in both products.
For example :

  • Prod1.ProcessTime05 = Prod1.ProcessTime05 + Prodt2.ProcessTime05
  • or Prod3.ProcessTime05 = Prod1.ProcessTime05 + Prod2.ProcessTime05
1 Like

To add to Tilma’s reply, the component “Advanced Feeder” in 4.10 eCatalog has something very similar. It creates the components on the right order and gives each created component the right properties that were read from the table.

The component comes with an example of each feed mode that you can open by clicking the note. I’d recommend CreationMode Batch or Timestamp, you just have to add the intervals/creation times manually to the spreadsheet.

1 Like