InfoPath Dev

Hello,

I would like to set values in an infopath form from outside of infopath. Therefore I have written a small javascript to access the Infopath object modell.

Now I have a problem with setting the information in the appropriate fields in the form.

In the following you will find my script and everthing works fine --- without the last line. ;-(((

var oApp = new ActiveXObject("InfoPath.Application");
WScript.Echo("InfoPath Version: " + oApp.Version);

var oXDocumentCollection = oApp.XDocuments;
var oXDocument = oXDocumentCollection.NewFromSolution("file:///C:\\InfopathFormCall.xsn");
var oXMLDocument = oXDocument.DOM;

oXMLDocument.setProperty("SelectionNamespaces","xmlns:my='http://schemas.microsoft.com/office/infopath/2003/myXSD/2004-01-19T21:16:49'");

oXMLDocument.selectSingleNode("/my:meineFelder/my:txtTelefon").text = "New value";

I get the error message that 'oXMLDocument.selectSingleNode(...)' is Null or not an object...

BTW: 'meineFelder' is the german expression for 'myfields' but replacing this will result in the same error message.

Can someone help me to get the correct syntax for accessing the selectSingleNode object.

Any help is greatly appreciated

This is a common error and it almost always has to do with your XPath expression. It sounds like you have checked this against your data source to make sure that it is correct, but that's the only action I would suggest.

Hi Matt,

thank you for your advice. Yes, I know that the problem is the XPath expression but that exactly is my problem ;-((

I´ve tried various syntax for the XPath expression beginning from

...("meineFelder:txtTelefon").text to ...("//my:myFields//my:txtTelefon).Text

but all without success...

Therefore I hoped that someone can show me the correct XPath expression in this case.

Thank you very much.

Hello,

...in the meantime I have found a solution which I want to share for anyone who is interested in.

The problem in my code was the correct declaration of the namespace.
If you don´t declare the -really- exact namespace for the property 'SelectionNamespaces' the above mentioned code will failed.

You can determine the exact namespace definition for the used form template with the method 'namespaceURI' as I show in the following line:

var oXMLDocNamespace = oXMLDocument.selectSingleNode("/*[1]").namespaceURI;

Now you can set the correct value for the 'SelectionNamespaces' property:

oXMLDocument.setProperty("SelectionNamespaces","xmlns:my='" + oXMLDocNamespace + "'");

So, the whole working code looks like...

var oApp = new ActiveXObject("InfoPath.Application");
var oXDocumentCollection = oApp.XDocuments;
var oXDocument = oXDocumentCollection.NewFromSolution("file:///C:\\Mytemplate.xsn");
var oXMLDocument = oXDocument.DOM;
var oXMLDocNamespace = oXMLDocument.selectSingleNode("/*[1]").namespaceURI;

oXMLDocument.setProperty("SelectionNamespaces","xmlns:my='" + oXMLDocNamespace + "'");

oXMLDocument.selectSingleNode("//my:myFields//my:singleFieldname").text = "This is a new value";

HTH,