Is it possible to fill in custom properties quickly?

Hi all

Do you know if it is possible to fill in custom properties with excel, for example?

I will have the following properties: overturning torque, vertical reaction, horizontal reaction...

I have to fill in these properties for a large number of configurations (part family) ... And I already have an excel table in which there is all this information.

Do you have an idea? The best thing would be to be able to control these custom properties with excel.

Note: I retrieve these properties in the form of a note in my drawing.

You post your Excel table directly in your drawing and that's it

@+ ;-)

1 Like

Of course, via a family of rooms. Then you can also use the custom properties pane like in my tutorials.

1 Like

Hello

The best thing is to have the MyCAD tools that allow you to do this mass processing on several files.

@+

1 Like

@gt22: I have already tried to put the excel table in my drawing but the format is not adjusted to the boxes that interest me... I tried copy/paste and insert object link but it doesn't work...

@a.leblanc: Otherwise, for the part family, how can I retrieve the value that I put in the part family in my drawing?

It's a complicated subject, in fact I already had to abandon a project similar to yours, because I had too many columns to display.

You can insert your room family into your MEP.

Regarding the layout of the table, you can shift the one that is done automatically (family of parts on your excel sheet) and return the necessary values in a smaller table on which you will adjust your window to delete the display in the MEP.

You can set "equal to another cell " to drive the values from your small table on the MEP. 

Well, the picture is bigger than the family of parts, but you have to imagine the opposite...

 

MYCAD utilities are there for that.

INTEGRATION to automatically fill in a series and/or a repertoire of parts.

2 Likes

flegendre, it looks nice the INTEGRATION tool, but you need a subscription to what I understand?

So I tinkered by creating a sketch in which a trait was assigned to a property.

Which I then recovered in my mep...

It works well ...