topic Re: Link text parameter from excel file in Inventor Forum

Link text parameter from excel file

Anonymous — Wed, 04 May 2016 03:17:06 GMT

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.

Re: Link text parameter from excel file

admaiora — Wed, 04 May 2016 10:39:59 GMT

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)

Re: Link text parameter from excel file

Anonymous — Tue, 10 May 2016 04:59:58 GMT

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!

Re: Link text parameter from excel file

admaiora — Tue, 10 May 2016 07:20:47 GMT

Hi,

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

Re: Link text parameter from excel file

Anonymous — Tue, 10 May 2016 07:33:07 GMT

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".

Re: Link text parameter from excel file

admaiora — Tue, 10 May 2016 07:52:47 GMT

I have no problem with that.

can you attach the files? And describe exactly your workflow

Re: Link text parameter from excel file

admaiora — Tue, 10 May 2016 07:57:56 GMT

Re: Link text parameter from excel file

mslosar — Thu, 10 Nov 2016 16:03:02 GMT

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).

Re: Link text parameter from excel file

karthur1 — Fri, 10 May 2019 14:04:50 GMT

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

Re: Link text parameter from excel file

johnsonshiue — Fri, 10 May 2019 23:08:19 GMT

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!

Re: Link text parameter from excel file

thomas.robertson6YU9Y — Sat, 03 Aug 2019 14:25:21 GMT

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

Re: Link text parameter from excel file

gcoombridge — Sun, 04 Aug 2019 06:11:25 GMT

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-model-parameters/td-p/3133368

'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,

Re: Link text parameter from excel file

thomas.robertson6YU9Y — Sun, 04 Aug 2019 11:57:10 GMT

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