<div>
Hi Yes I have looked at this, and I have sent a question to them, I was wondering if there was any alternatives
</div>


Hi Yes I have looked at this, and I have sent a question to them, I was wondering if there was any alternatives

<div>
If the data was in promoted properties, then you could harvest it from there but I am guessing that is not the case.<br />
<br />
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.<br />
<br />
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.
</div>


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.

<div>
thank you for the reply, yes there are a large number of files, I was wondering if SSIS or BCS could provide an option
</div>


thank you for the reply, yes there are a large number of files, I was wondering if SSIS or BCS could provide an option

<div>
Not that I know of, since they do not have the ability to open or process the files en mass.
</div>


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

<div>
<div class="content wysiwyg-content">
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, &nbsp;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<br />
Thanks in advance
</div>
</div>


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

Extract data from InfoPath XML

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.

InfoPath

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

A Document Management System (DMS) is a system (both hardware and software) used to track, manage and store documents and reduce paper. Most are capable of keeping a record of the various versions created and modified by different users (history tracking). It is often viewed as a component of enterprise content management (ECM) systems and related to digital asset management, document imaging, workflow systems and records management systems.