General

Re: Infopath

Kajal Patel — Fri, 31 Oct 2008 12:53:53 GMT

Unbelievable

It is working fine now. I really appreciate your help.Thanks everyoneKajal

Re: Infopath

Anuma — Fri, 31 Oct 2008 12:15:01 GMT

Hi,

I think you didn’t give “http:” before site address while taking submit data connection.

Site address should be: “http://Sitename/subsitename/Document folder name”

I hope this will help you.

Re: Infopath

santhoshp — Fri, 31 Oct 2008 12:10:13 GMT

Hi,

Make sure that your document library path should be in this format while taking the submit data connection.

http://<ServerName>/<SiteName>/<DocumentLibraryName>

Re: Infopath

Kajal Patel — Fri, 31 Oct 2008 11:53:53 GMT

Hey Thanks!

I did everything you asked me to do but I am still having some problems. When I click on my button I am getting an error message saying some rules were not applied

Details:

InfoPath cannot submit the form.
An error occurred while the form was being submitted.
The following location does not use the HTTP or HTTPS protocol: //learn/sites/college/staff/Departments/miS/aOL/sainath.xml

The data gets stored in SQL but not in Sharepoint

Re: Infopath

santhoshp — Fri, 31 Oct 2008 09:34:32 GMT

Hi,

You can submit the data to both SQL and SharePoint document library at the same time by using Rules. Follow these steps

1.First take the submit data connections to both SQL and SharePoint.
2.Add a button and go to button properties -> Rules->Add->Add Action.
3.In action window select ‘Submit using a data connection’ in Action drop down.
4.In data connection drop down select your data connection (SQL or SharePoint data connection).
5.Click ‘Ok’ and click on Add Action to add one more action.
6.Repeat the steps 3 and 4.
7.Then Click ‘Ok’ to close all the windows.

Re: Infopath

swathip — Fri, 31 Oct 2008 08:56:16 GMT

Hi, You cannot submit to both at a time. But you can submit one by one using code with a button. Take a button and add code to submit the form to sharepoint and data base in the button click event.

Re: Infopath

Kajal Patel — Fri, 31 Oct 2008 08:50:01 GMT

Thanks to you both for your reply

I know how to create the data connection to submit the data but I want to submit the data in both SQL and SharePoint library at the same time. Is this possible?

Re: Infopath

swathip — Fri, 31 Oct 2008 07:32:26 GMT

Hello and welcome to the forum, By taking the submit data connections, you can submit the data to sharepoint library or data base.

Re: Infopath

santhoshp — Fri, 31 Oct 2008 04:48:43 GMT

Hi,

Yes. In InfoPath we can submit data into both SQL and SharePoint document library.

Infopath

Kajal Patel — Thu, 30 Oct 2008 14:51:33 GMT

Is it possible to submit data into both SQL and SharePoint document library?