Monday, 7 February 2011

How to add webparts on Item Display Form Page through browser

Easy!- With out using sharepoint designer, you can able to add webparts on List Item Display Page.


All you need to do is open the displayform page-Dispform.aspx (view item), then amend the url of the page by removeing everything after the ID number and add this


&PageView=Shared&ToolPaneView=2




So the url will look like






Now the page will be in edit mode and you should be able to add webparts!

Also the Edit Page option under siteaction is visible after the first modification




Wednesday, 26 January 2011

MOSS: Report of Users and their permissions

-- All users in site collection

Select tp_Title,tp_Login, tp_IsActive from UserInfo order by tp_Title,tp_Login, tp_IsActive


-- All users in a group

Select Distinct Title, tp_Title,tp_Login from Groups gr

inner join GroupMembership grm on gr.ID = grm.GroupID

inner join UserInfo usr on usr.tp_ID = grm.MemberId

order by Title,tp_Title,tp_Login




-- All groups for a user

Select Distinct tp_Title,tp_Login, Title from Groups gr

inner join GroupMembership grm on gr.ID = grm.GroupID

inner join UserInfo usr on usr.tp_ID = grm.MemberId

order by tp_Title,tp_Login,Title


Thanks to my mate Navneet Singh.

MOSS: Report how many web pages are under the SiteCollection

You can find only by using SQL query


Select distinct DirName,LeafName from AllDocs where DirName like '%Pages' and LeafName like '%.aspx'

order by DirName,LeafName

Office documents prompt for login in anonymous SharePoint site

I have a MOSS 07 site that is configured for anonymous access. There is a document library within this site that also has anonymous access enabled. When an anonymous user clicks on a PDF file in this library, he or she can read or download it with no problem. When a user clicks on an Office document, he or she is prompted with a login box. The user can cancel out of this box without entering a log in, and will be taken to the document.

This happens in IE but not FireFox.

Solutions

Unfortuantly the only work around I've found breaks some functionality for logged in users (can't upload multiple files, connect to outlook ect..)
If that is acceptable, or you want to try it and see:
In central admin > application management > application security > authentication providers select your web app and select your provider (likely "default").
Select No for client integration and save the settings.

Open your web config, find the line add verb="OPTIONS,PROPFIND,PUT,LOCK,UNLOCK..... and remove the verb OPTIONS.

You should no longer be asked in ie for credentials.

Reference:
http://stackoverflow.com/questions/375390/office-documents-prompt-for-login-in-anonymous-sharepoint-site

Wednesday, 8 December 2010

Disable "The Web site wants to run the following add-on: 'Name ActiveX Control'" Message

Consider the following scenario. You use Windows Internet Explorer 7 to browse to a Microsoft Windows SharePoint Services 3.0 site or to a Microsoft Office SharePoint Server 2007 site. The SharePoint site is located in the Internet zone. Additionally, the SharePoint site has online presence enabled. When you browse to the SharePoint site, you receive the following message in the Information bar in Internet Explorer 7:
The Web site wants to run the following add-on: 'Name ActiveX Control' from 'Microsoft Corporation'. If you trust the Web site and the add-on and want to allow it to run, click here...

This issue occurs if the Name ActiveX control (Name.dll) is not added to the list of preapproved controls in Internet Explorer 7. The Name ActiveX control is included in the 2007 Microsoft Office system.

Configure the master page of the SharePoint site on the front-end Web server
loadTOCNode(3, 'workaround');

If the SharePoint site does not require online presence for anonymous users, configure the master page of the SharePoint site to use a new InitNoPresence.js file. Note: Disabling this control can also disable the Multiple Document Upload control for the affected audience which is why it is recommended to target the change below to anonymous users only. To do this, follow these steps:
Create the InitNoPresence.js file. To do this, follow these steps:
Start Notepad and create a InitNoPresence.js file on the front-end Web server in the same file folder as Init.js.Note The Init.js file is located in the Drive:\Program Files\Common Files\Microsoft Shared\Web server extensions\12\Template\Layouts\1033 folder.
In the InitNoPresence.js file, add the following lines of code.
function ProcessImn()
{
if (typeof(ctx)=="undefined") return;
if (ctx.CurrentUserId == -1) return;
if (EnsureIMNControl() && IMNControlObj.PresenceEnabled)
{
imnElems=document.getElementsByName("imnmark");
imnElemsCount=imnElems.length;
ProcessImnMarkers();
}
}
Save the InitNoPresence.js file.
Configure the master page of the SharePoint site to use the InitNoPresence.js file. To do this, follow these steps:
Start Microsoft Office SharePoint Designer 2007. Then, open the a copy of the master page for the SharePoint site.
In the copy of the master page, locate the following line of code.

Below the line that you located in the step 2b, add the following line of code.

Save the new copy of the master page and set it as the new default master page.Note Microsoft does not support making changes directly in the Init.js file. By adding a new file to override the function the customization will not be removed by an update. By using a new master page the customization can be easily removed for testing by restoring the original default.master page.

To fix this issue follow the instruction from the link below:

http://support.microsoft.com/kb/931509

Friday, 4 June 2010

Installing Team Foundation Server 2010 on Windows Server 2008 R2

How to Install TFS 2010

1) Install IIS (add role)
2) Add feature .net framework 3.5.1
you must have .NET Framework 3.5 installed. On Windows Server 2008 R2, you can install .NET Framework 3.5 by using the Add Features Wizard from Server Manager.
3)restart your server
4)Install SQL Server 2008
You will get known compatability issue but continue. But after Installed you must install SP1.

To run Team Foundation Server, you must install both the Database Engine and Full text search on the same instance of SQL Server And Client Tools Connectivity (required if no other SQL Server components are installed on the server that is running Team Foundation Server.)

5)Install SQL SP1

6)Install TFS2010
7)Configure TFS2010

Team Foundation Installation Guide for Visual Studio 2010 can be found under
http://www.microsoft.com/downloads/details.aspx?FamilyID=2d531219-2c39-4c69-88ef-f5ae6ac18c9f&displaylang=en

This installing guide is really helpful.

How to Connect TFS2010 from VS 2008

Connect Team Foundation Server TFS 2010 from Visual Studio 2008

1) Install or use allready installed Visual Studio 2008

2)Install Visual Studio Team System 2008 Team Explorer (if you haven't installed before)http://www.microsoft.com/downloads/details.aspx?FamilyID=0ed12659-3d41-4420-bbb0-a46e51bfca86&displaylang=en

2)Install Visual Studio SP1
http://www.microsoft.com/downloads/details.aspx?familyid=FBEE1648-7106-44A7-9649-6D9F6D58056E&displaylang=en

3- Install Visual Studio Team System 2008 Service Pack 1 Forward Compatibility Update for Team Foundation Server 2010 (Installer)
(http://www.microsoft.com/downloads/details.aspx?FamilyID=CF13EA45-D17B-4EDC-8E6C-6C5B208EC54D&displaylang=en)

You must Install this (3) other wise you will get this error
Possible reasons for failure include:
The Team Foundation Server name, port number or protocol is incorrect.
The Team Foundation Server is offline.
Password is expired or incorrect.

4) When you connect to TFS server specify the full url including port number
e.g ) http://yourTFSserver:8080/tfs/yourcollection

Done!