Visiativ myCADtools

Operation possible on parts, assemblies or drawings.

This operation allows you to create or modify the value of a property in the selected files by retrieving the value from an Excel table.

The utility connects only once when the is selected. If you modify the Excel file in the meantime, it will not be updated in the utility. To take changes into account, exit the utility and relaunch it to reload the table.

Example:

The "Description" property must be created (or modified if it already exists) by retrieving the value contained in the Excel file " SmartBom. xls" corresponding to the "Description" column on the first sheet ( " 1 ") for the selected files.

• If you want to apply (or modify) all the properties in your Excel file, you can use the "*" character. This results in the following:

The format for criteria using "|" as a separator is structured as follows and allows you to encode the cell to be read:

1 => Number of the Excel sheet to use

<PathName> => Key used to retrieve the row.

Description => Name of the column to read.

The file ID must be the first column in your Excel file.

Example for selecting the following files:

For the file "180-Shoulder Axis," the "Description" property will be set to "Shoulder Axis."

For the file "180-Disk," the "Description" property will be set to "Disk."

For the file "180-Male Shackle," the "Description" property will be set to "Male Shackle."

Valid keys for the second field:

<PathName> => Full file path

<FileName> => File name

<$Property> => Property value

Optionally, in addition to the second field, you can use the <Configuration> key => Name of the column containing the name of the configuration where the property should be created (otherwise, the property is created on the document).