Skip to content

Master Data Loading Process#

Initial Loading#

For the initial master data loading (Facilities, Areas, Products, Flows, Steps and other fundamental MES entities) we can create a model using the actual Critical Manufacturing GUI, although the process can become tiresome for abundant quantity of data and objects.

As an alternative, we can use the Master Data Packages tool for bulk data loading, using a spreadsheet of interconnected entities that can be loaded by the tool without the need for user interaction.

graph LR
    Excel[MasterDataOne.xlsx] -.->MD[Master Data Package]
    subgraph Master Data Loading
    MD[Master Data Package] --> MES[Critical Manufacturing MES]
    end
    Excel2[MasterDataTwo.xlsx] -.->MD
    Excel3[MasterDataThree.xlsx] -.->MD

classDef mermaid_title color:#000, fill:#fafafa, stroke:#fafafa, stroke-width:0x, font-size:100%, font-weight:200;
classDef mermaid_start color:#000, fill:#fafafa, stroke:#fafafa, color:#fafafa, stroke-width:0x, font-size:100%, visibility: hidden;
classDef mermaid_businessdata color:#000, fill:#65CDE8, stroke:#65CDE8, stroke-width:0px, font-size:100%;
classDef mermaid_nonbusinessdata color:#000, fill:#B7DEE8, stroke:#B7DEE8, stroke-width:0px, font-size:100%;
classDef mermaid_entity color:#000, fill:#FB9F53, stroke:#FB9F53, stroke-width:0px, font-size:100%;
classDef mermaid_entitylinked color:#000, fill:#FCD5B5, stroke:#FCD5B5, stroke-width:0px, font-size:100%;
classDef mermaid_context color:#000, fill:#B9CDE5, stroke:#B9CDE5, stroke-width:0px, font-size:100%;
classDef mermaid_optional color:#000, fill:#B7DEE8, stroke:#65CDE8, stroke-width:1px, font-size:100%, stroke-dasharray: 5 5;
classDef mermaid_state color:#000, fill:#d7e4bd, stroke:#000, stroke-width:1px, font-size:100%, font-weight:300;
class Excel,Excel2,Excel3 mermaid_entity
class MD,MES mermaid_businessdata

Master Data Loader Main Features#

  • Allows fast implementation to get the system running in minutes.
  • Built-in page in Critical Manufacturing MES to allow template loading and validation.
  • Retrieves all objects from an Excel file and uploads them into a predefined Critical Manufacturing environment.

Behavior#

  • Works by communicating with the MES database through the host via API.
  • Creates the objects if they do not exist; otherwise, it updates them.
  • In case of versioned objects, a new revision and version is always created, managing the Change Sets automatically.

Deployment#

The Deployment of the Master Data through an Excel file, can be made:

  • Manually, by someone with the proper permissions.
  • Automatically, as part of a deployment pipeline.
graph LR
    Excel[MasterDataOne.xlsx] -->MD[Master Data Package]
    Excel -->MD2[TFS Release Management]
    subgraph Master Data Loading inside MES
    MD --> MES[Critical Manufacturing MES]
    end
    subgraph Master Data Loading from outside
    MD2 --> MES
    end

classDef mermaid_title color:#000, fill:#fafafa, stroke:#fafafa, stroke-width:0x, font-size:100%, font-weight:200;
classDef mermaid_start color:#000, fill:#fafafa, stroke:#fafafa, color:#fafafa, stroke-width:0x, font-size:100%, visibility: hidden;
classDef mermaid_businessdata color:#000, fill:#65CDE8, stroke:#65CDE8, stroke-width:0px, font-size:100%;
classDef mermaid_nonbusinessdata color:#000, fill:#B7DEE8, stroke:#B7DEE8, stroke-width:0px, font-size:100%;
classDef mermaid_entity color:#000, fill:#FB9F53, stroke:#FB9F53, stroke-width:0px, font-size:100%;
classDef mermaid_entitylinked color:#000, fill:#FCD5B5, stroke:#FCD5B5, stroke-width:0px, font-size:100%;
classDef mermaid_context color:#000, fill:#B9CDE5, stroke:#B9CDE5, stroke-width:0px, font-size:100%;
classDef mermaid_optional color:#000, fill:#B7DEE8, stroke:#65CDE8, stroke-width:1px, font-size:100%, stroke-dasharray: 5 5;
classDef mermaid_state color:#000, fill:#d7e4bd, stroke:#000, stroke-width:1px, font-size:100%, font-weight:300;
class Excel,Excel2,Excel3 mermaid_entity
class MD,MD2,MES mermaid_businessdata

Location#