1 Reply Latest reply on Jan 31, 2017 3:48 PM by Prasad Bhonsule

populating epdm data card field from excel spreadsheet

Dan Margulis Jan 30, 2017 3:11 PM

Hello,

My company recently starting using Solidworks PDM and we have a lot of legacy data which we have brought into the vault. One of the thing which we have brought in is all of the models we use for hardware (screws, nuts, etc.). I am wondering if there is a way to use an existing excel spreadsheet which contains the hardware descriptions to populate the description field of the data cards. This would be a very daunting task to do manually as there are hundreds of hardware items.

Thank you for your help.

Re: populating epdm data card field from excel spreadsheet

Prasad Bhonsule Jan 31, 2017 3:48 PM (in response to Dan Margulis)

Hi Dan, there are no bulk property update tools for PDM out of the box. It would be possible with programming.

If the files you are looking to update are SolidWorks files, I would look at tools to update their custom properties, and ensuring that the custom properties you are updating are mapped to appropriate variable in PDM data cards.

For a tool that can help update properties from an Excel spreadsheet, take a look at #TASK here, it may be able to help.

http://centralinnovation.com.au/#tab-tools

Cheers

Prasad
Like Show 0 Likes(0)

Actions