Microsoft Sharepoint

Installing Office 2010 Web Apps on SharePoint server 2010

Thu, 15 Jul 2010 21:06:38 GMT

This blog explains the steps invovled in installaing Office 2010 Web Apps in Sharepoint 2010 Server

AAPT India Website Developed in SharePoint is live now

Tue, 15 Jun 2010 16:20:20 GMT

IOTAP has been developing a SharePoint based website for AAPT India. The website acts as information source about AAPT and the range of services they offer. Development was completed last week and site went live. Checkout the site from www.aaptindia.com

Improve performance of SharePoint internet sites

Fri, 14 May 2010 09:06:26 GMT

Faster loading websites are need of the day as even a minor delay in the website response could cause frustration on the visitors part. Faster websites lead to happy users which in turn lead to increased business. A study by Google reveals that visitors spend less time in websites that are slow.

With our experience in building internet websites with Sharepoint we have acquired knowledge of several techniques that will greatly improving the website performance. Some of the techniques are listed below

1. Setup compression at web server level

2. Setup caching at web server level

3. Remove Core.js and other scripts that are used internally Sharepoint but required for anonymous users

4. Remove unwanted styles and markups from Sharepoint master page

5. Remove unwanted images

6. Minify Java script files and style sheets

7. Use CSS sprites

8. Remove unwanted web parts

After applying the performance enhancement techniques the speed of Sharepoint internet websites have increased drastically. If you want IOTAP to help you with improving your Sharepoint website performance drop in an email to info@iotap.com

tiCorridors.com portal developed in SharePoint went live

Wed, 12 May 2010 08:56:44 GMT

IOTAP has been developing a Sharepoint based economic portal called ti Corridors. This portal portal focuses on providing comprehensive analysis of the existing and projected economic activity between two nations. Our development was complete last week and site went live. Checkout the site from www.ticorridors.com

Getting rid of “The server returned a non-specific error” in SharePoint Designer

Tue, 11 May 2010 13:00:29 GMT

Every SharePoint developer who has worked with extensively with dataview webpart in SharePoint Designer would have encountered the below misleading error at least once

“The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again. If the problem persists, contact the server administrator.”

There are several solutions out there in the web for this error like the ones listed below but none of them are sure shot fixes

http://blogs.msdn.com/spdsupport/archive/2008/06/06/how-to-fix-error-unable-to-display-this-web-part-on-data-views-after-restoring-site-from-backup.aspx

http://cedric.sharepointspace.com/SharePoint_blog/Lists/Posts/Post.aspx?ID=70

After having tried out several solutions with no luck we tried copy the datasource from a newly created dataview and replace the datasource in the erroneous dataview. Gotcha this worked. Below are the steps we did

1. Create a new page in SharePoint designer.

2. Add a dataview webpart to the new page and set the datasource as the same list or library that the erroneous dataview uses.

3. Switch to the code view.

3. Open the page with the erroneous dataview in code view mode.

4. Copy the datasource element from the dataview in new page

5. Replace the datasource element of the erroneous dataview with the copied datasource element

Use of Colligo Reader For SharePoint and Installation

Thu, 18 Mar 2010 10:43:44 GMT

Purpose of Colligo Reader for SharePoint:

Colligo enables you to easily download content from SharePoint sites to your laptop or machine so you can access the content offline such as document libraries offline, Get read-access to document and forms, view customs and standard lists, Access events, issues, links, contacts, tasks and agendas rather than having to copy files one by one through a browser. Reader is a client-only application - no server modifications are required. Colligo Reader works with all shipping versions of SharePoint, including Windows^® SharePoint^® Services (WSS 3.0 & 2.0), Microsoft^® Office SharePoint^® Server (MOSS 2007), and SharePoint^® Portal Server (SPS 2003).

Installation:

Download the Colligo Reader for SharePoint and install it from http://www.colligo.com/products/sharepoint/reader.asp

Create a new downloadable site whatever your SharePoint site with your credentials. Select and download the content based on your requirement and synchronize it. It will get downloaded and everything is offline now.

For more information click here

Written By,

A.Ramu

Could Not Connect to MICROSOFT##SSEE (SharePoint Windows Internal Database)

Thu, 18 Mar 2010 07:12:20 GMT

