Passing Data into a Form: Input Parameters

re: Passing Data into a Form: Input Parameters

ramkumar1910 — Tue, 22 May 2007 22:27:49 GMT

Great introduction!

it will be very helpful if you could write a bit more on how to use the nput param.

For exampe:

how to pass the input param(student id) to the web service to get the details of one student and display in the form. Thanks

re: Passing Data into a Form: Input Parameters

Scott Heim — Tue, 22 May 2007 22:57:49 GMT

Hi ramkumar1910,

Here is some sample code that I tested on the Loading event - note this does not have any error handling though:

string strCustID = e.InputParameters["CustID"];

DataSource dsCustomers = this.DataSources["GetSelectedCustomer"];

XmlNamespaceManager ns = this.NamespaceManager;

XPathNavigator xnCustomers = dsCustomers.CreateNavigator();

XPathNavigator xnCustID = xnCustomers.SelectSingleNode("/dfs:myFields/dfs:queryFields/tns:GetSelectedCustomer/tns:CustID", ns);

xnCustID.SetValue(strCustID);

dsCustomers.QueryConnection.Execute();

In this sample, I had a secondary data connection called GetSelectedCustomer that takes a CustomerID to pull information for just that customer. I then use the InputParameter to set the "queryField" value of my data connection and then execute that connection.

I hope this helps!

Scott

re: Passing Data into a Form: Input Parameters

BobC — Wed, 06 Jun 2007 23:21:54 GMT

Is there a way to set a parameter at the content type or form library level? I have tried adding a parm in the List Content Type Advanced settings like so:

/FormServerTemplates/MJWorkRequest2007.xsn?View=HelpDesk

but wss seems to lose the ability to open the form since .xsn is no longer at the end of the string.

re: Passing Data into a Form: Input Parameters

swaven — Sun, 05 Aug 2007 06:24:27 GMT

Hi,

I have a question regarding connecting two infopaths.

How can we connect two infopaths through a common column?

I have an infopath with CustID1 and this infopath contains another file

attachment(infopath) and I have to popup the second infopath with the same

CustID1.

I tried the following code in the OnLoad event.

try

{

string strCustID = e.InputParameters["CustID"];

DataSource dsCustomers = this.DataSources["GetCustID"];

XmlNamespaceManager ns = this.NamespaceManager;

XPathNavigator xnCustomer = dsCustomers.CreateNavigator();

XPathNavigator xnCustomer = xnCustomer.SelectSingleNode("/dfs:myFields/dfs:queryFields/tns:Customers/tns:CustomerID");

xnCustomer.SetValue(CustomerID);

dsCustomer.QueryConnection.Execute();

}

catch (exception e)

{

messagebox.show(e.message,"Error");

}

but encountered the following error:

System.Collections.Generic.KeyNotFoundException was unhandled by user code

Message="The given key was not present in the dictionary."

Source="mscorlib"

StackTrace:

at System.ThrowHelper.ThrowKeyNotFoundException()

at System.Collections.Generic.Dictionary`2.get_Item(TKey key)

at Microsoft.Office.InfoPath.Internal.ReadOnlyDictionary`2.System.Collections.Generic.IDictionary<K,V>.get_Item(K key)

at Customer_Checklist.FormCode.FormEvents_Loading(Object sender, LoadingEventArgs e)

at Microsoft.Office.InfoPath.Internal.FormEventsHost.OnLoad(DocReturnEvent pEvent)

at Microsoft.Office.Interop.InfoPath.SemiTrust._XDocumentEventSink2_SinkHelper.OnLoad(DocReturnEvent pEvent)

Is this the process for transferring the value of a field from one infopath to another infopath.

Thanks in Advance

re: Passing Data into a Form: Input Parameters

zullu — Thu, 06 Sep 2007 17:49:14 GMT

Hi Scott,

Your sample code was of great help to understand few more concepts in InfoPath 2003.

Thanks again for this.

I have another small question.

Can we create a secondary data connection with a filter criteria set as parameter to receive a value of a sharepoint list column for the current record pointer.

Thanks for all your help,

zullu

re: Passing Data into a Form: Input Parameters

zullu — Wed, 12 Sep 2007 18:30:22 GMT

I was able to figure out my stuff through a web service for the second alternative way.

Thanks to responses from David Dean, Sr. Member Technical Staff, Insource Technology Corp. and Kit Kai's Blog post at the below url:

http://community.sgdotnet.org/blogs/kitkai/pages/Consuming-Web-Servic...

which helped me to resolve my issue quickly.

Thaks again.

zullu

re: Passing Data into a Form: Input Parameters

shamrez — Sat, 15 Sep 2007 10:57:55 GMT

Thanks for this informative article. I have a question. If I pass parameters from one InfoPath form to another, I know that is possible but what If I want to send data back to the first InfoPath form. How will I do that? I am using web forms and my InfoPath template is hosted in a forms library in SharePoint. I want to open a new InfoPath form from my xsn template. After doing some processing in the newly opened form I would like to send the processed data back to the original form that is hosted in SharePoint. Can this be done? Plz help!

Thanks,

Sham

re: Passing Data into a Form: Input Parameters

shamrez — Sat, 15 Sep 2007 11:02:18 GMT

Some more info! I created an aspx page that has a xmlformview control and this page is hosted in SharePoint (main site on port 80). I send some parameters in querystring to this aspx page from an InfoPath form hosted in SharePoint. I do some business processing and now I want to send the data back from this aspx page to the InfoPath form opened from SharePoint. How will we do this? Is it possible at all? Please help!

Thanks,

Sham

