InfoPath Dev

Hi everyone,

I am new to both InfoPath and SharePoint so I appreciate any help you can give. Through the use of other sources, I have put together a form which will create List Items (really events in a Calendar List) in SharePoint programmatically. Using CAML, the UpdateListItems method and some VBScript, the form creates items just fine.

The issue is this: I would like to modify my form so that it will overwrite the List Item/Event if the same title is being input. How would I go about doing this? Can the CAML be modified to overwrite if a duplicate is found?

 I appreciate any help you can give. Here is my code thus far:

CAML Script:
<?xml version="1.0" encoding="UTF-8" ?>
<Batch>
<Method ID="1" Cmd="New">
 <Field Name="Title" />
 <Field Name="Location" />
 <Field Name="Description" />
 <Field Name="EventDate" />
 <Field Name="EndDate" />
 <Field Name="ProjectManager" />
 <Field Name="ProjectSponsor" />
 <Field Name="DIPhase" />
 <Field Name="ProjectName" />
</Method>
</Batch>

The basics of my code:

Dim batch
Set batch = XDocument.DataObjects("EventCAML").DOM
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = ProjectName
XDocument.DataAdapters("Submit").Submit

 

Hello Welcome to the Forums,

It will update the existing list item using your code. While submitting where you are getting the error? Can you give more detail on error message?

I apologize if I was not clear. The code I have currently seems to create new List Items, but I would like it to, if the Title Fields are equivalent, to update the existing List Item instead of creating a new one. What seems to happen if I press the button and the script runs again, with any of the information changed, is that a completely new List Item will be created. There are no errors that seem to crop up, just duplicate creation instead of editing existing items.

 Would I need to query the existing list items to determine if it is a duplicate and then run an update? If so, how would I go about doing that?

Thanks for your help!

Hi,

Can you verify the below link once.

http://msdn.microsoft.com/en-us/library/cc162745.aspx#ip2007SubmitDataSPList_AddingaConnectiontotheListsWebServiceandSpecifyingtheParametersoftheUpdateListItemsWebMethod

In that “Adding a Connection to the Lists Web Service and Specifying the Parameters of the UpdateListItems Method” will tell you how to use UpdateListItems method.

Hope this helps.

I appreciate your help. Using the above source I developed a solution which, while it may not be extremely efficient, gets the job done.

I set up another data connection which queries the Event List. That connection is used to filter for the identical title, and returns the row ID to update.

Using a variable called "EventExists" I keep track of the event existing, and then determine whether to add a new one or update an exisitng one.

 

The following article provides a similar solution which uses a CAML template and the UpdateListItems method of the Lists web service to update an existing item in SharePoint.  The article includes some important notes when submitting data to Sharepoint using a CAML query, including the DateTime field, which requires an XML format date string (ISO8601 - "YYYY-MM-DDTHH:MM:SSZ" , eg. "2009-07-27T21:20+01:00", or "2009-07-27T20:20Z" ) for the CAML query to work.  Code used in the form to populate the CAML template is written in JScript and is provided in the article.

See InfoPath - Update Existing SharePoint List Item Programmatically Using CAML for details.

Provided below are code samples written in C# to format an input as per SharePoint DateTime field. /* -- Format for Date Only Field -- */ private static String ToSPDate(String strDt) { if (strDt == String.Empty) return strDt; else return (Convert.ToDateTime(strDt)).ToString("yyyy-MM-dd"); } /* -- Format for DateTime Field -- */ private static String ToSPDateTime(String strDt) { if (strDt == String.Empty) return strDt; else return (Convert.ToDateTime(strDt)).ToString("yyyy-MM-ddTHH:mm:ssZ"); } http://www.mindfiresolutions.com/Format-Input-for-SharePoint-DateTime-field-186.php