Representation of a list item within the SharePoint API.

learn more… | top users | synonyms

2
votes
1answer
1k views

How to check if user has read/write permission for a SPListItem in c#?

In my SP2010 visual webpart, I am checking permissions with the code below. Basically the current user is either an admin or a regular user. If they are an admin, they need to have permission to edit ...
1
vote
2answers
202 views

Deleting all items from a list and then adding new items will not give the new items id 1,2,3 etc

I have a list with 3 items. When I delete these 3 items and add new items they get ID 4, ID 5 and ID 6. But I want the new items to get ID 1, ID 2, and ID 3. Is there any workaround? This is how I ...
13
votes
1answer
10k views

How to get a SPFieldLookupValue from an SPListItem?

When you get an SPListItemCollection from a SPList.GetItems(SPQuery) request, and the items have SPFieldUser or SPFieldLookup fields, what is the sexy way to get typed values, not the ...
0
votes
1answer
104 views

Read from an excel Sheet and write to a List

My requirement is that, i need to upload data from an excel sheet to an existing sharepoint List in SP 2010.I will have 2 different Lists Like this. Then I need to compare Both the List and retrieve ...
1
vote
0answers
404 views

SPListItem.Update Not working

So I have this really simple function which updates a couple of fields on two different lists (one is a document library) The thing is on the document library does not updates any of the fields I need ...
1
vote
1answer
244 views

Delete List Items Using PowerShells with Date Filtering

