Code

Re: Copy text from Secondary Datasource(Sharepoint list) to repeating table in the main data connection JScript

Hilary Stoupa — Thu, 02 Aug 2012 23:11:01 GMT

Well, the resource file is a secondary data source, but I get what you mean - the difference between the resource file in that sample and the secondary data source you are using is that your 2ds has namespace prefixes.

Re: Copy text from Secondary Datasource(Sharepoint list) to repeating table in the main data connection JScript

xjoutsider — Thu, 02 Aug 2012 20:09:26 GMT

I belive What have done here. http://www.infopathdev.com/blogs/hilary/archive/2008/07/04/how-do-i-copy-repeating-data-from-an-external-source-into-my-form.aspx will work for me pretty well. I am now trying to figure out how to adapt it to my needs. Thanks for the tip Hilary. I guess my question is does the file have to be a resource file or can it be connected as a secondary data source.

Thanks

James

Re: Copy text from Secondary Datasource(Sharepoint list) to repeating table in the main data connection JScript

Hilary Stoupa — Thu, 02 Aug 2012 15:36:51 GMT

There are a lot of sample forms here. Perhaps one will help you?

Re: Copy text from Secondary Datasource(Sharepoint list) to repeating table in the main data connection JScript

xjoutsider — Thu, 02 Aug 2012 15:26:49 GMT

I added the Reference to the name Space

XDocument.DOM.setProperty("SelectionNamespaces", 'xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"');

This resolved ths issue. for this situation

But now it does not reconize the my I addded the Ref but it still does not work.

XDocument.DOM.setProperty("SelectionNamespaces", 'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-07-26T17:23:36"');

Re: Copy text from Secondary Datasource(Sharepoint list) to repeating table in the main data connection JScript

Hilary Stoupa — Wed, 01 Aug 2012 23:43:13 GMT

I think you have to set the namespaces - I have a C# sample for that - sorry, I'm pretty pathetic at jscript, but maybe this will point you in the right direction:

IXMLDOMDocument2 dom = (IXMLDOMDocument2)thisXDocument.GetDOM("DataSourceName");
dom.setProperty("SelectionNamespaces", "xmlns:dfs='http://schemas.microsoft.com/office/infopath/2003/dataFormSolution'");

Re: Copy text from Secondary Datasource(Sharepoint list) to repeating table in the main data connection JScript

xjoutsider — Wed, 01 Aug 2012 17:02:26 GMT

Thanks for that.

Now I'm having issues with the Xpath of secondary data source it does not Recognize the dfs prefix.

Re: Copy text from Secondary Datasource(Sharepoint list) to repeating table in the main data connection JScript

Hilary Stoupa — Wed, 01 Aug 2012 15:57:24 GMT

Your XPath is wrong:

var clone = XDocument.DOM.selectSingleNode("/my:myFields/my:ProgramCapacity/my:Meetings/my:BAU_Meeting").cloneNode(true);

Should be:

var clone = XDocument.DOM.selectSingleNode("/my:myFields/my:Program-Capacity/my:Meetings/my:BAU_Meeting").cloneNode(true);

Copy text from Secondary Datasource(Sharepoint list) to repeating table in the main data connection JScript

xjoutsider — Wed, 01 Aug 2012 15:50:15 GMT

Infopath 2007 / SharePoint 2010

I have a form that is connected to a SharePoint list as a secondary data source. I need to get the record from this SharePoint List and populate The repeating table in main data connection. I am not permitted to use Any type of code except Jscript. I am stuck and not sure what i am doing wrong. I am getting an error at Line one

// Get a copy of the main DOM node.
var clone = XDocument.DOM.selectSingleNode("/my:myFields/my:ProgramCapacity/my:Meetings/my:BAU_Meeting").cloneNode(true);
// Clear the main DOM nodes.
XDocument.DOM.selectNodes("/my:myFields/my:ProgramCapacity/my:Meetings/my:BAU_Meeting ").removeAll();
// Copy nodes from 2DS to main DOM. var nodes = XDocument.GetDOM("Meetings").selectNodes("/dfs:myFields/dfs:dataFields/dfs:Meetings");
foreach(node in nodes)
{
clone.selectSingleNode("@Meeting-Project_Name").text = node.selectSingleNode("BAU_Meetings").text;
XDocument.DOM.selectSingleNode("/my:myFields/my:ProgramCapacity/my:Meetings/my:BAU_Meeting").appendChild(clone.cloneNode(true));
}

Main Data connection

Secondary data Connection

Any help would be appreciated I am really new to this. Thanks