Import Update From Excel - CADWorx - Help

CADWorx Spec Editor

PPMProduct
CADWorx
PPMCategory_custom
Help
Version_CADWorx
20.1 (2020 R1)

CADWorx Spec Editor Project: Home Tab > Export/Import Data > Import Update From Excel

Imports data from an Excel file to a specification.

File Path

Specifies the location of the Excel file.

Select the components for import

Displays the information details for the import.

Import

Enables you to select the items to import.

Type

Displays the type of import if the import contains a type.

Description

Displays a description of the import. For example, if you made a change to the Pipe component, the Description displays the long description of the piping. However, if you changed the Component ID or the Program Code of Pipe in the Excel file, the description displays the Table Field types that display in Long in the New and Edit Component pane.

Property

Displays the property that you changed in the Excel file.

Action

Displays the action taken for the import. For example, if you change the Weight factor in the Excel file, the Action reads Update, because the action taken updates the specification. In addition, if you changed the Component ID or the Program Code of Pipe in the Excel file, the Action reads Addition, because this action adds a new component to the specification.

Existing Spec

Displays the value of the property from the existing specification.

Excel Spec

Displays the value of the property from the Excel file. The value displayed here comes from the changes made to the Excel file.

Result

Displays success or failure of the imported property.

  • Success =

  • Failure = Import data displays in red before import. After import you receive the following:

Saves backup project

Saves a backup of the original project.

View Log

Enables you to view a log of the import.