×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel to Catia input for Part Properties

Excel to Catia input for Part Properties

Excel to Catia input for Part Properties

(OP)
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!

RE: Excel to Catia input for Part Properties

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

RE: Excel to Catia input for Part Properties

(OP)
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...

RE: Excel to Catia input for Part Properties

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

RE: Excel to Catia input for Part Properties

(OP)
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?

RE: Excel to Catia input for Part Properties

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...

RE: Excel to Catia input for Part Properties

(OP)
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?

RE: Excel to Catia input for Part Properties

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...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources