Hello community,
I work for a very small company where we design furniture in kits for converted vans.
I have just set up a spreadsheet for the management of our hardware stores and bills of materials.
To make my spreadsheet work perfectly, I need a column in my BOM extracted from SolidWorks where the furniture reference (assembly file) appears on each line. I could then import my nomenclature directly into my spreadsheet without needing to touch up anything.
I can't find the solution, if it's not possible, there's always the possibility to add the column manually in my google sheet file but it adds manipulation and risk of error.
Thank you for your help
Hello Man_SRVL, (SW2022SP4)
And we use that=>
for our nomenclatures.
But it is possible to extract an excel directly from SW, going directly through your 3D or 2D, to extract an excel, you just have to open your assembly or your drawing, point to your nomenclature and save under an excel.
There you go, there you go, ... Good luck.
@+.
AR.
Hello,
It will not be possible to call a property of the document in the BOM table.
However, you can deploy the assembly name -or other text- with a column formula:
Hello,
Thank you for the feedback, I have no problem saving my Bill of Materials from SW in excel.
And it is not current to take a MYCADTOOLS license (I am not a decision-maker).
My problem is that I would like to make the reference of the furniture (assembly) appear on all the lines of my nomenclature.
OK thanks,
I just tried, this may be a solution indeed.
But it's the same as creating the column directly in google sheet after extraction from SW and filling it in practically, without the ergonomics and ease of implementation.
But I take note.
It's a shame not to be able to retrieve this data directly.
Hello
BOMs work like excel, a simple formula can work
Hello,
OK, but what is the formula to enter to retrieve the property of the assembly file?
I know that for a part file you can look for a property by calling $PRP: " NOM_PROPRIETE ", for a welded part $PRPWLD: " NOM_PROPRIETE " but here I can't find it...
Using the $PRPMODEL:" DESCRIPTION " data in a column formula as mentioned by
, I was able to retrieve the DESCRIPTION property of my drawing document.
Which is already great.
So, now, is it possible to link the DESCRIPTION property of the drawing document to the REF_MEUBLE property of my assembly with a formula?
Yes
In this kind (formula that I got from my nomenclatures but which is not suitable for you)
IF(REFERENCE FOURNISSEUR<>" »;DESCRIPTION " - " REFERENCE FOURNISSEUR;DESCRIPTION)
But I only know about it