.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Querying InfoPath forms deployed to a Sharepoint Library

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :Sql Server

Hello all,

We have a form library that stores a form with information for each database we host for our clients. Each database we host has an associated form with information such as:

Database Owner
Application Supported
Backup Location
Security Requirements
And so on...

I was asked to put the form together back a couple months back so we could inventory our databases.

It works, the library now has over 30 forms.

Now I'm being asked to transfer these records from the infopath forms/libray into a database table so we can report from.

I have no clue if I can connect to these forms and pull data from them, do you guys know?

I would like to loop through this library and pull the data from each form into a SQL table, is this doable?

Let me know if you guys can help.

Best regards,
-Igor Santos

View Complete Post

More Related Resource Links

Submitting Infopath forms to a Sharepoint Library - how can I generate a unique name for each record


I have published an Infopath form to a Sharepoint Library. What is the best way to ensure the following:

1. have a name per saved form (I do have a name field which has a set certain amount of available names in it which I am currently using as the form name - coming from an XML file)
2. users can edit already submitted forms without changing the name of the saved form
3. Ensure that users who may create a new form which happens to have more or less the same data as a previously saved form don't end up overwriting the existing one and hence I end up loosing saved data?

Using the name field + allow overwrite will allow me to have a unique name for the form and allow it to be overwritten but if I create a new form with the same name and maybe just a few small differences I will overwrite the existing form which is what I don't want - someone may not realise that an existing form with the relevant information already exists and we could loose already saved information

Any advice would be greatly appreciated.


Building InfoPath forms against Sharepoint 2010 Data Connection Library and Form Services...


Hi Sharepoint Experrts,

I'm trying to develop InfoPath 2010 forms that use External Lists that have been created in Sharepoint Server 2010.  I have problems when testing the forms because access is denied to the external lists.

When I try deploying the forms to the sharepoint site, I cannot upload the form template because it says I have to be a member of the local administrators group.  However, I'm running the administrator account used to install and setup sharepoint on the Windows 7 development machine I'm using.

I also tried loading the InfoPath Data Connections to a data connection library on my Sharepoint site... I can see the files when I login to the site but when I try creating a New form from a Data Connection File, I get an error message "This location does not contain any data connection files with the appropriate settings".  What ARE the appropriate settings?

I'm just really confused about this because I cannot seem to be able to build forms that use data connection files loaded onto a Sharepoint site or central server....

I appreciate any help I can get!




Thanks, KBW

Programmatically submit Infopath Forms to the Sharepoint Library from client computer


Hello. I have a task to programmatically sumbit/update/delete infopath forms (from .NET console application) to Sharepoint server 2007. The application must work from client computers (without Sharepoint installed). Therefore I've decided to use Sharepoint web services (Lists.asmx), but after some time of investigation I've figured out that I can't work with Forms Library via Lists.asmx service. Please, advice me the most optimal solution. Some choices that I see:

- use some another web service to work with "Forms Library"

- use "List" (instead of "Forms Library") on Sharepoint (am I right, that I can submit/update/delete forms as file attachments? Am I right that this could be achieved with UpdateListItems/AddAttachment methods of Lists service?)

- implement a server and client applications to use Sharepoint Object Model on server side


Please, advice me the right solution. Thank you.

Integrating InfoPath 2010 Forms with the SharePoint 2010 Data Connection Library

Learn how to create a data connection library on SharePoint Server 2010, and create a UDC file in InfoPath Designer 2010 to define a SharePoint List connection.

File Attachments from info-path forms to Sharepoint document library


Hi Experts,

How to upload file attachements from info-path forms to Sharepoint document library?

I need to add attachement from local-PC/Any User to Sharepoint Document Library.


Any help please?? Appreciated




Infopath Brower enabled form not visible in the sharepoint library after being submitted

Hi, I have created a infopath browser enabled form to submit to a sharepoint form library, however the submitted forms are not visible in the sharepoint link structure.   I'm able to see them in the SPD structure.  I'm using infopath 2007 and MOSS. I actually created a SPD workflow which retrieves specific values from the submitted form and saves it to another sharepoint list. This works fine even if the forms are not visible. Appreciate any help. Thanks

InfoPath Form not showing up in Sharepoint Form Library

I have set up a template form setup that users can fill out and then by pressing the submit button sends an email.My current issue is, when I publish the form to sharepoint, I don't see it, I have sharepoint set to view all documents and I still don't see it.  I can get to the form by clicking the "view my form in browser" pop up after I'm done publishing it.  I would like the users to just be able to click on a link in the library, but I can't find where it was published.Any insight on this would be great thanks.

Infopath form and forms library error

I've created an InfoPath 2010 form and associated it with a forms library on a SharePoint site. When I go to the library and choose "Add document" the form opens up to be filled out by the user. When the form is filled out, and the user tries to submit, they get an error saying that I need to configure SharePoint to allow cross-domain data access for user form templates that use connection settings in a data connection file and store a UDC file in the same site collection as the form. So I've enabled cross-domain data access and I've already created a Data Collection Library for Forms in the Site that is approved. What am I missing?  Why am I still getting the error?  

Changing fields while updating an InfoPath Form to a SharePoint 2010 Document library