If you get the following error message in SQL Management studio while accessing your SharePoint windows internal database, follow-up the solution steps

An error occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings, SQL Server does not allow remote
connections.

Solution steps:

1. open the SQL server configuration manager and right click the “ protocols for Microsoft##SSEE” under SQL server Network Configuration, Select properties then Change the “Hide Instance” status NO and click ok to close.

2. Confirmed the TCP Protocol is enabled and restart the SQL service instance.

3. Open the SQL server surface Area configuration, Click Surface configuration for Services and Connections and confirmed remote connection status to using TCP/IP protocols under the MICROSOFT##SSEE Instance.

4. Restart the Microsoft##SSEE instance service and now you can successfully access your SharePoint Database Instance.

Written by

A.Ramu

SharePoint Warm up Scripts for WSS/MOSS using power shell

Tue, 16 Mar 2010 12:27:59 GMT

Normally all the Application Pools that get created are scheduled to reset themselves at a certain time usually around 1.45 AM in the morning. Therefore if you browse the web site for the time, it takes long time to load the web application but instead of using this script, it speed the web application.

So if you want this script, add the below code I have provided in a PS1 script and scheduled in windows scheduled task list. You can remove those app pool recycles that are scheduled

Save the following in a script named SharepointWarmUpscript.ps1 (1 is numeric value one).

Code:

iisreset

############################################################################

#Assumptions:

#-Running on machine with WSS/MOSS

#-C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN in path

############################################################################

function get-webpage([string]$url,[System.Net.NetworkCredential]$cred=$null)

{

$wc = new-object net.webclient

if($cred -eq $null)

{

$cred = [System.Net.CredentialCache]::DefaultCredentials;

}

$wc.credentials = $cred;

return $wc.DownloadString($url);

}

#This passes in the default credentials needed. If you need specific stuff you can use something else to

#elevate basically the permissions. Or run this task as a user that has a Policy above all the Web Applications

#with the correct permissions

$cred = [System.Net.CredentialCache]::DefaultCredentials;

#$cred = new-object System.Net.NetworkCredential("username","password","machinename")

[xml]$x=stsadm -o enumzoneurls

