Import Sub-Structure of a Calculation

You can import a sub-structure with or without referenced master data of a Should Cost Calculation at any point in the calculation structure.

The Excel import consists of two steps:

Generally, the Excel template is imported row by row. If an error occurs, the import is interrupted and an error message appears. This message contains the cause of the error, so it can be debugged straight away, e.g. the respective row and/or column number of the missing values.

Note

Updating imported sub-structures is not possible. The repeated import of sub-structures does not update the existing structure. Instead, the sub-structure is re-inserted into the calculation structure.

Step 1: Import Sub-Structure of a Calculation

Import Calculation Structure (BoM)

  1. In the Structure view, select the calculation element under which you want to import the sub-structure.
  2. In the ribbon, click on Edit ► From File.

    The FACTON - Select file to import dialog opens.

  3. Alternative:  

    • Right-click on the calculation element ► Insert from File.
  4. Select the .xlsx file you wish to import.
  5. Click Open.

    The sub-structure of the calculation from the Excel file is inserted under the selected calculation element.

    If an error occurs, a detailed error message is displayed at the end of the import.

Note

If you have not publish changes to the calculation yet, click Yes to publish all local changes.

Step 2: Publish Imported Sub-Structure of a Calculation

Publish Changes

  • In the ribbon, click on the File ► Publish All.

    All existing changes are published.

Note

It is not possible to undo changes after publishing.