Using parameters to name iPart members

[fridtjofZM5ME]

I'm currently trying come up with a simple solution for naming the individual members of an iPart i intend to publish to my content center, in this case a blind rivet that doesen't exist in there from  before. Since this type of fastener will be any length within a specific interval, and I also want it to behave like a screw upon insertion, the iPart table will be very long and would like to avoid to name the members individually.

Ideally I would like to type in:

"DIN 7337 - <STOCKNUMBER> - <GRIPLENGTH>"

in the member cell and and get member names corresponding to the parameter/property values for each line in the table, much in the same way as you can define the naming scheme of frame members. I know I could create a formula in Excel that would return the naming scheme I want, which is probably the most rational way to it for large tables anyway, but I would really like to know if there is a clever way to use references to parameters and properties in member names and part numbers in the iPart table dialogue.

[WCrihfield]

 I usually had the first column (or close to first column) in the spreadsheet use the CONCAT (concatinate) function (or the & symbol) to chain togeather several key pieces of information to form the Name I wanted.

See the following link for examples:

CONCAT function 

[J.VandeMerckt]

Hi
When doing this.
If I add a new member in the Ipart table it doesn't use the formulas.
I there a way to add a new Member in the ipart family and it uses the formulas that are in its spreadsheet.
Or will I have to add the new part in the excel instead of the ipart table.

[WCrihfield]

Hi @J.VandeMerckt.  That is a good question.  I believe you would have to add the new member using the iPartFactory.ExcelWorkSheet if doing it by code, or manually through Excel.  I believe this is because it simply does not know to copy the Excel function from a previously existing row to a new row when done using the native Inventor tools.  But I honestly have not been using iParts/iAssemblies for a few years now, so I have not tested this theory lately.  The Excel CONCAT trick is basically a workaround, rather than a direct desired solution.  A solution would look more like Inventor adding more options or abilities like this into thier built-in iPart/iAssembly naming parameters.

[J.VandeMerckt]

Hi

Thank you for responding and sorry for my delay. (I was traveling)
I'll have a look with the code once I find the time to play with Iparts again.
Having more options for naming Iparts members would be great.
I'll look into suggesting it as a idea if it doesn't exist yet.