Archive for August, 2011

Exporting Large Lists To Excel 2010

August 13th, 2011 Abed Khooli No comments

You try to export a large list (say over 100000 items) to Microsoft Excel 2010 and guess what? Only the first 52000 rows (plus the header) are exported. You also get a warning that reads “you do not have permission to view the entire list because it is larger than the list view threshold enforced by the administrator.” However, using Excel 2007, you can export the whole list without any complaint (a test was done on a little over 100000 items). Office 2010 is integrated with SharePoint 2010 more than 2007 is and this is one downside of this integration – or is it? Consider performance implications if several users start exporting large lists to Excel (may be security issues as well – taking data away easily).
The warning message resonates very well with the resource throttling in SharePoint 2010 except that the default threshold for a user is 5000 items only. In fact, the fix is to adjust resource throttling.
From Central Admin – application management – manage web applications, highlight the specific web applications and from the web application’s general settings (ribbon), select resource throttling and adjust the limit (for end user or for auditors and administrators) or enable and specify a time window for large queries. Export the list and reset the throttling back when done.

Categories: Lists Tags: 52000 rows exported, Export to excel 2010, Resource throttling

How To Display Tasks Assigned Directly And Through A Group

August 4th, 2011 Abed Khooli No comments

Let’s say we have a traditional SharePoint 2010 Tasks list. The Assigned To field allows both users and groups. Tasks are being assigned both on individual level and on group level. How do you filter your tasks? SharePoint has several views for the Tasks list and two of them are relevant: My Tasks and By My Groups. The first is obvious and the second refers to the group membership of the current user. So, the answer is in the combination of the two.
An easy trick would be to create a web part page and add two web parts to it – one based on the My Tasks view (edit web part, select view) and the other based on the By My Groups view. You stack them on top of each other and that should work.
What we will do in this short article is actually combine them in one view. I created a view (in the browser) based on the By My Groups – actually exact copy. Then I headed to SharePoint Designer and opened the view for editing. I also opened the My Tasks view and switched both to code view. The focus is on the QUERY part. All you need to do is use an Or operator and copy the criteria from the My Tasks view.
The image shows the final query in context (code view of a copy of By My Groups view).
You can see, in the inset, that I have my tasks grouped (expandable and collapsible) whether they were assigned explicitly or implicitly (as part of a group I am a member of).

Categories: Lists, SharePoint Designer 2010, Views Tags: group tasks, my tasks