My document library has following EventReceiver: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Receivers ListTemplateId="101"> <Receiver> <Name>EventReceiverDocumentLibraryItemUpdating</Name> <Type>ItemUpdating</Type> <Assembly>$SharePoint.Project.AssemblyFullName$</Assembly> <Class>EventHandling.EventReceiverDocumentLibrary</Class> <SequenceNumber>10000</SequenceNumber> </Receiver> </Receivers> </Elements> Updating a browser enabled InfoPath form in the document library fires following event: Public Overrides Sub ItemUpdated(ByVal properties As SPItemEventProperties) Try Me.EventFiringEnabled = False properties.ListItem("Lastname") = "Testperson" properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = True properties.ListItem.SystemUpdate(False) ' solution 1 properties.ListItem.Update() ' solution 2 properties.ListItem.UpdateOverwriteVersion() ' solution 3 properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = False Me.EventFiringEnabled = True MyBase.ItemUpdated(properties) Catch ex As Exception Me.EventFiringEnabled = True E

Updating an InfoPath Form Library Template breaks preexisting SharePoint List Views

When updating an InfoPath template (e.g. adding a new field), any views I have created on the library lose their filters and sorting, as if the columns on which they were built no longer exist.  Has anyone else encountered this and, if so, is there a solution? V/r Noelle

Using Workflow to create an InfoPath item in a Forms Library

Hi Experts: Here is my situation: I have a MOSS 2007 server with list A (regular sharepoint list) and List B (InfoPath form library with a published form) This is what I am trying to accomplish using SharePoint Designer: List A is just a basic list User changes a column in list A to a specific value A new form needs to be added to the forms library B SharePoint designer Workflow will not create a valid xml file in the List B forms library. It just creates an invalid file based on the .xsn file template. Does anyone have any experience creating a valid xml form in a forms library using SharePoint Designer workflow? I can't migrate to 2010 so that is not an option. Thanks for all your advise.

InfoPath Forms library in visual studio 2010

If I create a list definition of document library type, and add some new fields to the list.  Is there any way to only allow infopath forms to be submitted to the list?  And also can I change the "add new item" link on the default list to point to my infopath form?

Sharepoint 2010 workflow using asp.net forms and or infopath forms

Hi, Does anyone know of any good step by step articles on a state machine workflow with ASP.NET forms and or inforpath forms ? Ive created a blog on a generic workflows but want to learn more about the forms side of things - any pointers would be great. Paul.   PS here is my how to guide : http://sp2010site.blogspot.com/2010/09/how-to-create-and-debug-state-machine.html  

Creating report from Infopath library/submitted forms

Hi, I got a form that has repeating table containg data. The form is submitted to a form library on MOSS 2007 site. Some of the key fields from the form has been promoted to the library, which allows creating views and gives the user a quick report based on the filter. Now, the user wants similar function, however the data is stored in the repeating table. I can use double eval function to combine data from each columns and promote them to the library. But obviously, it doesn't give the user accurate/the kind of report he is looking for using the views. Do you have any suggestion? The only option I can think of is storing each row from repeating table into an Access database or sharepoint list. But that'll also involve making sure correct data is being updated in these secondary data source when updating the form.  Pman http://www.pmansLab.com/

Sharepoint 2010 workflow using asp.net forms and or infopath forms

Hi, Does anyone know of any good step by step articles on a state machine workflow with ASP.NET forms and or inforpath forms ? Ive created a blog on a generic workflows but want to learn more about the forms side of things - any pointers would be great. Paul.   PS here is my how to guide : http://sp2010site.blogspot.com/2010/09/how-to-create-and-debug-state-machine.html  

InfoPath 2007 - Publishing Creates multiple columns on SharePoint Form Library (GUIDS apparently are

I have been working this issue for 2 days now.  This has happened to me in the past and I was able to work through it.  It doesn't appear that this time I am going to be so lucky. Issue Description: When publishing an InfoPath form a new column is created that has the same name as the correct one, but a new GUID is created. Troubleshooting steps: I have read this article: http://www.delphi-ts.com/blogs/lozzi/post/2009/06/03/Duplicate-site-columns-in-MOSS-from-InfoPath-Forms.aspx   This was the solution the last time I had this problem.  However, no matter what I do, it is not working now.  I have a column named User Name which is the username of the person that submitted the InfoPath form for use with my Visual Studio workflow.  When the workflow kicks off, it reads this column and attempts to get the value.  The value is blank because a new column with the name User Name now exists and that is where the value is stored.  I attempted to fix it by remapping the GUIDs as described in the article.  I also reverted the code to a previous version from TFS.  None of these worked.   I now have 3 columns called User Name and I can remap the GUID to the second column and third column.  But when I try to map it to the first column (the one I need) it doesn't work. The first column that is circled is the correct column. 

import data from infopath xml forms to SharePoint list

Hi. I have this issue, a customer has an old application that consists of a SharePoint 2003 site and a 'forms library' with forms listing information about physical servers. The infopath (2003) form is pretty straight forward and has a few dropdowns from lists and so on. Now, we need to move this to 2010 and preferably to a list only using oob functionality. I would like to know if anyone has a clue as to how I can get the data from the hundreds of xml files into a list, could be to excel and then to SharePoint, or any means Necessary. I would prefer it if it can be scripted or done using standard tools from Microsoft, no 3rd party custom xml importer...(if it's not really good and free :-) ) ThanksThomas BalkestÃ¥hl - Technical Specialist - SharePoint
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend