Data Connections

Re: How to Query XML File in InfoPath With XPath, Filtering on my:FieldName

Hilary Stoupa — Wed, 22 Jun 2011 21:28:01 GMT

Opening in design after moving is not the most intuitive thing - I mean, you don't have to open an Excel or Word file in a different, special fashion after moving. :-}

Re: How to Query XML File in InfoPath With XPath, Filtering on my:FieldName

gleapman — Wed, 22 Jun 2011 20:02:01 GMT

Thanks. That worked. For the record, I had saved it locally and double clicked on the file and got the error message. I'm in my first week of working in InfoPath and feeling my way.

Re: How to Query XML File in InfoPath With XPath, Filtering on my:FieldName

Hilary Stoupa — Wed, 22 Jun 2011 19:04:07 GMT

You can't just open a template that has been moved. Save it locally, right click it, and open it in design mode. From there you can resave it and it will recover from its current confusion.

Re: How to Query XML File in InfoPath With XPath, Filtering on my:FieldName

gleapman — Wed, 22 Jun 2011 18:55:44 GMT

Skarn - more on the error message: Forms that require the domain permission level contain features that access information on a network, such as data connections, linked images, and code.

Re: How to Query XML File in InfoPath With XPath, Filtering on my:FieldName

gleapman — Wed, 22 Jun 2011 18:52:11 GMT

Skarn - cannot open your attachment - Error: "This form cannot be opened because it requires the domain permission level and it currently has restricted permission. To fix this problem, open the form from the location it was published to."

It then give the published location as a folder on your c-drive.

Re: How to Query XML File in InfoPath With XPath, Filtering on my:FieldName

Skarn — Wed, 20 Apr 2011 11:25:57 GMT

Hm. interesting proposal. Don't really know why you would need to do this though.

But I love a bit of fiddle for fiddles sake.

Working example attached! :-)

Gonna explain why you need this generic/dynamic query method?

How to Query XML File in InfoPath With XPath, Filtering on my:FieldName

RKEMN2 — Tue, 29 Mar 2011 17:06:27 GMT

Using InfoPath 2010, I want to retrieve a value from an xml file based on the value of a field in my InfoPath form. I'm using this queried value to set a field value using a Rule on Form Load.

This hard-coded XPath retrieves the desired value:
xdXDocument:GetDOM("XmlFileName")//GroupB/NodeWithTextValue[@AttributeX='DDD']

In the above XPath string, I'd like to use form field values for 'GroupB' & 'DDD'

Assigning just one value in the path with a form field, this validates using the Verify Formula, but does not set the field value as before:
xdXDocument:GetDOM("XmlFileName")//my:FieldName1/NodeWithTextValue[@AttributeX='DDD']

This also does not work:
xdXDocument:GetDOM("XmlFileName")/RootNode/*[. = xdXDocument:get-DOM()/my:myFields/my:FieldName1]

I've tried several things using the InfoPath function UI to generate the XPath syntax with this filter on a form field, but no success.
Please suggest an XPath syntax that would accomplish this or the steps using the UI to accomplish this.
Thanks

XML structure:
<RootNode>
<GroupA>
    <NodeWithTextValue AttributeX="GGG">ValueA1</NodeWithTextValue>
    <NodeWithTextValue AttributeX="HHH">ValueA2</NodeWithTextValue>
</GroupA>
<GroupB>
    <NodeWithTextValue AttributeX="FFF">ValueB1</NodeWithTextValue>
    <NodeWithTextValue AttributeX="DDD">ValueB2</NodeWithTextValue>
</GroupB>
<GroupC>
    ...

</RootNode>