19 March, 2011

File Name, Length, Size and Invalid Character Restrictions and Recommendations


New Blocked File Types

If you were familiar with the WSS 2.0 list, there are some new Blocked File Types: .asmx, .rem, .resx, .soap, or .ashx.  If they existed before upgrade they are no longer visible or cannot be opened after upgrade.  These file extensions have been added to the list of blocked file extensions.

You now have the ability to make differences between farm wide blocked file types and web application blocked file types.  If you want to un block it, it needs to be removed at both farm and application levels, but you can add specific blocked files for a single web application.  The farm level block list for example will override anything removed at the web application level.

My most commonly removed blocked files are .chm (help files), .lnk (url link), .url (url link) 

My most commonly added blocked files are .mp3 (audio), .pst (mail), .vhd (virtual hard drive)


Site Names

-In WSS Site Names may not contain the following characters: \ / : * ? " < > | # { } % & " ~ +
-You cannot start a site name, sub site name, or a site group name with an underscore (_) character or with the period character (I recommend avoiding the (_) underscore in site names)
-You cannot use the period character consecutively in the middle of a site name
-You cannot use the period character at the end of a site name

File Names

-Invalid characters: " # % & * : < > ? \ / { | } ~ 
-Cannot be longer than 128 characters
-You cannot use the period character consecutively in the middle of a file name
-You cannot use the period character at the end of a file name
-You cannot start a file name with the period character


Folder Names

-You cannot use the following characters anywhere in a folder name or a server name:  ~ # % & * { } \ : < > ? / | "
-Cannot be longer than 128 characters
-You cannot use the period character consecutively in the middle of a folder name
-You cannot use the period character at the end of a folder name
-You cannot start a folder name with the period character

Max File Upload/Download Sizes

The default max single file upload size is 50 MB by default for a web application.  

Microsoft IT limits their environment at 100 MB, and the maximum that the product itself can handle or support is 2GB which is essentially a SQL limit.  By setting the limit to blank will essentially support what SQL will support.

Increase the maximum upload size

1.  Click Start, point to All Programs, point to Administrative Tools, and then click SharePoint Central Administration.
2.  Under Virtual Server Configuration, click Configure virtual server settings.
3.  On the Virtual Server List page, click the virtual server you want to change.
4.  On the Virtual Server Settings page, under Virtual Server Management, click Virtual server general settings.
5.  Under Maximum upload size, type the maximum file size (in MB) that you want to allow to be uploaded.
6.  Click OK.

1. Get into the SharePoint Central Administration Site
2. Select "Application Management"
3. Under the "SharePoint Web Application Management" section select "Web Application General Settings"
4. Change the "Maximum Upload Size"

If IIS is timing out when you upload large files, you can configure the Connection timeout setting in IIS to allow more than the default 120 seconds (2 minutes).

Tune the IIS connection timeout

1.    Click Start, point to All Programs, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
2.    Right-click the virtual server you want to configure, and then click Properties.
3.    Click the Web Site tab.
4.    In the Connections section, in the Connection timeout box, type the number of seconds you want IIS to wait before timing out.
5.    Click OK.

Coying the files from document library to local hard disk / how to copy/upload documents from local folder to Sharepoint document library


Document libraries are collections of files that you can share with team members on a Web based on Microsoft Windows SharePoint Services. For example, you can create a library of common documents for a project, and team members can use their Web browsers to find the files, read them, and make comments. Users with Microsoft Office 2003 can check out and edit the files as if they resided on a local or network drive.

Please refer the following steps as mentioned below:

Copy / Move SharePoint Document Library files to local folder:

1. Open the sharepoint site that you are using/referring to

2. Go to the sharepoint document library in which all the files resides

3. In the right hand side of the document library, you can see 'ALL DOCUMENTS' View, Please click on that and select 'EXPLORER VIEW'

4. You will see the same set of files/folders which are present in standard view, now select the number of files/folders that you wants to move/copy by using basic windows operations.

Windows commands:

CTRL A: Select
CTRL C: COPY
CTRL V: PASTE
CTRL X:  CUT

