I had a hard time finding a good source for this, and therefore decided to write a short post about it.
First of all, I want to say that I am against the use of folders unless you absolutely need them. They add unnecessary complexity, and you can have the benefits of folders without many of the drawbacks by using metadata instead, for example with managed metadata fields. However, as there are no OOTB (out of the box) way of handling permissions for a group of items based in their metadata, folders MIGHT be useful for that purpose. There are other solutions though.
Now to the task at hand, moving a SPListItem based on it’s metadata, and then moving it to a subfolder in the same list. In my example, I will be moving the item in an event receiver.
What we need to do is to check the SPFileSystemObjectType of the SPListItem. This value will actually be File, even it it’s not a document library. Regular list items will also return object type File. This is only needed if you don’t want to move folders the same way.
This code assumes you have already got your SPListItem:
|
1 2 3 4 |
if (item.FileSystemObjectType == SPFileSystemObjectType.File) { // Put the rest of code here. } |
Then we need to get the file object of the item. The file object will exist even if the list is not a library, and this code will work for documents and list items alike.
|
1 |
SPFile file = item.Web.GetFile(item.Url); |
Then we want to build the new destination path were the item will be moved to. The path should follow the pattern: “<web url>/<list rootfolder url>/<subfolder>/<item Id>._000″
|
1 |
string filePath = string.Format("{0}/{1}_.000", "My Folder", item.ID); |
And lastly, we simply call the SPFile.MoveTo method on our file object, and add the destination path.
|
1 |
file.MoveTo(filePath); |
And that’s it. Put this in an ItemAdded function in an event receiver for a list and items will automatically be moved to the correct folder. Below is my complete example where I also make sure the folder exist before moving the item.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
public override void ItemAdded(SPItemEventProperties properties) { var item = properties.ListItem; var folderName = item["My Column"].ToString(); var folderUrl = SPUtility.ConcatUrls(SPUtility.ConcatUrls(item.Web.Url, item.ParentList.RootFolder.Url), folderName); EnsureFolder(item.ParentList, folderName, folderUrl); MoveItemToFolder(item, folderUrl); } private static void EnsureFolder(SPList list, string folderName, string folderUrl) { if (!list.ParentWeb.GetFolder(folderUrl).Exists) { SPListItem newFolder = list.Items.Add(list.RootFolder.ServerRelativeUrl, SPFileSystemObjectType.Folder, folderName); newFolder.Update(); } } private static void MoveItemToFolder(SPListItem item, string folderUrl) { if (item.FileSystemObjectType == SPFileSystemObjectType.File) { var filePath = string.Format("{0}/{1}_.000", folderUrl, item.ID); var file = item.Web.GetFile(item.Url); file.MoveTo(filePath); } } |
Sources:
http://zhebrun.blogspot.se/2011/06/sharepoint-how-to-move-listitem-or.html
