Kopperla's SharePoint Blog

MOSS 2007 – WSS 3.0 Version / Build Numbers

2011-08-03T13:34:00.001-07:00

12.0.0.6529 : MOSS 2007 – WSS 3.0 Feb 2010 Cumulative update
12.0.0.6524 : MOSS 2007 – WSS 3.0 Dec 2009 Cumulative update
12.0.0.6520 : MOSS 2007 – WSS 3.0 Oct 2009 Cumulative update
12.0.0.6414 : MOSS 2007 – WSS 3.0 Aug 2009 Cumulative update
12.0.0.6510 : MOSS 2007 – WSS 3.0 June 2009 Cumulative update
12.0.0.6504 : MOSS 2007 – WSS 3.0 April 2009 Cumulative update
12.0.0.6421 : MOSS 2007 – WSS 3.0 Service Pack 2
12.0.0.6341 : MOSS 2007 – WSS 3.0 Feb 2009 Cumulative update
12.0.0.6327 : MOSS 2007 – WSS 3.0 Aug 2008 Cumulative update
12.0.0.6318 : MOSS 2007 – WSS 3.0 Infrastructure Update
12.0.0.6303 : MOSS 2007 – WSS 3.0 post-SP1 hotfix
12.0.0.6301 : MOSS 2007 – WSS 3.0 post-SP1 hotfix
12.0.0.6300 : MOSS 2007 – WSS 3.0 post-SP1 hotfix
12.0.0.6219 : MOSS 2007 – WSS 3.0 SP1
12.0.0.6039 : MOSS 2007 – WSS 3.0 October public update
12.0.0.6036 : MOSS 2007 – WSS 3.0 August 24, 2007 hotfix package
12.0.0.4518 : MOSS 2007 – WSS 3.0 RTM
12.0.0.4407 : MOSS 2007 – WSS 3.0 Beta 2 TR
12.0.0.4017 : MOSS 2007 – WSS 3.0 Beta 2

Sharepoint Excellent Blogs

2011-06-14T11:59:00.000-07:00

SharePoint Profile Cleanup

http://blogs.technet.com/b/seanearp/archive/2009/03/04/sharepoint-profile-cleanup.aspx
http://blogs.msdn.com/b/gyorgyh/archive/2009/11/13/how-it-works-moss-2007-automatic-user-profile-removal.aspx

SharePoint List Xml Schema

http://blogs.msdn.com/b/kaevans/archive/2009/05/01/getting-xml-data-from-a-sharepoint-list-the-easy-way.aspx

Get SPUser object from SharePoint List Item People/Group picker field

2011-06-06T12:53:00.000-07:00

