from the different basis the excel foglio

[doriano]

Good morning to all
I have this problem and I don't know if it has already been treated. I have an equipment of 4 pieces of molds between them repeat to 60% both the parts, and the commercials. the question is this: the company that commissioned me this project wants me to put all the parts and commercial in a excel sheet doing the sum of everything (part ,commercial ) the reason is that they are not equipped to do it inside and do not want to put themselves with the 4 assemblies in front and sum everything for fear of wrong!!!!
to speed up it is possible to automatically create an excel sheet from the axieme so as not to do it manually.
Thank you.
p.s. work with catia v7 r19

 

[mcbramby]

Of course you can ...................
in the product menu analysis / separate base , if you have personalized info
with inside data, you configure the separate
with what you want to see and save by name by selecting the file
in excel...... You do it x all 4 and you're done.
otherwise create a product throws it inside the 4 assemblies and create a total distinction of that product with all the same pieces already counted ....................... :

 

[doriano]

Of course you can ...................
in the product menu analysis / separate base , if you have personalized info
with inside data, you configure the separate
with what you want to see and save by name by selecting the file
in excel...... You do it x all 4 and you're done.
otherwise create a product throws it inside the 4 assemblies and create a total distinction of that product with all the same pieces already counted ....................... :

Thank you for the answer but there is a problem to put the 4 assemblies in a set, both the equal parts and the equal trades go into conflict and I should rename them what I don't have to do.
Is there any other solution?
Hi.

 

[mcbramby]

you will get out of the errors xché catia sees the names part equal but the files do not have the same code and x catia the files are different.......
You could make four separate pieces, put them together and then the orders for the name of the part, at this point if you have 4 equal pieces in the four assemblies you find them in a row, it's not the top if you have a tide of files................ otherwise a macro in excel that reads the 4 files and recopy by adding the number pieces in another file.................... but here we are in the visualbasic field, or if you have someone in the office who slew with excel and helps you there are some instructions that already do something like that.................. I don't want to be wrong and say a beaver but it should be like this

 

[falonef]

Perhaps I can help you: there is also the possibility to open the assembly .catproduct and to save the whole in .txt format.

from here open the .txt copy and paste into an excel file.

The rest you should do it yourself

 

[mcbramby]

. . . . . . . . . . . I have done a quick test because I have never used it, then the numbers pieces if you have to count them by hand..................... or I'm wrong (maybe)

while making the pieces separate, at least for each set, are counted

 

[Vittorio]

Good morning, everyone.
I join the mcbramby solution, because it is the only fast solution to get the result of the total pieces.
you create a new catproduct and insert the 4 catproducts of the molds. It is true that he warns of a conflict of parties. but it is reported only to the names of the 4 catprodut inserted. you perform automatic renomination of the 4 names.. and then generate the distinct base with its xls file.
ps.
on the xls file. at the bottom, there is the summary of the catproduct with the total number of pieces.

Hi.