Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 990
  • Last Modified:

Extract data from InfoPath XML

We Need to extract the data from InfoPath forms to a database so we can run some reports on this data, the infopath data is stored in XML files that are on the server,  The InfoPath XML for a given form is stored/persisted in a Sharepoint blob field, I am a newbie to InfoPath so any assistance is appreciated
Thanks in advance
0
appsdba_uk
Asked:
appsdba_uk
  • 3
  • 2
1 Solution
 
Clay FoxDirector of Business IntegrationCommented:
I believe www.qdabra.com has a tool for this, which will crack each one open and then save it to SQL.
0
 
appsdba_ukAuthor Commented:
Hi Yes I have looked at this, and I have sent a question to them, I was wondering if there was any alternatives
0
 
Clay FoxDirector of Business IntegrationCommented:
If the data was in promoted properties, then you could harvest it from there but I am guessing that is not the case.

Since the data is in each file, a process has to open each one and extract it and send it to the destination and then move on to the next.

you could make a new template which had a submit to a database, but you would have to open each file and press a submit button on each. I am assuming this is a large number or files.
0
 
appsdba_ukAuthor Commented:
thank you for the reply, yes there are a large number of files, I was wondering if SSIS or BCS could provide an option
0
 
Clay FoxDirector of Business IntegrationCommented:
Not that I know of, since they do not have the ability to open or process the files en mass.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now