×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

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

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

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

(OP)
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

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

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

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

(OP)
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

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

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

 

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

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

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

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

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources