Search for parts/products without material

[LuKeUmbo]

Hi,
like reported in thread560-455348,
i'm looking for a method to search if, a opened part and/or product with sub assembly, are without material applied.
The result obtained, can be in any type of file (csv, txt, ecc.).
Someone know if it's possibile to do (macro, catscript, VB, ecc.)?

I've got this advise from my previous (closed) thread: Product.GetItem("CATMatManagerVBExt")

But I don't know hoew to develop a CatScript or VBA. I've never learned it at my work or in school.
So I can't use a single string to develop a complete routine
When I find some complete code on the net, often I'm able to modify it to fit to my needs, but starting from scratch is impossible to me.


Thank you

 

[Little Cthulhu]

Hi.

When an assembly is opened, do you want script to analyze subassemblies and nested parts as well?

 

[ferdo]

Hi

Hint: search all body features in a loop for MaterialType and if the count of MaterialType is bigger then 0 grab the values in a file.

First, try macro recorder.


Regards
Fernando

https://www.youtube.com/playlist?list=PL9mSHa4SOedV3dr0D3kfIWFUg7mIYm94k

 

[LuKeUmbo]

@Little Cthulhu:
yes, I need a complete analysis of a product and the nested products/parts.
I need to apply material to all my parts

@ferdo:
for search all body feature do you mean like in the attached image?
I don't know other system for searching inside Catia files


Thanks

 

[ferdo]

Yes, that search.

Regards
Fernando

https://www.youtube.com/playlist?list=PL9mSHa4SOedV3dr0D3kfIWFUg7mIYm94k

 

[LuKeUmbo]

Hi,
with that search I can see the items with a material applied, but I cannot export for a comparison with the entire products/parts.
Is there a command/routine to do this?


Searching around the Web and eng-tips, I've found this post
Post

I tried your attached macro without success. The process stopped with an error on the end of the code (MyXL.Parent.Windows(1).Visible = True) but I've found the generated txt file.
This was probably the best solution for my need, but even if a part/product have a material the relative column is empty. Maybe is possible to modify this script to fit my needs?

Thanks