Representation of a list item within the SharePoint API.

learn more… | top users | synonyms

0
votes
2answers
1k views

ItemEventReceiver - ItemDeleting not working with a document library and referencing list

I have a custom list that has a GUID column which refers to the UniqueId of a document in a document library. Every time I upload a document, it should add an entry in this list and populate the ...
1
vote
2answers
1k views

SPListItem.Attachments - what type cast?

When iterating through a SPListItems SPAttachmentCollection what type cast am I supposed to use? SPFile or SPFileStream or something else? I want to display the item's filename and when it was ...
0
votes
0answers
978 views

C#: cannot get listitem field value but works fine in powershell?

back again with a strange issue. Using powershell I can get a handle on a SPListItem and do Item["My Field"] which prints its value. However, in a C# custm workflow activity, when I attempt to do ...
0
votes
1answer
482 views

Getting the properties of an item through web services

Is it possible to get the SPListItem.Properties property of an item through one of the out-of-the-box API web services in SP 2013?
1
vote
2answers
3k views

Unable to update item using powershell when event reciever is enabled

I have a powershell script that I am using to update some list items programatically. It seems to work as I expected when I disable the event reciever that is associated with the list however when I ...
0
votes
4answers
275 views

SPListItem.Delete() has some issues

I have a list which consist of more than 5600 items. In my application i will search all the items from particular date range by using SPquery. As the result of the SPQuery, the splistitem collection ...
1
vote
3answers
5k views

How to programmatically restart a workflow

I have a workflow linked to my list. Is there any programmatically way to select a list item and restart the associated workflow? Something like: SPListItem item = List.Items.GetById(1); item....
2
votes
1answer
4k 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
311 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 ...
17
votes
1answer
23k 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 item["Field"]....
0
votes
1answer
198 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
1answer
1k 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
192 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
127 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
2k 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
826 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
2k 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
252 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, ...
1
vote
0answers
510 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
8k 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
721 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
54 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
364 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
317 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
365 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
1k 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
323 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
151 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
112 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
258 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] = "E714297B-E922-...
0
votes
2answers
1k 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
5k 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
393 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
0answers
76 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
355 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
3k 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
429 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 ...
2
votes
3answers
5k 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
333 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
370 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
656 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
3k 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 ...
3
votes
2answers
383 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
716 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 link....
0
votes
2answers
136 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
256 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
748 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 = (string)...
0
votes
1answer
1k 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
2k 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 Convert.ToDateTime(oItem["Status"])....
1
vote
0answers
321 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 ...