Newbie Questions

Re: Add a field's value to a Repeating Table field programically.

Shiva — Tue, 26 Aug 2008 07:33:27 GMT

Hello,

Here is the code you have to write in your onClick Event,

IXMLDOMDocument2 sampleDataDom = (IXMLDOMDocument2)thisXDocument.CreateDOM();

sampleDataDom.async = false;

sampleDataDom.validateOnParse = false;

sampleDataDom.setProperty("SelectionNamespaces", "namespace of your form");

sampleDataDom.load("sampledata.xml");

IXMLDOMNode perActivityNodeFromSampledata = sampleDataDom.selectSingleNode("/my:TimesheetDetails/my:EmployeeInformation/my:TimeReporting/my:PerActivity").cloneNode(true);

IXMLDOMNode timeReportingNode = thisXDocument.DOM.selectSingleNode("("/my:TimesheetDetails/my:EmployeeInformation/my:TimeReporting ");

//Inserting the sample node at first position.

timeReportingNode.parentNode.insertBefore(perActivityNodeFromSampledata, timeReportingNode);

Re: Add a field's value to a Repeating Table field programically.

Hilary Stoupa — Mon, 25 Aug 2008 01:13:40 GMT

Well -- I'm afraid it took me quite a bit longer to get back to this, but so that it is posted somewhere, here is a sample that gets sampledata.xml using the 2007 object model:

XPathDocument sampleData = new XPathDocument(this.Template.OpenFileFromPackage("sampledata.xml"));
XPathNavigator newGroup = sampleData.CreateNavigator().SelectSingleNode("/my:myFields/my:topGroup/my:repeatingGroup", NamespaceManager).Clone();

Note the OpenFileFromPackage method -- it took me a bit to find it, but I can already see it is going to be *very* handy...

Edit:
After I revisted this, I discovered that XPathDocument is read-only! So, if you clone from it, you'll not be able to set values in your new group. Use this instead:
            //get sampledata
            XmlDocument sampleData = new XmlDocument();
            sampleData.Load(this.Template.OpenFileFromPackage("sampledata.xml"));

Re: Add a field's value to a Repeating Table field programically.

zeroecho — Wed, 13 Aug 2008 18:41:49 GMT

Hilary sorted my problem out for those who may find themselves with a similar problem. e.Source.Clone() was what I was after for the entire row :)

Re: Add a field's value to a Repeating Table field programically.

Hilary Stoupa — Tue, 12 Aug 2008 22:48:08 GMT

Hi, Catharine:

I have not been able to run code using rules that changes the main DOM of the form -- which is what you'd be doing if you called that code from a rule. I know of one series of posts on this where they worked around it by changing a hidden field's value in a rule and then putting the code in the Changed event for that field, which I thought was rather clever.

Here is some sample code for getting info from the Sample.xml. I'm sorry -- it is in C# and uses the 2003 object model, but I don't have time today to work up a 2007 sample -- if I get a chance tomorrow, I'll post again. This may at least give you an idea, however:

IXMLDOMDocument2 sampleData;
sampleData = (IXMLDOMDocument2)thisXDocument.CreateDOM();
sampleData.async = false;
sampleData.validateOnParse = false;
sampleData.setProperty("SelectionNamespaces", "xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:dfs=\"http://schemas.microsoft.com/office/infopath/2003/dataFormSolution\" xmlns:my=\"http://schemas.microsoft.com/office/infopath/2003/myXSD/2008-07-06T22:11:15\" xmlns:xd=\"http://schemas.microsoft.com/office/infopath/2003\"");
sampleData.load("sampledata.xml");

IXMLDOMNode newGroup = sampleData.selectSingleNode("/my:myFields/my:Group1/my:Group2/my:Field1").cloneNode(true);

You'll want to replace the namespaces in sampleData.setProperty with the ones from your sample.xml

Re: Add a field's value to a Repeating Table field programically.

Catharine — Tue, 12 Aug 2008 20:59:49 GMT

Hi, Thank you for your reply...

I have altered the code and it is now working. Instead of running this code from a button I would like to be able to call it from rules as described in http://blogs.msdn.com/infopath/archive/2005/06/17/430347.aspx - do you think this is feasible?

