I'm not sure which section is the best place to post this question, as I'm not sure how to do it.
For a given project (assembly) we have a "master" spreadsheet, that will have all the filenames of all the parts, and all the important information about that part, including information that will end up being in the drawing bom, but also many more columns of information associated with that part (like outsourcing vendor information), important dates, etc.
My question is I would like my master spreadsheet to be the master for all the custom properties in a part. If a part has a custom property, I want that property to be a column in my master spreadsheet. Then if I update a column in my master spreadsheet, for then to have some way of updating the custom property in the part.
Ideally, I would like it to be two way, that is if I update the spreadsheet, it will update the custom property of the part. Or if I update the custom property of the part, it will update the master spreadsheet.
We do not currently use PDM, so I don't know if that is a feature of that. Does anyone know how I can implement this?
Thanks. We are currently using version 2017.
I am not sure if you can have an assembly design table that can drive the custom properties of the parts in the assembly, but you can save the design table outside of the assembly model and then link them together.
Add a design table to the assembly.
Open the design table in a new window. This will open it in Excel.
Save the design table to a folder.
Edit the properties of the table to say from File and link it to the file.
Edit the design table with the desired custom properties like this $PRP@Description
This assembly had two configurations so that is why there are two rows. But I can either edit the design table from within the configuration editor or from the excel spreadsheet.
If you update the spreadsheet you will have to open the assembly before the changes take affect.
If I have time tomorrow I will see if you can add parts to a spreadsheet.