Solved

Extract data from InfoPath XML

Posted on 2014-03-05
5
870 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article shows how to convert a multi-page PDF file into multiple image files, with one image file created for each page of the PDF. It does this by utilizing an excellent, free software package called GraphicsMagick. The solution is amazingly s…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Viewers will learn the different options available in the Backstage view in Excel 2013.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

708 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now