InfoPath Dev

Hi everyone,

I'm having a problem with populating the text boxes in my repeating sections.  The repeating section has 1 textbox where the user will paste a string of text, which is then parsed and used to populate the rest of the text boxes in the section.  The code works fine for the first box.  The user can then click the 'Add Item' button, which makes another section which is identical to the first.  The problem is that when the user pastes another string on information into the new textbox, none of the fields are populated.  I'm not sure if it has something to do with the field tags, or if I'm just not coding the functionality properly; I'm kind of figuring out form programming as I go.  If anyone can shed some light on my problem, it would be much appreciated.

Thanks in advance,

Drew

// Write your code here to restore the global state.

// An undo or redo operation has occurred and the DOM is read-only.

// A field change has occurred and the DOM is writable.

// Write your code here.

try

          // do nothing

     else

     // specify field delimiters

     "City :", "State:", "Zip:", "Time Zone:", "Start:", "End:", "Contact Name:",

     "Password:", "Type:", "Status:"};

     if (elements.Length == 19) // correct info has been pasted into field

          if (elements[17].Equals("Master")) // populate fields

               e.XDocument.DOM.selectSingleNode("/my:myFields/my:Dealer_Info/my:Branch_ID").text = elements[1];

               e.XDocument.DOM.selectSingleNode("/my:myFields/my:Dealer_Info/my:Address").text = elements[3];

               e.XDocument.DOM.selectSingleNode("/my:myFields/my:Dealer_Info/my:State").text = elements[5];

               elements[7] = elements[7].TrimStart(' ');

               e.XDocument.DOM.selectSingleNode("/my:myFields/my:Dealer_Info/my:Start_Time").text = elements[8];

               e.XDocument.DOM.selectSingleNode("/my:myFields/my:Dealer_Info/my:Contact_Name").text = elements[10];

               e.XDocument.DOM.selectSingleNode("/my:myFields/my:Dealer_Info/my:Fax_Num").text = elements[12];

              e.XDocument.DOM.selectSingleNode("/my:myFields/my:Dealer_Info/my:Username").text = elements[15];

              e.XDocument.DOM.selectSingleNode("/my:myFields/my:Dealer_Info/my:Type").text = elements[17];

         else

                    " Please verify that you have selected the correct user.");

     else

finally

// implement any clean-up that needs to be done

Your selections are a problem... You are always selecting from the root node down... This is bad for repeating lists. You need to select from the current row.

BAD: IXMLDOMNode InputString = e.XDocument.DOM.lastChild.selectSingleNode("/my:myFields/my:Dealer_Info/my:Input");
GOOD: IXMLDOMNode InputString = e.Site;

BAD: e.XDocument.DOM.selectSingleNode("/my:myFields/my:Dealer_Info/my:Dealer_Name").text = elements[0];
GOOD: e.Site.selectSingleNode("../my:Dealer_Name").text = elements[0];

I tried replacing my selections with .Site as you suggested, but the fields are still not updating;  it still fills in the text boxes for the first section correctly, but when I tried to enter information in the newly generated Input textbox in the next instance of the repeating section, nothing was filled in again.  Is there something I'm not doing correctly to specify that I want the fields in the last Repeating Section to update?  I tried using some of the properties in conjunction with .Site, but I kept getting the same results.

IXMLDOMNode InputString = e.Site; //.selectSingleNode("/my:myFields/my:Dealer_Info/my:Input");

// do nothing

else

// specify field delimiters

"City :", "State:", "Zip:", "Time Zone:", "Start:", "End:", "Contact Name:",

"Password:", "Type:", "Status:"};

if (elements.Length == 19) // correct info has been pasted into field

if (elements[17].Equals("Master")) // populate fields

e.Site.selectSingleNode("/my:myFields/my:Dealer_Info/my:Branch_ID").text = elements[1];

e.Site.selectSingleNode("/my:myFields/my:Dealer_Info/my:Address").text = elements[3];

e.Site.selectSingleNode("/my:myFields/my:Dealer_Info/my:State").text = elements[5];

