- Please select -

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:

Bulk export and import custom properties

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.

Bulk export and import custom properties

Now the modified property values in the Excel can be used to re-import to update all the files using the “Bulk Property Import”:

Bulk export and import custom properties

Once the task is complete, the custom property “PartNo” has been updated successfully for all the files:

Bulk export and import custom properties

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:

Bulk export and import custom properties

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.

Mark Deng
Applications Engineer
Central Innovation, NZ

At Central Innovation, we can provide all – or part – of the solution. Including SOLIDWORKSARCHICAD, 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.

 

Back to Tips and Tricks