.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

import data from infopath xml forms to SharePoint list

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :SharePoint
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

View Complete Post

More Related Resource Links

Submitting InfoPath data to a SharePoint 2007 List

Clayton, i sure hope you get this.  I would like to let the form get published to the form library and then workflow can create the new list item with all the required metadata mapped.  if data is updated i would like for the list item data to update as well.  currently i have an infopath form that is web-enabled.  i several views based on a status field as which view to open to.  this form have drop-down fields linked to list already on the sharepoint site.  i have tried using the "Submitting Data from Infopath 2007 to Sharepoint List" and it works as designed but unfortunately i cant customize the fields.  i need a dynamic user friendly form with drop downs etc.  any suggestions?

Infopath Form Data submitting to Sharepoint 2010 List

Making a Client intake form that once submitted will send data to  a sharepoint 2010 List called contacts. Short Summary the form will have repeating fields and alot of information to submit. I have looked and read all over but I cannot find an easy step by step guild on how to submit the form data like that. Long Summary on the sharepoint site a button will open a form for adding a new client.  once the form has been filled out and the user hits submit sharepoint will then create a User File, in clients file, and take the data and put it into contacts list. I am trying to make use of Sharepoint as I would with access, meaning the more information I have on a client the easier it will be to mail merge letters, motions, basicly any file prepaired stuff. So once I have css designed forsharepoint to make it look the way I want then the forms should intergrate perfect

cascading drop down list in infopath forms services Using SharePoint Look up list from multiple Sh



Some one can help me, if possible screen shots.
Environment : MOSS 2007, InfoPath 2007

update SharePoint list with data from infopath form using the Command Prompt or similar


i have a InfoPath form that is updating a SharePoint list when it is submitted. Now i added some extra Fields to the Sharepoint List. All these new Fields are empty till I open the InfoPath form and hit the submit buttion again.

Is there a way to update all the empty fields from the old entrys I made.

My first Idea was to search for a Powershell Solution but unfortunately I am using Windows Server 2003 R2, Sharepoint 2007 and IndoPath 2007.

Hopefully someone can Help ;)

thanking you in anticipation

Loop through SharePoint list and copy values into InfoPath Main Data



i have the following problem, i designed an Infopath form which should display the data (in a repeating table) from a SharePoint list, which is connected to the form.

 I found the following code in the internet to copy rows from a sharepoint list to a repeating node in the Main data source and followed the tutorial.

Public Sub CTRL48_6_Clicked(ByVal sender As Object, ByVal e As ClickedEventArgs)

      Dim secDSNav As XPathNavigator = DataSources("Projektsummary").CreateNavigator()

      ' Zeilen aus der Projektsummaryliste auslesen
      Dim rows As XPathNodeIterator = secDSNav.Select( _
      "/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW", _

      'Dim Current As XPathNavigator
      'Loop durch die einzelnen Zeilen der Liste

      While rows.MoveNext()

        Dim name As String = rows.Current.SelectSingleNode( _
        "/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Title", NamespaceManager).Value
        Dim nummer As Object = rows.Current.SelectSingleNode( _
        "/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Projektnummer", NamespaceManager).Value

        ' Werte der wiederholten Tabelle (main data source) übergeben 
        AddItem(name, nummer)

      End W

Submitting data from Infopath 2010 to a Sharepoint 2010 list fail


Hello everybody,

I'm trying to submit data from an Infopath 2010 form to a Sharepoint list using the following tutorial: http://msdn.microsoft.com/en-us/library/cc162745(office.12).aspx 

However this doesn't work. The form creates new entries but when you whant to change or delete an entry, I get the following error: Object reference not set to an instance to an object. Any idea what is wrong with the code?

using Microsoft.Office.InfoPath;
using System;
using System.Windows.Forms;
using System.Xml;
using System.Xml.XPath;
using mshtml;

namespace Sharepointupdate
  public partial class FormCode
    // Membervariablen werden in browserfähigen Formularen nicht unterstützt.
    // Schreiben und lesen Sie diese Werte stattdessen aus dem FormState-
    // Wörterbuch, indem Sie Code wie folgt verwenden:
    // private object _memberVariable
    // {
    //   get
    //   {
    //     return FormState["_memberVariable"];
    //   }
    //   set
    //   {
    //     FormState["_memberVariable"] = value;
    //   }
    // }

    // HINWEIS: Das folgende Verfahren ist für Microsoft InfoPath erforderlich.
    // Es kann 

Customizing SharePoint List Forms in InfoPath 2010

Learn how to customize the forms for viewing and editing items in a SharePoint list with the InfoPath Designer, and then take the forms offline using SharePoint Workspace.

Sample: Customizing SharePoint List Forms in InfoPath 2010

Explore the code sample as you learn to customize the forms for viewing and editing items in a SharePoint list with the InfoPath Designer, and then take the forms offline using SharePoint Workspace.

Auto populate the list data into infopath-- sharepoint 2007


I have a list with Job code,Apply online,Name.. as columns with two workflows.

When a new item is created in the list,workflows will run(mentioned the workflows below).

1.Job code ---Setting a unique number to JobCode field(i.e 1 and the next Jobcode wil be 2....)

2.Apply Online(it is a hyperlink)---Storing the infopath url into this ApplyOnline field.

Now on clciking on the list item,we will get dispform.aspx page then on clciking on Aply Online field then infopath form wil open.

Infopath has Job code field as Text box.

Now,I want to auto populate the infopath form with the corresponding list job code field.

help me on this.



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

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.

How to pull data from SharePoint List to Infopath field?

I have customer's name, address, account number, etc in Sharepoint list. In infopath I have a field's like Customer Name, Address, Account number..I created a data connection for Customer's name and I want to populte the related data of that customer in Infopath field by calculated formula or something. When ever we pull some one's name ..I need that customer's Address and other details about him in INfopath form. The data should keep changing if I pull out some other customer's name..Does any one know how to do this? Seems simple..but not able to it though...

How do I embed an InfoPath form in the body of an e-mail and have the data go to a SharePoint list w

I've managed to create a form in InfoPath with all the required fields.  I can publish this to be embedded in the body of an e-mail as long as it is not linked to the SharePoint list.  I can also publish the form directly in the SharePoint list so that when you 'Add document' the form appears and can be filled out.  However, I can't publish the form to an e-mail (embedded in the body) and have a end-user submit the information to a SharePoint list.  Is this possible?  If so, what steps am I missing to allow it to happen?  Thanks!

import filtered sharepoint 2010 list data into a word document

i want my filtered list data in sharepoint and export the data into a word document with some relevant fields not all the fields. how can i acheive this ?  
e.g i want to show all items related to "taskname" in word document.

SharePoint 2007 - Import from User Info List into InfoPath 2007

We are using Sharepoint 2007 with InfoPath 2007 and are trying to pull names from the UIL and display the name last name first.  Such as Smith, John.  It seems to pull and display first-name first.  Any way of displaying last name first? Thanks for the assist.

Sharepoint list group by column data ,display in webcontrol like panel or label


I  have a sharepoint list[Managers] with groupby sector column. like below




Each Sector group by column data i want to display in label or panel control.

How to do that ? how to write the logic?



Regards, Mansoor

Video: Accessing SharePoint 2010 List Data

In this video you will learn how to create strongly typed classes using a tool called SPMetal to do LINQ programming against a SharePoint 2010 list. (Length: 15:22)
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