Creating Columns In Bom that Pull Info from the Drawing title Block 1

[NTME76249]

Does any one know how to create columns in the Bom that will pull information out of the title block. Drawing number, elect. Sounds repetitive but i need it for my application

 

[fcsuper]

I believe the only way to do this is to have those values stored in the part (whether or not they are also in the drawing).

Matt Lorono, CSWP
Lorono's SolidWorks Resources & SolidWorks Legion
Follow me on Twitter

 

[JMirisola]

Are you manually filling in the title block? If not, why not have the BOM pull from the same source the title block pulls from?
You can create new columns by right clicking on the BOM->insert column. You'll then be prompted as to what the column is for. Once you have it set up as you want, right click->Save As and save your new BOM template.

Jeff Mirisola, CSWP
Design Manager/Senior Designer
M9 Defense
My Blog

 

[NTME76249]

So here is what’s going on. Currently, after we create a drawing we have to save out our Bom into excel and make a lot of modifications such that we can pull it into our company’s inventory system. What I would like to do is skip that step and have a second Bom template that we can insert into the drawing such that we can save it out as a csv. Straight into our inventory system. I need to be able to pull out drawing numbers and Qty and Find No. out of the component custom properties. This is not a problem. The other thing I need to do is to pull the drawing number off the sheet and the description and the revision. These will be repetitive for each item. I also need to generate identical text for each item. If I can match the format for my csv then this will save us about 3 hours a day of labor.
Thanks

 

[SnowCrash]

Not a BOM, but you can insert a SWks general table and link the cell text to any drawing or part properties you want.

--
Hardie "Crashj" Johnson
SW 2010 SP 4.0
HP Pavillion Elite HPE
W7 Pro, Nvidia Quaddro FX580

 

[NTME76249]

In a general table is it possible to make it auto generate rows based on the parts from the bom?

 

[SnowCrash]

I do not have Excel, but I think you can create a SWx bill and link a column to the properties you want by clicking on a cell and selecting the chain icon to link to a drawing or part or assembly property. Maybe you can cut and paste from there?
I know you can then export because I do that with Open Office.

--
Hardie "Crashj" Johnson
SW 2010 SP 4.0
HP Pavillion Elite HPE
W7 Pro, Nvidia Quaddro FX580