Tuesday, August 9, 2011

SharePoint 2010: The List Cannot be Displayed in Datasheet view.....

The list cannot be displayed in DataSheet view for one or more of the following reasons:

- A datasheet component compatible with Miicrosoft Sharepoint Foundation is not installed.
- Your web browser does not suport ActiveX controls
- A component is not propelry configured for 32- or 64-bit support.

If you're a SharePoint Dev/Admin/Enthusiast using a 64bit system with 64bit Office / IE, chances are you will run into this issue. I was combing for a solution when I came across this MSDN SP2010 General Q&A forum post.

Special thanks to Jennie E [MSFT] for pointing us to the 2007 Office System Driver: Data Connectivity Components

Tuesday, July 12, 2011

SharePoint 2010 - PDF Security

IE8 and PDF files in SharePoint don't necessarily play nice together for a reason - security. By default you'll click on your PDF and get an option to either Save or Close. Here's a good explanation and the reason you should use an ‘Inline Download’ exclusion as opposed to the common (but not recommended) Browser File Handling setting in Central Admin.

Quick link to share via JB's Just Saying...

PowerShell Script:

$webApp = Get-SPWebApplication http://webapp.domain
 If ($webApp.AllowedInlineDownloadedMimeTypes -notcontains "application/pdf")
   Write-Host -ForegroundColor White "Adding Pdf MIME Type..."
   Write-Host -ForegroundColor White "Added and saved."
 } Else {
   Write-Host -ForegroundColor White "Pdf MIME type is already added."

In addition, if you want your PDFs to open in a new window or even in Adobe Reader you'll want to change your local Adobe Reader client settings:

Open Adobe Reader
Select “Edit” –> “Preferences” from the menu system.
Select the option on the left called “Internet”
Either select or de-select the option called “Display PDF in Browser” depending on your preference.

SharePoint Administrators, don't forget your PDF iFilter for searching those PDFs!

Monday, January 24, 2011

SharePoint 2010 - Content Query Web Part (CQWP) Slow Loading New Items?

We've recently implemented several Content Query Web Parts (CQWP) which I love. However, I noticed that new items weren't showing up so quickly. I did a couple of quick checks to make sure items weren't checked out or unapproved but to no avail.

Then, after some digging, I came across the following article from Michael Nemtsev: Why Content Query Web Part (CQWP) doesn’t return all results.

The workaround is a simple one:
set “UseCache” property to “false”.

Interesting note from the SharePoint Team:

Cite from SharePoint Team:

“You are only seeing your items in edit mode because the caching infrastructure of the CQWP does not cache checked-out items of individual users and we disable cache in edit mode. You can disable caching on your Web Part by setting the "UseCache" property to false”

Just a handy note in case anyone else has trouble with that very useful (but sometimes pesky) Content Query Web Part.

Monday, January 17, 2011

SharePoint 2010 Limits, Thresholds, and Boundaries

Here are some key SharePoint 2010 Boundaries and Limits
Via: http://technet.microsoft.com/en-us/library/cc262787.aspx


Content database size - 200 GB per content database

Site collection size - 100 GB per site collection

File Size - 2GB - The default maximum file size is 50 MB. This can be increased up to 2 GB, however a large volume of very large files can affect farm performance.

Documents - 30,000,000 per library

Major Versions - 400,000

Bulk Operations - 100 items per bulk operation

List view lookup threshold - 8 join operations per query

List view threshold - 5,000

List view threshold for auditors and administrators - 20,000 - This setting works with Allow Object Model Override.

Subsite - 2,000 per site view

Web Parts - 25 per wiki or Web part page

Users in a site collection - 2 million per site collection

Alerts - 1,000,000 per search application - This is the tested limit.

Keywords - 200 per site collection

Social tags, notes and ratings - 500,000,000 per social database

Blog Posts - 5000 per site