Hey.
Our company requires that we put sheet # /page no. in a part balloon when we display a weldment or assembly (pic1). This is so the fabricator can find the specific part in the pack of prints. We have been doing this for a few years with some iLogic I found and cobbled together. The code basically iterates thru all the views and puts a custom iProperty with the sheet number into the part (pic2). As you can see this can add up depending on how many assemblies the part is in. This allows me to balloon the part and pull the custom property with the sheet number specific to the drawing as seen in pic 1. Also the BOM part list also has sheet numbers in the table(pic3).
This all works well with some caveats. The biggest one being the endless updating of assemblies that use the same part.
I would like to develop some code that would build an excel parts table specific to the assembly or drawing that has all the information I need for the BOM and for the balloons. This way the parts don't get changed. I don't see a problem with the parts BOM but with the balloons. The balloons pull information from the part and not an excel sheet.
There may not be any other way to accomplish this task. Any thoughts?
Thanks
John
pic 1 Part sheet numbering
Pic2 Part iProperty
Pic3 BOM
