Re: sharepoint and infopath issue

[Kevin Lundy]

If I understand you, the requirement driving your desire to also save into
a database is being able to query and report?

If so, I think you might be over architecting.  Then again, I'm a believer
in KISS, so maybe I'm over simplifying.

Why not just use SQL Server Reporting Services to query/report on the
list(s) being populated by the InfoPath form?  You can expose the SSRS via
a web part on another site, or even on the same site.  See
http://msdn.microsoft.com/en-us/library/ee633650.aspx

Kevin

On Mon, Jul 2, 2012 at 6:42 PM, S Powell  wrote:

> SharePoint 2010 and InfoPath 2007.  If any of you can help me figure
> out how to do this, or can offer an off-list consult, I'd be grateful:
>
> here is what we have layer out.
> We have an InfoPath template hosted on our SharePoint site.  Teams
> open the template in a browser, this generates a form that is filled
> out to create meeting agendas; the filled out form is then saved to
> the SharePoint site.
> We would like to have this form, as filled out, saved on the site; as
> well as having the data from that form saved into a database or
> otherwise be available for searching (not just SharePoint’s search but
> also being able to generate reports from the data contained therein) .
> It does not need to happen in that order; but we do need to have both.
>
> This is really the most important issue, that the information can be
> queried.
>
> Our users are using IE9 or Safari to fill out the forms, and according
> to Microsoft, a web form cannot be saved to a database, but only to a
> form or a web service.
>  --“To configure a browser-compatible form template to submit data to
> a database, use a data connection that submits data to a Web service
> that works with the database.”
>
> Are there web services that we can use (and how do we use them) to do
> this? What we need is something that will be happy to generate the
> form for our users to view, and still have the data that can be
> queried?
> Here is the workflow; starting from a template, filling it out online
> in a browser compatible format then saving the form and getting the
> data in to a database to be queried.
>
>
>
> -
> "Choose the highest bidder" was my answer when they told me I was up for
> sale.
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~   ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>
>

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

sharepoint and infopath issue

[S Powell]

SharePoint 2010 and InfoPath 2007.  If any of you can help me figure
out how to do this, or can offer an off-list consult, I'd be grateful:

here is what we have layer out.
We have an InfoPath template hosted on our SharePoint site.  Teams
open the template in a browser, this generates a form that is filled
out to create meeting agendas; the filled out form is then saved to
the SharePoint site.
We would like to have this form, as filled out, saved on the site; as
well as having the data from that form saved into a database or
otherwise be available for searching (not just SharePoint’s search but
also being able to generate reports from the data contained therein) .
It does not need to happen in that order; but we do need to have both.

This is really the most important issue, that the information can be queried.

Our users are using IE9 or Safari to fill out the forms, and according
to Microsoft, a web form cannot be saved to a database, but only to a
form or a web service.
 --“To configure a browser-compatible form template to submit data to
a database, use a data connection that submits data to a Web service
that works with the database.”

Are there web services that we can use (and how do we use them) to do
this? What we need is something that will be happy to generate the
form for our users to view, and still have the data that can be
queried?
Here is the workflow; starting from a template, filling it out online
in a browser compatible format then saving the form and getting the
data in to a database to be queried.



-
"Choose the highest bidder" was my answer when they told me I was up for sale.

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin