Bulk part properties editing

[weagan22]

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:

 

[sudhakarn]

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.

 

[JeniaL]

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

 

[weagan22]

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.

 

[1CATIAuser]

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.

 

[weagan22]

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.

 

[JeniaL]

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?

 

[ferdo]

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

 

[sudhakarn]

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.