Skip to main content
N
nborrerojr.1-Visitor
1-Visitor
June 9, 2015
Solved

Substitute Parameters with Excel Integration

  • June 9, 2015
  • 2 replies
  • 2051 views

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

    Best answer by KaelLizak

    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

    2 replies

    K
    KaelLizak16-PearlAnswer
    16-Pearl
    June 12, 2015

    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

    N
    nborrerojr.1-VisitorAuthor
    1-Visitor
    July 15, 2015

    RFC 180985 is required to meet this need.

    V
    VolkerEckardt17-Peridot
    17-Peridot
    July 8, 2015

    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

    N
    nborrerojr.1-VisitorAuthor
    1-Visitor
    July 15, 2015

    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.

    Terms & ConditionsAccessibility statement