General

Re: Code to add rows at the end of repeating table

franck — Tue, 15 Nov 2005 16:26:36 GMT

You are welcome.

Good luck with your InfoPath Developments. Don't hesitate to come back and to open a new thread if you have any other issue.

Re: Code to add rows at the end of repeating table

Abhishek — Tue, 15 Nov 2005 15:50:21 GMT

Thank you very very much Frank.

Something had gone wrong with my schema.Becoz I deleted the groups and fields and added the same thing again and it worked.
And I really dont know as to how something can go wrong with my schema without me doing anything to it.

Anyway thank u very much.
U guys make a lot of guys like me happy by providing solutions.
Just cant tell u how releived I am.
regards,
Abhishek

Re: Code to add rows at the end of repeating table

franck — Mon, 14 Nov 2005 14:35:52 GMT

Hi Abhishek,

Something may be wrong with your schema. To check that it is working:
- Create a new blank form.
- Drag-n-Drop a Repeating Section (from your "Controls" Task Pane) on your main View.
- Inside the repeating section, Drag-n-Drop 1 textboxe
You should have:
myFields
group1
group2 <-- repeating
field1

Use the code that I posted (make sure to update the namespace). It will work.
Now, compare the schema of that form with your.

Now, you can't replace the template by the DOM as you described at the end of your post.

Regards,

Franck Dauché

Re: Code to add rows at the end of repeating table

Abhishek — Mon, 14 Nov 2005 06:08:27 GMT

Thank you very much guys.But I have a problem when using the same code as the one given by Frank

Case1
The structure of my data source is as follows

--PR_Form //root
--Executers //This is a group
--Approvers //This is a group
---Approver //This is a repeating group
--- ApproverName //Field

Now in the onclick event if I write the code given by Franck as follows..
IXMLDOMDocument2 templateDom = (IXMLDOMDocument2)thisXDocument.CreateDOM();

templateDom.validateOnParse = false;
templateDom.load("template.xml");

templateDom.setProperty("SelectionNamespaces", "xmlns:my='http://schemas.microsoft.com/office/infopath/2003/myXSD/2005-11-02T09:58:08'");

IXMLDOMNode oTemplateGrp = templateDom.selectSingleNode("/my:PR_Form/my:Executers/my:Approvers/my:Approver");

IXMLDOMNode oTemplateNode = oTemplateGrp.cloneNode(true);

IXMLDOMNode oGroup1 = thisXDocument.DOM.selectSingleNode("/my:PR_Form/my:Executers/my:Approvers");

oGroup1.appendChild(oTemplateNode);
But when debugging,after the last line i.e "oGroup1.appendChild(oTemplateNode);",
Infopath throws an error stating

System.Runtime.InteropServices.COMException
Element 'http://schemas.microsoft.com/office/infopath/2003/myXSD/2005-11-02T09:58:08}Approver' is unexpected according to content model of parent element 'http://schemas.microsoft.com/office/infopath/2003/myXSD/2005-11-02T09:58:08}Approvers'.

at Microsoft.Office.Interop.InfoPath.SemiTrust.IXMLDOMNode.appendChild(IXMLDOMNode newChild)
at Microsoft.Office.Interop.InfoPath.SemiTrust.DOMNodeWrapper.appendChild(IXMLDOMNode newChild)
at Microsoft.Office.Interop.InfoPath.SemiTrust.DOMNodeWrapper.appendChild(IXMLDOMNode newChild)
at PR_Automation.PR_Automation.CTRL16_40_OnClick(DocActionEvent e) in e:\1pr_automation\pr_automation\formcode.cs:line 123
at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

Out of curiosity,I used "templateDom.selectSingleNode" instead of "thisXDocument.Dom.selectSingleNode" when creating the oGroup1 node.Surprisingly Infopath did not throw the error nor did I get the desired results.
So I think its got something to do with setting namespace or some thing like that.
Need ur help guys.

Regards,
Abhishek

Re: Code to add rows at the end of repeating table

franck — Sun, 13 Nov 2005 18:08:23 GMT

Hi,

Here is a C# sample is you need managed code instead:

IXMLDOMDocument2 templateDom = (IXMLDOMDocument2)thisXDocument.CreateDOM();
templateDom.validateOnParse = false;
templateDom.load("template.xml");
templateDom.setProperty("SelectionNamespaces", "xmlns:my='http://schemas.microsoft.com/office/infopath/2003/myXSD/2005-10-10T17-59-19'");
IXMLDOMNode oTemplateGrp = templateDom.selectSingleNode("/my:myFields/my:group1/my:group2");
IXMLDOMNode oTemplateNode = oTemplateGrp.cloneNode(true);
IXMLDOMNode oGroup1 = thisXDocument.DOM.selectSingleNode("/my:myFields/my:group1");
oGroup1.appendChild(oTemplateNode);

Regards,

Franck Dauché

Re: Code to add rows at the end of repeating table

vt_asparagus — Sun, 13 Nov 2005 14:48:08 GMT

This is in VBScript but you can translate it pretty easily to whatever language.

For sXML pass in an XML string for the group item like:

sXML = "<Approver><fname></fname><lname></lname><email></email></Approver>"

For sParentNodePath pass in the XPath string for the Approver repeating group.

sParentNodePath = "//my:Approvers"

Sub CreateRow(sXML, sParentNodePath)

'Create a new row
dim oXml
set oXml = XDocument.CreateDOM()
oXml.async = false
oXml.loadXML(sXML)

'add the row to the DOM
XDocument.DOM.selectSingleNode(sParentNodePath).appendChild(oXml.documentElement)

End Sub

Code to add rows at the end of repeating table

Abhishek — Sun, 13 Nov 2005 14:34:17 GMT

Hi,

I have a repeating table that is used to capture the list of approvers who approve the form in the work flow.
So when each approver selects his superior,I need to add the superior name to this repeating table.

I need a code sample to append a row at the bottom of the repeating table which already contains some number of rows.

Any help greatly appreciated.

regards,
Abhishek.