Level Paramter for Indented BOM?

[fiebigc]

I am trying to export a bill of materials. I've created a bom_format.fmt file that prints the BOM in CSV format so I can open it in Excel. I would like the exported BOM to be an indented BOM but I do not know what the syntax is for the Level.

Please see my file below. What syntax will provide me with the part level (where I have '???')?

Thanks.


<div style="margin-left: 40px;">.summary

Summary of parts for assembly %$name

.titles
Part Number,Qty,Part Name,Level
.row %part_number,%$quantity,%$name, ???

</div>

 

[fiebigc]

I'm open to any suggestion for creating an indented BOM from ProE. So far I haven't found any information that ProE will export an indented BOM (something I find hard to believe).

 

[anwyl]

To create a level information column in a drawing or report table use &rpt.level (this is what will show in the cell Properties box).

I export the table in CSV format and in Excel use this formula to create the indenting: =REPT(REPT(" ",indent),Level-1)&Cad_file_name. There is a space between the quotation marks.
In the formula "indent" sets the number of spaces per indent (try 3), Level is the imported level column, Cad_file_name is the imported column to indent.



Edited by: anwyl

 

[fiebigc]

Anwyl,

Thank you for the reply. I was hoping to export an indented BOM from the assembly file. You offer a good work around however there are a couple of hiccups.

1. I need to recursively display all components and levels of the BOM. I found how to recursively display a sub-assembly but you have to select it manually. The assembly size I am dealing with does not make this practical.

2. The quantities doesn't seem to work. When I set a column in the repeat region to rpt.qty I only receive a blank column.

 

[anwyl]

Try loading this table file into a report or drawing and see if it gives you the information you want.

The file reports all components recursively in an indented structured format. It also shows the component type (part or Assembly), the quantity per parent assembly, and the depth.

The recursion is set using Table / Repeat Region / Attributes. The settings used are No Dup/Level, Recursive, Bin by Part.




2012-07-25_151717_structured_bom.tbl.1.zip

Edited by: anwyl