×
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

Bulk part properties editing

Bulk part properties editing

Bulk part properties editing

(OP)
I am editing the properties (user defined) of all of the parts in a assembly, there are hundreds. I have all of the properties that I am inputting listed out in an excel document by part number. Is there an easy way to push these values from excel into CATIA. I have done a small amount of scripting with macros, but am by no means an expert. Should I keep looking into macros or is there a better way? Are there any macros I can see that will help achieve this?

Below is a picture of the beginning of my excel spreadsheet as an example:



Below is the location I am filling out:

RE: Bulk part properties editing

Hi,

Please try if it helps you.In the drafting workbench goto insert...annotations...table...table from csv...import the csv file ( excel file saved as csv format ). Not sure if this is your requirement. All the best.

RE: Bulk part properties editing

do you need a table that associated with a part? if you don't need that just do what sudhakarn said.

RE: Bulk part properties editing

(OP)
Thank you both for responding! Yes, I need the association with the part. The model is being released to a customer.

It is easy to export the bill of materials to excel/add them to a drawing. I just don't know how to push the properties in the excell bom back into the part files.

RE: Bulk part properties editing

Would Generating a Design table from your Existing Excel spreadsheet to drive those values work for what you need?

Seems like it would keep the link as well as control those parameters.

RE: Bulk part properties editing

(OP)
I don't know a whole lot about design tables. I briefly looked into this; however I found that I had to go in and manually link every instance.

RE: Bulk part properties editing

if you have all that properties in catpart you can use a macro to insert it to drawing. do you create title block using title block macro?

RE: Bulk part properties editing

Hi,

I believe question and pictures suggest that weagan22 wants to copy/modify from Excel file in corresponding CATParts all those User Defined Properties....so, keep searching for macros if you have hundreds.

But I would search first the forum, I remembered that I answered a similar question with example on a txt file....

Regards
Fernando

https://picasaweb.google.com/102257836106335725208 - Romania
https://picasaweb.google.com/103462806772634246699... - EU

RE: Bulk part properties editing

Hi,

We use macros for this in our company. you need to define a macros linking CATIA with excel. You need to save both the CATIA part file and excel files in a same location. then open the part in the catia window and close all other open catia windows. run the macros from excel by opening the excel file. this is how we do. All the best.

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