Visiativ myCADtools

Operation possible on parts, assemblies or drawings.

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

The utility connects only once when the is selected. If in the meantime you modify the Excel file, it is not updated in the utility. To take into account the modifications it is necessary to leave the utility and to start it again so that the table is reloaded.

Example :

The property ''Descriptionmust be created (or modified if it exists) by retrieving the value contained in the Excel file ''.SmartBom.xls'' corresponding to the column ''Description'' from the first leaf ''1''for the selected files.

• In case you want to apply (or modify) all the properties present in your Excel file, you can use the "*". This is what we get:

The formatting of the criteria with the separator ''.|'' is decomposed as follows and allows to codify the cell to be read:

1 => Number of the Excel sheet to use

<PathName> => Key to get the line.

Description => Name of the column to 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 property ''Description'' will take the value ''Shoulder axis''.

For the file: ''180-Disc'' the property ''Description'' will take the value ''Disc''.

For the file : ''180-Manila-male'' the property ''Description'' will take the value ''Manila-male''.

The keys that can be used for the second field :

<PathName> => Full address of the file

<FileName> => File name

<$Property> => Property value

And, optionally, we can use in addition to the second field the key <Configuration> => Name of the column that contains the name of the configuration where to create the property (otherwise the property is created on the document).