How Do I Copy Repeating Data From an External Source into My Form?

re: How Do I Copy Repeating Data From an External Source into My Form?

gec13 — Wed, 19 Mar 2014 09:35:28 GMT

Hi Hilary

Very nice post, thanks.

I would be grateful, if you could guide me on the following please (this may already have been asked before).

I am new to InfoPath and designed forms which Submit to one row in SQL table.

My question is, Is there any way that I can store information to multiple rows in SQL table?

If yes than which components should I use?

Many thanks in advance.

re: How Do I Copy Repeating Data From an External Source into My Form?

Jorge Luna — Fri, 12 Jul 2013 15:10:54 GMT

Hi again, i have the drop down list but with this format:

4;#Mirage

9;#Decameron

4;#Sheraton

what i do, for delete or elimate this symbols (4;# - 9;# - ....) ?

thanks..

re: How Do I Copy Repeating Data From an External Source into My Form?

Hilary Stoupa — Thu, 10 Jan 2013 23:03:13 GMT

Hey, Kourtney - so you are getting the null ref exception when you follow the full tutorial? You aren't trying to use this code in a form with a different schema, right?

re: How Do I Copy Repeating Data From an External Source into My Form?

Kourtney — Tue, 06 Nov 2012 23:06:07 GMT

Hilary

I hope you can help me, I am new to programming.

I have a similar situation with an InfoPath 07 form that is pulling from the SharePoint 07 form library (Second Data Source) that it submits to.

On a change request, one can select a specific docId and prepopulate the new form with data from an existing form.

Of course, the repeating section does not prepopulate.

I merged the data and then published it back to sharepoint. I could tell it is trying to read something, but I pretty much ruined everything good that I had going on.

So, not only do I submit my form data to SharePoint, but I also submit the form data as XML to SQL Server which is where I generate my docId. I'm not sure how to reference my XML in the database from the code. Nor do I know how to extend the repeating table, using code (c#).

The above code looks helpful, but I have no idea what its trying to tell me and I know my situation is a bit different than what is explained.

Could you please guide me in the right direction and/or maybe point out specific areas that would be helpful to me?

So far I have played around with the following code:

public void ExistingFormList_Changed(object sender, XmlEventArgs e)

{

// Write your code here to change the main data source.

//XPathNavigator myCarList = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:grpMain/my:grpCarRental/my:grpCarRentalRepeating/my:grpCarRentalItinerary", NamespaceManager);

//myCarList.AppendChild();

XPathNavigator xPathNavi = MainDataSource.CreateNavigator();

XPathNavigator details = xPathNavi.SelectSingleNode("/my:myFields/my:grpMain/my:grpCarRental/my:grpCarRentalRepeating", NamespaceManager);

XPathNavigator repTable = details.SelectSingleNode("/my:myFields/my:grpMain/my:grpCarRental/my:grpCarRentalRepeating", NamespaceManager);

XPathNavigator node;

int counter = 0;

for (int i = 0; i < 1; i++)

{

node = repTable.Clone();

node.SelectSingleNode("my:txtCarFrom", NamespaceManager).SetValue("my:txtCarFrom" + i.ToString());

node.SelectSingleNode("my:txtCarTo", NamespaceManager).SetValue("my:txtCarTo" + i.ToString());

node.SelectSingleNode("my:picCarPickupDate", NamespaceManager).SetValue("my:picCarPickupDate" + i.ToString());

node.SelectSingleNode("my:picCarPickupTime", NamespaceManager).SetValue("my:picCarPickupTime" + i.ToString());

node.SelectSingleNode("my:picCarReturnDate", NamespaceManager).SetValue("my:picCarReturnDate" + i.ToString());

node.SelectSingleNode("my:picCarReturnTime", NamespaceManager).SetValue("my:picCarReturnTime" + i.ToString());

node.SelectSingleNode("my:optOneWayRental", NamespaceManager).SetValue("my:optOneWayRental" + i.ToString());

node.SelectSingleNode("my:chkCarInterview", NamespaceManager).SetValue("my:chkCarInterview" + i.ToString());

node.SelectSingleNode("my:chkCarBusComp", NamespaceManager).SetValue("my:chkCarBusComp" + i.ToString());

details.AppendChild(node);

counter += 1;

}

****NullReferenceException was unhandled by user code****

Let me know if you need better explaination

Thank you so much for all your help

re: How Do I Copy Repeating Data From an External Source into My Form?

Gennady Vanin (Геннадий Ванин, Новосибирск) — Mon, 03 Sep 2012 19:14:19 GMT

For the stupid like me remember to replace

schemas.microsoft.com/.../2008-06-03T00:09:57

string vehicleXml = "<my:Vehicle xmlns:my='schemas.microsoft.com/.../2008-06-03T00:09:57'>"

+ ....

by the value from your Infopath form (from Details of properties of myFields in Fields pane)

re: How Do I Copy Repeating Data From an External Source into My Form?

Beircheart — Fri, 06 Aug 2010 13:57:59 GMT

This tutorial was of great help to me. Thank you Hilary!

See here for more detail: www.infopathdev.com/.../57561.aspx

re: How Do I Copy Repeating Data From an External Source into My Form?

Hilary Stoupa — Thu, 08 Jul 2010 00:17:04 GMT

Hey, mahakbhalla -- I know you also emailed me on this, as well as posted a question on the forum on this. Here's a link to the question: www.infopathdev.com/.../56596.aspx

re: How Do I Copy Repeating Data From an External Source into My Form?

mahakbhalla — Tue, 06 Jul 2010 05:14:44 GMT

URGENTLY HELP SOUGHT!!!

I have an infopath form and I want to display top 3 values from secondary data source in a repeating table. I will select a name from drop down and it should display only top 3 rows and not all from database on infopath repeating table out of many in database. How can it be done.

re: How Do I Copy Repeating Data From an External Source into My Form?

Hilary Stoupa — Wed, 26 May 2010 23:49:41 GMT

What about changing your form to use JScript instead of VB? Or do you alread have VB Script in your form?

re: How Do I Copy Repeating Data From an External Source into My Form?

DerekB — Thu, 01 Apr 2010 20:16:10 GMT

Hi...I'm afraid I cannot seem to find anybody that can convert the jScript to VB, is there anybody around here that might be able to do so?

re: How Do I Copy Repeating Data From an External Source into My Form?

Hilary Stoupa — Sun, 27 Sep 2009 13:31:31 GMT

As to RhysAZ's question, you'd need to add a filter to the list so it didn't display anything that had previously been selected. Previous-sibling can help with that.

To riaz secl -- just don't include the blank row by default -- you'll find this under the default values.

And to Derek -- the jscript sample is for IP 2003. You'll just have to translate from jscript to vb.

re: How Do I Copy Repeating Data From an External Source into My Form?

DerekB — Fri, 11 Sep 2009 18:15:41 GMT

Hi,

This is exactly what I need, with one small problem. All of the code in my forms is vbScript, and secondly I'm stuck in Infopath 2003. Can this still be done?

re: How Do I Copy Repeating Data From an External Source into My Form?

riaz_secl — Tue, 07 Jul 2009 05:15:46 GMT

Thak you so much for this very helpfull article.

Now i have a question to you...here i see you doesn't use the existing first blank row.

have any process to use this first blank row..???

if have any......please reply me.

re: How Do I Copy Repeating Data From an External Source into My Form?

RhysAZ — Tue, 19 May 2009 01:57:18 GMT

Thanks for the tutorial Hilary.

While I was testing out your example form, I noticed that your are able to select the same vehicle type & insert the vehicle's data into the repeating table as many times as you want, by pushing Add Rows.

I would like only for my form user to be able to select the "vehicle type" once, prefill the repeating table rows with the vehicle's data by using the Add Rows button, and then the user will not be able to select that particular "vehicle type" again.

Can this be done? And if so, how?

How To Submit and Refresh the Active Form Window Programmatically? | keyongtech

How To Submit and Refresh the Active Form Window Programmatically? | keyongtech — Fri, 20 Feb 2009 04:07:05 GMT

Pingback from How To Submit and Refresh the Active Form Window Programmatically? | keyongtech