You mentioned copying the from the Sample.xml How do you do that ?

Catharine

Re: Add a field's value to a Repeating Table field programically.

zeroecho — Tue, 12 Aug 2008 19:24:59 GMT

Hi Hilary,

Thanks again for your reply.

I tried what you said, basically the button is the last row in a repeating table called PerActivity of which there contains a whole bunch of information. So then I press Copy I want the whole PerActivity repeating group to be copied.

When I try without the entire XPath and just put the group name "my:PerActivity" it fails saying "XpathNavigator newGroup = oldGroup.Clone()' Object reference not set to an instance of an object"

When I select any field from within PerActivity such as

public void CTRL244_5_Clicked(object sender, ClickedEventArgs e)
        {
            string xpath = "/myLocation";
            XPathNavigator oldGroup = e.Source.SelectSingleNode(xpath,NamespaceManager);
            XPathNavigator newGroup = oldGroup.Clone();
            oldGroup.InsertBefore(newGroup);
        }

I get Object reference not set to an instance of an object

When I try a field from within PerActivity and have the full xpath I get "Schema validation found non-date type errors"

When I try a group within PerActivity "/my:TimesheetDetails/my:EmployeeInformation/my:TimeReporting/my:PerActivity/my:HoursPerDay" I get Object reference not set to an instance of an object (for both just /my:HoursPerDay and for the whole path)

When adding a button in a repeating row theres nothing particularly special you have to do do you?

/my:TimesheetDetails/my:EmployeeInformation/my:TimeReporting/my:PerActivity/my:HoursPerDay/my:Mon is the full xpath of the lowest field in my schema where PerActivity and EmployeeInformation are the only repeating groups.

Frokm what you've said about redirecting back to the root and selecting from there it would seem that by doing e.Source("/my:RepeatingTable", NameSpaceManager) would do the trick, so either my button is being added/linked incorrectly or I'm getting the wrong end of the stick with the XPath query!

Thanks again for your help, feel like I'm almost there and just a syntax error holding me back I hope :D

Re: Add a field's value to a Repeating Table field programically.

Hilary Stoupa — Tue, 12 Aug 2008 17:19:36 GMT

Hi, Catharine:

I suspect your xpath in that line does not point to a valid node. Given your data structure, I would expect "my:Name1" for the first line and "my:Comment1" for the second.

Re: Add a field's value to a Repeating Table field programically.

Hilary Stoupa — Tue, 12 Aug 2008 17:17:20 GMT

Hi, zeroecho:

The problem is your XPath. You are redirecting back to the root and selecting from there (which gives you the first one....) Let's say that your button is in a table connected to "my:TimeReporting". You would want e.Source.SelectSingleNode("my:PerActivity", NamespaceManager). e.Source will get you the correct "my:TimeReporting" row that the button is in.

Re: Add a field's value to a Repeating Table field programically.

zeroecho — Tue, 12 Aug 2008 17:08:51 GMT

        public void CTRL244_5_Clicked(object sender, ClickedEventArgs e)
        {
            string xpath = "/my:TimesheetDetails/my:EmployeeInformation/my:TimeReporting/my:PerActivity";
            XPathNavigator oldGroup = e.Source.SelectSingleNode(xpath,NamespaceManager);
            XPathNavigator newGroup = oldGroup.Clone();
            oldGroup.InsertBefore(newGroup);
        }

PerActivity is a group containing multiple fields I am trying to copy depending on which row the user presses the "Copy" button on.

When I use e.Source.SelectSingleNode and press the Copy button, it simply copies the top node only. It doesn't copy the current field. As far as I was aware, the Button wasn't aware of any XML structure, as it's just a button because that was the first thing I tried but it didn't work.

Thanks for the help so far by the way. I've uploaded the last() version for the time being but am hoping I can figure this one out soon.

Re: Add a field's value to a Repeating Table field programically.

dlocc — Tue, 12 Aug 2008 16:47:03 GMT

Thanks, I actually would prefer to use VB as well.

I just tested the C# code in a new form and it DOES NOT change all the values in the field. I'm clueless as to why my other form went whacko on me. Anyways, thanks for all the input everyone!

