AnsweredAssumed Answered

Ho wdo I create a BOM using the filenames fo reach part instead of part numbers

Question asked by Dmitry Ponomarev on Feb 27, 2017
Latest reply on Feb 28, 2017 by Jim Steinmeyer

Like • Show 0 Likes0
Comment • 5

The feature of solidworks to label all the parts using the part number instead of the filename seems to have received a lot of complains.

I have an issue where I have a large assembly and a lot of my parts are made from the same basic part, that originally had a part number

(think aluminum extrusions of different length)

Now, all I need is to export a BOM, but every time I try to export it, it makes it so that each item in BOM uses the Part number defined for that part, instead of the filename.

All my filenames for different lengths of aluminum contain the length, so all I really need is to export a table with each filename as a row, and the number of times that filename repeats in the assembly as the column,

But solidworks 2015 wont let me do that,

Is there a way I can do it without changing the part number in each individual file???

If not can someone give me some instructions on how to do this quickly

Thanks,

No one else has this question

Outcomes

John Stoltzfus Feb 28, 2017 7:40 AM

Did you try to right click on the BOM and save as an Excel File??

Actions

Deepak Gupta Feb 28, 2017 8:32 AM

You can change the column property to pull the part number property from the models.

Actions

Ed Cyganik Feb 28, 2017 1:35 PM

Input BOM

Edit the "Part Number" column (or create a new column)

Double click on column heading , then select "Custom Property" for Column type

Then select "SW-File Name" for Property name

Export as required.

Actions

Steven Mills @ Ed Cyganik on Feb 28, 2017 1:41 PM

And maybe another column that tells the configuration used as well.

Actions

Jim Steinmeyer Feb 28, 2017 2:33 PM

Dmitry,

In case you do not follow what they are saying. First you place the BOM and then double click on the part number heading in the BOM 1. It will edit to allow you to change the heading. with that active select the Link To Property 2 icon and it will open the Link Dialog box. Select : Model found Here 3 and from the Property Name box 4 you can select any Custom Property and many SW properties to have shown in the column.

This will get the desired property shown in the BOM. To sort by the desired column,pick in the BOM and then Right Mouse Button on it and select Edit Sort:

You will be allowed to select which Column you want to sort by and which order. If you select the save sort box below this sort will be saved even though you may have to select the Sort button every time the BOM changes. You can then save the BOM as a specific BOM template and use it anytime you need.

Actions

5 Replies

John Stoltzfus Feb 28, 2017 7:40 AM
Mark Correct
Correct Answer
Did you try to right click on the BOM and save as an Excel File??
Like • Show 0 Likes0
Actions
Deepak Gupta Feb 28, 2017 8:32 AM
Mark Correct
Correct Answer
You can change the column property to pull the part number property from the models.
Like • Show 0 Likes0
Actions
Ed Cyganik Feb 28, 2017 1:35 PM
Mark Correct
Correct Answer
Input BOM
Edit the "Part Number" column (or create a new column)
Double click on column heading , then select "Custom Property" for Column type
Then select "SW-File Name" for Property name
Export as required.
Like • Show 0 Likes0
Actions
- Steven Mills @ Ed Cyganik on Feb 28, 2017 1:41 PM
  Mark Correct
  Correct Answer
  And maybe another column that tells the configuration used as well.
  Like • Show 0 Likes0
  Actions
Jim Steinmeyer Feb 28, 2017 2:33 PM
Mark Correct
Correct Answer
Dmitry,
In case you do not follow what they are saying. First you place the BOM and then double click on the part number heading in the BOM 1. It will edit to allow you to change the heading. with that active select the Link To Property 2 icon and it will open the Link Dialog box. Select : Model found Here 3 and from the Property Name box 4 you can select any Custom Property and many SW properties to have shown in the column.

This will get the desired property shown in the BOM. To sort by the desired column,pick in the BOM and then Right Mouse Button on it and select Edit Sort:

You will be allowed to select which Column you want to sort by and which order. If you select the save sort box below this sort will be saved even though you may have to select the Sort button every time the BOM changes. You can then save the BOM as a specific BOM template and use it anytime you need.
Like • Show 1 Like1
Actions

Ho wdo I create a BOM using the filenames fo reach part instead of part numbers

Outcomes

Related Content

Recommended Content