The list or library contains a large number of items. Learn about managing a large list or library and ensuring that items display quickly.

Today we have received one incident ticket in which the user was facing the below mentioned error message:

The list or library contains a large number of items. Learn about managing a large list or library and ensuring that items display quickly.

Hmm…Pretty much enough to understand that the library or list consist of so many items and now it’s affecting the performance. If you wanna see the performance criteria which have been defined by Microsoft then please refer this link:

http://office.microsoft.com/en-us/windows-sharepoint-services-help/manage-lists-and-libraries-with-many-items-HA010173667.aspx

Microsoft has given a very detailed description regarding the performance criteria:

Once you’ve exceeded the 2000 item limit, you may see this message on the list settings page (red exclamation point):

The list or library contains a large number of items.

Please keep one more msdn article handy with you to make the clear understanding of this point: http://blogs.msdn.com/b/ecm/archive/2010/04/05/it-looks-like-you-re-building-a-large-library-would-you-like-help.aspx

If you still has any queries/questions then please let me know. I would be more than happy to discuss the problem and helps you to resolves your issues as soon as possible. Thank you.

This installation is forbidden by system policy. Contact your system administrator

Problem Description:

When installing Excel Viewer 2007, about half through he gets the error "your system administrator has set policies to prevent this installation" - The verbose log shows: This installation is forbidden by system policy. Contact your system administrator.

When we were running Excel Viewer 2007, about half through he gets the error
"Your system administrator has set policies to prevent this installation".

The verbose log shows:

This installation is forbidden by system policy. Contact your system
administrator.
C:\Program Files\MSECache\xlview_en-us\xlview.msi
MSI (c) (10:E0) [17:37:07:981]: Product: Microsoft Office Excel Viewer - Update
'Microsoft Office Excel Viewer 2007 Service Pack 1 (SP1)' could not be installed.
Error code 1625. Additional information is available in the log file
C:\DOCUME~1\p112279p\Local Settings\Temp\MSId301e.LOG.

Steps taken to resolve this issue-

There may be an invalid past reference in the registry to Excel viewer here:

[HKEY_CLASSES_ROOT\Installer\Products\00002159F30090400000000000F01FEC]

"ProductName"="Microsoft Office Excel Viewer 2007"

Points of interest -

1. The product name for the current version of the Excel viewer should be:

"Microsoft Office Excel Viewer"

2. There are no other values under

"HKEY_CLASSES_ROOT\Installer\Products\00002159F30090400000000000F01FEC". Only the

ProductName.

If we delete the key

HKEY_CLASSES_ROOT\Installer\Products\00002159F30090400000000000F01FEC, and reattempt the Excel Viewer 2007 install, it succeeds without the bogus Policy error.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you

Opening HTML Files in Sharepoint 2010

In SharePoint 2010 I have created a Library in which I have placed an Html document and related file system to go with the document.  Under Library Settings / Advance Settings I have selected (Open in Browser). However, when I click on the file to open it in SharePoint it does not open in the browser but opens up a dialogue box to save the file locally.


Requirements: We wanted the ability to open the HTML document directly within the browser. 


Multiple Requirements:

1. upload html files to a sharepoint library: in document library we can add html files, but the problem is when i open that html file in the library a popup message box appears asking to save the file. is there a way to open these html files in a browser like documents are open in word.

2. Asking to save file when try to open it from sharepoint: When I try to open the files(.html,.xml.....) which are uploaded to sharepoint,Its not getting opened directly instead a pop up window to save the file is coming.

3. In a document library when I check out a Word document, I get prompted "You are about to check out ___" with the option to use Local Drafts folder.  I can then open the document from Local Drafts and upon saving, I get prompted to check in.

4. If you have converted Word document to HTML file and uploaded it to SharePoint.  Now I would like to make modification to the new HTML file and save it through SharePoint.  However, it is not possible because it the HTML file doesn't "save" option, only "save as" option. 

Resolution:

By default, Sharepoint 2010 is blocking the ability to open HTML documents directly from a document library. 

However this can be changed by adjusting the browser file handling option. The option is located here:

1. Central Admin\Application Management\Manage Web Applications.
2. Select General Settings for the specified web application
3. For Browser file handling, select permissive. The default is strict​

Detailed Explanation as why it happens:

This is intentional behavior. In SP2010 Microsoft has tightened up security for people with contribute access. Previously, a malicious user could upload a file with script in it that would get run as whoever browses to the page ie. an admin. In 2010 where we have a javascript object model, this would be a big problem if we didn't have this restriction in place.
Browser File Handling  
Specifies whether additional security headers are added to documents served to web browsers. These headers specify that a browser should show a download prompt for certain types of files (for example, .html) and to use the server's specified MIME type for other types of files.
Permissive Specifies no headers are added, which provides a more compatible user experience. 
Strict Adds headers that force the browser to download certain types of files. The forced download improves security for the server by disallowing the automatic execution of Web content that contributors upload

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, thank you

Office Web Apps

Office Web Apps are online mechanisms to Microsoft Word, Microsoft Excel, Microsoft PowerPoint and Microsoft OneNote applications that allow us to access documents from anywhere. Some of the features include concurrent editing with Excel files, meaning you can have several people all editing the same file at the same time. Way cool! Another is dynamic saving, which works in all apps except Word. This means there is no save button and changes are automatically saved back to the server.

Windows browser support includes IE 7 and IE 8, Firefox 3.5 and later, and Safari 4 and later. Expect good results when working from a Mac or Linux machine. You also have pretty good mobile support for viewing, but not editing files. Office Web Apps works on Windows Mobile, BlackBerry, iPhone, and some others.

Don’t look to Office Web Apps to replace your Office client; rather, it’s a complementary offering. Although the viewing support is fantastic, editing is limited and is only practical for lightweight tasks.

I would like to share some vital points that i had observed after the deployment of office web apps:

1. Office Web Apps must be installed on every server in SharePoint 2010 Farm

2. Office Web Apps is it is not a part of SharePoint 2010, its Office 2010 functionality and is integrated with SharePoint 2010.

3. SharePoint 2010 has to be installed first before you can install Office Web Apps.

4. Office Web Apps works with SharePoint Server 2010 or SharePoint Foundation 2010.

5. Installing Office web applications on SharePoint 2010 installed on Win 7 client is not supported.

6. Office web applications are meant for intranet and not for Extranet Collaboration Environments where there are large numbers of users.

7. You can control default open behavior to open using Office Web Apps, you cannot control the default new behavior to use Office Web Apps. What I mean by this is if you have Office Installed on Client its always going to use office client when you try to add new document to document library.

If you have any queries/questions regarding the above mentioned info then please let me know, Thanks...