Extract data from InfoPath XML

appsdba_uk
appsdba_uk used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Director of Business Integration
Commented:
I believe www.qdabra.com has a tool for this, which will crack each one open and then save it to SQL.

Author

Commented:
Hi Yes I have looked at this, and I have sent a question to them, I was wondering if there was any alternatives
Clay FoxDirector of Business Integration

Commented:
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.

Author

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
Clay FoxDirector of Business Integration

Commented:
Not that I know of, since they do not have the ability to open or process the files en mass.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial