Link part family and custom properties of MEP

3D Design Volume Model
1

Hello

It's all said in the title!

To summarize, it is a question of selecting a configuration from the MEP P.P. pane.

I would like us to just have to fill in the desired reference in the P.P. pane, that it be included in the part family, and that with the Vsearch function the dimensions of the configuration be filled in automatically.

And it's this link between the MEP P.P. and the family of parts that makes me block.

I attach a folder for example with the part family, the part and a custom properties file.

Thank you in advance.

Kind regards

Alex


nouveau_dossier_compresse.zip
1 Like
2

Hello

So if I summarize, you want that from the drawing:

  • Recover the value of the custom property
  • Go to the workbook of the part family
  • Find the cell whose value matches the custom property
  • Update the baseline in the MEP

Is that right?

2 Likes
3

Hello

So the idea is that since a drawing, you must:

1- Use the custom properties pane of MEP to select a code --> code list (excel sheet - see p.p file) or a free field.

2- This code is then automatically registered in a cell of the coin family (this is where I get stuck).

3- The values of the default configuration in the part family are automatically filled in using the Vlookup formula (see excel file).

4- All these actions  must be carried out and updated automatically.

That's it, not easy and not sure if there is a solution!

thank you in advance

4

1- Use the custom properties pane of MEP to select a code --> code list (excel sheet - see p.p file) or a free field.

You can't create a list of choices in custom properties, which forces the user to know in advance the code of the configuration he wants.

2- This code is then automatically registered in a cell of the coin family (this is where I get stuck).

That's not complicated, you have to use interoperability with excel.

3- The values of the default configuration in the part family are automatically filled in using the Vlookup formula (see excel file).

If you have already entered the data in excel, why not go directly through the configuration names?

4- All these actions  must be carried out and updated automatically.

That's not a problem either, that's the purpose of a macro:)

1 Like
5

Great it's great if it's feasible!

Could you elaborate on  the concept of interoperability please?

In fact, it is possible to include a list in the custom properties pane and refer it to a column in an Excel file.

I have to redo the links between the files in the folder I attached, and fill in the path of the list with the custom properties editor. I'll make a little video tomorrow to explain all this.

The objective is to merge the family of parts with an already existing excel file, heavy and completed by everyone, so not to add several hundred lines of configuration to weigh down the file if possible.

Thank you for your support.

Good night

6

Good evening

You will find attached the beginning of an answer.

There are two functions that can be useful for everyone:

  • Recover the value of a private property by name
  • Retrieve the path to a linked excel workbook

I'll continue a little tonight:)


liaison_pp_famille_de_pieces.swp
1 Like
7

Great, I'll watch all this tomorrow on my computer. Thank you

1 Like
8

I just noticed that the part crashes when opened, I put the file back available.


nouveau_dossier_compresse.zip
1 Like
9

Hello

I completed the code and it works.

I still have to solve an Excel instance problem that won't close.

The code is a bit heavy, I'll try to fix that a bit.

I'll post the macro certainly tonight.

2 Likes
10

 Hello industrialcadservices,

I tried the macro you posted to me, and apparently there is a problem with references or version...

I am attaching a short video to illustrate the concept from examples.

 

Thank you.


2017-02-24_at_09-42-43.mp4
11

Hello, it's just that we don't have the same version of excel.

Add the reference to the version of Office and Excel that you have, validated and recompiled.

Kind regards.

2 Likes
12

Sorry for this late return, I couldn't try again before.

So, I changed the references of the office versions and the name of the custom property in the macro.

I then selected a code from my p.p. list, ran the macro and the part family opens, but the code entered does not change.

On the other hand, there is no error message when running the macro.

 

13

It's normal, the processing is missing in the excel file:)

I posted the macro so that you have a basis to do your macro :)

By running the macro, you get the path to the Excel workbook driving the MEP reference model.

As I said in a previous post, I have written the code for processing the Excel file but I still have to fix some errors.

1 Like
14

Good evening

You will find attached the updated and functional macro (at least at home :))

You will just need to change the value of the vPropertyName variable in the macro, if you haven't named your private property like I did.

Kind regards.


macro_mep_config.zip
2 Likes
15

Hello 

Great, you were very quick to make this macro, thank you for that.

I will test it as soon as possible and keep you informed.

Have a nice day, thank you.

16

Hello 

I tried the macro, and there is a small problem with the undefined variable, I may have forgotten something?

I changed the references to office, redefined the name of the property, but it gets stuck. 

I am attaching screenshots of the error message.


api_configurations.docx
17

Good evening

The "t" is missing from the definition of the variable:

Dim swCusPropMgr as CustomPropertyManager

It should be:

Dim swCustPropMgr as CustomPropertyManager

 

1 Like
18

Holala I searched for a little while. Well I'll try all that again tomorrow.

Thank you, good evening.

1 Like
19

Hello

It's great , it works!

It's really amazing the work you've done.

Thank you very much.


2017-02-28_at_09-10-46.mp4
3 Likes
20

Thank you, I'm glad I was able to help you.

Have a nice day.

3 Likes