SharePoint Integration

Re: Add Sharepoint List Items with InfoPath

Patrick Halstead — Tue, 05 Oct 2010 18:52:19 GMT

Hi Airflight89,

This is an old post. We have a much easier way for you to add InfoPath fields to SharePoint Lists - it's called qRules. Check it out - it's a free download (link in ad at bottom). Send us a testimonial if you like it and we'll give you a coupon for a discount off of the already inexpensive list price. No code required and you get tons of functionality.

Cheers!

Re: Add Sharepoint List Items with InfoPath

airflight89 — Tue, 05 Oct 2010 15:09:17 GMT

I filled out my form and submit it. It creates a record in SharePoint List with blank data. Any suggestion for me to troubleshoot it? Thank you

Michael

Re: Add Sharepoint List Items with InfoPath

Daniels — Sun, 07 Feb 2010 02:19:40 GMT

louis:
Whoaa Cowboy, Column Guids are text? This ain't my first rodeo, and i think you might be mistaken. Column do have guid's just like lists, they are just harder to find than pulling them from query strings.

Can you use the GUID to match field elements to SharePoint list columns when using the UpdateListItems method of the Lists Web Service? My previous post related specifically to using the UpdateListItems method to modify data in SharePoint from an InfoPath form.

The UpdateListitems method takes the List GUID as the first paramater, and the CAML (XML) containing the update command. When mapping elements in the CAML template to columns in SharePoint lists, the internal field name is used, not the column GUID. The statement "This is the GUID if the list only, not any individual columns" is referring specifically to the ListName parameter of the UpdateListItems method, which requires the List GUID, not column GUIDs. In this case, the column GUIDs can be ignored as the internal names are used to identify columns in SharePoint:

wlarimore:
example:
"Field Three" translates to "Field_x0020_Three"

So, in your xml template you must have Field_x0020_Three defined

Re: Add Sharepoint List Items with InfoPath

louis — Sun, 07 Feb 2010 01:23:13 GMT

Whoaa Cowboy, Column Guids are text? This ain't my first rodeo, and i think you might be mistaken. Column do have guid's just like lists, they are just harder to find than pulling them from query strings.

Re: Add Sharepoint List Items with InfoPath

Daniels — Sat, 24 Oct 2009 00:13:19 GMT

Hi Jay,

If you are using the UpdateListItems Method of the Lists Web Service as suggested in Matt's Post, the GUID of the list being updated is stored in the ListName field as a default value (remove the curly braces {...}, so that there is just the number and hyphens "38472564-2......73634A5" ). This is the GUID if the list only, not any individual columns.

The CAML Template will need to have an XML Field element to map to each field in the SharePoint list which you are updating. Once you have populated the CAML Template with the required data to be submitted to the SharePoint list, the Secondary Submit data connection will Submit the CAML template using the Lists Web Service and the UpdateListItems method.

You will need to make sure you are using the "internal" columnn names when mapping to fields using the CAML template. The U2U CAML Query Builder can assist with finding the column names to use in the CAML template.

When configuring the submit data connection, selecting "XML Subtree, Including Selected Element"is an important step, but this should only be done for the "updates" paramater. Leave the default option for the ListName paramater, so that the value inside the field is used, not the field as an XML element.

Another article which may assist explains how to update existing items in a SharePoint list using a similar technique, with some important notes for data types when updating data in SharePoint using web services.

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

Thanks

Daniel

Re: Add Sharepoint List Items with InfoPath

jayvo — Tue, 11 Aug 2009 16:05:21 GMT

Hi Matt,

I think this is where i am going wrong. In your blog you only mention copying one GUID into the text box for ListName which i did and i end up getting this No List error. Can you confirm whether i need to add a GUID for each column and if so where do i need to do this?

Many Thanks

Jay

Re: Add Sharepoint List Items with InfoPath

BuildPro Guru — Thu, 20 Nov 2008 21:05:49 GMT

Hello Matt. Sorry to resurrect such an old post, but I am having no luck. I can do this at the root of the site with no problems, but even one layer in does not work. I can get the list displayed in the form no problem, but the insert never works (except in the root list). I have checked (about 40 times) the GUID for the list and for each of the columns and nothing. Here is my CAML:

<?xml version="1.0" encoding="UTF-8"?>
<Batch OnError="Continue">
    <Method ID="1" Cmd="New">
         <Field Name="Title"></Field>
         <Field Name="Last%5Fx0020%5FName"></Field>
         <Field Name="First%5Fx0020%5FName"></Field>
    </Method>
</Batch>