I've been trying to delete more than 10,000 list items in SharePoint using PowerShell. So far, this is what I've had [System.Reflection.Assembly]::Load("Microsoft.SharePoint, Version=12.0.0.0, ...
0
votes
1answer
101 views

OnWorkflowItemChanged fire multiple times

I have been using a State Machine workflow (SharePoint 2010). Workflow design Main State: The Main State does not update the item. The Main State contains a OnWorkflowItemChanged. When the item ...
0
votes
1answer
87 views

Best way to update 200 items on a list [closed]

Situation in a VS2010/SP2010 site: List A with main items List B with subitems, having a lookup column that points to List A ID There are about 200 subitems for each item The Page where users edit ...
0
votes
2answers
496 views

Save conflict when trying to update a listitem

In my SPItemEventReceiver I have two methods one ItemCheckedOut and one ItemUpdated. In the ItemCheckedOut I update one listitem column. In the other one I do some other updates to the listitem. ...
0
votes
2answers
290 views

Inserting new list items into SQL

When I add new item into the list, I have to insert the items into the SQL database. How can I do it? Any clue is good for me.
2
votes
2answers
748 views

Adding list item when user does not have permissions question

I am trying to programmatically add a list item to a SharePoint list. The code works fine when executed by a user with contribute permissions, but does not work when a user has view only. Funny thing ...
0
votes
2answers
109 views

How to Upload Documents using Visual Fox Pro

We have an application written in foxpro, part of the application is creating reports (basically excel and pdf files), i would like to add the capability of uploading those files to a sharepoint list, ...
0
votes
0answers
212 views

Object refenrece not set to instance of an object - list template items

This may be a duplicate, because this error is pretty common in every part of sharepoint. However, the search function didn't find anything for my particular problem. To the problem: I have a List ...
0
votes
3answers
4k views

How to retrieve File version from SPListItem

I'm trying to get file versions from an an SPListItem... I tried in many way, looping on SPListItem.Versions or SPListItem.File.Versions, tring to return my byte stream.. I can retrieve file info's, ...
0
votes
2answers
310 views

Populate list item from XML feed

How to create new list item using data from XML feed? Is it possible to handle multi line of text in XML feed?
0
votes
1answer
43 views

MOSS 2007 stripping out URL in SPListItem

We have a SharePoint List with a multi-line text column. In this column we have HTML code. When I retrieve the column in an SPListItem, the url is often stripped from the string. If the SharePoint ...
3
votes
1answer
149 views

Get actual item from SPRecycleBin

Similar to this question, I need to permanently delete only specific items from the recycle bin. I need to know more than just their names, however, and SPRecycleBinItem seems to have only have a ...
2
votes
1answer
202 views

How to import one single row of data from excel to one list item in a SharePoint 2010 list?

I have a problem where we want users to attach a file to a new item and the SharePoint list will automatically read on row or column of data (maybe 20 cells-worth of data) and populate some additional ...
0
votes
2answers
196 views

add SPListItem with more than one field of data

I want to add an item to a SharePoint task list, with data in the Title, AssignedTo, and Status columns. The code below adds the item with data in the Title column, but no data in the other columns. ...
1
vote
1answer
948 views

Export-SPWeb with Where Clause to filter List Items?

I am trying to export list items to a local folder but I only want certain items, not the complete list.Is this possible? I have tried to iterate through the SPListCollection with the "Modified" ...
0
votes
1answer
157 views

Programmatically adding a sequence number to the 'Title' column during item creation in SP List

As per the title above, I have a list that stores IT support requests. I need a sequence number that matches with the item ID and I want to add this sequence number to the Title of the request. I ...
1
vote
0answers
113 views

send email to users including alert template with list items using visual studio?

I don't want to set list alerts when items created or changed. I want to send email(including alert template and all fields in item) to that user which not configured in sharepoint. My function for ...
2
votes
0answers
79 views

Bulk file upload creates multiple versions of all files except last file

I have an interesting (well to me anyways) problem here. I am doing a code based mass upload of documents into a SharePoint library with a twist. The twist is that the file's last modified date ...
0
votes
1answer
143 views

Set SPBuiltInFieldId.WorkflowInstanceID value

I start worklfow programmaticaly on SPListItem (custom ContentType). When i try to save all fields but "WorkflowInstanceID", its ok. But, item[SPBuiltInFieldId.WorkflowInstanceID] = ...
0
votes
2answers
460 views

How to display list item attachment to a user without permissions on the list

I have sharepoint list/library. Only admin user has permission on this list. Now i want to display attachment to all authenticated user in my custom web part. How can i achieve this functionality.? ...
0
votes
3answers
2k views

Better way to get a SPListItem by Field

I want to get a SPListItem from a SPList where a field match a value. I have to ways to do it, CAML and LINQ. My code is: LINQ ... SPList list = Web.Lists["MyList"]; SPListItem item = (from ...
0
votes
1answer
238 views

Double value in URL from SPListItemCollection result

I have a basic list which I am using to generate a "Quick Links" menu WebPart. It looks ok but for some reason the URL field (of URL type) when rendered renders html that looks like this: <a ...
0
votes
1answer
289 views

Proper way to evaluate/get status of boolean field when looping through SP List with code

What is the best way to do this when looping a list? I have tried to evaluate it with something like this but it wont let me evaluate bool as an "if" condition if (item["ShowTitle"] == true) //do ...
0
votes
0answers
48 views

Access unable to update singular column in SP list

When I try use Access 2007 to update a linked SharePont table, Access tries to update the entire list rather then the column I specify in my query. Anyone else encounter this problem?
1
vote
1answer
214 views

What is the difference? (Checked out files)

I am in the process of writing a powershell script to work with checked out files and I stumpled on this article: Find All Checked Out Files My question is what is the difference between the two ...
1
vote
1answer
1k views

How to get the sharepoint website url in a workflow from the current SPListItem?

I am using sharepoint 2010 and have created a workflow in vs. In this workflow I create some tasks and fill the title, bodytext and assign it to a user or group. In the bodytext I add an hyperlink as ...
0
votes
2answers
315 views

How to call a c# method in my XSL File

I have two lists Client and Project, each Client has from 0 to N Project stocked in his SPLookupField where multi values are allowed. And I created a new computed Column in the Client List where it ...
1
vote
3answers
2k views

Possible to load a SPListItem from the item url?

I have a FullTextSqlQuery that is returning the URL for a list item. I would like to create a new SPListItem object from that URL. Is there an easy way to do this, or will I need to peel apart the ...
0
votes
2answers
189 views

Adding extension methods to SharePoint types

Heads up, this is very much a beginner question. My SharePoint experience is primarily with working with SharePoint designer and powershell. I've never touched Visual Studio or anything to use custom ...
1
vote
0answers
229 views

Get SPListItems based on contribute permissions, programmatically

I have a problem in getting the list items the current logged user has contribute rights on. I have this scenario: List A has read permissions for anonymous access. Group 1- Has contribute rights ...
1
vote
0answers
370 views

Can I set SPListItem Item.Id programatically

I want to delete some list items and recreate them using a csv file. I can see if I delete the items and then recreate, Sharepoint adds it's own auto icrement int. what if I want a set of fixed values ...
3
votes
2answers
2k views

Updating a ListItem that another user has edited

I have an event receiver that creates/updates/deletes publishing pages in a publishing library. In ItemUpdating, I get a handle to the page's underlying ListItem, change some of its properties and ...
1
vote
2answers
2k views

update SPList using csv via Powershell

knowing that is possible in PS, exporting SPList items to PS objects(link1 link2) what is the best way, to go into the other way: Create/Update an SPList from an exported csv or format-table.
3
votes
2answers
210 views

Get Notified on List Item Changes - not using email

I'm searching for an easy way to display the latest changes of a sharepoint list. Situation: one huge list (10k entries) with a lot of daily changes (lets say 100). Target: Display the changes during ...
0
votes
0answers
547 views

SharePoint 2010 Announcement web part - truncate/char limit issue

There are old threads on this topic but most of them for MOSS or prior versions or without any resolutions. This thread is close but solution doesn't work for me. Feel free to forward any working ...
0
votes
2answers
123 views

is this CrossSiteListViewWebPart causing memory leaks?

i would like to know, whether I should be disposing the SpWeb object or I have closed it and trying to use it? using System; using System.ComponentModel; using System.Web; using System.Web.UI; using ...
0
votes
1answer
130 views

where i can find trace for item.systemupdate()

I am working on a project which was initially developed by someone else. few of my list items are getting updated but i am not getting anything in version history. I believe that some schedule job is ...
1
vote
1answer
453 views

Set data to Sharepoint Gridview from List and remove appropriate selected columns

I am using c# and I have a SPList with fields such Title and Translation. I want to set Word and Translation into SPGridview. I can retrieve data from my List: string translation = ...
9
votes
1answer
4k views

SPList.Add() vs SPList.AddItem() SharePoint 2010

Using some test code i found out that SPList.AddItem() executes slight faster then SPList.Add() - does anyone know why is it so ? DateTime start = DateTime.Now; SPList ...
0
votes
1answer
579 views

Update custom property on listItem using -replace in powershell?

I have two different web application with one site collection each. One Site collection is privat and the other on is public inside the intranet. The public site links to the private site which link ...
1
vote
2answers
892 views

Add/Copy SPListItem object to Sharepoint List

explanation: I have fetched list items based on conditions. Like this. var query = from SPListItem oItem in splist.Items where ...
1
vote
0answers
192 views

SPSiteDataQuery without subfolder items?

I'm trying to use the SPSiteDataQuery to return the contents of several lists across a site collection. The problem I'm having, though, is that while there are only a few documents at the root level ...
5
votes
2answers
350 views

SPQuery returning different before and after using RunWithElevatedPrivileges method

I am having a huge problem here. I am executing a query looking for a SPListItem, when I execute this query with user identity it works well, retuning the fields "Author" and "Editor" that I need. ...
1
vote
1answer
224 views

How do I get the current Editor of an Listitem while ItemUpdating?

How can I get the current Editor of an list Item in SharePoint 2010 during ItemUpdating? Problem is properties.AfterProperties["Editor"].ToString() throws and Exception cause it's null. This ...
0
votes
1answer
305 views

How to change file in sharepoint library?

I have sharepoint documents library and I have wcf service from where i should download new version of document file on button click. So i got next method: public void UpdateFile(SPListItem ...