Finding and collecting sets of files is difficult when working with collections of files. Mecad recently completed a small document retrieval utility program for a client which does exactly this. The intent of the program is to get a list of required files (typically from an ERP system like Syspro) with their given revisions in Excel / CSV format, and then to retrieve this list of files from your PDM Professional vault.
The core functions are as follows:
- Loop through a list of file names inside an Excel file
- Find all the files matching these names in the vault
- Retrieve (Get-Latest) the correct revision of each file
- Copy / aggregate these files to a local folder on the user machine, ready for distribution