I tried it with just text (Last Name) with the same results - 'you have sucessfully submitted the form' but no data in the list. What am I missing?

Re: Add Sharepoint List Items with InfoPath

LGrote — Thu, 24 Jan 2008 19:58:56 GMT

yonah,

I have been trying to follow your wonderful example here, but am running into a problem everytime I try and submit the Form.

It keeps giving me the following:

The following error occurred:

'attributes.0' is null or not an object
File:script.js
Line:48

with my Line 48 being:

fields.text=XDocument.DOM.selectSingleNode("//my:"+fields.attributes[0].text).text;

Any ideas?

Re: Add Sharepoint List Items with InfoPath

mayankagarwal — Wed, 05 Dec 2007 06:39:01 GMT

Hey Guys

Any one out there was able know how we can trap the error when infopath talks to sharepoint.

when i submit the infopath form to add entry to sharepoint list, i dont get any error desings"form successfully submitted" but no entry to the list. Can you suggest anyway if the entry failed in sharepoint how can i trap the error at infopath end.

Re: Add Sharepoint List Items with InfoPath

mayankagarwal — Wed, 05 Dec 2007 04:01:56 GMT

Dear Matt

I have tried this solution of your and ufortunatly it works on some list and not the other. its quite frustrating and i have repeated the step a few times and no results. it work perfect on a list and then when i create another list in exactly the same manner the infopath for doesnt work, i have recreated the form, checked the guids etc no avail.

Also i notice that once the form does work, and if i change the list structure like add another column or so and replicate it on the infopath side like update the data sources, xml file etc it stops to work again.

I dont really get any error as that form says it was successfully submitted but there are no entries in the list...is there a way to trap errors that sharepoint list throws.

<?xml version="1.0" encoding="UTF-8"?>
<Batch OnError="Continue">
    <Method ID="1" Cmd="New">
        <Field Name='Title'></Field>
        <Field Name='FName'></Field>
        <Field Name='Lname'></Field>
    </Method>
</Batch>

I have also checked the guid of columns..

Re: Add Sharepoint List Items with InfoPath

KristyKay — Mon, 03 Dec 2007 17:25:11 GMT

My first question is are you sure you got the GUID correct? Next question is what are the data types in your SharePoint list? You have to careful with dates and lookup fields.

Re: Add Sharepoint List Items with InfoPath

infopathstartup — Mon, 03 Dec 2007 16:18:46 GMT

I followed every step in your tutorial :)....I get the msg box data was submitted but nothing appears on the list. Please advice :)

Thank you.

Re: Add Sharepoint List Items with InfoPath

KristyKay — Sun, 25 Nov 2007 22:14:16 GMT

I'm having difficulties deleting items from a SharePoint list so I thought I'd post here in case there's something obvious I'm missing. I've been able to succesfully add new items and update existing items using the UpdateListItems web service. And I'm not getting any sort of error message that says the delete failed but the item remains in the list so it's definitely not working.

Here's my CAML:

<?xml version="1.0" encoding="UTF-8"?>
<Batch OnError="Continue">
    <Method ID="1" Cmd="Delete">
        <Field Name="ID"></Field>
    </Method>
</Batch>

And here's the JScript code:

batch = XDocument.DataObjects["TimeActivityDeleteCAML"].DOM;
batch.selectSingleNode("/Batch/Method/Field[@Name='ID']").text = id;

//Update the list
var update = XDocument.DataAdapters["Update"];

try {
var xml = update.Submit();
}catch (err) {
XDocument.UI.Alert("There was an error updating the information: " + err.message);
}

TimeActivityDeleteCAML is my secondary data connection to the CAML mentioned above. Update is my secondary data connection to the UpdateListItems web service. Like I said, it works fine for updates. The only difference between the update and delete is the update CAML contains an entry for the field being updated and the code contains a line to set that value.

Am I missing something obvious? Any help would be appreciated since I've been staring at it blankly for a while now.

I'm using InfoPath 2003 and SharePoint 2007.

Re: Add Sharepoint List Items with InfoPath

AndrePSantos — Mon, 12 Nov 2007 18:35:59 GMT

I've been following the post and created the connection just fine, but it came to my attention that the webservice doesn't respect the required fields.

Is it possible, without using any programming, to force a field in the caml to be required, and make that show up in the form?

I can do it using programming, I create fields for the parameters and force them to be riquired, the, using the on_change event i "copy" them to the xml data source field. But is there a way to this without programming?

Cheers

Re: Add Sharepoint List Items with InfoPath

shaun.nieves — Thu, 11 Oct 2007 17:19:13 GMT

Check your pm. Let me know if you have any other questions...

Cheers!