?
Solved

Extract data from InfoPath XML

Posted on 2014-03-05
5
Medium Priority
?
982 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:
Clay Fox earned 2000 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:Clay Fox
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:Clay Fox
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
In a previous article here at Experts Exchange (http://www.experts-exchange.com/articles/18414/Create-a-PDF-file-with-Contact-Sheets-montage-of-thumbnails-for-all-JPG-files-in-a-folder-and-each-of-its-subfolders-using-an-automated-batch-method.html)…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This video Micro Tutorial is the first in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 (http://www.experts-exchange.com/articles/17490/). But the ability to create custom scanning profiles al…

616 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