Code

Re: Copy text from one repeating table to another

ChuckP — Fri, 29 Jul 2011 14:36:05 GMT

Greg,

I have a similar issue. I am using VB and would like to do the same thing; However, my repeating table is using conditional formatting as the filter and pulls in all of the records from a sharepoint list.
There are 5 fields with duplicate values in 2 of them. The conditional format unhides only those records that are relevant to the search.
Search Fields below

Discipline
Test
Phase
Begin
Form Code: Private Sub InternalStartup(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Startup AddHandler EventManager.XmlEvents("/dfs:myFields/dfs:dataFields/dfs:Level_1_Adoption_Dump/@Level_1", "Level 1 Adoption Dump").Changed, AddressOf Level_20_1_20_Adoption_20_Dump__Level_1_attr_Changed AddHandler EventManager.XmlEvents("/my:myFields/my:Discipline").Validating, AddressOf Discipline_Validating AddHandler EventManager.XmlEvents("/my:myFields/my:Discipline").Changed, AddressOf Discipline_Changed AddHandler EventManager.XmlEvents("/my:myFields/my:field1").Changing, AddressOf field1_Changing AddHandler EventManager.FormEvents.Submit, AddressOf FormEvents_Submit AddHandler EventManager.XmlEvents("/dfs:myFields/dfs:dataFields/dfs:Level_1_Adoption_Dump/@Level_1", "Level 1 Adoption Dump 2").Changed, AddressOf Level_20_1_20_Adoption_20_Dump_20_2__Level_1_attr_Changed End Sub Repeating Table Below:
Level	Eval
1	a
2	b
3	c
Repeating Table

(The other records are hidden)

The repeating is labeled after the 2DB and I am unsure how to reference it.
Public Sub Level_20_1_20_Adoption_20_Dump_20_2__Level_1_attr_Changed(ByVal sender As Object, ByVal e As XmlEventArgs)

I want to be able to copy data to another repeating table or use the data in this one to add a dropdown with several choices and a comment box for each and then publish to a SP list as a new record.

How can i accomplish this??
Thank you,

Re: Copy text from one repeating table to another

Patrick Halstead — Tue, 05 Oct 2010 21:06:33 GMT

Hi Sanjay,

This is an old thread. Nowadays, we recommend people use qRules to copy from one table to another. It's very easy to do. Jo-Anne's recent blog describes the technique of using insert and rules to do this: http://www.infopathdev.com/files/folders/qrules/entry58577.aspx. We're going to be posting another document in the next week that discusses how to do nested repeating sections, but it's essentially the same technique of using qRules Insert row along with rules. No code required but you will need the qRules plugin.

Re: Copy text from one repeating table to another

sanjay619 — Tue, 05 Oct 2010 12:10:46 GMT

I have same issue copy from one repeating table to another but with condition (i.e if condition satisfied particular data should seen in another repeating table)

thanks in advance.........if 1 can help

Re: Copy text from one repeating table to another

alokpalsingh — Thu, 04 Mar 2010 03:24:21 GMT

Found the answer, when I used "getAttribute" it worked just fine, following is an example:

clone.selectSingleNode("/my:field1").text = nodes(i).getAttribute("Checklist__")

Re: Copy text from one repeating table to another

alokpalsingh — Wed, 03 Mar 2010 05:15:30 GMT

Hey Greg,

I tried writing the code per your suggestion however it is returning only first row, here is the code, can you please help ?

XDocument.GetDOM("Tran Type Generated").setProperty("SelectionNamespaces", 'xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2008-10-20T16:02:22"');
XDocument.DOM.setProperty("SelectionNamespaces", 'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2008-10-20T16:02:22"');

// Get a copy of the main DOM node.
var clone = XDocument.DOM.selectSingleNode("/my:TTFields/my:group7/my:group8").cloneNode(true);

// Clear the main DOM nodes.
XDocument.DOM.selectNodes("/my:TTFields/my:group7/my:group8").removeAll();

// Copy nodes from 2DS to main DOM.
var node;
var nodes = XDocument.GetDOM("Tran Type Generated").selectNodes("/dfs:myFields/dfs:dataFields/dfs:Tran_Type_Generated"); // Note: need to supply the correct namespace per element in this XPath.
XDocument.UI.Alert(nodes.length);
var row;
//for (i=0; i< nodes.length; i++)
while (row = nodes.nextNode())
{
      clone.selectSingleNode("/my:field1").text = row.selectSingleNode("/dfs:myFields/dfs:dataFields/dfs:Tran_Type_Generated/@Checklist__").text;
   clone.selectSingleNode("/my:field2").text = row.selectSingleNode("/dfs:myFields/dfs:dataFields/dfs:Tran_Type_Generated/@Source").text;
   clone.selectSingleNode("/my:field37").text = row.selectSingleNode("/dfs:myFields/dfs:dataFields/dfs:Tran_Type_Generated/@Transaction_Type_Description").text;

XDocument.DOM.selectSingleNode("/my:TTFields/my:group7").appendChild(clone.cloneNode(true));

}

Re: Copy text from one repeating table to another

SARISILVA — Thu, 25 Feb 2010 03:39:48 GMT

Hi Greg, thanks for all your valuable feedback.

I am trying to do the same thing, moving text from one repeating table to another. I actually have about 5 repeating tables. BUt, I keep getting the following error, whenever I try to add a row to the repeating table, whenever the code parent.appendChild(templeteRow) runs.

THE ERROR:

System.Runtime.InteropServices.COMException
Element '{http://schemas.microsoft.com/office/infopath/2003/myXSD/2010-02-08T11-28-21}OutagePersonalGrid' is unexpected according to content model of parent element '{http://schemas.microsoft.com/office/infopath/2003/myXSD/2010-02-08T11-28-21}ReportFields'.

Sometimes when I move my repeating table, that is the "OutagePersonalGrid" in the error above, around the Data Source, this error does not occur. However, since I have many repeating tables, I am confused as to move which table to where in the datasource. I am using Infopath 2003.

Why does this issue come in Infopath 2003. How can I totally get rid of it, is there a workaround?

- Sari.

Re: Copy text from one repeating table to another

anpira — Thu, 04 Jun 2009 11:10:24 GMT

Hi everyone,

First, I want to apologize if this topic already has gone out, but I have searched for the whole forum and do not find a good solution for my problem. I tell you:

I have an InfoPath 2007 form and I have to copy all the rows from one repeating table to another diferent repeating table with VSTA (C#). I have something like the file attached:

I need to copy all the rows from tableA in tableB. Another user will be able to complete the rest of the columns of the tableB. I manage to write rows in a repeating table, but I do not manage to be reading row by row each of the fields of a repeating table.

This is part of my code:

XPathNavigator main = this.MainDataSource.CreateNavigator();

XPathNavigator tableA = main.SelectSingleNode("/my:myFields/my:tableA/my:ext_tableA", this.NamespaceManager);

XPathNavigator tableB = main.SelectSingleNode("/my:myFields/my:tableB/my:ext_tableB", this.NamespaceManager);

string ns = this.NamespaceManager.LookupNamespace("my");

// I NEED A LOOP AND A READER TO READ FIELD BY FIELD---I don't know how...

using (XmlWriter escritor = docuDestino.AppendChild())

{

escritor.WriteStartElement("ext_tableB", ns);

escritorWriteElementString("placeB", ns, >>fiel i have read from placeA<<);

escritorWriteElementString("nameB", ns, >>fiel i have read from nameA<<);

escritor.WriteEndElement();

escritor.Close();

}

The code is incomplete because I don't know how to read all the rows of the tableA. I know that it is a great effort for your part, but...I need your help!

Thank you for everything.

Re: Copy text from one repeating table to another

infoguy — Fri, 01 May 2009 17:08:56 GMT

My situation is very similar.

I have a form based on a schema XYZ. I also have a secondary data connection to an XML file. I can successfully retreive data from the XML file so I know the connection is working. However, I need to copy the contents of nodes within one node from the XML file to a repeating table in the XYZ form. Both the main source and the secondary source have the same exact namespace. I am currently getting an error message when the function hits this line:

XDocument.DOM.selectNodes("/xyz:TRAN/xyz:DEALER/xyz:PERSON").removeAll();

I'm not sure what the issue is. First time with jscript in infopath. Please assist...

Thanks much.

Re: Copy from a repeating table nested within another repeating table to another repeating table nested within the same row of the parent repeating table!

Section2 — Tue, 27 Jan 2009 15:01:09 GMT

The solution I proposed will not work because InfoPath 2007 Form Services is not compatible with the function "position()" (or "last()" for that matter), i.e the message "Use of unsupported XPath functions, position() or last()" is encountered.

I suppose there is a way to insert a default value (ideally a guid) into a node using VSTO, otherwise the only viable option is to use "now()" as the default value for an element at the upper repeating table row level, and copy it as the default value for an element at the lower repeating table row level.

This is a bit of a hack, since if two rows are added to the upper repeating table during the same second, the timestamp will not be unique. InfoPath doesn't offer any other useful functions, such as rnd() to help making a unique identifier. This is also an unpleasant solution since the identifier will need to be persisted in the datasource.

So I am rejecting this hack, and giving up for now, and look forward to you supplying an elegant solution...!

Stu

Copy from a repeating table nested within another repeating table to another repeating table nested within the same row of the parent repeating table!

Section2 — Tue, 27 Jan 2009 13:14:31 GMT

Dear Greg,

I used your code and found it worked excellently! Now I need to step it up a bit and have got problems:

In the above (where there are multiple <rowA>'s, <rowB>'s and <rowC>'s, I am trying to copy the value in <fieldB2> to the value in <fieldC2>. The context of the "Copy" button is <rowB>, so it should be possible to copy to the new context of <rowC> whilst keeping the context of <rowA>.

The problem is that the context of <rowA> is inaccessible. Here is the original code (non-nested) that works:

public void elnCopyToProposed_Clicked(object sender, ClickedEventArgs e)

{

// Create temp copy object

XmlDocument doc = new XmlDocument();

XmlNode group = null;

XmlNode node = null;

// Check parent node exists

if (MainDataSource.CreateNavigator().SelectSingleNode("/my:Case/my:Facilities/my:Proposed/my:Loans",

this.NamespaceManager) == null)

{

group = doc.CreateElement("my:Loans", NamespaceManager.LookupNamespace("my"));

XmlNode nodeOrphan = doc.CreateElement("my:Loan", NamespaceManager.LookupNamespace("my"));

node = group.AppendChild(nodeOrphan);

}

else

{

node = doc.CreateElement("my:Loan", NamespaceManager.LookupNamespace("my"));

}

{

// Create and add fields

XmlNode fieldOrphan = doc.CreateElement("my:lnBalance", NamespaceManager.LookupNamespace("my"));

XmlNode field = node.AppendChild(fieldOrphan);

field.InnerXml = e.Source.SelectSingleNode("my:elnBalance", this.NamespaceManager).InnerXml;

fieldOrphan = doc.CreateElement("my:lnLoanType", NamespaceManager.LookupNamespace("my"));

field = node.AppendChild(fieldOrphan);

field.InnerXml = e.Source.SelectSingleNode("my:elnLoanType", this.NamespaceManager).InnerXml;

fieldOrphan = doc.CreateElement("my:lnTermRemaining", NamespaceManager.LookupNamespace("my"));

field = node.AppendChild(fieldOrphan);

field.InnerXml = e.Source.SelectSingleNode("my:elnOriginalTerm", this.NamespaceManager).InnerXml;

}

// Add the doc to the main data

if (group != null)

{

doc.AppendChild(group);

MainDataSource.CreateNavigator().SelectSingleNode("/my:Case/my:Facilities/my:Proposed",

this.NamespaceManager).AppendChild(doc.DocumentElement.CreateNavigator());

}

else

{

doc.AppendChild(node);

MainDataSource.CreateNavigator().SelectSingleNode("/my:Case/my:Facilities/my:Proposed/my:Loans",

this.NamespaceManager).AppendChild(doc.DocumentElement.CreateNavigator());

}

And the (nested) code that doesn't:

public void oelnCopyToProposed_Clicked(object sender, ClickedEventArgs e)

{

// Create temp copy object

XmlDocument doc = new XmlDocument();

XmlNode group = null;

XmlNode node = null;

// Check parent node exists /my:Case/my:OtherFacilities/my:oFacilities/my:oExisting/my:oeLoans

if (e.Source.CreateNavigator().SelectSingleNode("ancestor::my:oFacilities/my:oProposed/my:oLoans",

this.NamespaceManager) == null)

{

group = doc.CreateElement("my:oeLoans", NamespaceManager.LookupNamespace("my"));

XmlNode nodeOrphan = doc.CreateElement("my:oeLoan", NamespaceManager.LookupNamespace("my"));

node = group.AppendChild(nodeOrphan);

}

else

{

node = doc.CreateElement("my:oeLoan", NamespaceManager.LookupNamespace("my"));

}

{

// Create and add fields

XmlNode fieldOrphan = doc.CreateElement("my:olnBalance", NamespaceManager.LookupNamespace("my"));

XmlNode field = node.AppendChild(fieldOrphan);

field.InnerXml = e.Source.SelectSingleNode("my:oelnBalance", this.NamespaceManager).InnerXml;

fieldOrphan = doc.CreateElement("my:olnLoanType", NamespaceManager.LookupNamespace("my"));

field = node.AppendChild(fieldOrphan);

field.InnerXml = e.Source.SelectSingleNode("my:oelnLoanType", this.NamespaceManager).InnerXml;

fieldOrphan = doc.CreateElement("my:olnTermRemaining", NamespaceManager.LookupNamespace("my"));

field = node.AppendChild(fieldOrphan);

field.InnerXml = e.Source.SelectSingleNode("my:oelnOriginalTerm", this.NamespaceManager).InnerXml;

}

// Add the doc to the main data

if (group != null)

{

doc.AppendChild(group);

e.Source.CreateNavigator().SelectSingleNode("ancestor::my:oFacilities/my:oProposed",

this.NamespaceManager).AppendChild(doc.DocumentElement.CreateNavigator());

}

else

{

doc.AppendChild(node);

e.Source.CreateNavigator().SelectSingleNode("ancestor::my:oFacilities/my:oProposed/my:oLoans",

this.NamespaceManager).AppendChild(doc.DocumentElement.CreateNavigator());

}

Note that I am also checking that the target group node exists... <oFacilities> is structurally equivalent to <rowA> and <oLoans> to <groupC>.

The line:

if (e.Source.CreateNavigator().SelectSingleNode("ancestor::my:oFacilities/my:oProposed/my:oLoans",

instead of:

if (MainDataSource.CreateNavigator().SelectSingleNode("/my:Case/my:Facilities/my:Proposed/my:Loans",

is to blame. The root node of the e.Source is the node relating to the context of the button so there is no ancestor to go up to, but if we go down through MainDataSource, how do we indicate the context of the upper repeating structure?

When looking into the original problem, a colleague suggested using a calculated field to give the position() of the row. I think that this might offer the solution to this problem, i.e. adding a calculated field in the lower repeating structure which stores the position() in the upper structure. I'll try this, but please offer a solution if you can think of one!

Stu

Re: Copy text from one repeating table to another

Greg Collins — Wed, 14 Jan 2009 21:22:13 GMT

Thank you zxjyqyb! It's always nice to hear a good word back! Glad to have been of assistance!

Re: Copy text from one repeating table to another

zxkuqyb — Wed, 14 Jan 2009 19:43:24 GMT

Greg,

The advice and coding guidance you provide on this site is amazing. I have used several of your examples / methods before and wanted to express my thanks to you for being a solid resource.

Re: Copy text from one repeating table to another

eirike — Fri, 25 Jul 2008 12:47:14 GMT

Hi.

I have problems with this.. Could you please help?

here is my code...

public void CTRL19_5_Clicked(object sender, ClickedEventArgs e)

{

XPathNavigator rootMain = MainDataSource.CreateNavigator().SelectSingleNode("/my:MineFelt/my:Selected/my:Selected2", NamespaceManager);

XPathNavigator rootSecondary = this.DataSources["getStorfeIDyrehold"].CreateNavigator().SelectSingleNode("/dfs:myFields/dfs:dataFields/tns:getStorfeIDyreholdResponse/tns:getStorfeIDyreholdResult/storfeListe", NamespaceManager);

XPathNodeIterator selectnodes = rootSecondary.Select("getStofeIDyrehold", NamespaceManager);

XmlWriter writer = rootMain.SelectSingleNode("/my:MineFelt/my:Selected/my:Selected2", NamespaceManager).AppendChild();

string myNameSpace = NamespaceManager.LookupNamespace("my");foreach (XPathNavigator node in selectnodes)

{

writer.WriteStartElement("S_dyrehold", myNameSpace);

writer.WriteElementString("S_opprMerkeDyrehold", myNameSpace, node.GetAttribute("S_opprMerkeDyrehold", ""));writer.WriteElementString("S_dodsdato", myNameSpace, node.GetAttribute("S_dodsdato", ""));

writer.WriteEndElement();

}

Re: Copy text from one repeating table to another

Greg Collins — Thu, 19 Jun 2008 17:10:14 GMT

Great! Glad to hear you got it working!

Re: Copy text from one repeating table to another

DMcKinnon — Wed, 18 Jun 2008 12:01:44 GMT

Thanks Greg, I will have to try it and see if that works.

Update: Thanks a lot Greg, that seemed to be my lynch pin problem, after fixing that and a few other minor fixes I was able to get it working perfectly.

Thanks again