Code

Re: Accessing secondary datasource through code

spudy — Wed, 20 Jun 2007 08:09:47 GMT

Matt, You are right about the namespace. After my last post I decided to create a new datasource (from an infopath form) and then set this up as a secondary datasource. My code then did retrieve the correct count. I then compared the two XML files - and there was a very obvious difference. The root of my original file had a namespace, but none of the elements did.

I am presuming now that I will be able to search this secondary datasource using an xpath filter and then drop results into a group as part of the main datasource to enable the use of a master detail table. But first I need to clean my datasource......

Many thanks for your help.......

Re: Accessing secondary datasource through code

Matt Faus — Tue, 19 Jun 2007 23:19:49 GMT

Hi Spudy,

From what you're telling me, it seems like your XML does not have a namespace at all. Try the XPath "/Util/Details" (without namespace prefixes). I think that should work. If that still doesn't work, could you paste an example of the XML that your form is trying to query against?

Re: Accessing secondary datasource through code

spudy — Tue, 19 Jun 2007 21:26:57 GMT

Matt,

Thanks for responding so fast. I had already seen it but I did revisit in case I missed something. My secondary datasource doesn't have anything showing under the details tab. To get the string I extracted the files and opened in notepad the xml file and took the detail from there. It is probably worth mentioning at this stage that the data contained within the secondary datasource was originally imported from an excel spreadsheet into XML document.

Could this have caused an iffy xml document in some way that will not work with infopath? At times infopath seems rather sensitive. I am now wondering if I should get the data in SQL database and use the XML output function to create a clean XML document.

Thanks again, Spudy.

Re: Accessing secondary datasource through code

Matt Faus — Tue, 19 Jun 2007 19:09:21 GMT

Hi Spudy

Look at silly me posting something you've already seen, haha! I really think this is an XPath issue. Are you sure that your "User List" DOM is also using the my namespace? If it is from another form, it might be using this same namespace, but with a different value. You should check this by double-clicking the nodes and looking at the Details tab, as demonstrated in the tutorial. You will have to explicitly state the namespace from that tab in your query. If the URI is different than the Main DOM, I would suggest using a different prefix than "my", to lessen confusion.

If you are still having trouble, please provide some screenshots from your data source taskpane and the Details tab of Properties on the the /my:User/my:Details node.

Re: Accessing secondary datasource through code

spudy — Tue, 19 Jun 2007 18:50:16 GMT

Matt, that is the example I have been working from. I have double checked my xpath but it all looks ok. I am presuming there is something obvious I am missing here. My form has very little to it, just the code I posted originally.

Any help on this one will be most appreciated.

Re: Accessing secondary datasource through code

Matt Faus — Mon, 04 Jun 2007 08:15:09 GMT

See this blog post for a great tutorial on accomplishing this: http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Setup-Namespaces-for-a-Secondary-Data-Source.aspx

Re: Accessing secondary datasource through code

chang — Sat, 02 Jun 2007 09:42:20 GMT

Double-check the XPath expression you are using to retrieve the nodes; it might be incorrect.

Re: Accessing secondary datasource through code

spudy — Fri, 25 May 2007 13:39:39 GMT

Chang,

Thanks for your response. I did select this option. Any other ideas?

Thanks

Re: Accessing secondary datasource through code

chang — Sun, 20 May 2007 09:37:30 GMT

When adding the secondary data source to your form, did you select to automatically retrieve data when the form is loaded? If not, you'll need to query the data source before trying to use data that it might contain.

Accessing secondary datasource through code

spudy — Thu, 17 May 2007 09:46:40 GMT

I found a very useful post from Matt Faus -

http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Setup-Namespaces-for-a-Secondary-Data-Source.aspx

I have mapped the namespace for a secondary datasource into my form. There are no errors displayed. I then added some code to count the number of items in the datasource (I know the number but need to use the number for looping purposes)

The code I used is:

var oNodeList;

oNodeList = XDocument.GetDOM("User List").selectNodes("/my:Users/my:Details" );

var oIndex = oNodeList.length ;

XDocument.DOM.selectSingleNode("//my:NumberofUsers").nodeTypedValue = oIndex;

The number is returned as 0 which is not what I expect. Is there something obvious missing here? Do I need to intialize the secondary datasource somehow before the data is accessible?

Regards Spudy