i have about 10,000 parts that i need to update the weights into a shared excel file for other non CAD users to update our ERP system. Is there a way to use PDM automation tools to do this?
What do you want to update? ERP or PDM?
If the weight is present in PDM, the easiest way is to create a search that shows the weight. The result can be exported to Excel.
As far as I know, you need a macro that reads the weight from the PDM and writes it into Excel.
do you have a variable with the weight in the datacard ? If yes you can use the report generator and an sql query to export datas to excel.
Yes we have the variable on the datacard, and I have the macro to add the custom property to the parts. The only problem now is opening and adding it to all of the parts. I’m trying to find the best way to do that efficiently.
I want to update our ERP system, but since the data has to be manually entered- I need to first pull the data out of PDM.
totally forgot about the search XD
that's easier than a query !
Retrieving data ...