topic Re: Populate Table with Custom Properties in Inventor Forum

Populate Table with Custom Properties

FORBESWILSON6174 — Mon, 07 Dec 2020 18:35:57 GMT

I have tried to find an answer to this question without success.

Is it possible to create a Table and populate it with custom properties.

We have custom properties that we would like to include for example in a Revision Table.

If you open the Revision Table for editing, you can open the iProperties from the dialogue box, but I don't know how to attach the values to the required cell.

Any help and suggestions would be appreciated.

Regards,

Re: Populate Table with Custom Properties

mcgyvr — Mon, 07 Dec 2020 19:07:15 GMT

https://beinginventive.typepad.com/being-inventive/2012/11/add-model-iproperty-to-the-drawing-revision-table.html

Re: Populate Table with Custom Properties

CGBenner — Wed, 09 Dec 2020 18:34:08 GMT

@FORBESWILSON6174 Did the information provided by @mcgyvr answer your question? If so, please use Accept Solution so that others may find this in the future. Thank you very much!

Re: Populate Table with Custom Properties

FORBESWILSON6174 — Thu, 10 Dec 2020 06:47:59 GMT

We are in the process of trying the proposed solution, I will give feedback as soon as I have an answer.

Regards,

Re: Populate Table with Custom Properties

FORBESWILSON6174 — Thu, 10 Dec 2020 18:33:39 GMT

We have followed the procedure o the link, but unfortunately we cannot get the table to populate the cells with our custom values.

If I put it in a nutshell, we want to create a Table and populate the cells with either custom drawing or custom model values.

The Revision Table at least sees the iProperties, but we don't know how to transfer those values to specific cell.

Regards,

Re: Populate Table with Custom Properties

rhasell — Thu, 10 Dec 2020 23:37:23 GMT

Is it possible that you missed the step to add the custom iProperties?

Re: Populate Table with Custom Properties

FORBESWILSON6174 — Fri, 11 Dec 2020 09:33:04 GMT

Thanks for the response, however creating custom Columns and populating them manually is not the problem, I want to populate the cells, for example where you have C1 with a custom property value, not a manual input as with the other revision columns.

If your value C1 is an iProperty, I want to know how you populated the cell with it.

If I create a normal table, I do not have the option to populate it with iProperties.

Regards,

Re: Populate Table with Custom Properties

mcgyvr — Fri, 11 Dec 2020 13:32:09 GMT

@FORBESWILSON6174 There are clearly specific details to your situation that it seems you aren't communicating to us properly. The link I posted above is quite clear and works just fine but something about your case must be different or you are missing a step or not understanding the process enough..

Please post example Inventor files and state very clearly where they should show up in a rev table for each example.

Give us very clear information like " in part1.ipt we have custom iproperty "Apple".. When we create a drawing of part1.ipt and place a rev table we want a column named "Apple" that shows the text from that iproperty"..

Or "in drawing.ipt we created custom iproperty...blah blah.."

Re: Populate Table with Custom Properties

FORBESWILSON6174 — Fri, 11 Dec 2020 15:21:19 GMT

Apologies for any confusion. Hopefully this will clear up what we are trying to achieve.

I have added some custom values in the Drawing which we would like to be able to populate the Revision Table Column 'Activity' with.

The principle would apply to a Revision Table, and a Table in general.

I hope this makes more sense.

Regards,

Re: Populate Table with Custom Properties

rhasell — Mon, 14 Dec 2020 05:35:35 GMT

Everything has already been answered, but hopefully this will help. Please see my note at the end.

I created the same plate, and custom iProperties:

Edit your Revision table, and click on the Column Chooser icon.

Click New Property

Click on the line <<Click here to add a new property>>

and type in the name of the property, in my example I used "ACTIVITY 1", press enter and OK

The new property will be added to the revision table.

If you right click on the column, you can change the display name to "ACTIVITY"

You will have to make this change for every one of the ACTIVITY entries, and I personally do not think that will be the best solution.

