SharePoint Integration

Re: Programmatically add an item to a SharePoint list fails

elizas — Tue, 22 Jun 2010 13:21:57 GMT

Hi, Plz check the answer given below. We can use SharePoint API to create these fields and associate the corresponding attributes programmatically within an existing List. Provided below is a code snippet in C#.Net describing the same. using (SPSite oSPsite = new SPSite("http://Web-URL")) { oSPsite.AllowUnsafeUpdates = true; using (SPWeb oSPWeb = oSPsite.OpenWeb()) { oSPWeb.AllowUnsafeUpdates = true; /* get the SPList object by list name*/ SPList lst = oSPWeb.Lists["EmpList"]; /* create a Numeric field for EmpID */ SPFieldNumber fldEmpID = (SPFieldNumber)lst.Fields.CreateNewField( SPFieldType.Number.ToString(), Sharepoint migration India http://www.mindfiresolutions.com/Sharepoint-Support.htm

Re: Programmatically add an item to a SharePoint list fails

elizas — Mon, 08 Feb 2010 12:08:28 GMT

You can think of a SharePoint List somewhat similar to a table present within a Database. As tables consist of different columns, a SharePoint List also comprises of different columns / fields and these fields can indeed have different attributes associated to it (like "Required field check", "Max Length", "Display Formats", etc). We can use SharePoint API to create these fields and associate the corresponding attributes programmatically within an existing List.

Re: Programmatically add an item to a SharePoint list fails

Gagan — Tue, 16 Jun 2009 12:21:26 GMT

So theoretically i can now change my sharepoint collum names from the unreadable (ex:Currentshift) to readable (ex: Current Shift) and my form should submit without any problems, without any changes?

Re: Programmatically add an item to a SharePoint list fails

Hilary Stoupa — Mon, 15 Jun 2009 20:40:52 GMT

I recently (...erm, this very morning....) had a similar issue. This CAML Query Builder can help.... It is free, and when you chose to use UpdateListItems instead of a Query, you can see the exact syntax that is needed to add an item -- that includes any field name oddities.

I believe that ShP gives the column a name when you first create it, and that name is kept for the life of the column. If you change the name in the list settings, all you are changing is the display, not the true value....

Re: Programmatically add an item to a SharePoint list fails

symwongaton — Mon, 15 Jun 2009 20:28:34 GMT

Glad to hear you got it sorted. Yes, column names can be a pain to change in SharePoint once they've been created; and what you see on the front-end is not what SharePoint has stored on the back-end. So you have to keep them simple and get them right from the start. Good job, though, on figuring out what the problem was!

Re: Programmatically add an item to a SharePoint list fails

Gagan — Mon, 15 Jun 2009 17:09:25 GMT

I have figured it out, the problem is that infopath/sharepoint is very anal.

When i added an extra field to the working one, the problem was that it was called "Current Shift" with the space, and the space in the sharepoint list was the problem, (CurrentShift wouldnt work either) so i changed it in sharepoint, and in my code. even though i changed it to a working title, it still did not work, so i assume that even after changing the title, it doesnt work and you really need to create a whole new collum. so back to my original form, i changed all my titles to follow a standard of Only the leading char being Capitol, and no spaces, and it worked. plus i created a whole new sharepoint list from scratch.

Re: Programmatically add an item to a SharePoint list fails

Gagan — Mon, 15 Jun 2009 13:20:01 GMT

SYM,

your plain version works great, i just tested. it seems like there is an error with the webservicesubmit in my modified version. i added a repeating table for my CAML, and the CAML does get populated with my custom info, so im assuming everything works great until then. I even created a whole new custom list in sharepoint and updated all connections plus a new GUID, but still no luck. i'll keep troubleshooting, and post if i have any results, in the meantime any info would help.

EDIT: ok so i may have found something. I took my perfectly working example and added just one field. i updated the CAML, removed the previous CAML resource file, added the new one, created new code in VSTA for my new field, created a new collum in sharepoint and upon hitting submit, it now does nothing, doesnt even update what it use to. i tried both .innerxml and .value in the code.

Re: Programmatically add an item to a SharePoint list fails

symwongaton — Fri, 12 Jun 2009 08:09:22 GMT

No worries. I'm doing OK, thanks. I've not seen Office 2010, yet. You? :)

Re: Programmatically add an item to a SharePoint list fails

Patrick Halstead — Fri, 12 Jun 2009 07:19:34 GMT

Thanks S.Y.M. for the reply here. Hope you are doing well! How do you like Office 2010? :)

Re: Programmatically add an item to a SharePoint list fails

symwongaton — Fri, 12 Jun 2009 06:10:25 GMT

Hi, All code on BizSupportOnline.NET is tested before it goes online. While I don't guarantee that it will work nor give support for any code I publish, I do ensure that I go through all of the steps of each article before publishing them. Have you followed the exact steps as described in the article and tested the solution before making modifications? If not, I'd suggest doing that first to get a "plain vanilla" solution working before making your own modifications. If the solution does not work as described in the article, let me know; I'll then retest it. The issue you're having could be related to virtually anything. Did you rename a SharePoint list column after creating it? Are all of your field names correct? Also check the contents of your CAML batch before submitting it to the web service. You can also look whether anything has been logged in the SharePoint logs. And finally, you can search InfoPathDev on "CAML", because many people have had an issue similar to yours before. CAML is difficult to debug, which is why I generally don't recommend it as a way of submitting InfoPath data to a SharePoint list. There are other solutions available for submitting InfoPath data to a SharePoint list and which are much easier to debug. You may want to look into those. Hope this helps.

Re: Programmatically add an item to a SharePoint list fails

Patrick Halstead — Thu, 11 Jun 2009 20:54:36 GMT

Hi Goober,

Why not ask the people on the site that posted the tutorial? We don't debug other people's stuff.

By the way, the MVP that posted that article does post here. You can search for her name and maybe email her separately.

Programmatically add an item to a SharePoint list fails

Gagan — Thu, 11 Jun 2009 14:12:02 GMT

Hello all,

I have followed this tutorial, with slight modifications to fit my needs but it seems like when i hit submit, nothing shows up in my sharepoint list. no errors or anything.

my code seems alright, my GUID is correct, im not sure what to check from here. any ideas?