Import Update From Excel - CADWorx - Reference Data

CADWorx Spec Editor

Language
English
Product
CADWorx
Subproduct
Plant
Search by Category
Reference Data
CADWorx Version
20.0 (2020)

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

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 = Success in Excel Import Update

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

Saves backup project

Saves a backup of the original project.

View Log

Enables you to view a log of the import.