List of Every Product and Part 2

[jzecha]

Is there a way to export a BOM/List of every Product and Part in a Catia Product?
I would like a full list of everything, not broken down by each Product.

 

[ferdo]

V5? 3DEx?

If is V5 you can modify the default BoM to look how you wish.

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

- Romania

https://picasaweb.google.com/103462806772634246699/

- EU

 

[Costin Ruja]

Please see thread560-442453.

Might be what you are looking for.

Best regards,
Costin Ruja

 

[jzecha]

Wow, I completely forgot I posted that thread over a year ago and didnt ever see the final response.

That is exactly what I was looking for.
Thanks for the reminder.

 

[jzecha]

costinruja, I am having problems figuring out how to perform step 4.

Could you please elaborate exactly how step 4 is accomplished?

 

[Costin Ruja]

Good morning,

At the moment i'm out out of the office. I'll post you some pics and a step by step guide as soon as i get back.

Best regards,
Costin Ruja

 

[Costin Ruja]

Step 1: Add an "index" column

Step 2: Filter your relevant column by the term "Recapitulation". This should give you only one row.

Step 3: RMB on that number in the index column and select "drill down" This will output that number as a value and you can use it in the next step.

Step 4: Duplicate the query and delete some steps. Finally you can filter top rows. Please see the formula bar and how to use the number from step 3. You need "+4" because you also have to filter some 4 preset rows where Catia writes some stuff.

Best regards,
Costin Ruja

 

[jzecha]

Thanks for all the help this has worked great with my limited excel abilities.

I have a few questions:
1. Does the "query_index" need to be changed to the format that shows a 123 the the left of the title?
I was able to get all of this done and it seemed to perform correctly, but my "query_index" shows up just like the "query_parts" in your picture as a sheet.

2. My product has multiple of the same assemblies, is there an easy way to combine duplicate rows and have it add the Quantity column together?

3. What is the best way to implement this for future uses?
Can I set this multi-query / combination up as a Macro to run on the exported BOM when I open it in Excel?

 

[tesak]

This is pretty easy task, you can use recursion. Please, take some inspiration from here:

https://scripts4all.eu/export-a-product-structure-to-excel-in-vba/

To count the total amount of unique parts & products, you can use a dictionary.

Tesak

https://scripts4all.eu/play-tetris-in-catia-v5-drawing-vba/

- Play Tetris in CATIA V5 drawing

 

[Costin Ruja]

A similar approach was done by a colleague of mine, but we are having trouble reading the "do not show in BOM" attribute. Can this be done ?

Best regards,
Costin Ruja