elements[7] = elements[7].TrimStart(' ');

e.Site.selectSingleNode("/my:myFields/my:Dealer_Info/my:Start_Time").text = elements[8];

e.Site.selectSingleNode("/my:myFields/my:Dealer_Info/my:Contact_Name").text = elements[10];

e.Site.selectSingleNode("/my:myFields/my:Dealer_Info/my:Fax_Num").text = elements[12];

e.Site.selectSingleNode("/my:myFields/my:Dealer_Info/my:Username").text = elements[15];

e.Site.selectSingleNode("/my:myFields/my:Dealer_Info/my:Type").text = elements[17];

else

" Please verify that you have selected the correct user.");

else

finally

// implement any clean-up that needs to be done

I was just stepping through the code and saw that in the local variables, e.Operation is listed as being "Insert" the first time through. However, on the 2nd run, it changes to "Delete".  This property is read-only.  Is there and way that I can get it to register as an Inset operation the 2nd time?

Please disregard the last post.  This happened after information was pasted over information already in the field.

You are close. It's still not working because you only made half the change. Note carefully the difference in the XPaths:

BAD: e.Site.selectSingleNode("/my:myFields/my:Dealer_Info/my:Dealer_Name").text = elements[0];
GOOD: e.Site.selectSingleNode("../my:Dealer_Name").text = elements[0];

You are using ABSOLUTE XPaths (which always start at the root node and work their way down to the FIRST repeating row). You need to be using RELATIVE XPaths, which start with the CURRENT row and get sibling fields. The ".." tells the XPath to go to the parent node and start selecting from there.

Wow, I'm feeling a bit foolish.  I noticed that in your first reply but thought it was just a shorthand for the rest of the XPath.  I made the change and it's working like a charm.  Thanks again for all your help, Greg.

No problem. Glad to help. The XPath language can be difficult at times to get your mind around.

I just posted this inquiry to a different thread in this forum (http://www.infopathdev.com/forums/p/8156/31383.aspx#31383) but thought I'd post it here as well... 

I am at a loss.  Is it really just my xpaths that are faulty or is it also the type of event handler I am declaring/working on?  Well, all that and faulty coding?  Let me ask, will a changed event trigger each time a new row is added to a repeating table?  Or do I need a different handler?  Morever, is the handler associated with the right grouping?  Please note that I am using the default insert row functionality that comes with the repeating table control (in other words, I am not using a button control).  That said, assuming that a changed event triggers with each new row insert, then the problem is definitely with the xpaths and/or the code.  Currently, I can auto-populate the person's job title textbox ***for the first row only***.  Once I insert another row and resolve a name from the Contact Selector, however, the person's job title textbox no longer auto-populates and so on with other inserted rows.

This is happening in a ***browser-enabled*** form in the browser (not in preview mode). 

Can someone please let me know how to resolve this quickly?

My main data source for this particular set of fields looks like:

(...)
selector_table (repeating group)
    selector_control
       Person (repeating group)
          DisplayName
          AccountId
          AccountType
  job_title textbox
  textbox2
  textbox3
  textbox4
(...)

My secondary data source for GetUserProfileByName is the standard structure everyone's familiar with.

This is what I am coding: 

string title = string.Empty;

XPathNavigator main = MainDataSource.CreateNavigator();

secondary.SelectSingleNode("/dfs:myFields/dfs:queryFields/s0:GetUserProfileByName/s0:AccountName", NamespaceManager).SetValue(id);

title = secondary.SelectSingleNode(@"/dfs:myFields/dfs:dataFields/s0:GetUserProfileByNameResponse/s0:GetUserProfileByNameResult/s0:PropertyData[s0:Name = ""Title""]/s0:Values/s0:ValueData/s0:Value", NamespaceManager).Value;

 I just wanted to add my thanks to this thread as well. I had been struggling with this problem for days. I finally found the answer I was looking for here. I had posted on Expert's Exchange and the Microsoft Office site and had no luck. My thanks again to Greg!

 Tom