Substitute Parameters with Excel Integration

[nborrerojr.]

How can I get a field to substitute parameters when pulling data through the Excel integration?

[KaelLizak · Accepted solution]

Hello Nolin,

I think you probably want to file your organization against RFC 180985, because parameter substitution does not exist.  It's unclear, as stated, whether this would apply to the Excel integration, so investigation by PTC Integrity Lifecycle Manager Support will be necessary.

It may be possible to do this with as a global setting in the Integrity client, with:

    im setprefs --command=viewsegment --save substituteParams=true

That can be reversed by changing true back to false.  I haven't tested that, because I don't have a good test for doing so.

Please let us know if this helps.

Regards,
Kael

[nborrerojr.]

RFC 180985 is required to meet this need.

[VolkerEckardt]

Hi Nolin,

I like your question. Just to add some thoughts.

The excel integration has been build for down- and upload. Assuming, we would allow parameter substitution, this would then deliver the parameter values into your excel. So good so fine.

Then, the question is how you like to handle the upload. Do you like to keep the values as normal text, or do you like to push the text back into Integrity with the {{parameter definitions}} in it? How shall Integrity know that?

Volker

[nborrerojr.]

I wouldn't expect it to update parameter definitions. I would think it would compare the value of the string in Excel to the value in Integrity with parameters substituted. If it finds that they are the same then it makes no updates. If it finds that they are different, then it would replace the string in Integrity with the string in Excel with no parameters. This is just an idea though.