Pro/ENGINEER Forum: another bom question

Active Topics

Help

Assembly
Pro/ENGINEER Forum : Assembly

Topic: another bom question

Author

Message

<< Prev Topic | Next Topic >>

housta
Member
Member

Joined: 09 June 2008
Location: United States
Online Status: Offline
Posts: 8

Posted: 30 September 2008 at 8:04am \| IP Logged

I apologize if this topic has been beat to death, but after looking through the old posts I am still confused on this issue. I have an assembly in the concept stage and I want to create a bom, preferrably in excel, and at this point the only parameter I want other than part name is the mass in cubic inches of each part and or subassembly. I need to be able to share the weights with my team in a useable way.

To make a long story short, how can I create a bom that shows the part weights, then what is the best way to create a readable bom that I can send to non-cad personnel?

Thanks in advance, and once again, sorry for beating on a dead horse!

Edited by housta on 30 September 2008 at 8:14am

rudresh.hm
Veteran
Veteran

Joined: 05 February 2008
Location: India
Online Status: Offline
Posts: 154

Posted: 08 December 2008 at 4:41am \| IP Logged

you can creat an analysis feature to calc volume at required point on the model tree or use defaulf volume, mass prop param value in a param. in the model tree of the assy you can set the column desplay to show up mass prop i, e volume and export this to excel.

or try in intralink if you use it.

__________________
Rudresh HM
(using WF 3)

brenyw
Member
Member

Joined: 09 June 2005
Location: Australia
Online Status: Offline
Posts: 38

Posted: 10 December 2008 at 5:56pm \| IP Logged

It might sound long winded, but it is easy to do the following:

create with notepad a file called say bomformat.fmt
containing the following syntax:

.breakdown
%$type %$name contains items
.titles Part Number;*Mass;*Qty
-------------------------------------------------------
.row %$name[-20.20s]; *%mass[-5.2f]; *%$quantity[-3d]
-------------------------------------------------------

Create a line in your config.pro bom_format <path>\bomformat.fmt
where the path is the location on your computer, on mine it would be
bom_format C:\formats\bomformat.fmt

Make sure all of your parts have a parameter called 'mass' defined by the relation mass=mp_mass("")

This should work for mass of parts. The the 5.2f refers to real numbers (floating point), the 20.20s refers to number of spaces for string value, if you want to display an integer value then use say [-3d] which allows 3 spaces, you can change to suit. Preceding with - causes the columns to left justify. The system supplied attributes (name, quantity) are preceded with %$, mass is a user defined parameter and only preceded by %.

The reason for inserting asterisks is for importing into excel. Pick 'info', then pick 'Bill of Materials', then pick 'both' so you can see if the bom layout on the screen is what you want.

A file will be saved with the extension .bom.1
Open excel then go open files, all types, find the relevant fie then you will see the text import wizard, click 'delimited' then next, click 'other' and place an asterisk in the box. Then go 'next' and 'finish'. The asterisk causes each column to separate.

The data will then be on excel, save the file as a .xls and the job is done.

The task of getting a useable excel sheet from this method takes less than 1 minute.

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.2656 seconds.