Excel to Catia input for Part Properties

[SREYNOLDS28]

Hello All way smarter than me, I want to start again by saying this website is awesome and full of amazing people!

I was wondering if anyone has ever heard of a way to back-feed catia an excel sheet of info for things like property names and such. I thought since Catia is so user friendly with excel and you can save out to excel don’t you think there would be a way to fill out an excel form and transfer it into catia with some Macro that finds the Part name and then inserts properties based on your excel sheet/part name column?

Thanks in advance, any response is appreciated!

 

[itsmyjob]

most of the information can go both way: catia <==> excel.

I am sure that if you provide all necessary information you can build an assembly from a BOM in excel.

Can you detail what you are looking for?

Before you do any code, it is always nice ( read recommended / critical) to define what you need:

what is the input
what is the output
...​

Eric N.
indocti discant et ament meminisse periti ​

 

[SREYNOLDS28]

Thank you Eric, Here is a link to a BOM that I hand type in all Properties except for the L1, L2, L3, L4 and Dia those are Formulas...

I have another company that requesting all different custome part properties and it would be nice if I could type it out in an excel format and then send it to Catia to fill out internally...

 

[itsmyjob]

That should work, but you need also information about where to get ref file from, and where to save new file.

a VBA script could get info from your file and build the assembly in CATIA but you will have to position elements by hands...

Eric N.
indocti discant et ament meminisse periti ​

 

[SREYNOLDS28]

I'm kinda lost is there any way to insert this into an existing ccatia session and it updating all my cat parts if they already have the properties names?

 

[ferdo]

Hi,

As Eric said, yes, you can insert products or parts in an existing CATIA session, and even positioning them with the condition to know their matrix position in the product where you want to heve it, otherwise you have to position them manually.

All this can be done in a CATIA or Excel macro. Properties names will help you eventually in programming.

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

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

 

[SREYNOLDS28]

No I think I am explaining it all wrong....

What I mean is when you go into the properties of a catpart and type in all of the parts added properties like the definition lets say. Instead of going into each part and filling out the definition is there a way to just fill out an excel form for the entire job, for each part and product. Fill out the definition in the excel sheet complete then transfer that excel sheet into your job and let IT fill out the properties in the data rather than the reverse?

 

[ferdo]

Yes, you can take the information from excel (or a text file) and fill properties of CATIA files. You need to explain very clear to someone who can program all this stuff. This can be done in different ways, depending also if you are using a PLM system or not, if you want to do it in an opened CATIA session or if you want to open files one by one.

Take in consideration the time to develop something like this and see if worth the money or not.

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

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