5. Suppose if you had selected to copy(CTRL C) then go to the local drive/Desktop location where you wants to paste/move and paste it(CTRL V)-thats it..

6. Depending upon the size of the documents, it will take some time to complete the operation...

same procedure will be applied to copy/upload documents from local folder to SharePoint document library i.e. EXPLORER VIEW so that the activity will be completed in quick manner...

If you have any queries/questions then please let me know..


I would be more than happy to help you as well as resolves your queries..Thanks...

17 March, 2011

How to Enlarge the Size of Announcements Web Part

The purpose of an announcement web part is to provide relevant information to the users of a center. The content displayed in announcement web parts is page-based. That means, if a user has access to the page displaying the web part, they will be able to see the content displayed in the web part.

Yesterday, one user raised a ticket as she wants to enlarge the size of the announcement webpart. The reason behind this is-When we create the announcement then the announcement webpart shows some information and remaining one in the dotted lines. So user has to click on that link to view the complete announcement.

User's query was reasonable as why the user click on the link each time if they want to view the complete info. Let me clear first thing-There is no out-of-box way to achieve this functionality. If you want to fulfill this requirement then please use SharePoint Designer 2007(SPD).

In this post, i am going to convey the steps that i have taken to resolve this issue. In case of any doubts/queries then please let me know. I would be more than happy to help you as well as resolves your issues, Thanks...

Here we go:-
1. Open the default.aspx page in SharePoint Designer (Please take the backup of this page first before making any kind of changes)

2. Click on the announcements web part and you'll notice a List View Options button is displayed in the upper left corner of the web part.

3. Click on Change Layout.

4. Select the Layout tab and select the layout that is 3rd or 4th from the bottom of displayed layouts and click OK.

5. Click yes to the Site Definition Page Warning dialog. 

6. Save your work in SharePoint Designer.

7. Go back to your browser in which the site is currently open and check the results (Please refresh once)

16 March, 2011

This Form Template Is Browser-Compatible, But It Cannot Be Browser-Enabled On The Selected Site.


I have an InfoPath form which is published to a document library in a SharePoint site. I am using InfoPath 2007 and MOSS 2007 enterprise edition. When I try to publish the form, and when I check the box "Enable the form to be filled out by using a browser", I only have the option to publish the form as Administrator approved form template, the other options of publishing it in a document library or publishing it as a content type are grayed out. 

 The InfoPath wizard is throwing an error message:

"This form template is browser-compatible, but it cannot be browser-enabled on the selected site"

Troubleshooting Steps:

1. Check Central Administration Settings

 -Central administration
 -Application Management
 -Click on Configure InfoPath Forms Services in the InfoPath Forms Services section (Check the following Check-boxes)
 a. “Allow users to browser-enable form templates”
 b.“Render form templates that are browser-enabled by users”

2. SharePoint Site Settings
1)   Open your SharePoint site
2)   Click on Site Actions 
3)   Site Settings
4)   Select Site collection features under Site Collection Administration
5)   Activate InfoPath Forms Services support or Office SharePoint Server Enterprise Site Collection feature

3. InfoPath 2007 client settings:
1)   Open the InfoPath client
2)   Tools
3)   Form Options
4)   Select the Compatibility category
5)   Check the 'Design a form template that can be opened in a browser or InfoPath'
6)   Click Ok

4. Form Publishing:

1)   When you published the form on to a document library then please make sure this settings (imp step):
2)   Check the “Enable this form to be filled out by using a browser” checkbox and finish.

5. Document Library Settings:
1)   Open the document library
2)   Settings
3)   Document Library Settings
4)   Advanced Settings
5)   Select the “Display as a Web page” option in the Browser-enabled Documents category

After all these troubleshooting steps, if you still faces the same issue then please execute the below mentioned commands and your issue will be resolved:

stsadm -o deactivatefeature -filename IPFSSiteFeatures\feature.xml -force -url %SITE_COLLECTION_URL%

