Product data / process / import excel or cvs

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