.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

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

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :SharePoint

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

View Complete Post

More Related Resource Links

How to prevent automatic update from sharepoint list on Infopath 2007 form

Hi there, I've got an Infopath 2007 form on MOSS 2007. I have a custom list in sharepoint and the infopath form has a data connection to that list to receive data. Is there any way to prevent automatic update on the values in the form that is received from the list. I'd like the new form to have updated info received from the list. However, the old/existing forms that were created should have the data that were available at the time when the form was created. Let me know if this is not clear and I'll try to explain more. Thanks,Pman http://www.pmansLab.com/

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

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!

How to read a column of a sharepoint list to a text string field of infopath form?

My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

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?

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

submit infopath 2003 form to a sharepoint list

hi, is it posible to add  an infopath 2003 form to a sharepoint list, not document library but a list. and can i create views from the infopath 2003 form?

Invalid data has been used to update the list item in sharepoint 2010.

I have created a custom list definition with one lookup field <      Field ID="{865CD714-7DF6-4F65-9DBC-5FE910B10BC5}" Name="CompanyName" DisplayName="Company Name" Group="Custom contents" Description="Select Company" Type="Lookup" ShowField="CompanyName" Required="FALSE" FieldRef="CompanyName" List="Lists/LookupListDefinition-ListInstance1" ReadOnly="FALSE"></Field>   <nativehr>0x80070057</nativehr><nativestack></nativestack>Invalid data has been used to update the list item. The field you are trying to update may be read only. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. My solution is perfectly get deployed on site. I can see the list instance created on site its also appears on quicklaunch. When i am trying to add the item into the custom list using UI then i am getting the input form correctly i can see the lookup values in dropdown list but when i click on save button then its give me an error as mention above. For debugging purpose i have created the event reciver class for list item adding event. In that i have check the column status and

Infopath 2007: Cant we fetch data from a list or form library without using a Query to the data conn

I am trying to fetch data from a form library and a list (both secondary data sources). But cant do it without using a rule (Query using a data connection). However when I use the 'Refresh' control on the form it brings the value. I find it quite weird, as the connections are made properly and logically speaking all the data connetions should fetch dynamic data once the form opens or loads. Cant we do it without using a (data query) rule? Update: I am using a web based infopath forms, while using the same form on client its working fine. Why is that?

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

Add a New Item to a Custom Sharepoint List and Sharepoint Calendar from one Infopath form.


I am trying to create an infopath form for requesting time off.  Once the request is approved I want the form to add the event to a calendar on sharepoint.  I was able to do this using the article by S.Y.M. Wong-A-Ton at http://www.bizsupportonline.net/infopath2007/programmatically-add-item-sharepoint-calendar-infopath.htm.  But I want the form to also add an item to a custom list that has the employees available time off stored on it.  That way the form can automatically subtract the time entered on the infopath form from what is available on the custom list.  I was able to do this using another article by S.Y.M. Wong-A-Ton at  http://www.bizsupportonline.net/infopath2007/programmatically-add-rich-text-item-sharepoint-list-infopath.htm.  I can make both of these functions happen seperately but I need them to happen on the same Infopath form.  I am using Infopath and MOSS 2007.  I have tried to use 2 CAML receive data files and I treid to co

Infopath cannot generate a form template for the sharepoint list


Dear All,

For Sharepoint 2010, Infopath 2010

When I trying to login Infopath by link Customize Form that available in the List tool bar I found the following error:

Infopath cannot generate a form template for the sharepoint list

The SOAP response indicates that an error occurred on the server

Can anybody help me figure out what is causing this error?

How do I submit an attachment in an Infopath Form to a Sharepoint list?

I have already written code to submit my infopath data to my share point list, but now I need to find out how to submit an attachment to the same existing custom list in Share Point 2007.

can i save to a Sharepoint List from an InfoPath form created from Blank template


Guys, i am using SharePoint 2010. i created a form using InfoPath, created hi using the Blank form Template, all i want to do is save this to an existing SharePoint 2010 List using writing code. I also tried creating a DataSource connection but when i select the optoin for "Submiting Data" it does not show me an optoin to save data to a sharepoint list. Cand i do this using SharePoint webservices, if yes then how is it possible.

thanks in Advance


How to Customize SharePoint List form: newform.aspx to add functionality similar to a repeating tabl




I want to customize SharePoint List form: newform.aspx to add functionality similar to a repeating table in InfoPath?

I’d like to achieve similar functionality using in SharePoint Designer and Javascript/JQuery.


Any suggestions / links / examples are sincerely appreciated.



Abhijit Sil

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 
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