Visiativ myCADtools

Operation possible on parts, assemblies or drawings.

This operation allows you to create or modify the value of a property in 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 '' propertyDescriptionmust be created (or modified if it exists) by retrieving the value contained in the Excel file ''.SmartBom.xls'' corresponding to the column ''Description'' of the first leaf ''1''for selected files.

• If you wish to apply (or modify) all the properties present in your Excel file, you can use the character "*". The result is :

Criteria formatting with '' separator|'' is broken down as follows and is used to code the cell to be read:

1 => Excel sheet number to use

<PathName> => Key to get the line.

Description => Name of the column to be read.

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

Example for the selection of the following files:

For the file: ''180-Shoulder axis'', the ''Description'' property will be set to ''Shoulder axis''.

For the file: ''180-Disc'', the ''Description'' property will be set to ''Disc''.

For the file: ''180-Manille-male'', the ''Description'' property will be set to ''Manille-male''.

The keys used for the second field :

<PathName> => Complete file address

<FileName> => File name

<$Property> => Property value

And, optionally, the key <Configuration> => Name of the column containing the name of the configuration where to create the property (otherwise the property is created on the document).