Re: Add a field's value to a Repeating Table field programically.

Catharine — Tue, 12 Aug 2008 16:44:01 GMT

Hi I am following this code as well - but I only know VB (and that not very well)

My Xml looks like this

<my:History1>
<my:Name1></my:Name1>
<my:Comment1></my:Comment1>
</my:History1>
<my:text1></my:text1>
<my:text2></my:text2>

I have converted the code to VB

'get values from a couple of fields

Dim xpath As String = "/my:myFields/my:text1"

Dim field1 As XPathNavigator = MainDataSource.CreateNavigator().SelectSingleNode(xpath, NamespaceManager)

xpath = "/my:myFields/my:text2"

Dim field2 As XPathNavigator = MainDataSource.CreateNavigator().SelectSingleNode(xpath, NamespaceManager)

'clone last repeating table row

xpath = "/my:myFields/my:History1[last()]"

Dim oldGroup As XPathNavigator = MainDataSource.CreateNavigator().SelectSingleNode(xpath, NamespaceManager)

Dim newGroup As XPathNavigator = oldGroup.Clone()

'insert the new group

oldGroup.InsertBefore(newGroup)

'set the values of the fields

newGroup.SelectSingleNode("name1", NamespaceManager).SetValue(field1.Value)

newGroup.SelectSingleNode("comment1", NamespaceManager).SetValue(field2.Value)

I am trying to debug and I get

System.NullReferenceException was unhandled by user code
Message="Object reference not set to an instance of an object."
Source="TestInsertRow"
StackTrace:
       at TestInsertRow.FormCode.Insert_Clicked(Object sender, ClickedEventArgs e)
       at Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)
       at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

When I try the newGroup.SelectSingleNode("name1", NamespaceManager).SetValue(field1.Value) line. What have I done wrong in my conversion ?

Re: Add a field's value to a Repeating Table field programically.

dlocc — Tue, 12 Aug 2008 16:42:36 GMT

There's no rules set, All the values for once column change. I have a drop down list field, a date box, and a button. The date field works just fine, but the drop down list is changing all the values when the button clicks. No idea why this is happening as the date column is working properly.

Re: Add a field's value to a Repeating Table field programically.

Hilary Stoupa — Tue, 12 Aug 2008 16:34:38 GMT

Hey, zeroecho:

If you have a button in a repeating table, it knows where it is -- look at this on ClickedEventArgs memebers at MSDN. So, instead of using MainDataSource.CreateNavigator(), you'd use:

XPathNavigator field4 = e.Source.SelectSingleNode("my:field4", NamespaceManager);
MessageBox.Show(field4.Value);

to pop up the row's field4 value in a message box, for demonstration purposes.

Re: Add a field's value to a Repeating Table field programically.

Hilary Stoupa — Tue, 12 Aug 2008 16:26:09 GMT

All the values for one column change, but not the other? Do you have a rule set somewhere that may be running and setting all the values for that column?

Re: Add a field's value to a Repeating Table field programically.

dlocc — Tue, 12 Aug 2008 15:42:04 GMT

Hello Hilary,

I used your code to clone the repeating table row:

//get values from a couple of fields

string xpath = "/my:myFields/my:Actions";

XPathNavigator Actions = MainDataSource.CreateNavigator().SelectSingleNode(xpath, NamespaceManager);

xpath = "/my:myFields/my:ActionDate";

XPathNavigator ActionDate = MainDataSource.CreateNavigator().SelectSingleNode(xpath, NamespaceManager);

//clone last repeating table row

xpath = "/my:myFields/my:group1/my:group2[last()]";

XPathNavigator oldGroup = MainDataSource.CreateNavigator().SelectSingleNode(xpath, NamespaceManager);

XPathNavigator newGroup = oldGroup.Clone();

//insert the new group

oldGroup.InsertBefore(newGroup);

//set the values of the fields

newGroup.SelectSingleNode("my:field1", NamespaceManager).SetValue(Actions.Value);

newGroup.SelectSingleNode("my:field2", NamespaceManager).SetValue(ActionDate.Value);

But the code is still changing all of the values for column 1...