Can I perhaps suggest using iLogic, which populates a single "ACTIVITY" entry, that way, you can just have the single entry, which is populated and updated with each revision change. You will not loose the previous entry, it becomes a dumb entry retaining it's contents, the new revision row will take on the custom iproperty.

Re: Populate Table with Custom Properties

FORBESWILSON6174 — Mon, 14 Dec 2020 11:26:55 GMT

Thanks for the response and your patience, I am the middle man in this, but your iLogic suggestion is he way we want to go, but as you can see it is obvious I have limited knowledge with iLogic.

The engineer I am working with understands this part of the software, so if we know what to do, I am sure he can sort it out.

Regards,

Re: Populate Table with Custom Properties

mcgyvr — Mon, 14 Dec 2020 14:25:56 GMT

@FORBESWILSON6174 wrote:

Apologies for any confusion. Hopefully this will clear up what we are trying to achieve.

I have added some custom values in the Drawing which we would like to be able to populate the Revision Table Column 'Activity' with.

The principle would apply to a Revision Table, and a Table in general.

I hope this makes more sense.

Regards,

Not totally clear IMO..

Your example shows 6 custom iproperties and 1 column in the rev table..

Do you really want 6 columns in the rev table? 1 corresponding to each activity? Or do you want to concatenate all of the values into a single column?

Maybe you just want to use iproperty expressions like this..

https://modthemachine.typepad.com/my_weblog/2010/04/iproperty-expressions.html#:~:text=In%20the%20iProperties%20dialog%2C%20Inventor,into%20a%20single%20iProperty%20value.&text=symbol%20to%20the%20right%20of,is%20defined%20using%20an%20expression.

Re: Populate Table with Custom Properties

FORBESWILSON6174 — Mon, 14 Dec 2020 15:34:21 GMT

This is turning into a can of worms, and I must apologise for the confusion.

All we want to be able to do is :-

a) Add a custom Columns to a Revision Table and populate the cells with custom properties from the Drawing.

b) Create a Table and populate the cells with custom properties from the drawing / Model.

Reg's response regarding iLogic is I think basically what we need. Once the rows / cells are updated, the previous input becomes a dumb entry.

Regards,

Re: Populate Table with Custom Properties

rhasell — Mon, 14 Dec 2020 23:42:13 GMT

Here is an example of an iLogic rule.

Requirements:

You need a custom iProperty of ACTIVITY as well as a column in your revision table.

You can adjust everything to suit your own environment.

The rule will give you the option to add a new revision, or edit the exiting revision. (It's a cut back from my rule, and I need that option)

Sub Main oCHOICE = InputRadioBox("Add Revision Row", "Yes", "No", oCHOICE, Title := "Revision tag") If oCHOICE = True Then Call add_row Else Call REV_TAG End If End Sub Sub add_row() Dim oDrawDoc As DrawingDocument = ThisDoc.Document ' Get the revision table Dim oRevTable As RevisionTable = oDrawDoc.ActiveSheet.RevisionTables.Item(1) ' Get last row Dim oRow As RevisionTableRow oRow = oRevTable.RevisionTableRows.Item(oRevTable.RevisionTableRows.Count) ' Add another row at the end Dim oRows As RevisionTableRows = oRevTable.RevisionTableRows oRows.Add() REV_TAG End Sub Sub REV_TAG() Dim oResult As String = "Result" Dim oRev As New ArrayList oRev.Add("COMMENTS") oRev.Add("PRICING") oRev.Add("REFERENCE") oRev.Add("APPROVAL") oRev.Add("CONSTRUCTION") oRev.Add("AS BUILT") 'Display table and get the selection oResult = InputListBox("Select Revision Desc", oRev, oResult, _ Title := "Revision Description", ListName := "Rev Desc") 'Set iProperties based on the selection. iProperties.Value("custom", "ACTIVITY") = oResult End Sub

Re: Populate Table with Custom Properties

FORBESWILSON6174 — Mon, 28 Dec 2020 07:29:22 GMT

Hi Reg,

Thanks for the feedback, and apologies for the incredibly long delay.

What you provided was great, our engineer made a few changes and we have got exactly what we needed.

Regards,