Browser Forms

Re: Insert Blank Rows to Repeating Table

JonesAF — Wed, 11 Feb 2015 19:01:53 GMT

Hi Hilary, I have a similar situation. I think what you have shared here has gotten me part of the way. Here is what I have done so far: What I am trying to do is simple, but I cannot figure it out. I am ready to just give up so please help. 1. How do I create and XML structure that I can then read back into InfoPath to automatically insert the values from my XML into my repeating table? 2. I would like to use a drop-down list to select / set the XMLml file it should be reading in. thanks for any help Here is my current XML structure based the one you shared here: sampledata.xml

My current c#(2007) code

"using Microsoft.Office.InfoPath; using System; using System.Windows; using System.Xml; using System.Xml.XPath; namespace CustomRepeatingSection { public partial class FormCode { // Member variables are not supported in browser-enabled forms. // Instead, write and read these values from the FormState // dictionary using code such as the following: // // private object _memberVariable // { // get // { // return FormState["_memberVariable"]; // } // set // { // FormState["_memberVariable"] = value; // } // } // NOTE: The following procedure is required by Microsoft InfoPath. // It can be modified using Microsoft InfoPath. public void InternalStartup() { EventManager.FormEvents.Loading += new LoadingEventHandler(FormEvents_Loading); } public void FormEvents_Loading(object sender, LoadingEventArgs e) { //get your repeating group. The XPath in quotes needs to change according to your form's data structure //you want to add a new row only if there is no completely blank row available, so we will filter our XPath to only select a group where all the fields are blank //my group only has two fields. Yours may be different. You'll need to change the bit in the square brackets to address your data structure XPathNavigator parent = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:topGroup", NamespaceManager); XPathNavigator group = parent.SelectSingleNode("my:repeatingGroup[my:rgField1 = '' and my:rgField2 = '' and my:rgField3 = '' and my:rgField4 = '']", NamespaceManager); //MessageBox.Show("this method was executed at runtime"); //if our variable group is null, we have no 'empty' rows in our form and need to add one if (null == group) { //get our repeating group from sampledata.xml XmlDocument sample = new XmlDocument(); //sample.Load(this.Template.OpenFileFromPackage("https://team.duke-energy.com/sites/PMCoEP/PMCoE%20Qualification%20Card/QCAssetLib/sampledata.xml")); //sampledata.xml sample.Load("sampledata.xml"); XPathNavigator newGroup = sample.CreateNavigator().SelectSingleNode("/my:myFields/my:topGroup/my:repeatingGroup", NamespaceManager); parent.AppendChild(newGroup); } } } }

Re: Insert Blank Rows to Repeating Table

LeslieAD — Mon, 01 Oct 2012 06:11:34 GMT

