Quantity Column in BOM
Scott Pierce
that have lots of fasteners. I have run into 2 problems:
1) We sometimes use different configurations of a part in a single
assembly. Each of these configurations has its own part number which I
store as a configuration-specific custom property.
The "PART NO." column of the default BOM template will only list either
the name of the part file or a number which is assigned as the
document's summary info title. Both of these are specific only to the
file, not to the configuration. I can make a new custom BOM column
which lists my configuration specific part number, but if I
subsequently delete the original "PART NO." column then the "QTY."
column no longer picks up the quantities of each part. And from what
I've tried, there's no way to create a custom "Quantity" column that
automatically picks up the part quantities (assigning the "quantity"
name to the column in Excel doesn't work).
The gist: How can I get quantities of each part CONFIGURATION listed
seperately in a BOM?
2) We generally don't model-in all fasteners as the models get too
large and slow. However, we often want to show one or two of a
particular fastener in an assembly drawing in order to clarify the
assembly process. So here's the problem: If I put one fastener into
the assembly model, but the assembly actually uses 100 of these
fasteners I'd like to be able to change the value in the "QTY." column
from 1 to 100. But I can't change the value in the "QTY" column and
have it stay changed after a regen (a regen changes the quantity back
to 1, the number of fasteners in the model).
Is there any way to change the quantity and make it stay changed?
This whole fastener issue is so common, you guys must have come up with
some good approaches for handling this. I would welcome your
ideas/suggestions.
Thanks very much.
--
Scott Pierce
Sr. Mechanical Eng.
MI Technologies
Duluth, GA USA
Sent via Deja.com http://www.deja.com/
Before you buy.
M.B.Stephens
To provide a separate part no. for each configuration of a part within your
BOM
1) click on the configurations tab to show the config "tree"
2) right-click on the configuration and select properties
3) select advanced
4) select use name below and enter your part no.
Your BOM will now update correctly with different part numbers and
quantities for each config.
As far as changing the quantity and having it stay changed, I simply
de-select "Automatic Update of BOM" under tools, options. This will freeze
the BOM. You could also hide the quantity column and put in your own dummy
quantity column. Cut and paste the numbers over from the real one to the
dummy, and change whatever numbers you want in the dummy column. Then you
have access to both.
You can also have a custom description for each configuration using the
method you are now using for part numbers (You obviously know how to do
this part of it Scott, I'm just including this for reference for any
newbies who might be lurking). This assumes that you are going to use a
custom property to set the description. I use "Descr", as in the example
below.
1) Activate the configuration you want
2) In the main document, click on the pull down menu's File & Properties
3) Select the "Configuration Specific" Tab
4) Enter the Name "Descr" and the Value "Part Name Here"
5) Repeat for other configurations as required
Another useful thing avialable in right-clicking configurations and
properties occurs in sub-assemblies. If you have a sub-assembly that you
use a lot, and call out as a standard part (but don't want all the sub-assy
parts to show up in your BOM), you can do the following.
1) Click on the configurations tab to display the configurations "tree"
2) Right click on properties
3) select Advanced
4) You can now tell the SWX to treat this as a single part in your BOM
Regards
Malcolm Stephens
Machine Design & the Art of Engineering
Visit the Gallery at www.stethour.com
sambo...@my-deja.com
SW Bom template. Use the excel hide command to hide the row / column
instead. I had the same problem with qty's not showing up because I
did the same thing you did (deleted a column). If you hide a
row/column it will not come back when the bom regenerates.
Also with creating a custom qty column that you can type in the
qty's, surely some of the qty's you do want to update automatically so
try creating an excel link between the SW qty column and your new qty
column for those items but do not link those items that you do not want
to update. :)
I have not tried this trick but sounds like a winner..........
Good luck.
Jason Capriotti
If you have alot of configurations.....using a design table. Fasteners
for example. You can Input the same information in the design table.
Create a column heading in the excel design table called:
$partnumber
This is what Solidworks uses to fill in the Part Number field. If you
look in the BOM template...its the Cell name for that column. Each
column heading has a Name.
Next create another column in your design table called:
$prp@description
This will create a custom property you specify for each configuration.
Solidworks also inserts this text into the description field on
Automatic BOMS. You can also create the custom property without the
design table....under File/Properties.......just make sure it's spelled
correctly.
I can send you our design table template with this information already
there if you like.
--
Jason Capriotti
Thyssen Dover Elevators
Kern-Tech
--
Best Regards,
Engineering Department
Kern-Tech
405 E.19th Street
Bakersfield, CA 93305
Phone: 661-323-1561
fax: 661/323-7844
e-mail: en...@lightspeed.net
http://www.kern-tech.com
"Jason Capriotti (JC)" <gilda...@xoommail.com> wrote in message
news:87qe8o$dv9$1...@nnrp1.deja.com...
Don Jackson
Don Jackson
Jason Capriotti
There a link to xdrive.com with login and password given.
Good luck
In article <38A1A5A5...@airfiberinc.com>,
Lars Eriksen
> large and slow. However, we often want to show one or two of a
> particular fastener in an assembly drawing in order to clarify the
> assembly process. So here's the problem: If I put one fastener into
> the assembly model, but the assembly actually uses 100 of these
> fasteners I'd like to be able to change the value in the "QTY." column
> from 1 to 100. But I can't change the value in the "QTY" column and
> have it stay changed after a regen (a regen changes the quantity back
> to 1, the number of fasteners in the model).
The simplest (if not necessarily always the best) solution to this is to
insert all those fasteners (typically using a component pattern) and then
hiding the ones you don't want to show. (Select the second or third
fastener, shift-select the last one, hide.) Hiding components speeds up
rendering (rotation etc.). The disadvantage is that it presumably does not
reduce memory usage or speed up regeneration.
Lars
Wayne Matus
that SolidWorks uses. For Items that SolidWorks gives the correct qty. copy
the SolidWorks QTY cell to your QTY cell. On others, you can key in the
quantity that you want and SolidWorks will not change it.
Wayne
Lars Eriksen wrote in message <3qXp4.30074$in5.5...@news1.online.no>...