Re-numbering and re-ordering part list in a assembly model

[Anonymous]

Hello Everyone,

I want to get some advice/tips on how to streamline re-numbering and re-ordering of part list in the assembly. Here is the issue: I design big oil storage tanks, for each model we have 2 drawing page with 2 separate BOM list. 1st one is for fabrication, where all the metal parts are assembles/welds before painting (walls, shells, legs, etc..) and the 2nd page is for all the parts that goes in after painting (decal, serial #, etc...). Currently I use View Representation to create the  two models for Drawing (feel free to advice  if you know better way). I can also filter the two BOM using this method as well. The problem or issue I have is the numbering of the Item in the BOM, they are all over the place. It is time consuming and tedious to go into the part list in the model and re-number each Item one by one specially when you have over 100s of parts.

Now, is there any way either via iLogic or other means that can automate this process.

Eg. Items 1-40 in the BOM are for items that goes in before painting and Item 41-60 are for items that goes in after painting. That way I can place first BOM (Item 1-40) in the first Sheet in the drawing and place the 2nd BOM (Item 41-60) in the second Sheet.

Thanks in advance.

[salariua]

If you have some iproperties or other info to sort by then it's really easy to arrange them. 

Do you have the Part Number, Filename or any other fields as a sequential order to sort by?

Then here are my thoughts on the issue

If you don't, you can create a custom iproperty and use it as a coordinated Item number as Paul is mentioning here.

[mdavis22569]

you can set up a field for say prepaint and after paint ... you could sort by that .... (doesn't have to show up in the BOM)

you'll probably still have to do a little work, but you could BOM it 1-40 and 41- etc ...

You just turn off the rows you don't want to show in the BOM for each page.    I'm sure Ilogic could be possible to turn it off too. I haven't played that deep within it.   

But it would sort for you then turn off say with a starting with prompted value, or a controlled value.    A second code would be made for the nexst page if it's a controlled value, turn off row 41 thru .....     

[Anonymous]

Can you please elaborate on what you mean by setting up custom fields.

Here is an example of a typical workflow: I have an assembly that has 60 parts. Out of these 60 parts 40 goes in before paint and 20 after paint.  On my first page of drawing I need a BOM that places Item # 1-40 and on the second page Item # 41-60 (this can easily be done by using filter in the BOM window). The problem is that the 40 items i want to place on the first sheet are mixed with the other 20. Currently what i do at the moment is i go into the BOM in the assembly and manually find each Item that will be part of the first 40 item and renumber them 1 to 40 and sort it out that way.  As you can see it is very time consuming and tidious.

Is there anyway to add a tag to each of the item that will go before paint and a different tag for each of the item that will go after the paint, after that using some sort of iLogic rule to sort out the BOM where iLogic places item with certain Tag are placed on top of the BOM list and item with other Tag are placed at the bottom of the list?

[rhasell]

Hi

Have a look at my blog post.

Reg Blog

I have created custom fields to allow more detailed sorting of the BOM.

Some of the code has been "Borrowed" from various post on the forum and Curtis as always.

This might be of use to you.

[Anonymous]

If i understand correctly from reading you blog is that you assigned a custom field called '****' to all you part and used iLogic rule to force the item to be place on top or bottom of you list?

Can this be modified and use for Assembly?

[rhasell]

Hi

Yes that is correct. I used the 'z' to force the items to the bottom of the parts list. (I use 'x' as well)

There are three areas available for sorting the parts list. I am making use of all three to try and get a consistent sort throughout a project.

I used "Cost Center" as a broad strokes sorting, eg, all TUBES, PLATES, EXTRUSIONS, FASTENERS are placed together.

Then "TYPE" narrows down the sort a little further, EG: within TUBES, we get CHS, RHS, SHS.

The "Stock Number" will fine tune the sort even further.

I am not 100% sure of your question, this is for an Assembly already, it will work for Both "Parts Only" and "Structured" Parts Lists

As mentioned in my Blog, I will sometimes have more than one Parts list on my drawings, I will use a structured Parts list for member marks, but also show the Parts only Parts list as well.

I have tried doing this from the Assemby BOM, it does not work well.

It is far easier from the Parts list in the drawing environment, then write the changes back to the Assembly BOM.

You may want to add your own fields for sorting, just remember, keep it to a maximum of three fields. (one being paint/finish)

If I get a gap, I will try and post an example.

[mdavis22569]

probably could be made via custom iproperties and ilogic.... and some testing ...   

Maybe make it stage 1, stage 2, stage 3 ... and they get a value.   My concern is more the renumbering.    It's almost sounding like there needs to be new levels of detail or assemblies that come about during these stages. 

[kennyj]

As mentioned by others already, we use the "Category" filed in iProperties. For us we sort by the areas of the shop: Metal, CNC, Paint, Purchased, etc. Then in the BOM we do a sort by Category, then renumber. So all of our part numbers are grouped by area. Then we turn off the category column, and will sometimes even turn off the different categories to create custom BOM for just Purchased, etc. The best part is you can change it all from the BOM, so you don't have to go part by part, and if you get in the habit of setting the category as you go even better.

[IgorMir]

For a simple parts rearranging in the BOM - open up a BOM, highlight the part you want to move up (or down) on the list and drag it to where you want it to be, then click Renumber button. Just like it is shown in the attached image.

Cheers,

Igor.

---

@Anonymous wrote:

Hello Everyone,

I want to get some advice/tips on how to streamline re-numbering and re-ordering of part list in the assembly. Here is the issue: I design big oil storage tanks, for each model we have 2 drawing page with 2 separate BOM list. 1st one is for fabrication, where all the metal parts are assembles/welds before painting (walls, shells, legs, etc..) and the 2nd page is for all the parts that goes in after painting (decal, serial #, etc...). Currently I use View Representation to create the  two models for Drawing (feel free to advice  if you know better way). I can also filter the two BOM using this method as well. The problem or issue I have is the numbering of the Item in the BOM, they are all over the place. It is time consuming and tedious to go into the part list in the model and re-number each Item one by one specially when you have over 100s of parts.

Now, is there any way either via iLogic or other means that can automate this process.

Eg. Items 1-40 in the BOM are for items that goes in before painting and Item 41-60 are for items that goes in after painting. That way I can place first BOM (Item 1-40) in the first Sheet in the drawing and place the 2nd BOM (Item 41-60) in the second Sheet.

Thanks in advance.

---