File management
File ID:
The file ID is defined in the column (see "Defining Excel Data").
There are four possibilities:
When using "Full Paths," you can start with the vault view by beginning with \
For example:
In "File Variable" mode, DataRecovery will modify the document in which the variable is found.
Modified configuration:
-All settings and tabs on the card will be set to the same value.
-Configurations defined in the Excel column; only the configurations defined in the Excel file will be updated.
The name of the column containing the name of the configurations is mandatory in this case.
-Found in the search results, this option is available only in File Variable mode. If a file contains a variable with different values for each configuration, and you use that variable as the File Identifier, it will modify each configuration with the variables from the corresponding line. For example, if you use “ProjectNumber” as the file variable to search for, it will modify the “Comment” variable in the document within the configuration that contains the corresponding value for “ProjectNumber”:
Type of change:
-When a version is created, each document in the Excel file will be extracted, modified, and archived, and a version will be created.
The following options are available:
-Without version control, every document in the Excel file will be modified directly in the SQL database; the file itself is not modified.
Restrictions on use via SQL:
If you use attributes mapped to SOLIDWORKS properties, the SOLIDWORKS properties must not exist in the file, because the file's properties take precedence when populating the cards.
If the properties exist when the file is archived, the values you entered using DataRecovery will be overwritten.
This option allows you to update revisions using one of the Excel columns.
Creating nonexistent files using templates:
This option allows you to create files in PDM with the attributes defined in the Excel file, using a column that contains the model name defined in DataRecovery.