Representation of a list item within the SharePoint API.
0
votes
2answers
39 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.
1
vote
4answers
410 views
List Item Timeout
I am trying to open/close the a custom list item with 11500 items but I am getting an error which seems to be a timeout error, i checked the logs and found 'Unable to execute query: Error 0x80131530'. ...
2
votes
2answers
439 views
Attach ListItem to TaskItem
I've created a custom approval worfkflow for an listitem. Now I need to see the values of the item in the taskitem. So I think one way would be to attach the ListItem to the TaskItem.
Does anybody ...
1
vote
3answers
3k views
Fastest way to retrieve an item by title?
Currently I am using a foreach loop to find the item I want by its title using the following code:
SPList list = web.Lists.TryGetList("DocumentLibrary");
foreach ...
2
votes
2answers
35 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
17 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
14 views
Retrieving the SPLookupFieldCollection with particular ID's
The situation is following:
I have this kind of string = 58;#value;#59;#value2;#60;#value3;....
So as you see this is just if i do:
SPFieldLookupValueCollection collection= new ...
0
votes
0answers
13 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
0answers
31 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
2answers
308 views
Move Existing SPListItem to an Existing SPFolder?
Is there a way to programmatically move an existing list item (SPListItem) to a folder or do I need to make a new item that is a duplicate of the list item in the folder in question and then delete ...
1
vote
1answer
538 views
SharePoint 2010 - get list item from search result
I'm using FullTextSqlQuery to search items on specific list. Query returns results properly. Now I'd like to get SPListItem from search results. As I searched Internet, I found couple of examples, but ...
0
votes
3answers
2k 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
50 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
481 views
Looking for a way to replace the File in an SPListItem
I have implemented a system for publishing documents from a document library to a Document Centre. This uses a Send To Connection set up with the "Move and leave a link" option.
When this is used the ...
0
votes
2answers
460 views
Is it possible to determine if a given URL represents an SPListItem?
I am wondering if there is some sort of way to check a URL to see if it represents a list item before calling SPWeb.GetListItem that I haven't found.
I have code that needs to retrieve a list item ...
0
votes
1answer
16 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 ...
0
votes
1answer
20 views
Dates and times in Properties vs Fields
I'm trying to roll my own archiver for SharePoint. I always try to let the underlying object serialize itself. Only when it fails do I try to use .ToString(). Anyway, while inspecting the Properties ...
3
votes
1answer
36 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 ...
0
votes
0answers
22 views
File in document library is missing SPListItem
I have a "Master Page Gallery" where I can get some files using myList.RootFolder.Files but they do not exisit in myList.GetItems()
Using powershell I have found the file has all valid data but no ...
2
votes
1answer
119 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
35 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
709 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
50 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
26 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
26 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
3answers
888 views
Value does not fall within the expected range. But the field exist
I have the following problem.
I have a list with a custom content type, when programmatically I want get an information from my SPListItem I get the following exception: Value does not fall within the ...
0
votes
1answer
19 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
47 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.? ...
7
votes
2answers
445 views
Is it possible to create a “Link to a Document” in a Document Library using a CAML Batch Command with UpdateListItems?
I have a Document Library in WSS 3 which has the "Link to a Document" content type enabled, and I want to use a batch command (via lists.asmx updatelistitems) to create a series of links. Here is the ...
1
vote
1answer
355 views
Randomly: Item does not exist. It may have been deleted by another user
I have a rather curious issue with some workflow tasks.
My (state machine) workflow creates a handful of tasks while running. Users interact with the tasks to move the workflow between its states. ...
0
votes
3answers
95 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
49 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
17 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 ...
2
votes
1answer
61 views
Unable to update list item - Additions to this web site have been blocked
I am developing a SharePoint job. In the public override void Execute(Guid targetInstanceId) method, my code goes:
SPSecurity.RunWithElevatedPrivileges(delegate()
{
int count = ...
0
votes
0answers
29 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
64 views
Do I need to do an update after set permissions on a listitem in the ItemAdded event receiver?
I have an event receiver on itemAdded. I set some permissions like below.
SPRoleAssignment role = new SPRoleAssignment(spPrincipal);
...
1
vote
1answer
91 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 ...
0
votes
1answer
190 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
107 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
828 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
0answers
160 views
Updating SPListItem with all values in SPFieldLookupValueCollection
Hi I have a custom field from base type SPFieldLookup.
I am retrieving taxonomy fields from a another list and updating the current list items.
This works fine with single lookup values.
I am trying ...
0
votes
2answers
82 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
46 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
0answers
44 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 ...
0
votes
2answers
262 views
Sharepoint 2007 Powershell: $item.update() gives error that file has been modified
I am trying to programmatically update some metadata for a sharepoint item using powershell. Here is my code:
$web = getWebByURL("http://test-site/spadmin/")
$itm = $web.lists["Documents"].items[0]
...
1
vote
0answers
135 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
1k 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
1k 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.
2
votes
1answer
126 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
335 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 ...
