Bulk Export and Import Custom Properties
Tips and Tricks • Mark Deng • 24 July 2020
Recently I have come across a case where a customer has been requested by his manager to change the custom property “PartNo” for all the existing SOLIDWORKS files. There are tens of thousands of files that require modification and it could take weeks for a customer to do it manually.
Luckily Central Innovation has developed a tool #TASK to achieve this task.
In #TASK, we can use the macro “Bulk Property Export” to export files properties to an excel sheet:
Once the export process is completed, the excel file will have the values for file path and custom properties captured. This will allow us to quickly modify the values for “PartNo” etc. using Excel tools.
Now the modified property values in the Excel can be used to re-import to update all the files using the “Bulk Property Import”:
Once the task is complete, the custom property “PartNo” has been updated successfully for all the files:
If the files are managed in PDM vault, you can enable the PDM Plug-in in #TASK to allow automatically check-out and check-in on all files set in the task scope in #TASK:
If there are tens of thousands of files you need to modify, you can leave #TASK running over the weekend and the job will be completed automatically.
I hope you find this useful.
Central Innovation, NZ
At Central Innovation, we can provide all – or part – of the solution. Including SOLIDWORKS, ARCHICAD, and many more industry-leading tools.
It’s something we’ve been doing for almost 30 years. Our commitment to customer service is second to none: we help you get the best out of your technology.
For a truly unique solution to your unique challenges, please contact us. Or read about some of the great services and solutions we offer.