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:
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
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
RE: Bulk part properties editing
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
Seems like it would keep the link as well as control those parameters.
RE: Bulk part properties editing
RE: Bulk part properties editing
RE: Bulk part properties editing
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
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.