I'm here to ask for your help because I'm trying to extract a bill of materials from a SOLIDWORKS assembly that contains data tagged in " Component Reference ".
For example, my valves (single reference) have different TAGs (" RH-VM-01 ", " RH-VM-02 ",...) and I would like to have the complete list of all these TAGs in excel . But when I do the extract, the tool brings together all these valves because the same reference and only a TAG goes up instead of listing them all for me.
How do you do the extraction? Via the assembly plan nomenclature, with a Tirs software such as Smartbom (MyCadTools Visiativ)? Then see how the grouping is done at the extract level according to the method used. Are the TAGS in a custom property? Edit: A small screenshot before/after extraction can also help with understanding
Tested on assembly or drawing. As soon as the " Component Reference" column is displayed, it displays one row per component without grouping them. SW2023 SP5 Edit: by saving the table in Excel
TAGS are written directly to the component's property under component reference:
For the extract, I tested with the SmartBom of MyCADTool but also with the insertion of a nomenclature table in the tree structure that I save in excel afterwards:
here we can see that the BSPxxxxx valve is debited in x24 quantity but I only have a TAG (EI-VM-018) which goes up instead of 24 TAG and therefore quantity 1.
Tested under Smartbom, it effectively groups the lines without taking into account the different component ref. It is however very possible that I missed an option, do you reproduce the problem @fmarchand ? On the other hand, no problems in extraction under excel via MEP.
Indeed, I validate that it works well by going through the drawing, by generating the nomenclature in this same layout and by saving this nomenclature in Excel.