I want to save MS Office files in the Vault using a serialized file name.
Imagine working on a project. All the parts, assemblies and drawings are in a project folder in the Vault. A supplier sends you a spreadsheet MOTOR.XLSX containing motor data and you want to put it in your project folder and have a workflow notify your engineers that the motor data supporting their models is now in the project area. Then a second supplier sends you their bid on the motors...
- Incoming has your Excel file MOTORS .XLSX
- Drag and drop MOTORS.XLSX into the Vault\Projects\P12345\Documents folder (say)
- The file is saved using a serial number 452176.XLSX (say)
- The old file name is captured in a variable on the data card and the user can enter some supplier data
- The second spreadsheet, from the other supplier, comes in, dragged and dropped to become 452177.XLSX (serial increment from last file) etc etc
I can't find any information suggesting whether this is possible or impossible. Thoughts on this process would be most welcome.
Regards.
Thys
Hi Thys, the way I would do this is by using Dispatch.
Set up your Datacard so that both the old name and the serial number are on the datacard as the file is added to the vault. Then you can use Dispatch to rename the file(s) using a specified value on the datacard.
Here is a screenshot of a sample datacard I set up:
So initially when I add my file to the vault, it looks like this:
Then when I run the Dispatch action:
You can see how it's renamed according to the value from the datacard. I have attached some instructions on how to load Dispatch and a Dispatch script that does the renaming.
Hope this helps.
Kind regards,
Prasad Bhonsule