stsadm -o deactivatefeature -filename IPFSWebFeatures\feature.xml -force -url %SITE_COLLECTION_URL%

STSADM.EXE -o activatefeature -filename IPFSSiteFeatures\feature.xml -url %Sitecollection_URL% -force

STSADM.EXE -o activatefeature -filename IPFSWebFeatures\feature.xml -url %sitecollection_URL% -force

If you have any queries/questions then please let me know. I would be more than happy to help you as well as resolves your queries...

10 March, 2011

How to find GUID of SharePoint list:MOSS 2007/WSS 3.0


In this post i am going to discuss multiple ways by which we can easily find the guid of sharepoint lists. SharePoint list's are used on day-to-day basis and sometimes there might be customer requirement/project need where we required sharepoint list Guid.


Please refer the following ways and select the easiest way as per your requirement. In case of any confusion/queries then please let me know,Thanks...


First Way:


-Navigate to the SharePoint list using the browser.
-Select the Settings + List Settings menu command.
-Copy the Url from the browser address bar into Notepad. It will look something like:


http://sharepoint2007/ProjectX/_layouts/listedit.aspx?List=%7B26534EF9%2DAB3A%2D46E0%2DAE56%2DEFF168BE562F%7D


-Delete everying before and including “List=”.
-Change “%7B” to “{” 
-Change all “%2D” to “-“
-Chnage “%7D” to “}”


You are now left with the Id:


{26534EF9-AB3A-46E0-AE56-EFF168BE562F}


Second Way:


-Go to respective List
-Go to Settings 
-List Settings 
-Right-click on the 'Information management policy settings' link and 
-choose Copy Shortcut.
-Paste the URL and you can see the GUID surrounded with "{" and "}".


+ Access the list via your browser and select the View you want to find the GUID.
+Select "Modify this View" and copy the URL.
+You will get a URL like this,



http://sharepoint2007/admintesting/_layouts/ViewEdit.aspx?List=%7B5C65CB1A%2D2E1B%2D488A%2DAC07%2DB115CD0FC647%7D&View=%7B75E689B4%2D5773%2D43CB%2D8324%2D58E42E1EB885%7D&Source=http%253A%252F%252Fmysite%253A5050%252Ftestsara%252FLists%252FTasks%252FAllItems
%252Easpx



From the above URL, you will find this:


List=%7B5C65CB1A%2D2E1B%2D488A%2DAC07%2DB115CD0FC647%7D
View=%7B75E689B4%2D5773%2D43CB%2D8324%2D58E42E1EB885%7D


Replace "%7B" with "{"
Replace all "%2D" with "-"
Replace "%7D" with "}"


You are now left with the following GUIDs:


List ID is {5C65CB1A-2E1B-488A-AC07-B115CD0FC647}


View ID is {75E689B4-5773-43CB-8324-58E42E1EB885}


Third Way:


SharePoint Tips Utility Pack: http://spstipsutilitypack.codeplex.com/


SharePoint Tips Utility Pack is a package of utilities for the administrator\developer\deployer of SharePoint 2007 and WSSv3. 


Fourth Way:


A little GUID picker: Credit goes to Ronalus- http://blogs.msdn.com/b/ronalus/archive/2007/09/08/a-little-guid-picker.aspx


+Type a Site URL, and select “Display Lists Titles and Ids”. From the list of lists you can select a list GUID, and with right-click copy it to the List ID input field.


+After clicking “Display Views” you see the available list views. Again you can select a view guid, and with right-click copy it to the View input field.


+Select “Display Items” to display the list items in the view.


+With a click on “Display default List Attribute Names” de internal names of the fields in the list are displayed.


Fifth Way: 


SharePoint Inspector: http://spi.codeplex.com/


=SharePoint Inspector is a free tool to browse your SharePoint 2007 farm. 
=You can see objects composing its structure, get their properties by reflection, which can be very useful when you want to check if your code does what it should do.
=You can use also some advanced features like activate/deactivate SharePoint features, add/remove event receivers, manage your recycle bin.


Please refer the following screenshots regarding the same: