BOM list - all parts and assemblies

[geertdaenen]

Dear all,<?:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" />


we are working with ProE WF3 and the structure of the assemblies we are making is like this:


Main assy: MA1
this main assy consists out of a few sub assy's, ex.: SA1, SA2, SA3
And these sub assy's consists all out of a lot of parts: Prt1, Prt2, Prt3,...


So the structure will be like this:
MA1
SA1
Prt5
Prt1
Prt6
Prt5
Prt3
Prt10
SA4
Prt25
Prt13
Prt64
Prt3
Prt10
SA2
Prt6
Prt3
Prt2
Prt3
Prt15
SA1
Prt5
Prt1
Prt6
Prt5
Prt3
Prt10
Now we want to create an excel-list which will have this structure (we need this structure for the Mabec TDI list of Renault):
Name Qty Description
MA1 (1x) xxxxx
SA1 (2x) yyyyyy
Prt1 (1x) gsdsdgs
Prt3 (1x)

 

[telecomguy]

Kinda sucks when you type a long reply and enter the wrong Captcha. I try to copy long replies before submitting for that simple reason, but not this time...

Here's a solution that may be better than what you are doing now. Attached is a BOM table file you'll need to extract somewhere. It is a recursive BOM formatted like you requested. Here's how to use it:


Create a drawing and place a view of your top level assembly.


Insert this table by selecting Table / Insert / Table From File...


Select the cell under the Part Number heading and edit it to reference your part number parameter (or model name if that's what you use) and similarly adjust the Description column. Adjust column widths as required and you'll probably have to adjust the Indentation in the 2nd column depending on the length of your part numbers (Table / Repeat Region / Indentation). Now update the table by selecting Table / Repeat Region / Update Tables.


Select the table and save it to a text file (Table / Save Table / As Text File...). Also save it As Table File for future use.


Open Excel and then open this text file (change file types to All Filles (*.*))


Use Fixed Width and adjust the columnsfor best import. The Qty columnhas some extra spaces in itthat you may want to remove. Just select the column and Ctrl-H replacing (space) with nothing.


Good luck. <tg>


2012-01-06_174410_structured-bom.zip

 

[geertdaenen]

Dear telecomguy,


thanks for your answer. This already helps me a bit, but this is not yet what I really want.
Here you can see a screenshot of the table which I've made with your sugestions: 2012-01-09_034448_Table.zip


There are a few thinks I would like to change or add:

1. 
   <LI>As you can see the part called "plate" exists 4 times in the sub-assembly "EOLT RETOUCHE". Well in the table, this part comes back 4 times. I just want to have this part 1 time in the list, and have filled in by QTY "4".</LI>
   <LI>I'm not able to have the column "QTY" (quantity)filled in automatically. I have filled in "&rpt.qty" but this will not help.</LI>
   <LI>And than one more thing, but this is not an easy one I think: in the column "Mat

 

[s_pme20]

you need to change table>repeat region>attributes>No duplicates/level to eliminate parts repeating on list

 

[geertdaenen]

Thanks, this allready solves my problem 1 and 2.
Does anybody have a solution for my 3th problem as well?


Regards

 

[s_pme20]

Not sure, but just for a thought:
you need to create table relations like,
if rpt.level == 2
Mat

 

[telecomguy]

Hmmm, I guess it didn't save the 'No Duplicates/Level' attribute. That's how I had it in my drawing so I didn't have the problems 1&2 you mentioned. Glad s_pme20 was able to solve it for you.


And I thought the goal was to export to Excel with the MABEC column indented based on the level. If you did this, you could then use Excel's auto-fill feature and just drag the "E267 346 100" down and populate your table.


<tg>

 

[geertdaenen]

Well, the problem about the dublicates is solved. Thanks for this.


But the problem about the higher MABEC level is not solved if I do it in Excel. Because we have a lot of sub-assy's and a lot of parts.
So every part in sub-assy A has to have the MABEC number of sub assy A in the column "MABEC" and all the parts of sub-assy B have to have the MABEC number of sub-assy B in the column, and for C the same,...


So what s_pme20 is thinking about might be a solution. But I don't know neither what to fill in for XXX and YYY.

 

[s_pme20]

I think telecomeguy is right about using formula in excel instead of relations in Pro-E..
It does the same thing, but You will have more flexibility of using relations in excel than pro-E..

Anyhow, you need to do some manual manupulations to arrive at final results.

 

[SRINIVASANIYER1]

What you need looks like an Excel "Pivot Table". To
achieve the table you must have your data formatted as...
An example of the same is attached in ODF Spreadsheet file
format. Refer to both "Sheet 1" and "Data Pilot sheet".

<a target="_blank" href="uploads/SRINIVASANIYER1/2012-01-
<br / target="_blank">10_012342_Data_Pilot.rar">2012-01-
10_012342_Data_Pilot.rar</a>

 

[geertdaenen]

Well,


I'm still busy with this list. I've allmost solved all my problems. But there is still one more problem:
If you take a look at the printscreen enclosed: 2012-02-07_072034_Tabel.rar . You can see that the cells in the column "Filter" only are filled in when something is filled in in the column "N

 

[geertdaenen]

I'm sorry, I was forgoten to tell that you can see the example of the table in the drawing 0000.drw.


Regards

 

[geertdaenen]

Well, I've found the solution by myself.
It's very important that you have to be sure that a parameter in a part exists, before you use the parameter. So you first have to check if the parameter exists by this kind of rule in the relations (it's just an example):


IF exists("asm_mbr_DESCRIPTION")
DESCRIPTION=asm_mbr_DESCRIPTION
ELSE
DESCRIPTION="***"
ENDIF


Thanks anyway for all of your help!