re: Passing Data into a Form: Input Parameters

AD28 — Thu, 11 Oct 2007 17:32:40 GMT

Is there any way we could see the VB version of the InfoPath 2003 SP1 which is displayed in C# above?

I am very unfamiliar with syntax of both, but need to have this functionality written in VB however.

I would be so thankful for any help. :)

re: Passing Data into a Form: Input Parameters

AD28 — Thu, 11 Oct 2007 17:39:18 GMT

I should say VBScript.........

re: Passing Data into a Form: Input Parameters

CraigSchaeferWU — Thu, 27 Dec 2007 22:01:29 GMT

From the comments above, it appears that

XDocument.InputParameters["x"].Value

should work with Infopath 2003. However when I implemen this I get the following error:

The form contains XML that cannot be parsed:

An invalid character was found in text content.

Line 1, Position 5

MSCF

----^

I know the code is working becuase it works fine on Infopath 2007 clients. Should this work for infopath 2003?

re: Passing Data into a Form: Input Parameters

sakons — Mon, 21 Jan 2008 12:10:55 GMT

Hello

I use infopath 2007 inside sharepoint 2007 and I would like to pass parameters to the form via the querystring but it doesnot work the way you show it - no data enter the controls

I am posting the url

http://portal.tec.com/en/Zell/Application/_layouts/FormServer.aspx?year=2005XsnLocation=http://portal.tec.com/en/Zell/Application/ZellApplication/Forms/template.xsn&SaveLocation=http://portal.tec.com/en/Zell/Application/ZellApplication&Source=http://www.tec.com

It is a bit different from the your example but its the url I can get out of the new item in the sharepoint list the form is in it

10x

Shlomy

re: Passing Data into a Form: Input Parameters

sukebeta — Mon, 21 Jan 2008 19:18:09 GMT

I am using InfoPath 2003 SP3. I was trying to use JScript to get the input parameter from the URL. My url looks like this:

http://sharepoint/test/forms/form1.xml?view=Edit

Then on the OnLoad event of the form, I was trying to get the value of parameter "view":

var viewValue = eventObj.XDocument.InputParameters["view"].value;

eventObj.XDocument.UI.Alert(viewValue);

I got an error like this

A runtime error has occured. do you want to debug? the following error has occured:

'XDocument.InputParameters.view' is null or not an object

File: script.js

Line: 58

anyone know why it didn't work?

re: Passing Data into a Form: Input Parameters

forrestd — Tue, 22 Jan 2008 05:11:09 GMT

As it says in the first paragraph, Input Parameters are a new feature for InfoPath 2007.

re: Passing Data into a Form: Input Parameters

dkarantonis — Thu, 24 Jan 2008 15:34:05 GMT

hi to all,

i am using the e.InputParameter["List"] in order to get the list ID from the url and i get the exception "The given key was not present in the dictionary.". The List exists on the URL (this is a workflow list association form).

Any ideas?

re: Passing Data into a Form: Input Parameters

infopath — Thu, 24 Jan 2008 17:25:39 GMT

Hi dkarantonis,

In this scenario, the "List" parameter is not an "InputParameter" to the form. If you debug this you will see the InputParameter count is zero. I have been unable to find a way to get this from behind the InfoPath form - so you may want to look at trying to get the URL and parsing it from the ASPX page.

Scott

re: Passing Data into a Form: Input Parameters

dkarantonis — Fri, 25 Jan 2008 11:35:44 GMT

Hi Scott

i have commented on your "Submitting to 'this' document library" article.

thanks again

re: Passing Data into a Form: Input Parameters

JohnCHill — Thu, 21 Feb 2008 17:05:56 GMT

Hello,

I understand the parameter piece of this but I cannot figure out how query or filter the data to only show records that match the parameter criteria. Can you help or point me to some other documentation?

Thanks!

John

State Management in Infopath Forms

Sundar Narasiman — Mon, 23 Jun 2008 19:37:24 GMT

I'm currently working on a project that involves the modernization of lotus notes application to

re: Passing Data into a Form: Input Parameters

mike11stevens — Tue, 26 Aug 2008 20:38:06 GMT

Has anyone successfully used input parameters in a SharePoint / Forms Server scenario? Like several other commentors here, I am having trouble getting the url correct/working for my Forms Server forms...any/all help here would be greatly appreciated - thanks!

InfoPath and MOSS 2007 Useful Links

In the Trenches — Sat, 11 Oct 2008 14:47:36 GMT

u How to do custom themes for MOSS http://www.sharepointblogs.com/tigirry/archive/2007/07/03/custom-site-theme-for-sharepoint-2007-moss-2007-and-wss-3-0.aspx

re: Passing Data into a Form: Input Parameters

RRichie — Thu, 04 Jun 2009 15:02:23 GMT

I believe there is a bug in InfoPath 2003 SP3 as with several machines and several forms I get

The form contains XML that cannot be parsed:

An invalid character was found in text content.

Line 1, Position 5

MSCF

----^

Same code works in InfoPath 2007. As MainStreamSupport has just ended, I guess there is no hope for a bugfix?! However, my 450k-Employee-Org is still using InfoPath 2003...

re: Passing Data into a Form: Input Parameters

wizardntexas — Mon, 21 Dec 2009 03:34:29 GMT

So my question is, if I have data in a dropdown. How can i create a scheme where if in form "A" 6 items are selected from a dropdown box, then form submitted to library. Next user of the form "A", those 6 items are not availible in the drop down list. IE they are checked out? If sharepoint and infopath are these great collaboration tools, why can't I make them work in a dynamic role, Why must everything be so static?

Please advise?