Link text parameter from excel file

[Anonymous]

Does anybody know how to link a text parameter from an excel file? 

I'm able to link numeric paramters, but no text.

Thank you.

[admaiora]

Hi,

you can use a little iLogic

notes:

- the rule can be improved including a specific or generic path for the Excel file

- in this first example of iLogic it's enough to save the excel in the project folder (otherwise the the rule won't be enough to locate the excel without additional imputs)

[Anonymous]

Hi, 

Thanks for the info. I was able to do what you explained on your video but, was not able to assign that text parameter into an actual text. 

Could you please show me how to do it? 

On the text box, when selection "Model parameters" I got an error message saying "No model parameter under....".

I hope you can help me.

Thank you!

[admaiora]

Hi,

you have to choose "User parameters", because you have created a User parameter.

[Anonymous]

It is not recognizing text parameters.

It will work with a numeric parameter, but if I only have text parameters, this is what comes out: "There is no parameter under this source".

[admaiora]

I have no problem with that.

can you attach the files? And describe exactly your workflow

[admaiora]

[mslosar]

If you're trying to send a text parameter from an excel file into inventor, you cannot do it (at least through v2015) by simply linking the xlsx file into parameters. That only works for numeric values. (no clue why).

To get a text value out of an inventor file, you have to use ilogic which will find the designated field in your excel file and bring the text into ilogic. In ilogic you can then assign it to an iproperty or text parameter. If you're tying to get that value into something like a description, you have to create the text in ilogic and assign it to the description as you cannot export the values of text parameters (no idea why).

[karthur1]

I am having the same issue.  I am wanting to pass a text field into my parameters.  I suspect the issue is because when they added the ability to add text (and True/False) values into the parameters, they forgot about linking excel tables to the part.

When I add this, I get a message "Unable to create parameter:PartNo".

I am using Inv 2018.3.4

[johnsonshiue]

Hi Kirk,

Indeed, the text parameter was added later. However, it is not that we forgot about it. It is that the Excel spreadsheet parameter linking is for numerical data. The user needs to specify the unit on the 3rd column. There is no way to specify type. The Import XML parameter workflow does allow text type. I will need to work with the project team to understand if it is doable but I don't think it would be resolved quickly. Please feel free to report it as an idea on Ideas forum.

Many thanks!

[thomas.robertson6YU9Y]

we think it is doable since this section is poorly documented and the parameters tab shows "Text" under the units tab

[gcoombridge]

My understanding is the excel format needs to mirror the parameter dialogue box format - parameter name/parameter value/parameter unit/parameter column. As an alternative you can make the parameter value a nominal value (say 1) and add the text entry into the comment field and this will come through to Inventor when linked. Comments can be accessed through Ilogic and turned into parameters easily.

https://forums.autodesk.com/t5/inventor-customization/can-ilogic-access-the-comment-field-of-the-mod...

'Create TextParameterA normally then:
TextParameterA = Parameter.Param("ParameterFromExcel").Comment 

A colleague of mine does this for some excel driven models and it works fine (though a straight-up text parameter link would be preferable)...

Cheers,

[thomas.robertson6YU9Y]

Thank you so much for your reply. I will try the comment trick today.