Ilogic To Create A Table In Part Drawing File For Where Used

[matthew]

Hi All,

I wondered if anyone could help me out with an existing script to create a table in a drawing file where the script would look at all assemblies the part is used in then would return a table to be placed say in the top right corner. The table would be have a title of "Where Used" and two columns with rows to be determined by script. Column titles would be "ASSEMBLY" and "QTY". 

Hoping this is something somebody has done already. Appreciate Design Assistant can tell me where used but it won't tell me the QTY.

[bradeneuropeArthur]

Are you using Vault?

[matthew]

No I am only a small business so using NAS box as server at the moment.

[A.Acheson]

Hi @matthew 

Will the drawing reference the very assembly you need to pull the BOM qty from? If it does it sounds like you are recreation the partlist!

If it does not you will need to supply the root folder for the project workspace and then search for every assembly and then search it's reference documents for one thst matches the part. It will be a time consuming process to check all the files. Can you confirm what your criteria is? 

[matthew]

Hi Alan. It's the latter. So these are common parts that are used across multiple sub assemblies and then all sub assemblies exist in the top level assembly. I did find some ilogic that will search through the folder that the drawing exists in and would return a note list in the drawing but this was only a list of assemblies the part existed in without quantities.

[A.Acheson]

If you have some logic to show the assemblies then it is easy to extract the qtys. Can you share this code as a starting point? Having to use inventor to find such items is resource heavy and you can't use inventor while this in going. You could of course use task scheduler to just run a rule while your not using inventor at a specific time.