Solved

Extract data from InfoPath XML

Posted on 2014-03-05
5
901 Views
Last Modified: 2014-03-10
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
Comment
Question by:appsdba_uk
  • 3
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
ID: 39909114
I believe www.qdabra.com has a tool for this, which will crack each one open and then save it to SQL.
0
 

Author Comment

by:appsdba_uk
ID: 39909251
Hi Yes I have looked at this, and I have sent a question to them, I was wondering if there was any alternatives
0
 
LVL 28

Expert Comment

by:clayfox
ID: 39909302
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
 

Author Comment

by:appsdba_uk
ID: 39909365
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
 
LVL 28

Expert Comment

by:clayfox
ID: 39909382
Not that I know of, since they do not have the ability to open or process the files en mass.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Online collaboration can help businesses be more efficient, help employees grow their skills and foster a team environment.
When the confidentiality and security of your data is a must, trust the highly encrypted cloud fax portfolio used by 12 million businesses worldwide, including nearly half of the Fortune 500.
Sometimes we receive PDF files that are in the wrong orientation. They may be sideways or even upside down. This most commonly happens with scanned or faxed documents. It is possible to rotate the view of these PDFs with the free Adobe Reader produc…
We often encounter PDF files that are pure images, that is, they do not have text characters, but instead contain only raster graphics. The most common causes of this are document scanning software and faxing software/services that create image-only…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question