Import Sub-Structure of a Calculation
You can import a sub-structure with or without referenced master data of a
The Excel import consists of two steps:
- Step 1: Import Sub-Structure of a Calculation
- Step 2: Publish Imported Sub-Structure of a Calculation
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.
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)
- You are logged in as a Calculator.
- You are in the Calculations workspace.
- In the Structure view, select the calculation element under which you want to import the sub-structure.
- In the ribbon, click on Edit ► From File.
The FACTON - Select file to import dialog opens.
- Right-click on the calculation element ► Insert from File.
- Select the .xlsx file you wish to import.
- 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.
Alternative:
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.
It is not possible to undo changes after publishing.