The code below is to get SPUser from a multiple user item column

            string strURL = "http://YourSite/";
            using (SPSite oSPSite = new SPSite(strURL))
            {
                using (SPWeb oSPWeb = oSPSite.OpenWeb())
                {

                    SPList list = oSPWeb.GetList(strURL);
                    SPListItemCollection items = list.Items;
                    foreach (SPListItem oListItem in items)
                    {
                        if (oListItem["Title"].ToString() == "Test")
                        {
                            String usersString = oListItem["Audience Group"].ToString();
                            SPFieldUserValueCollection userValueColl = new SPFieldUserValueCollection(oSPWeb, usersString);

                            foreach (SPFieldUserValue userValue in userValueColl)
                            {
                                SPUser siteUser = userValue.User;
                                Console.WriteLine("User found: {0}", siteUser.Name);
                            }
                            break;
                        }
                    }
                }

Attaching an event handler to a specific SharePoint List

2011-04-07T06:32:00.000-07:00

When we attach an event handler through Features in SharePoint using “ListTypeId”, it attaches event handlers to all the lists of that particular type. This will result in a large performance hit. To execute the written code for a particular list we will have to check either with ListId or ContentTypeId.
So, here is a way of attaching an event handler to a specific list on “FeatureActivated” and to remove the event handler from the list on “FeatureDeactivating”. This is the best method I can find as of now for attaching and removing the event handler to a specific SharePoint List.

const string assembly = "ListItemPermissions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9f4da00116c38ec5";
const string listReceiverName = "ListItemPermissions.ListItemPermissionsItemEventReceiver";
public override void FeatureActivated(SPFeatureReceiverProperties properties)
{
try
{
// get a reference to the current SPWeb
SPWeb _SPWeb = SPContext.Current.Web;
_SPWeb.AllowUnsafeUpdates = true;
// get a reference to the "Projects" list
SPList _projectsList = (SPList)_SPWeb.Lists["Projects"];

// if the "projectsList" list exists
if (_projectsList != null)
{
// create an empty Guid
Guid _ItemUpdatedGuid = Guid.Empty;
Guid _ItemAddedGuid = Guid.Empty;

// enumerate thru all of the event receiver definitions, attempting to
// locate the one we are adding
foreach (SPEventReceiverDefinition _SPEventReceiverDefinition in _projectsList.EventReceivers)
{
// if we find the event receiver we are about to add
// record its Guid
if (_SPEventReceiverDefinition.Type == SPEventReceiverType.ItemUpdated &&
_SPEventReceiverDefinition.Assembly == assembly &&
_SPEventReceiverDefinition.Class == listReceiverName)
{
_ItemUpdatedGuid = _SPEventReceiverDefinition.Id;
}

if (_SPEventReceiverDefinition.Type == SPEventReceiverType.ItemAdded &&
_SPEventReceiverDefinition.Assembly == assembly &&
_SPEventReceiverDefinition.Class == listReceiverName)
{
_ItemAddedGuid = _SPEventReceiverDefinition.Id;
}
}

// if we did not find the event receiver we are adding, add it
if (_ItemUpdatedGuid == Guid.Empty)
{
_projectsList.EventReceivers.Add(SPEventReceiverType.ItemUpdated, assembly, listReceiverName);
}
if (_ItemAddedGuid == Guid.Empty)
{
_projectsList.EventReceivers.Add(SPEventReceiverType.ItemAdded, assembly, listReceiverName);
}

_projectsList.Update();
_SPWeb.Update();
_SPWeb.AllowUnsafeUpdates = false;
}
}

catch (System.Exception ex)
{
PortalLog.LogString(ex.StackTrace);
throw new SPException(ex.Message);
}
}

public override void FeatureDeactivating(SPFeatureReceiverProperties properties)
{
try
{
SPWeb _SPWeb = SPContext.Current.Web;
_SPWeb.AllowUnsafeUpdates = true;
// get a reference to the "Projects" list
SPList _projectsList = (SPList)_SPWeb.Lists["Projects"];
while(_projectsList.EventReceivers.Count > 0)
{
if (_projectsList.EventReceivers[_projectsList.EventReceivers.Count-1].Assembly.Equals(assembly))
{
_projectsList.EventReceivers[_projectsList.EventReceivers.Count-1].Delete();
}
} // looping thru event receivers.

_projectsList.Update();
_SPWeb.Update();
_SPWeb.AllowUnsafeUpdates = false;
}
catch (System.Exception ex)
{
PortalLog.LogString(ex.StackTrace);
throw new SPException(ex.Message);
}
}

Moss 2007 - Excel Services no file permissions message

2011-03-04T06:37:00.000-08:00

If you receive the following Exception when you try to open the sample workbook or another workbook try the following steps:

You do not have permissions to open this file on Excel Services.Make sure that the file is in an Excel Services trusted location and that you have access to the file.

1.Open Central Administration -> go to Operations tab -Ensure that the Excel Service is running.
2.Open Central Administration -> go to your configured Shared Service -> click Excel Service Settings.

-File Access Method: ensure that it is not using Impersonation, instead the Option Process Account should be enabled.

3. Open Central Administration -> go to your configured Shared Service -> click add new trusted file location
-Field URL: here you can specify a report library or the whole portal
-Location Type: should be Windows SharePoint Services
-Children trusted: defines whether the children should also be trusted or only the definied path

IIS7 - Tell me plase why my debugger timed out - Coz u r slow -"The web server process that was being debugged has been terminated by IIS"

2011-01-25T10:13:00.000-08:00

When you are debugging, IIS will not service any other requests until you are done stepping through your code. That includes the "ping" request that IIS sends to itself. Since IIS doesn't hear back from itself, it decides to shut itself down, which promptly terminates your debugging.
The solution is to increase the Ping Maximum Response Time in the application pool settings from its default value of 90 seconds. Set it to something high enough that will give you enough time to debug your code (like maybe 900 seconds). If you are not able to debug in 15 min, one should really look for a job which does include hardcore coding.

SPWeb GetList Exception from HRESULT: 0x80070003 System.IO.DirectoryNotFoundException

2011-01-11T09:19:00.000-08:00

If you see something like this while calling while calling SPWeb.GetList("BlahBlahBlah"), do not get alarmed.
All you need to provide is a site-relative URL like the following
"/sites/myWeb/Lists/myCoolList".
If you are in the top-lelel site collection and wondering what the heck , then it should be like "/Lists/myCoolList"

"Unhandled Exception: System.IO.DirectoryNotFoundException: The system cannot find the path specified. (Exception from HRESULT: 0x80070003)"

Deleting Document Library Items for large list size Failed?

2011-01-11T08:40:00.000-08:00

For novice to use this code, specify the strings variables siteURL, listName.
The maximum items that your program can delete is 25000 which can be changed.

Hey friends, If you have saved lot of time using my code, please pay me by smiling at all the people you see today. They will smile back at you. We will all be in a pool of happy smiles. If you have a big wallet, feed a hungry stomach today. And God will bless you.

using (SPSite site = new SPSite(siteURL))
{
using (SPWeb web = site.OpenWeb())
                {
                    web.AllowUnsafeUpdates = true;
                    StringBuilder sbDelete = new StringBuilder();
                    SPList spList = web.GetList("/" + listName);
                    sbDelete.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?><Batch>");
                    string command = "<Method><SetList Scope=\"Request\">" + spList.ID +
                        "</SetList><SetVar Name=\"ID\">{0}</SetVar><SetVar Name=\"Cmd\">Delete</SetVar><SetVar Name=\"owsfileref\">{1}</SetVar></Method>";
                    int limit = 0;
                    foreach (SPListItem item in spList.Items)
                    {
                        limit++;
                        if (limit > 25000)
                            break;
                        sbDelete.Append(string.Format(command, item.ID.ToString(), item.File.Url));
                    }
                    sbDelete.Append("</Batch>");

                    web.ProcessBatchData(sbDelete.ToString());
                    web.Update();
                    web.AllowUnsafeUpdates = false;
                }
}

Deleting ListItems for large list size Failed?

2011-01-11T07:34:00.000-08:00

The following code only works for List. Refer my other post for Document Library.
For novice to use this code, specify the strings variables siteURL, listName.

The maximum items that your program can delete is 5000 which can be changed.

The way web.Lists[listName] works is that it loads the meta-data information of the all lists for that specific SPWeb object and then it does SPList.Title comparison with metadata of all the lists returned and returns the first matching list from the SPWeb.Lists collection. This has got two implications:
1. The loading of list is slow as the meta-data information of all the list is loaded and then comparison happens on list name specified.
2. If there are large numbers of lists in a specific SPWeb, the process of getting the meta-data information of all the available lists may introduce transaction lock in backend database when multiple such calls happen in quick succession.

The suggested way to access a list is by using SPWeb.GetList(string url). In this case, first the GUID of list is figured out and then meta-data for the list is loaded. Obviously, this is a faster way also.
If your head is already spinning, the summary is that
"And you must use web.GetList(listName) instead of web.Lists[listName]. Otherwise it may take for ever."

Hey friends, If you have saved lot of time using my code, please pay me by smiling at all the people you see today. They will smile back at you. We will all be in a pool of happy smiles. If you have a big wallet, find & feed a hungry stomach today(not mine). And God will bless you.

using (SPSite site = new SPSite(siteURL))
{

using (SPWeb web = site.OpenWeb())
                {
                    web.AllowUnsafeUpdates = true;
                    StringBuilder sbDelete = new StringBuilder();

                   SPList spList = web.GetList("/Lists/" + listName);

                    sbDelete.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?><Batch>");
                    string command = "<Method><SetList Scope=\"Request\">" + spList.ID +
                        "</SetList><SetVar Name=\"ID\">{0}</SetVar><SetVar Name=\"Cmd\">Delete</SetVar></Method>";
                    int limit = 0;
                    foreach (SPListItem item in spList.Items)
                    {
                        limit++;
                        if (limit > 5000)
                            break;
                        sbDelete.Append(string.Format(command, item.ID.ToString()));
                    }
                    sbDelete.Append("</Batch>");

                    web.ProcessBatchData(sbDelete.ToString());
                    web.Update();
                    web.AllowUnsafeUpdates = false;
                }
}

SharaPoint CAML OrderBy DefaultView Limit

2010-12-29T15:37:00.000-08:00

The Default List view has direct effect on the number of records that return for the CAML query with OrderBy.

Changed the List's Default View limit to 5 and U see only 5items. Wierd One.

Hope this post will save a lot of time for people researching what the heck happened

Truncate and shrink Transaction Log file in SQL Server 2008

2010-11-18T10:01:00.000-08:00

SQL Server 2008

In SQL Server this process have been changed. In 20008, just change the recovery model to simple and then use DBCC Shrinkfile command.

use [YourDatabaseName]
select name,recovery_model_desc from sys.databases
GO
Alter database [YourDatabaseName] Set Recovery SIMPLE
GO
Declare @LogFileLogicalName sysname
select @LogFileLogicalName=Name from sys.database_files where Type=1
print @LogFileLogicalName

DBCC Shrinkfile(@LogFileLogicalName,1)

______________________________

If you may want to set the recovery back to Full. If so, add the following.
Alter database [YourDatabaseName] Set Recovery FULL

XSLT String Padding

2010-05-27T15:16:00.000-07:00

Create the Template

<xsl:template name="leftjustify">
    <xsl:param name="content"/>
    <xsl:param name="width"/>

    <xsl:choose>
      <xsl:when test="string-length($content) > $width">
        <xsl:value-of select="substring($content,1,$width)"/>
      </xsl:when>

      <xsl:otherwise>
        <xsl:value-of select="$content"/>
        <xsl:call-template name="spaces">
          <xsl:with-param name="length">
            <xsl:value-of select="$width - string-length($content)"/>
          </xsl:with-param>
        </xsl:call-template>
      </xsl:otherwise>

    </xsl:choose>

</xsl:template>

<xsl:template name="spaces">
    <xsl:param name="length"/>
    
    <xsl:variable name="longstringofspaces">
      <xsl:text>                                                                                                                                                                                                                                                               </xsl:text>
    </xsl:variable>
    <xsl:value-of select="substring($longstringofspaces,1,$length)"/>
</xsl:template>

Usage:

<xsl:call-template name="leftjustify">
      <xsl:with-param name="content">You can do this</xsl:with-param>
      <xsl:with-param name="width">40</xsl:with-param>
    </xsl:call-template>

InfoPath 2007 Template Parts

2009-07-07T05:50:00.000-07:00

Finding tough to keep the he sections, tables, fields, data connections and dropdown lists consistent between all forms.

The InfoPath 2007 was released and it has a new feature called Template Parts. Template Parts is a new type of InfoPath template that allows for predefined forms to be saved and then imported into the InfoPath Controls Task Pane. A Template Part is capable of saving Data Connections, Rules, Conditional Formatting, Data Validation and many other things. Just having this capability has saved me a tremendous amount of time when designing forms and it has increased the ROI for the client. A standard address block is one of the first things that I create for a new client because I'm able reuse it right away and show immediate ROI. At first you might not think this would have a big impact but when you take in account that, you no longer have to worry about defining the data source fields, layout table, field widths, colors, font style/size, data connections for states/regions and country, data validation, rules or conditional formatting then the ROI is reached pretty quickly. Once I understood this capability it changed how I started developing forms.

A feature of a Template Part that you need to take in consideration when using them to help designing forms is the Update capability. The Update capability allows for existing Template Part control on a form to be updated once the master Template Part control has changed and re-imported into the designer. At first this capability was frustrating because I didn't design everything with this in mind but after understanding how it worked, I quickly changed how I was designing forms and took advantage of the Update capability.

Long story short, Template Parts are great if you put thought into how you are building and using them. If you don't do this then it will just adds more complexity when building your InfoPath form and shouldn't be used.

Infopath - Edit in Browser + Close = "The form has been closed." Annoyed?

2009-07-02T08:05:00.000-07:00

(12Hive)\TEMPLATE\FEATURES\IPFSSiteFeatures\FormServerEcbEntry\EcbEntry.xml

Refer

http://geek.hubkey.com/2007/01/infopath-forms-services-close-button_17.html

Forcefully Activate "IPFSSiteFeatures" feature scoped to WebApp.

iisreset / recycle the application pool.

It must take you back without the annoying page "The form has been closed."

Update your upgrade document to redo the changes after the upgrade as upgrade may reset this feature.

Sharepoint Site Creation Notification Email

2009-06-29T12:28:00.001-07:00

Steps Involved:

1. Create an event reciever

2. Create a feature to call the reiever when activated.

3. Create a feature stapler to staple the feature to Site Defs.

public override void FeatureActivated(SPFeatureReceiverProperties properties)

{

SPWeb CurrentWeb = properties.Feature.Parent as SPWeb;

String Body = "A Sub Site Created with Title \""+ CurrentWeb.Title+ "\" with the URL "+CurrentWeb.Url;

foreach (SPUser user in CurrentWeb.Groups["AllAlerts"].Users)

{

SPUtility.SendEmail(CurrentWeb, false, false, user.Email, "Site Creation Alert", Body);

}

//Use the sharepoint inbuilt capability of sendin and email fron the SPUtility

Great Sharepoint Links

2009-06-24T13:47:00.001-07:00

Smart work is smart.

Here goes the Links

Authentic Admin *.* http://technet.microsoft.com/en-us/library/cc303422.aspx
Redirect options in Sharepoint http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=48
SharePoint UI http://www.heathersolomon.com/blog/
SharePoint Architecture http://www.andrewconnell.com/blog/category/133.aspx
Impersonation -http://www.sharepointu.com/tanujashares/archive/2007/08/07/impersonation-in-sharepoint-2007.aspx
User Profile Permission create modify delete code -http://stsadm.blogspot.com/2007/11/personalization-service-permissions.html

BDC Series

http://sharepointmagazine.net/technical/administration/everything-you-need-to-know-about-bdc-part-1-of-8

http://sharepointmagazine.net/technical/administration/everything-you-need-to-know-about-bdc-part-2-of-8

http://sharepointmagazine.net/technical/administration/everything-you-need-to-know-about-bdc-part-3-of-8

http://sharepointmagazine.net/technical/administration/everything-you-need-to-know-about-bdc-part-4-of-8

http://sharepointmagazine.net/technical/administration/everything-you-need-to-know-about-bdc-part-5-of-8

http://sharepointmagazine.net/technical/administration/everything-you-need-to-know-about-bdc-part-6-of-8

http://sharepointmagazine.net/technical/administration/everything-you-need-to-know-about-bdc-part-7-of-8

List Template Id

2009-06-09T09:26:00.000-07:00

ListId - Description

100 Generic list

101 Document library

102 Survey

103 Links list

104 Announcements list

105 Contacts list

106 Events list

107 Tasks list

108 Discussion board

109 Picture library

110 Data Sources list

111 Site Template Gallery

113 Web Part Gallery

114 List Template Gallery

115 XML Form Library (InfoPath)

120 Custom grid for list

200 Meeting Series list

201 Meeting Agenda list

204 Meeting Decisions list

207 Meeting Objectives list

210 Meeting text box

211 “Things to Bring” Meeting list

212 Meeting Workspace Pages list

300 Portal Sites list

1100 Issue Tracking list

2002 Personal document library

2003 Private document library

Sharepoint Banner

2009-06-05T07:20:00.000-07:00

Create you banner.jpg and
Copy to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\IMAGES
Make modification in the core.css as shown below.("C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033\STYLES\CORE.CSS")

Before Modification:

.ms-globalbreadcrumb{

font-size:8pt;

text-align:right;

background-color:#ebf3ff;

padding:2px 10px 2px 5px;

}

After Modification:

.ms-globalbreadcrumb{

font-size:8pt;

text-align:right;

background-color:#ebf3ff;

background-image:url("/_layouts/images/banner.jpg");

padding:2px 10px 79px 5px;

}

Override BDC default Action

2009-06-02T08:07:00.000-07:00

Create a new Property element in the Properties element of the Entity. Give it an attribute of DefaultAction and specify the name of the Action we defined earlier.

Default

Specify your custom Actoin with Name="Default".

eg.

Action Position="1" IsOpenedInNewWindow="false" Url="{0}" ImageUrl="" Name="Default"

When you import the application definition, you will receive a warning like the following.

"Could not create profile page for Entity MyEntity. The error is: Default action exists for application ‘MyInstance’, entity ‘MyEntity’. Profile page creation skipped.

This really isn’t an error. It is just telling you that since you specified a default action, it did not automatically generate a profile page for the entity.

Identify WFE Vs Complete option used

2009-06-02T06:38:00.000-07:00

Refer http://technet.microsoft.com/en-us/library/cc262901.aspx

“You must use the Complete installation option on all computers you want to be index servers, query servers, or servers that run Excel Calculation Services.”

To identify which Sharepoint Server is installed using complete option, just check the Excel Calculation Services Tab is available in the Services on the Server.

To Change a server with WFE to Complete, follow the following steps

1. Remove Server from the Farm

2. Uninstall Moss

3. Install Moss with complete Option. Install the updates(e.g., SP2)

4. Add to the Existing Farm.

That is it.

Get SSP URL

2009-05-29T11:01:00.000-07:00

Use the following Chunk 2 get the SSP URL. This uses reflection mechanism.

private string getSSPURL()

{

string uri = string.Empty;

ServerContext sc = ServerContext.Default;

object ssp = sc.GetType().GetProperty("SharedResourceProvider",BindingFlags.Instance | BindingFlags.NonPublic).GetValue(sc, null);

Guid sspGuid = (Guid)ssp.GetType().GetProperty("AdministrationSiteId").GetValue(ssp, null);

using (SPSite sspSite = new SPSite(sspGuid))

{

uri = sspSite.WebApplication.GetResponseUri(SPUrlZone.Default).AbsoluteUri + "ssp/admin";

}

return uri;

}

Kerberos - Pros & Cons

2009-05-20T12:06:00.000-07:00

Pros:

Faster performance is experienced when using Kerberos as it caches information about the client after authentication. This means that it can perform better than NTLM particularly in large farm environments
Delegation - Kerberos can delegate the client credentials from the SharePoint front-end web server to other back-end servers like Oracle. So you are eliminating double hops. (Login Challenges)
You can also with MOSS 2007 utilize RSS feeds "Within your SharePoint Environment"
Microsoft recommends to "Use Kerberos authentication for sites with a high security service level agreement."
Federated Search between Farms (e.g., will work based as the user credentials are passed automatically.)
Planning on utilizing BDC some LOB Applications will require Kerberos authentication.
SQL Serer Reporting Services integration works well with Kerberos.
Switch back to NTLM is possible.

Cons:

In Active Directory, SPN should be configured carefully .If not troubleshooting is difficult

http://ablog.apress.com/?p=1127

http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/de88fb8c-0101-4413-9855-34501569e077

http://blogs.msdn.com/martinkearn/archive/2007/04/23/configuring-kerberos-for-sharepoint-2007-part-1-base-configuration-for-sharepoint.aspx

Compiling audience object model.

2009-05-15T11:07:00.000-07:00

Refer the community content by me at

http://msdn.microsoft.com/en-us/library/microsoft.office.server.audience.audiencemanager.aspx

MSDN Note "Compiling audiences is not supported in the object model."

Actually we can compile the audience.
Following code to compile all the audiences.
Add Reference Microsoft Search Component(Microsoft.Office.Server.Search.dll)
using Microsoft.Office.Server.Search.Administration;

using (SPSite site = new SPSite(txtSite.Text))
{
ServerContext context = ServerContext.GetContext(site);
SearchContext searchContext = SearchContext.GetContext(context);
string[] args = new string[3];
args[0] = searchContext.Name;
args[1] = "1"; //"1" = start job, "0" = stop job
args[2] = "1"; //"1" = full compilation, "0" = incremental compilation (optional, default = 0)
AudienceJob.RunAudienceJob(args);
System.Threading.Thread.Sleep(3000);
}

To Compile a specific audience, add the optional arg[3] after making the String array size to 4 and specify the Audience Name.

2009-05-12T06:30:00.000-07:00

The lifecycle events of a Sharepoint Connectable WebPart wih a single ViewState backed property;

On Page Load

Constructor
OnInit
OnLoad
ConnectionConsumer method is called if web part is connectable (sets the connection providers interface in the webpart)
CreateChildControls
OnPreRender (if your web part is connectable you would typically call the connection provider here to retrieve data)
SaveViewState
Render
RenderChildren
RenderContents

On 1st Postback

(PostBack click handler sets ViewState via public Property)

Constructor
OnInit
CreateChildControls
OnLoad
PostBack click handling
ConnectionConsumer method is called if web part is connectable (sets the connection providers interface in the webpart)
OnPreRender (if your web part is connectable you would typically call the connection provider here to retrieve data)
SaveViewState
Render
RenderChildren
RenderContents

On 2nd Postback

(PostBack click handler sets ViewState via public Property)

Constructor
OnInit
LoadViewState
CreateChildControls
OnLoad
PostBack click handling
ConnectionConsumer method is called if web part is connectable (sets the connection providers interface in the webpart)
OnPreRender (if your web part is connectable you would typically call the connection provider here to retrieve data)
SaveViewState
Render
RenderChildren
RenderContents

Note that during the 2nd postback, LoadViewState, is called, since in the 1st postback the click handler sets the value of the ViewState backed public property.

Moss SDK 1.5 Released

2009-05-11T08:05:00.000-07:00

http://www.microsoft.com/downloads/details.aspx?familyid=6D94E307-67D9-41AC-B2D6-0074D6286FA9&displaylang=en

SharePoint Developer download Links

2009-05-08T07:52:00.000-07:00

Download the following and can start developing

Microsoft Virtual PC 2007 SP1 http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=28c97d22-6eb8-4a09-a7f7-f6c7a1f000b5
Microsoft Office SharePoint Server 2007 VHD http://www.microsoft.com/downloads/details.aspx?FamilyID=67f93dcb-ada8-4db5-a47b-df17e14b2c74&DisplayLang=en

MOSS SP2 Available

2009-05-08T06:30:00.000-07:00

SP2 = SP1 + InfraUpdate + Feb 2009 CumulativeUpdate.

DB StatisticsTimer Job rebuilds content db indexes everytime to stop fragmentation and maintain performance.
Automatic setting of read-only and updates the user interace so that users cannot perform tasks that write to db.
Browser now supports IE 8, Firefox 2 and Firefox 3.

Windows SharePoint Services 3.0 Service Pack 2 (SP2) – English

http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B&displaylang=en

The 2007 Microsoft Office Servers Service Pack 2 (SP2)

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b7816d90-5fc6-4347-89b0-a80deb27a082

List of sp2 are its details link

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

SharePoint WSS Extensions 64-bit and 32-bit Visual Studio 2008

2009-05-06T10:30:00.000-07:00

Download Visual Studio 2008 extensions for Windows SharePoint Services 3.0, v1.3 - Mar 2009 CTP
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fb9d4b85-da2a-432e-91fb-d505199c49f6
To Successfully Deploy Solutions follow these steps
From Cmd, go to
C:\Inetpub\Adminscripts>
and run the following.
cscript adsutil.vbs set w3svc/1/root/NTAuthenticationProviders "Negotiate,NTLM"

The last step is explained in detail the following link

(NTLM must be enabled on the IIS server. See the following for instructions on how to enable it: http://support.microsoft.com/kb/215383)

Microsoft Sharepoint Language Codes

2009-05-06T06:03:00.000-07:00

I have compiled from the following link

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=05046b1d-dd7b-456a-8838-8d978c5f3579

Please confirm before use. I used some of these and it was fine.

Arabic ar-sa

Bulgarian bg-bg

Catalan ca-es

Chinese - Simplified zh-cn

Chinese - Traditional zh-tw

Croatian hr-hr

Czech cs-cz

Danish da-dk

Dutch nl-nl

English en-us

Estonian et-ee

Finnish fi-fi

French fr-fr

German de-de

Greek el-gr

Hebrew he-il

Hindi hi-in

Hungarian hu-hu

Italian it-it

Japanese ja-jp

Korean ko-kr

Latvian lv-lv

Lithuanian lt-lt

Norwegian nb-no

Polish pl-pl

Portuguese - Brazil pt-br

Portuguese - Portugal pt-pt

Romanian ro-ro

Russian ru-ru

Serbian - Latin sr-latn-cs

Slovak sk-sk

Slovenian sl-si

Spanish es-es

Swedish sv-se

Thai th-th

Turkish tr-tr

Ukrainian uk-ua

SharePoint Facts, Top 10 Benefits of Moss

2009-04-23T19:57:00.000-07:00

SharePoint is the fastest-growing product in the history of Microsoft
• Over 75 million licenses of SharePoint have been sold worldwide
• SharePoint is listed, by Forrester, as the number 1 portal product
• SharePoint is positioned as a leader within the Gartner Magic Quadrant for Horizontal Portals products
• Over 400 case studies have been published on SharePoint

Microsoft Office SharePoint Server 2007 Top 10 Benefits

Provide a simple, familiar, and consistent user experience.

Office SharePoint Server 2007 is tightly integrated with familiar client desktop applications, e-mail, and Web browsers to provide a consistent user experience that simplifies how people interact with content, processes, and business data. This tight integration, coupled with robust out-of-the-box functionality, helps you employ services themselves and facilitates product adoption.

Boost employee productivity by simplifying everyday business activities.

Take advantage of out-of-the-box workflows for initiating, tracking, and reporting common business activities such as document review and approval, issue tracking, and signature collection. You can complete these activities without any coding. Tight integration with familiar client applications, e-mail, and Web browsers provide you with a simple, consistent experience. Modifying and extending these out-of-the-box workflow processes is made easy through tools like Microsoft Office SharePoint Designer 2007 (the next release of Microsoft Office FrontPage).

Help meet regulatory requirements through comprehensive control over content.

By specifying security settings, storage policies, auditing policies, and expiration actions for business records in accordance with compliance regulations, you can help ensure your sensitive business information can be controlled and managed effectively. And you can reduce litigation risk for your organization. Tight integration of Office SharePoint Server 2007 with familiar desktop applications means that policy settings are rendered onto client applications in the Microsoft Office system, making it simpler for employees to be aware of and comply with regulatory requirements.

Effectively manage and repurpose content to gain increased business value.

Business users and content authors can create and submit content for approval and scheduled deployment to intranet or Internet sites. Managing multilingual content is simplified through new document library templates that are specifically designed to maintain a relationship between the original version and different translations of a document.

Simplify organization-wide access to both structured and unstructured information across disparate systems.

Give your users access to business data found in common line-of-business systems like SAP and Siebel through Office SharePoint Server 2007. Users can also create personalized views and interactions with business systems through a browser by dragging configurable back-end connections. Enterprise-wide Managed Document Repositories help your organizations store and organize business documents in one central location.

Connect people with information and expertise.

Enterprise Search in Office SharePoint Server 2007 incorporates business data along with information about documents, people, and Web pages to produce comprehensive, relevant results. Features like duplicate collapsing, spelling correction, and alerts improve the relevance of the results, so you can easily find what you need.

Accelerate shared business processes across organizational boundaries.

Without coding any custom applications, you can use smart, electronic forms–driven solutions to collect critical business information from customers, partners, and suppliers through a Web browser. Built-in data validation rules help you gather accurate and consistent data that can be directly integrated into back-end systems to avoid redundancy and errors that result from manual data re-entry.

Share business data without divulging sensitive information.

Give your employees access to real-time, interactive Microsoft Office Excel spreadsheets from a Web browser through Excel Services running on Office SharePoint Server 2007. Use these spreadsheets to maintain and efficiently share one central and up-to-date version while helping to protect any proprietary information embedded in the documents (such as financial models).

Enable people to make better-informed decisions by presenting business-critical information in one central location.

Office SharePoint Server 2007 makes it easy to create live, interactive business intelligence (BI) portals that assemble and display business-critical information from disparate sources, using integrated BI capabilities such as dashboards, Web Parts, scorecards, key performance indicators (KPIs), and business data connectivity technologies. Centralized Report Center sites give users a single place for locating the latest reports, spreadsheets, or KPIs.

Provide a single, integrated platform to manage intranet, extranet, and Internet applications across the enterprise.

Office SharePoint Server 2007 is built on an open, scalable architecture, with support for Web services and interoperability standards including XML and Simple Object Access Protocol (SOAP). The server has rich, open application programming interfaces (APIs) and event handlers for lists and documents. These features provide integration with existing systems and the flexibility to incorporate new non-Microsoft IT investments.

Top 10 Benefits of Windows SharePoint Services

Improve team productivity with easy-to-use collaborative tools

Connect people with the information and resources they need. Users can create team workspaces, coordinate calendars, organize documents, and receive important notifications and updates through communication features including announcements and alerts, as well as the new templates for creating blogs and wikis. While mobile, users can take advantage of convenient offline synchronization capabilities.

Easily manage documents and help ensure integrity of content

With enhanced document management capabilities including the option to activate required document checkout before editing, the ability to view revisions to documents and restore to previous versions, and the control to set document- and item-level security, Windows SharePoint Services can help ensure the integrity of documents stored on team sites.

Get users up to speed quickly

User interface improvements in Windows SharePoint Services 3.0 include enhanced views and menus that simplify navigation within and among SharePoint sites. Integration with familiar productivity tools, including programs in the Microsoft Office system, makes it easy for users to get up to speed quickly. For example, users can create workspaces, post and edit documents, and view and update calendars on SharePoint sites, all while working within Microsoft Office system files and programs.

Deploy solutions tailored to your business processes

While standard workspaces in Windows SharePoint Services are easy to implement, organizations seeking a more customized deployment can get started quickly with application templates for addressing specific business processes or sets of tasks.

Build a collaboration environment quickly and easily

Easy to manage and easy to scale, Windows SharePoint Services enables IT departments to deploy a collaborative environment with minimal administrative time and effort, from simple, single-server configurations to more robust enterprise configurations. Because deployment settings can be flexibly changed, less pre-planning time is required and companies can get started even faster.

Reduce the complexity of securing business information

Windows SharePoint Services provides IT with advanced administrative controls for increasing the security of information resources, while decreasing cost and complexity associated with site provisioning, site management, and support. Take advantage of better controls for site life-cycle management, site memberships and permissions, and storage limits.

Provide sophisticated controls for securing company resources

IT departments can now set permissions as deep down as the document or item level, and site managers, teams, and other work groups can initiate self-service collaborative workspaces and tasks within these preset parameters. New features enable IT to set top-down policies for better content recovery and users, groups, and team workspace site administration.

Take file sharing to a new level with robust storage capabilities

Windows SharePoint Services supplies workspaces with document storage and retrieval features, including check-in/check-out functionality, version history, custom metadata, and customizable views. New features in Windows SharePoint Services include enhanced recycle bin functionality for easier recovery of content and improved backup and restoration.

Easily scale your collaboration solution to meet business needs

Quickly and easily manage and configure Windows SharePoint Services using a Web browser or command-line utilities. Manage server farms, servers, and sites using the Microsoft .NET Framework, which enables a variety of custom and third-party administration solution offerings.

Provide a cost-effective foundation for building Web-based applications

Windows SharePoint Services exposes a common framework for document management and collaboration from which flexible and scalable Web applications and Internet sites, specific to the needs of the organization, can be built. Integration with Microsoft Office SharePoint Server 2007 expands these capabilities further to offer enterprise-wide functionality for records management, search, workflows, portals, personalized sites, and more.

SharePoint Audience User Existance Check sample

2009-04-23T10:46:00.000-07:00

if HR is the audience.

GetAudience("HR") give access denied error.

Use the following

using (SPSite site = new SPSite(SPContext.GetContext(Context).Site.ID))

{

ServerContext context = ServerContext.GetContext(site);

AudienceManager audManager = new AudienceManager(context);

SPUser user = SPControl.GetContextWeb(Context).CurrentUser;

foreach(Microsoft.Office.Server.Audience.Audience objAudience in audManager.Audiences)

{

if (objAudience != null && objAudience.AudienceName == "HR")

{

if (objAudience.IsMember(user.LoginName))

{

//Your code goes here

}

Great Sharepoint Links

2009-04-20T10:49:00.000-07:00

Changing the Language of Sites

2009-04-17T13:13:00.000-07:00

Pre-Req: Specific Language Pack Installed. ( Korean )

SW_CD_Office_Srvr_Language_Pack_2007_64Bit_Korean_1_1_PA_BP_SvrISO_Onl_X12-34584.EXE

For changing the language of all sites in the content database to Korean the query would be:

UPDATE dbo.Webs SET Language = 1042

Changing the language of one site collection can be done with:

UPDATE dbo.Webs SET Language = 1042 WHERE SiteId = [[SiteCollectionId]]

And for changing the language of a single web or subsite you can use:

UPDATE dbo.Webs SET Language = 1042 WHERE Id = [[WebId]]

Installing Language Packs on 64-bit Sharepoint Farms

2009-04-16T14:06:00.001-07:00

Install additional language files on all the WFE’s

On your front-end Web server, click Start, point to Settings and then Control Panel, and then click Regional and Language Options, on the Languages tab, in the Supplemental Language Support section, select one or both of the following checkboxes:

· Install files for complex script and right-to-left languages

· Install files for East Asian languages

Restart the Servers.

The following installation sequence should be followed.

Remember to unblock the downloaded software from the properties.

Cancel the Configuration wizard for the first 3 installations.

For the last installation run the configuration wizard and restart the servers.

1. Windows SharePoint Services 3.0 Language Pack x64

http://www.microsoft.com/downloads/details.aspx?FamilyId=45FA2637-EFC0-4ED6-8F47-8A013E9CE9D9&displaylang=en

2. Windows SharePoint Services 3.0 Language Pack Service Pack 1 (SP1), 64-Bit Edition

http://www.microsoft.com/downloads/details.aspx?FamilyId=C7CF102B-5DD8-4D86-BE5A-D56F63EF37A4&displaylang=en

3. SharePoint Server 2007 Language Pack (x64)

http://www.microsoft.com/downloads/details.aspx?familyid=318d8562-58bd-4329-b1f6-f1941a38bc7f&displaylang=en&tm

4. The 2007 Microsoft Office Servers Language Pack Service Pack 1 (SP1), 64-Bit Edition

http://www.microsoft.com/downloads/details.aspx?FamilyId=56681742-7D2C-4A6F-9178-DACD32AADC6C&displaylang=en

SharePoint Master Pages

2009-04-16T10:58:00.000-07:00

Do not use the CTRL (K+D) option from the VS 2008 for the master pages.

This option applies the indenting and space formatting for the language as specified on the Formatting pane of the language in the Text Editor section of the Options dialog box.

I have noted extra space appearing just by that

SharePoint Object Model - Discussion

2009-04-15T06:21:00.000-07:00

using System;

using System.Collections.Generic;

using System.Text;

using Microsoft.SharePoint;

using Microsoft.SharePoint.Utilities;

namespace DiscussionBoardPoster

{

class Program

{

static void Main(string[] args)

{

SPSite site = new SPSite("http://kopperla:2030/Movies");

using (SPWeb web = site.OpenWeb())

{

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

SPListItemCollection myListCol = list.Items;

SPListItem disc = SPUtility.CreateNewDiscussion(myListCol, "Excellence2");

disc["Body"] = "C Sharp is great";

SPFieldUserValue oUser = new SPFieldUserValue(web, 289, "matcha");

disc.Update();

SPListItem reply = SPUtility.CreateNewDiscussionReply(disc);

reply["Body"] = "I like C Sharp and VB.NET much";

reply["Author"] = oUser;

reply["Editor"] = oUser;

reply["Created"] = DateTime.Parse("14 Jul 2006");

reply["Modified"] = DateTime.Parse("14 Jul 2006");

reply.Update();

SPListItem reply2 = SPUtility.CreateNewDiscussionReply(reply);

reply2["Body"] = "I like C Sharp and VB.NET too mubh";

reply["Author"] = oUser;

reply2["Editor"] = oUser;

reply2["Created"] = DateTime.Parse("10/22/2008");

reply2["Modified"] = DateTime.Parse("10/22/2008");

reply2.Update();

disc["Author"] = oUser;

disc["Editor"] = oUser;

disc["Last Updated"] = DateTime.Parse("10/22/2008");

disc["Created"] = DateTime.Parse("10/22/2008");

disc["Modified"] = DateTime.Parse("10/22/2008");

disc.Update();

}

Installing Adobe PDF iFilter 9 for 64-bit platforms

2009-04-08T06:52:00.000-07:00

1. Download Link: http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025
2. Add Path C:\Program Files\Adobe\Adobe PDF iFilter 9 for 64-bit platforms\bin) to the Environmental Variables. Dummies Steps below.
(Right-click MyComputer)->Properties->Advanced->Environmental Variables->System Variables
selct PATH and click Edit, Click End button to reach the end to avoid replace.
Add ;C:\Program Files\Adobe\Adobe PDF iFilter 9 for 64-bit platforms\bin

Click OK, Ok, Ok to apply the changes and to close the System Properties Window
3. Restart the machine

4. Follow the steps in the following link. - Simplified version of the following version coming soon.

http://www.adobe.com/special/acrobat/configuring_pdf_ifilter_for_ms_sharepoint_2007.pdf

How to increase Site or List Template Size

2009-03-12T08:07:00.000-07:00

This blog solves the follwoing errors
1. "The list is too large to save as a template. The size of a template cannot exceed 10485760 bytes"
2. "Failure decompressing data from a cabinet file"

For the first error,
To increase the Site or List template size, use the following STSADM command
stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 83886080
80MB = 80*1024*1024 bytes = 83886080
The maximum size that can be set is 500MB

For the second error,
use the -nofilecompression attribute of export and import of STSADM.

Export Using
stsadm.exe -o export -url http://replaceThisWithYourSiteUrl -includeusersecurity -nofilecompression -filename C:\backup

Import Using
stsadm.exe -o import -url http://replaceThisWithYourSiteUrl -includeusersecurity -nofilecompression -filename C:\backup

Hiding search on all application screens

2009-03-09T07:25:00.000-07:00

Application(_layout) screens usually don't display the search in the header.
There does appear to be a few screens out there that do, and depending on your design for application screens, this may throw a wrench in how your page looks.

To stop the search from showing in any application screen, add the following CSS style to your theme or alternate CSS file:

.ms-searchform {
display: none
}

Maximum File Size for Crawling

2008-12-03T13:07:00.000-08:00

By default, Search Services can crawl and filter a file with a size of up to 16 megabytes (MB). It will always crawl the first 16MB of a file. After this limit is reached, SharePoint Portal Server enters a warning in the gatherer log “The file reached the maximum download limit. Check that the full text of the document can be meaningfully crawled.”

To increase the limit of 16 MB, you must add in the registry new entry MaxDownloadSize. To do this, follow these steps:

1. Start Registry Editor (Regedit.exe).
2. Locate the following key in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Global\Gathering Manager
3. Open Edit - New - DWORD Value. Name it MaxDownloadSize.
4. Double-click, change the value to Decimal, and type the maximum size (in MB) for files that the gatherer downloads.
5. Restart the server.
6. Start Full Crawl.

NOTE: Increasing the file size may cause a timeout exception because the crawler can timeout if the file takes too long to crawl/index (because of its size). To increase timeout value, follow these steps:

1. In Central Administration, on the Application Management tab, in the Search section, click Manage search service.
2. On the Manage Search Service page, in the Farm-Level Search Settings section, click Farm-level search settings.
3. In the Timeout Settings section change Connection and Request acknowledgement time.

The publishing portal template explained

2008-11-19T07:33:00.000-08:00

In our real world example as mentioned above we were using the publishing portal example and our customer had some specific wishes which we could not meet out of the box.
So, how does this template work? Basically the site definition used is the BLANKINTERNET template you can find in the famous 12/template/site templates directory.
When you open ONET.XML you will see several configuration tags. Remember how your site already contains a root site and two sub sites (Press Releases and the hidden Search center)? Well, for the root site, BLANKINTERNET#0 is the one that is being used. For the Press releases subsite it is BLANKINTERNET#1 and there is another one called BLANKINTERNET#2 and that one is for the new subsites you create yourself.
So what happens when you select 'Create site collection' and select the 'Publishing portal' template? Well, that has been defined in the webtemp*.xml files you can find at c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\1033\XML. You are probably not aware that there is another important file called internetblank.xml which is located at c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\XML. The contents of that file looks like this:

As you can see, it actually defines your initial site structure and it uses the configurations from the ONET.XML.
In the Webtempsps.xml file you will see a list of all the templates that will show up in the Template picker when you create your site collection. The Publishing Portal definition looks little bit different from the other ones as it uses a provisioning technique to create not only one site but a site structure as has been defined in the internetblank.xml file:

Kopperla's SharePoint Blog

MOSS 2007 – WSS 3.0 Version / Build Numbers

Sharepoint Excellent Blogs

SharePoint Profile Cleanup

SharePoint List Xml Schema

Get SPUser object from SharePoint List Item People/Group picker field

Attaching an event handler to a specific SharePoint List

Moss 2007 - Excel Services no file permissions message

IIS7 - Tell me plase why my debugger timed out - Coz u r slow -"The web server process that was being debugged has been terminated by IIS"

SPWeb GetList Exception from HRESULT: 0x80070003 System.IO.DirectoryNotFoundException

Deleting Document Library Items for large list size Failed?

Deleting ListItems for large list size Failed?

SharaPoint CAML OrderBy DefaultView Limit

Truncate and shrink Transaction Log file in SQL Server 2008

XSLT String Padding

InfoPath 2007 Template Parts

Infopath - Edit in Browser + Close = "The form has been closed." Annoyed?

Sharepoint Site Creation Notification Email

Great Sharepoint Links

List Template Id

Sharepoint Banner

Override BDC default Action

Identify WFE Vs Complete option used

Get SSP URL

Kerberos - Pros & Cons

Compiling audience object model.

Moss SDK 1.5 Released

SharePoint Developer download Links

MOSS SP2 Available

SharePoint WSS Extensions 64-bit and 32-bit Visual Studio 2008

Microsoft Sharepoint Language Codes

SharePoint Facts, Top 10 Benefits of Moss

SharePoint Audience User Existance Check sample

Great Sharepoint Links

Changing the Language of Sites

Installing Language Packs on 64-bit Sharepoint Farms

SharePoint Master Pages

SharePoint Object Model - Discussion

Installing Adobe PDF iFilter 9 for 64-bit platforms

How to increase Site or List Template Size

Hiding search on all application screens

Maximum File Size for Crawling

The publishing portal template explained

Feature, Web Part , Images Solution sure shot deployment to Farm

%~dp0 SharePoint 2007 Visual Studio Extensions setup.bat

How to replace files in Sharepoint Solution wsp file

Moss custom master page Best Practices