Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Pulling data from SharePoint InfoPath form

  Asked By: Conor    Date: Aug 27    Category: Sharepoint    Views: 3228

I've been tasked with building a resume system for my company. I am thinking
about creating an Infopath form and publish it to a SharePoint form library.
The employees will use the Infopath form to create their resumes. What I'm not
sure about is once they fill out the form is there a way for me to pull the data
in the form into SQL tables?



4 Answers Found

Answer #1    Answered By: Jeffery Hayes     Answered On: Aug 27

InfoPath stores its forms in an XML doc within a list item. With that in
mind, you'll probably have to write some custom code to get it into SQL
Server in an unencoded form. There might be some third-party workflow apps
or actions that would do that for you; you'd have to check around.

Another option might be SSRS or SSIS, but I'm not sure about the boundaries
of each of those.

Answer #2    Answered By: Mohini Tiwari     Answered On: Aug 27

You could also potentially use property promotion combined with either a custom
workflow or event handler to do the push to SQL.

Answer #3    Answered By: Natasha Bennett     Answered On: Aug 27

I had an issue with property promotion that the original poster might also run
into. I have a form  with rich text fields, but when promoted they only seem to
be available as plain text. This limits their usefulness in showing views of the
data on web pages. Am I doing something wrong, or is this a limitation of
property promotion from InfoPath forms?

Answer #4    Answered By: Angel Matthews     Answered On: Aug 27

Yes, it is this a limitation of property promotion from InfoPath forms. We've
done extensive research on this (from a non-developer perpestive). However, we
hired consultant Qdabra to provide us with "print views" of specified fields
from a form. They are VERY reasonable and professional. Of course, we knew
EXACTLY what we wanted before they began.

Didn't find what you were looking for? Find more on Pulling data from SharePoint InfoPath form Or get search suggestion and latest updates.