Not sure if this topic is closed, or whether it should resurrect with each new InfoPath version :-(

How would I insert a new row in InfoPath 2010?

Ideally I intend using a Repeating Table for record the Review Dates when a list item is viewed (or reviewed with comments)

The RT will initially be empty and the first row will have the access date added when the form is closed. Next time the form is opened the RT needs to have a row added to enable the new access date to be inserted.

Any thoughts would be greatly appreciated

leslie

Re: Insert Blank Rows to Repeating Table

jaxkookie — Tue, 24 Jan 2012 14:24:24 GMT

Hilary,

I can really use this solution but I am struggling trying to get it to work. I am not sure if it is the structure of my XML file or something else. I run this on button clik

XPathNavigator parent = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:CommoditySummary/my:Line_Items", NamespaceManager);

//get our repeating group from sampledata.xml
XmlDocument sample = new XmlDocument();
sample.Load(this.Template.OpenFileFromPackage("CmdtyRow.xml"));

  XPathNavigator newGroup = sample.CreateNavigator().SelectSingleNode("/my:myFields/my:CommoditySummary/my:Line_Items/my:Commodity", NamespaceManager);

  parent.AppendChild(newGroup) XPathNavigator parent = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:CommoditySummary/my:Line_Items", NamespaceManager);

  //get our repeating group from sampledata.xml
  XmlDocument sample = new XmlDocument();
sample.Load(this.Template.OpenFileFromPackage("CmdtyRow.xml"));

Any suggestions?

Re: Insert Blank Rows to Repeating Table

Hilary Stoupa — Thu, 02 Jul 2009 17:38:47 GMT

RIght, but as discussed earlier in this thread, you can't use the 2003 object model in browser compatible forms....

Re: Insert Blank Rows to Repeating Table

MarsdeNation — Thu, 02 Jul 2009 02:56:47 GMT

Fantastic! Thank you so much!

I had some trouble publishing the form template, but I found a half decent and reasonably easy to understand description here:

http://blogs.interknowlogy.com/jeffschroeder/archive/2006/10/31/7913.aspx

Weird that such a simple thing like "insert a new row if data source is empty" is so hard to make happen ...

As a side note, I found in Tools / Options / Design an option "Programming language when designing forms in infopath:", where I could change it from C# to C# (Infopath 2003 Compatible). Changing this may have made my form accept the original 2003 code posted above, but I have not tested this ... Now that My form is working I'm not touching it!

Thanks again.

Re: Insert Blank Rows to Repeating Table

Hilary Stoupa — Wed, 01 Jul 2009 22:42:20 GMT

So, if Technician Comments is blank, you want to add a new row?

        public void FormEvents_Loading(object sender, LoadingEventArgs e)

        {

            //get your repeating group. The XPath in quotes needs to change according to your form's data structure

            //you want to add a new row only if there is no completely blank row available, so we will filter our XPath to only select a group where all the fields are blank

            //my group only has two fields. Yours may be different. You'll need to change the bit in the square brackets to address your data structure

            XPathNavigator parent = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:TechnicianPage/my:TechComments", NamespaceManager);

            XPathNavigator group = parent.SelectSingleNode("my:group7[my:TechnicianComments = '']", NamespaceManager);

            //if our variable group is null, we have no 'empty' rows in our form and need to add one

            if (null == group)

            {

                //get our repeating group from sampledata.xml

                XmlDocument sample = new XmlDocument();

                sample.Load(this.Template.OpenFileFromPackage("sampledata.xml"));

                XPathNavigator newGroup = sample.CreateNavigator().SelectSingleNode("/my:myFields/my:TechnicianPage/my:TechComments/my:group7", NamespaceManager);

                parent.AppendChild(newGroup);

            }

        }

Hopefully I don't have any typos in the XPaths and this will just work for you.

Re: Insert Blank Rows to Repeating Table

MarsdeNation — Wed, 01 Jul 2009 01:30:03 GMT

Hi Hilary, thank you for your help :)

Apologies for the Noob Question, but code gives me a headache and I really don't know how to enter the references to my data source in the square brackets as you have mentioned in the comments of your code.

Can you please re-post the code so that it will work with my data sources below:

The Repeating table group is called "Group 7", and the field in question is "TechnicianComments".

Thanks in advance.

Re: Insert Blank Rows to Repeating Table

Hilary Stoupa — Tue, 30 Jun 2009 16:06:28 GMT

Hi -- here's C# for 2007:

        public void FormEvents_Loading(object sender, LoadingEventArgs e)

        {

            //get your repeating group. The XPath in quotes needs to change according to your form's data structure

            //you want to add a new row only if there is no completely blank row available, so we will filter our XPath to only select a group where all the fields are blank

            //my group only has two fields. Yours may be different. You'll need to change the bit in the square brackets to address your data structure

            XPathNavigator parent = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:topGroup", NamespaceManager);

            XPathNavigator group = parent.SelectSingleNode("my:repeatingGroup[my:rgField1 = '' and my:rgField2 = '']", NamespaceManager);

            //if our variable group is null, we have no 'empty' rows in our form and need to add one

            if (null == group)

            {

                //get our repeating group from sampledata.xml

                XmlDocument sample = new XmlDocument();

                sample.Load(this.Template.OpenFileFromPackage("sampledata.xml"));

                XPathNavigator newGroup = sample.CreateNavigator().SelectSingleNode("/my:myFields/my:topGroup/my:repeatingGroup", NamespaceManager);

                parent.AppendChild(newGroup);

            }

        }

Re: Insert Blank Rows to Repeating Table

warrtalon — Tue, 30 Jun 2009 03:07:54 GMT

It does seem like it would be pretty simple, but I just don't know of a way.

Re: Insert Blank Rows to Repeating Table

MarsdeNation — Tue, 30 Jun 2009 03:00:29 GMT

Thanks for the idea,

I tried it and I lost the use of the ()username function, plus when I tried to open open Visual Studio Tools for Applications it made me change back to version 2007 anyway ...

It seems I need version 2007 compatible code.

Is there not an easier way to do this? It seems allot of trouble just to add another row to a repeating table :(

Thanks.

Re: Insert Blank Rows to Repeating Table

warrtalon — Tue, 30 Jun 2009 02:44:40 GMT

Mars, this is just a guess, but you can browser-enable a 2007-based form that is saves as a 2003 file. You can't do this from 2003, but you can do it from 2007. Maybe try doing a Save As on your template and choose the InfoPath 2003 format. Then, go back into the Programming settings to see if that 2003 option is there.

Re: Insert Blank Rows to Repeating Table

MarsdeNation — Tue, 30 Jun 2009 01:50:38 GMT

Hi Hilary,

Thanks for the clarification. My Form is browser-enabled, and when I go to Tools / Form Options / Programming only get 2 options in the drop down box, C# and Visual Basic.

I also get a message saying "Script and depreciated object models are not supported in browser-enabled form templates".

I am assuming that I cannot use this C# for 2003 code sample provided above because my form template is browser-enabled? DAMN!

Does anyonme have any other suggestions that would help me please?

Thanks in advance.

Re: Insert Blank Rows to Repeating Table

Hilary Stoupa — Mon, 29 Jun 2009 23:11:35 GMT

You have been provided with an InfoPath 2003 object model code sample. Your form is set to use InfoPath 2007. Under Tools / Form Options / Programming you can change your programming language. Since this sample is C# for 2003, you can select that from the drop down for the language.

Re: Insert Blank Rows to Repeating Table

MarsdeNation — Mon, 29 Jun 2009 23:07:36 GMT

I have inserted your code, and I get several errors that I do not understand.

Am I even close? I am really out of my depth here.

Thanks in advance.

Re: Insert Blank Rows to Repeating Table

MarsdeNation — Mon, 29 Jun 2009 22:55:44 GMT

Thanks for your help so far swathip, I think I am getting out of my depth here.

I read the link you sent, and it outlines how to add a row to a repeating table by clicking a button, but I want it to happen when the form loads.

I have installed Microsoft Visual Studio Tools for Applications and I can access that if I go to the Tools/Programing/Loading Event ... Menu item, and the VSTA loads and my eyes glaze over and I am lost.

Am I close and on the right track?

The code that appears when VSTA loads is below:

using Microsoft.Office.InfoPath;
using System;
using System.Xml;
using System.Xml.XPath;

namespace IT_Job_Requests_2_1_Change_to_C_
{
    public partial class FormCode
    {
        // Member variables are not supported in browser-enabled forms.
        // Instead, write and read these values from the FormState
        // dictionary using code such as the following:
        //
        // private object _memberVariable
        // {
        //     get
        //     {
        //         return FormState["_memberVariable"];
        //     }
        //     set
        //     {
        //         FormState["_memberVariable"] = value;
        //     }
        // }

        // NOTE: The following procedure is required by Microsoft Office InfoPath.
        // It can be modified using Microsoft Office InfoPath.
        public void InternalStartup()
        {
            EventManager.FormEvents.Loading += new LoadingEventHandler(FormEvents_Loading);
        }

        public void FormEvents_Loading(object sender, LoadingEventArgs e)
        {
            // Write your code here.
        }
    }
}

I am assumeing I should try and insert the code you wrote at ther bottom where the comment says "Write your code here" ...

Fingers crossed ...