foreach ($zone in $x.ZoneUrls.Collection) {

[xml]$sites=stsadm -o enumsites -url $zone.Default;

foreach ($site in $sites.Sites.Site) {

write-host $site.Url;

$html=get-webpage -url $site.Url -cred $cred;

}

Then go to the windows scheduled task, add new task and scheduled when you want and run it.

You can understand the difference between default scheduled recycling and the warm up script.

Written by

A.Ramu

Sharepoint Outlook Sidebar from Harmony

Fri, 12 Mar 2010 08:38:12 GMT

Harmony Outlook sidebar provides full featured access to documents within Sharepoint libraries. Using the Harmony sidebar documents in email attachments can be dragged to Sharepoint libraries and documents from Sharepoint libraries can be added as attachments or as links to emails. To cap it all Harmony Sidebar is Free!!!

Once the Harmony side bar is installed and the Sharepoint connection is setup, Sharepoint documents will be available in the side bar. Below screen shot shows contents of document library within the Harmony side bar

Harmony Sidebar for Sharepoint can be downloaded from http://harmony.mainsoft.com/content/downloads/harmony-for-sharepoint

Best Practice Analyzer for Windows SharePoint service 3.0 and MOSS 2007

Tue, 09 Mar 2010 13:31:13 GMT

What Best Practice Analyzer for WSS/MOSS can do?

The Microsoft Best Practices Analyzer for Microsoft Windows SharePoint Services 3.0 and the 2007 Microsoft Office System creates detailed reports to help administrators achieve greater performance, scalability, and uptime.

Install Best Practice Analyzer for WSS and MOSS 2007:

1. Download the best practice analyzer from the following URL.

http://www.microsoft.com/downloads/details.aspx?FamilyID=cb944b27-9d6b-4a1f-b3e1-778efda07df8&displaylang=en

2. Create the BPA folder on C drive.

3. Now run the downloaded file that Extracted to the C:\BPA folder.

Now we are going to execute the best practice analyzer on WSS/MOSS using command.

4. Start -> RUN-> CMD and type the following command.

Cd C:\BPA

Where C:\BPA is the location that contains the Microsoft Best Practices Analyzer for Microsoft Windows SharePoint Services 3.0 and the 2007 Microsoft Office System. (If the Microsoft Best Practices Analyzer for Microsoft Windows SharePoint Services 3.0 and the 2007 Microsoft Office System is in a different location, replace C:\BPA with that location.

5. Type the following command, and then press ENTER:
sharepointbpa.exe -cmd analyze -substitutions SERVER_NAME CentralAdministrationServer

where "CentralAdministrationServer" is the server name for your SharePoint Central Administration.
It is important that SERVER_NAME is included in the parameters capitalized and that CentralAdministratorServer is replaced with the server name that is running SharePoint Central Administration.

6. After the analysis is complete, open sharepointbpa.report.htm in a web browser.
sharepointbpa.report.htm will be in the same location that the Microsoft Best Practices Analyzer for Microsoft Windows SharePoint Services 3.0 and the 2007 Microsoft Office System was installed.

7. Exit the command. Now on the report html page you will get available Error on your server and warning message with solution.

8. Find the Problem and resolve it one by one.

Written by

A.Ramu

Manage Content Types on New Button

Wed, 03 Mar 2010 04:38:51 GMT

SharePoint Lists are enabled with multiple content types, because of that we can add items with different type of properties and documents. In advanced, the New Menu displays those Content type available in List as its sub-menu.

Fig1 Content Types Visible in New Menu

So how the SharePoint displays those Content types under New menu and how we can enable and disable those content types under that new Menu.

So here is the simple snippet to list out the content types enabled in New Menu.

SPList list = web.Lists["ListName"];

IList ctoFolder = list.RootFolder.UniqueContentTypeOrder;

foreach (SPContentType ctype in ctoFolder)
{
Console.WriteLine(ctype.Name);
}

UniqueContentTypeOrder of SPFolder member lists out the Content Types visible on New Menu. Now we’ll see the code for removing the ContentType on New menu.

SPList list = web.Lists["ListName"];

IList ctoFolder = list.RootFolder.UniqueContentTypeOrder;

//Code for removing the Content Type sub-menu in New Menu.

//Removing the "Test Content Type" menu under New Menu

for (int i = ctoFolder.Count – 1; i >= 0; i–)
{
    if (ctoFolder[i].Name == "Test Content Type")
    {
        ctoFolder.Remove(ctoFolder[i]);
    }
}

list.RootFolder.UniqueContentTypeOrder = ctoFolder;
list.RootFolder.Update();

//Code for adding the Content type sub-menu under New Menu

//Adding the "Test Content type" menu under New Menu

SPContentType ctype = list.ContentTypes["Test Content Type"];
ctoFolder.Add(ctype);
list.RootFolder.Update();

The above helps us to enable and disable the Content type on New Button in SharePoint List.

The SSP Timer Job Distribution List Import Job was not run.Event Id 6641

Fri, 22 Jan 2010 05:59:55 GMT

if the user profiles is not updated after you changed users property on the SSP and you get the following error

then follow the following solutions steps

1. One of Microsoft’s best practices is to make sure that the application pool account for your SSP and your service account for the SSP are the same account.

2. Make sure to add this account to the backup operator’s local group on all your MOSS servers.

3. If you are using Kerberos authentication for your web applications make sure you set your service name principle account for you ssp on you MOSS application server. In order to complete this operation you must install Window support tools from your Windows server installation files under support>>tools>>supporttools.msi. Once you have installed the support tools go to start>>All programs>> Windows support tools>> command prompt.
setspn.exe –A HTTP/name_of_ssp_address domain\appication
Assume your site address is ssp, your domain is sharePoint, and your application pool account is svc_ssp. Run these commands
setspn.exe –A HTTP/ssp SharePoint\svc_ssp (Run this Command)
setspn.exe –A HTTP/ssp.sharepoint.com SharePoint\svc_ssp (Run this command)
If you are using Kerberos authentication on any of your web applications you must run these commands for the web applications to function properly including your central administration site.

4. Check your system event logs on your MOSS server for any DCOM errors. You will notice your DCOM errors are associated with your application pool accounts. Add these acounts to the IIS WAMREG admin service. Make sure the accounts have local launch, remote launch, local activation, and remote activation.

5. Next stop your Office SharePoint Server Search through central administation>> operations>> Services on Server.

6. Then go to central administration>> operations>> service accounts. Click on web application pool. Then under web service choose Windows SharePoint Service Web application. Next under application pool, choose your Shared Service Provider application pool account. Under configurable you will notice that it populated your application pool account. Now re-enter your password and click ok.

7. Login into all your MOSS servers and run iisreset /noforce.

8. Go back to central administation>> operations>> Services on Server and restart your Office Server Search.

9. Then go to central administation>>Application Management>> Manage this Farm's Shared Services. click the drop down on the default SSP and click edit properties. In the SSP service credentials enter username and password. In the index server catagory select your index server and then click ok. Make sure you wait about 5 minutes.

i hope this should work.

User Profile synchronization is not working in SharePoint server 2007, Event id 5555

Thu, 21 Jan 2010 09:58:46 GMT

If the user profile is not synchronizing after you changed the property of the user property on SSP and if you found the following error message in your event log

then follow the following solution steps.

Solution Steps:

open the command prompt and run the following command.

stsadm -o sync -DeleteOldDatabases 0

then it removing the old data.

Now it should work properly.

Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content. Event Id:2436

Wed, 20 Jan 2010 11:42:08 GMT

Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content. Event Id:2436

Microsoft Sharepoint

Installing Office 2010 Web Apps on SharePoint server 2010

AAPT India Website Developed in SharePoint is live now

Improve performance of SharePoint internet sites

tiCorridors.com portal developed in SharePoint went live

Getting rid of “The server returned a non-specific error” in SharePoint Designer

Use of Colligo Reader For SharePoint and Installation

Could Not Connect to MICROSOFT##SSEE (SharePoint Windows Internal Database)

SharePoint Warm up Scripts for WSS/MOSS using power shell

Sharepoint Outlook Sidebar from Harmony

Best Practice Analyzer for Windows SharePoint service 3.0 and MOSS 2007

Manage Content Types on New Button

The SSP Timer Job Distribution List Import Job was not run.Event Id 6641

User Profile synchronization is not working in SharePoint server 2007, Event id 5555

Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content. Event Id:2436

Scrolling to Today’s date in Sharepoint Gantt Chart

Configure Twitter Search with Sharepoint and Search Server

Move sharepoint site from one domain to another domain

Creating a Sharepoint sub site from custom template through code

Removing Link from People Name in Sharepoint List

Highlighting Overrun Tasks In Sharepoint Gantt Chart

Adding document icons in Sharepoint dataview

No Item Exists error because of Querystring parameter name

Twitter Trends Sharepoint Webpart

Silverlight Loader Sharepoint webpart

New Sharepoint Features are not available in Visual Studio 2010 Beta1

Increase Print Font Size of Sharepoint Pages

Posting to SharePoint Blogs with Live Writer

Speeding up Sharepoint pages loading by removing core.css

Blocking Anonymous Users from Sharepoint List Pages

Grouping a Sharepoint list by Month Name & Year

Embedding Popfly Block within Sharepoint Page

Printer Friendly Page Sharepoint web part

Sharepoint Social Bookmarking Web part

SharePoint Copy WebService - Part 1

SPitter – A Twitter for Sharepoint

Missing "Edit in DataSheet" option in SharePoint Lists

How to Close browser window on server side using SharePoint

Cannot connect to Windows Sharepoint Services (WSS) Internal Database Microsoft##SSEE

Visual Studio 2008 Sharepoint Deployment Issue

Hide Sign-In link on the SPSites except admin page

Debugging Sharepoint Webpart from VS 2008

How we can Create Search Provider in Internet Explorer 8 Beta

How we can Create WebSlices in Internet Explorer 8 Beta

How we can Create Accelerator in Internet Explorer 8 Beta

Solving ActiveX Problem in Sharepoint

Alert Notification Tips

Custom Master Page Error

Live Cricket scores in Sharepoint site

Add Flash file to SharePoint Rich Text Field Editor

Sending Email using SPUtility Class

Custom Document Property as Page Title

SharePoint Designer Form Action Button

Redirecting to a custom URL from Sharepoint custom forms