Submit data from Infopath form to SharePoint List

Question

Hi All,

Can any one of you explain the procedure for submitting data from Infopath form to SharePoint List?

I would like to know Basic concepts of Infopath form in MOSS 2007 (How Infopath form plays an Important role in MOSS).

Please help me regarding this issue

 

Thanks In Advance,

Kumar.

Answer 1

Hello,

You might want to check the MSDN site: http://msdn.microsoft.com/en-us/library/cc162745(office.12).aspx

 

Jeroen

Answer 2

Two very different topics.  Please separate them into 2 threads.

InfoPath does not submit to lists - it submits to Form Libraries.  To get your data to automatically submit to lists from the form itself, you'll need to incorporate some custom methods.  Here are some options:

1) Use the CAML method: http://msdn.microsoft.com/en-us/library/cc162745(office.12).aspx (Jeroen referenced this link)

2) Use the pre-built code-based method in Qdabra's qRules: http://www.qdabra.com/en/products/qRules.aspx (Submit to SharePoint List)

3) Write your own code to do it.

There is an indirect method, which is what I use, and that is to use workflow to create and/or update list items upon submission of the form to a Form Library.  I do this with SharePoint Designer, but you can also do it with Visual Studio if you are a developer.

---

SharePoint Architect || Microsoft MVP || My Blog

Answer 3

Hi,

Thanks a lot for your kind response,

I have already checked the above link sent by you people.

Everything fine expect the "Cleaning Up the Layout of the Form ".

Let me know if you have any Queries?

 

Regards,

Kumar.

Answer 4

What?

---

SharePoint Architect || Microsoft MVP || My Blog

Answer 5

Ok, I have resolved the Issue,

But getting error while "Adding Event Handler Code to the Add New Contacts Check Box ".

Infopath cannot add event handler.

To work with visual basic or visual c# code, Microsoft Visual Studio Tools for Applications(VSTA) is required. The Microsoft .Net Framework 2.0 and Microsoft core XML Services must be installed prior to installing VSTA. To install VSTA, open Add or Remove Programs, locate your 2007 Microsoft Office system installation, and then click change.

 

Please help me regarding this Issue.

 

Thanks In Advance,

Kumar.

Answer 6

Did you do what the error says to do?

---

SharePoint Architect || Microsoft MVP || My Blog

Answer 7

Hi I have resolved the Issue. Please refer the following link.

 

http://www.bronios.com/index.php/2008/08/23/error-while-writing-managed-code-for-infopath-2007-forms-infopath-cannot-add-the-event-handler/

 

Regards,

Kumar.

Answer 8

So this event handler link was the answer to your original question, and you got your answer without any help?

---

SharePoint Architect || Microsoft MVP || My Blog

Answer 9

It is part of the problem for my original question.

Answer 10

Clayton

We tried using the sample you posted on  http://msdn.microsoft.com/en-us/library/cc162745(office.12).aspx

but this does not work. We have InfoPath 2007 and sharepoint 2010. I wonder if this is a problem of compatibility? When we submit changes, we get the following error message:

System.Net.WebException
InfoPath cannot submit the form.
An error occurred while the form was being submitted.

The form definition (.xsf) file has an invalid mapping from the document to the submit Web service.

   at Microsoft.Office.InfoPath.Internal.MomExceptionHelper.ExecuteDataConnectionAction(OMCall d)
   at Microsoft.Office.InfoPath.Internal.WebServiceConnectionHost.Execute()
   at Template.FormCode.btnSendChanges_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)

Also, we noticed that when attempting to open the list in SharePoint, we don't see the form created in InfoPath, but rather, we see a standard form of Sharepoint? Please confirm this is due to incompatibility between InforPath 2007 and sharepoint 2010. Please advise, is there a correct version available?

Answer 11

Hi Clayton,

Will the above options work for InfoPath 2010 Offline forms?

Thanks

Binu

---

Thanks, Binu Raj V, [e-mail]