Our company is in the process of implementing a new MRP system & as a consequence ALL of our existing product codes are having a complete overhaul and will be renamed to a more consistant type of coding.
This is a good idea and does need doing - however, in the last 3 years of having Solidworks we have generated about 3,500 files (parts/assemblies/drawings) that are now going to need renaming to the new product codes. They all sit in our 'vault' of the PDM Workgroup system. This is a mammoth task !!
So I am wondering, has anyone else had to do a batch re-naming of files (using PDM Workgroup) - and have they found a way to automate this process somehow ??
We will have a spreadsheet with 2 columns, one for old part number and one for new part number. So I'm thinking somehow along the lines of a V-LOOKUP kind of approach.......
I'm scratching my head here and trying to think of a way to avoid doing this manually !!! Any suggestions would be appreciated