Hannah Scott's Blog

IE Conditional Stylesheets and Hacks

2011-09-14T15:40:00.000Z

Thanks Chris Coyer for this useful list of CSS examples to target different versions of IE referencing Conditional Stylesheets and Hacks:

The Code

This would go in your <head> with all the other regular CSS <link>ed CSS files. The opening and closing tags should be familiar, that's just regular ol' HTML comments. Then between the brackets, "IF" and "IE" should be fairly obvious. The syntax to note is "!" stand for "not", so !IE means "not IE". gt means "greater than", gte means "greater than or equal", lt means "less than", lte means "less than or equal."

Target ALL VERSIONS of IE



Target everything EXCEPT IE


<link rel="stylesheet" type="text/css" href="not-ie.css" />


Target IE 7 ONLY



Target IE 6 ONLY



Target IE 5 ONLY



Target IE 5.5 ONLY



Target IE 6 and LOWER





Target IE 7 and LOWER





Target IE 8 and LOWER





Target IE 6 and HIGHER





Target IE 7 and HIGHER





Target IE 8 and HIGHER





Universal IE 6 CSS

Dealing with IE 6 and below is always an extra-special challenge. These days people are dropping support for it right and left, including major businesses, major web apps, and even governments. There is a better solution than just letting the site go to hell, and that is to server IE 6 and below a special stripped-down stylesheet, and then serve IE 7 and above (and all other browsers) the regular CSS. This is been coined the universal IE 6 CSS.


<link rel="stylesheet" type="text/css" media="screen, projection" href="REGULAR-STYLESHEET.css" />






Hacks

If you must...
IE-6 ONLY

* html #div {
height: 300px;
}

IE-7 ONLY

*+html #div {
height: 300px;
}

IE-8 ONLY

#div {
height: 300px\0/;
}

IE-7 & IE-8

#div {
height: 300px\9;
}

NON IE-7 ONLY:

#div {
_height: 300px;
}

Hide from IE 6 and LOWER:

#div {
height/**/: 300px;
}

html > body #div {
height: 300px;
}

List 'Boxed' Style with One Column Layout

2011-09-14T15:06:00.001Z

Thanks Christophe & Larry for this useful bit of styling to modify the SharePoint 2010 'Boxed' list style to display items in a single column layout (rather than the default 2 cols):

<script type="text/javascript">
var boxedview = document.getElementById("WebPartWPQ1").innerHTML;
boxedview = boxedview.replace(/ <\/td>/gi,"<\/tr> <\/td><\/tr>");
boxedview = boxedview.replace(/ <\/td>/gi,"<\/tr> <\/td><\/tr>");
boxedview = boxedview.replace(/ <\/td>/gi,"<\/tr> <\/td><\/tr>");

document.getElementById("WebPartWPQ1").innerHTML = boxedview;
</script>

Update the webpart ID (WebPartWPQ1) to match that of your list web part.

XSL Date using ddwrt Namespace

2011-07-26T13:58:00.000Z

The following comes from: http://msdn.microsoft.com/en-us/library/dd583143(v=office.11).aspx

XSL Date using ddwrt Namespace... NOTE: Ensure the xsl stylesheet includes a reference to ddwrt ... Eg:

<xsl:stylesheet xmlns:x="http://www.w3.org/2001/XMLSchema" xmlns:d="http://schemas.microsoft.com/sharepoint/dsp" version="1.0" exclude-result-prefixes="xsl msxsl ddwrt" xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" xmlns:asp="http://schemas.microsoft.com/ASPNET/20" xmlns:__designer="http://schemas.microsoft.com/WebParts/v2/DataView/designer" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:SharePoint="Microsoft.SharePoint.WebControls" xmlns:ddwrt2="urn:frontpage:internal" xmlns:o="urn:schemas-microsoft-com:office:office">

Functions:

public string FormatDate(string szDate, long lcid, long formatFlag);
<xsl:value-of select="ddwrt:FormatDateTime(ddwrt:TodayIso(),2057,'dddd MMMM dd yyyy')" />

public string TodayIso();
<xsl:value-of select="ddwrt:TodayIso()"/>

public string Today();
<xsl:value-of select="ddwrt:Today()"/>

Date only as M/d/yyyy. Example: "08/17/2000".
Date only as dddd, MM dd, yyyy. Example: "Thursday, August 17, 2000".
Time only as h:mm. Example: "16:32".
DateTime as M/d/yyyy h:mm. Example: "08/17/2000 16:32".
DateTime as dddd, MM dd, yyyy h:mm. Example: "Thursday, August 17, 2000 16:32".
Time only as h:mm:ss. Example: "16:32:32".
DateTime as M/d/yyyy h:mm:ss. Example: "08/17/2000 16:32:32".
DateTime as dddd, MMMM dd, yyyy h:mm:ss. Example: "Thursday, August 17, 2000 16:32:32".

XLV Web Parts

2011-07-06T16:07:00.001Z

To display an XLV on another site update the Title, Description, ListId and WebId values in this code; save as a .webpart; upload the file to a web part page (more info on Glyn's blog):

<?xml version="1.0" encoding="utf-8" ?>
<webParts>
<webPart xmlns="http://schemas.microsoft.com/WebPart/v3">
<metaData>
<type name="Microsoft.SharePoint.WebPartPages.XsltListViewWebPart, Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
<importErrorMessage>Cannot import this Web Part.</importErrorMessage>
</metaData>
<data>
<properties>
<property name="Title" type="string">My List</property>
<property name="Description" type="string">A view of My list from the root of the site</property>
<property name="ListName" type="string">8480D028-A2ED-474B-8259-BEE394EE4C53</property>
<property name="ListId" type="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">8480D028-A2ED-474B-8259-BEE394EE4C53</property>
<property name="WebId" type="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">adea17f7-e661-4ff0-91e9-70f021c60647</property>
<property name="ExportMode" type="exportmode">All</property>
</properties>
</data>
</webPart>
</webParts>

Return all values in XSL

2011-06-01T18:00:00.000Z

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" >
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes" />
<xsl:template match="/">
<xmp><xsl:copy-of select="*"/></xmp>
</xsl:template>
</xsl:stylesheet>

Contextual Search Results

2011-06-01T17:55:00.001Z

I wanted to configure a contextual search to bring back results from a particular list only and display the results on the same web part page. I also wanted to be able to open the results items in a modal dialogue box (new for SharePoint 2010). On my page I have:

a Search Box web part configured as follows:

Scopes dropdown: Do not show dropdown and default to target results page
Target search results page URL: /site/Pages/default.aspx

a Search Core Results web part configured as follows:

Results Query options / Append Text To Query - Site:http://site/Lists/ListName contentclass:STS_ListItem.
Edit the Display Properties XSL by searching for this line:

<xsl:attribute name="href"> <xsl:value-of select="$url"> </xsl:value-of></xsl:attribute>

and replacing it with this:

<xsl:attribute name="href"> javascript:OpenDialog('<xsl:value-of select="$url">') </xsl:value-of></xsl:attribute>

Thanks to Glyn for pointing me in the right direction again and Rain Tree Studio for this list of contentclass values, which can be appended to a search query:

case "STS_Web": // Site
        case "STS_List_850": // Page Library
        case "STS_ListItem_850": // Page
        case "STS_List_DocumentLibrary":            // Document Library
        case "STS_ListItem_DocumentLibrary": // Document Library Items
        case "STS_List": // Custom List
        case "STS_ListItem": // Custom List Item
        case "STS_List_Links": // Links List
        case "STS_ListItem_Links": // Links List Item
        case "STS_List_Tasks": // Tasks List
        case "STS_ListItem_Tasks": // Tasks List Item
        case "STS_List_Events": // Events List
        case "STS_ListItem_Events": // Events List Item
        case "STS_List_Announcements": // Announcements List
        case "STS_ListItem_Announcements": // Announcements List Item
        case "STS_List_Contacts": // Contacts List
        case "STS_ListItem_Contacts":               // Contacts List Item
        case "STS_List_DiscussionBoard": // Discussion List
        case "STS_ListItem_DiscussionBoard": // Discussion List Item
        case "STS_List_IssueTracking":              // Issue Tracking List
        case "STS_ListItem_IssueTracking": // Issue Tracking List Item
        case "STS_List_GanttTasks": // Project Tasks List
        case "STS_ListItem_GanttTasks": // Project Tasks List Item
        case "STS_List_Survey": // Survey List
        case "STS_ListItem_Survey":                 // Survey List Item
        case "STS_List_PictureLibrary":             // Picture Library
        case "STS_ListItem_PictureLibrary":         // Picture Library Item
        case "STS_List_WebPageLibrary":             // Web Page Library
        case "STS_ListItem_WebPageLibrary":         // Web Page Library Item
        case "STS_List_XMLForm":                    // Form Library
        case "STS_ListItem_XMLForm":                // Form Library Item
        case "urn:content-class:SPSSearchQuery":    // Search Query
        case "urn:content-class:SPSListing:News":   // News Listing
        case "urn:content-class:SPSPeople":         // People
        case "urn:content-classes:SPSCategory":     // Category
        case "urn:content-classes:SPSListing":      // Listing
        case "urn:content-classes:SPSPersonListing":// Person Listing
        case "urn:content-classes:SPSTextListing": // Text Listing
        case "urn:content-classes:SPSSiteListing": // Site Listing
        case "urn:content-classes:SPSSiteRegistry": // Site Registry Listing

Grouping list data in XSLT

2011-06-01T09:57:00.010Z

I used a linked XSL file to override the output of my list web part, grouped by one of my custom columns called 'Classification'.

To add in an XSL override link to your XSL file via the list web part properties:

XSL (uploaded to a SharePoint Document library):

<xsl:stylesheet xmlns:x="http://www.w3.org/2001/XMLSchema" xmlns:d="http://schemas.microsoft.com/sharepoint/dsp" version="1.0" exclude-result-prefixes="xsl msxsl ddwrt" xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" xmlns:asp="http://schemas.microsoft.com/ASPNET/20" xmlns:__designer="http://schemas.microsoft.com/WebParts/v2/DataView/designer" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:SharePoint="Microsoft.SharePoint.WebControls" xmlns:ddwrt2="urn:frontpage:internal" xmlns:o="urn:schemas-microsoft-com:office:office">
<xsl:include href="/_layouts/xsl/main.xsl"/>
<xsl:include href="/_layouts/xsl/internal.xsl"/>
<xsl:output method="html" indent="yes" version="4.0"/>
<xsl:template match="/">
<xsl:call-template name="MyTemplate" />
</xsl:template>
<xsl:key name="classificationKey" match="Row" use="@Classification" />
<xsl:key name="associatedTitle" match="Row" use="@Title" />
<xsl:template name="MyTemplate">
<xsl:for-each select="/dsQueryResponse/Rows/Row[generate-id(.)=generate-id(key('classificationKey', @Classification))]">
<h3><xsl:value-of select="@Classification" /></h3>
<xsl:variable name="thisClassification" select="@Classification" />
<xsl:for-each select="../Row[generate-id()=generate-id(key('associatedTitle', @Title)[@Classification = $thisClassification][1])]">
<div>
<strong>Title: </strong>
<xsl:value-of select="@Title" /><br/>
<strong>Description: </strong>
<xsl:value-of select="@Description" disable-output-escaping="yes" /><br/>
<strong>Link: </strong>
<a href="{@Link}" title="{@Title}"><xsl:value-of select="@Link"/></a>
</div>
</xsl:for-each>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

This is the output:

Classification 1

Title 1
Description 1
Title 2
Description 2
Title 3
Description 3

Classification 2

Title 4
Description 4
Title 5
Description 5

List View Lookup Threshold

2011-04-08T12:01:00.001Z

In my workflow I have multiple 'Collect Data from Users' actions configured. It tested with no problems in my dev environment running with an admin account. However, in a separate test environment running the workflow as a normal user the workflow failed with the following error:

SP Workflow Error: An error has occurred in YourWorkflow

I searched the SP logs and found the following ULS error:

Some lookup fields were omitted from the query results because the list exceeds the lookup column threshold.

The problem occurred because SP has a threshold on list lookup columns set to a default value of 8.

There are two possible solutions:

Increase the threshold in Central Administration

NOTE: It is recommended NOT to increase the threshold since it will affect performance across your web application.
However, if you do want to increase the threshold you can do so in the Resource Throttling settings in Central Administration. Here you can "specify the maximum number of Lookup, Person/Group, or workflow status fields that a database query can involve at one time":

Click Manage web applications.
Select the web application you want to update.
Click General Settings | Resource Throttling.
Update the List View Lookup Threshold to at least 12.
Click OK.

Reduce the number of lookup columns in your workflow.

NOTE - lists / libraries already have two lookup columns by default: 'Created by' and 'Modified by' so while the threshold is set to 8 you need to keep your additional columns to a maximum of 6.

Hide and auto-generate 'Title' column in SP Designer workflow

2011-04-07T15:14:00.000Z

I have a custom list content type, which applicants use to apply for jobs. The default 'Title' column is not required as it would make no sense to the applicant. However, I don't want to rename the site column or delete it from the site because it is used in other lists.

The 'Title' column is inherited by lists and libraries from the 'Item' content type. If you don't require it you can specify it's settings to be hidden so that it does not appear in any forms.

To Hide the Title Column:

Open your custom Content Type Information page and select the 'Title' column.
Set the Column Settings to 'Hidden'.

To Auto-Generate the 'Title' column Value:

Using SP Designer you can auto-populate the 'Title' column based the values of other columns in your list item using the 'Update List Item' action:

NOTE: When a user creates a new list item the 'Title' will initially be set to '(no title)'. Associated tasks in the workflow are related to the list item title by SharePoint (for example when collecting data from users). To avoid tasks being related to items with '(no title)' set a 'Pause for Duration' action for 5 minutes in the workflow to allow SP timer jobs to reflect your auto-generated title in the list.

Formulas for Calculated Fields

2011-04-07T14:19:00.002Z

This content comes from: http://office.microsoft.com/en-au/windows-sharepoint-services-help/examples-of-common-formulas-HA001160947.aspx

Examples of common formulas

You can use the following examples in calculated columns. Examples that do not include column references can be used to specify the default value of a column.

Conditional formulas

Check if a number is greater than or less than another number

Use the IF function to do this task.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
15000	9000	=Column1>Column2	Is Column1 greater than Column2? (Yes)
15000	9000	=IF(Column1<=Column2, "OK", "Not OK")	Is Column1 less than or equal to Column2? (Not OK)

Return a logical value after comparing column contents

For a result that is a logical value (Yes or No), use the AND, OR, and NOT functions.

COLUMN1	COLUMN2	COLUMN3	FORMULA	DESCRIPTION
15	9	8	=AND(Column1>Column2, Column1	Is 15 greater than 9 and less than 8? (No)
15	9	8	=OR(Column1>Column2, Column1	Is 15 greater than 9 or less than 8? (Yes)
15	9	8	=NOT(Column1+Column2=24)	Is 15 plus 9 not equal to 24? (No)

For a result that is another calculation, or any other value other than Yes or No, use the IF, AND, and OR functions.

COLUMN1	COLUMN2	COLUMN3	FORMULA	DESCRIPTION
15	9	8	=IF(Column1=15, "OK", "Not OK")	If the value in Column1 equals 15, then return "OK". (OK)
15	9	8	=IF(AND(Column1>Column2, Column1	If 15 is greater than 9 and less than 8, then return "OK". (Not OK)
15	9	8	=IF(OR(Column1>Column2, Column1	If 15 is greater than 9 or less than 8, then return "OK". (OK)

Display zeroes as blanks or dashes

Use the IF function to do this task.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
10	10	=Column1-Column2	Second number subtracted from the first (0)
15	9	=IF(Column1-Column2,"-",Column1-Column2)	Returns a dash when the value is zero (-)

Date and time formulas

Add dates

To add a number of days to a date, use the addition (+) operator. Note that when manipulating dates, the return type of the calculated column must be set to Date and Time.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
6/9/2007	3	=Column1+Column2	Add 3 days to 6/9/2007 (6/12/2007)
12/10/2008	54	=Column1+Column2	Add 54 days to 12/10/2008 (2/2/2009)

To add a number of months to a date, use the DATE, YEAR, MONTH, and DAY functions.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
6/9/2007	3	=DATE(YEAR(Column1),MONTH(Column1)+Column2,DAY(Column1))	Add 3 months to 6/9/2007 (9/9/2007)
12/10/2008	25	=DATE(YEAR(Column1),MONTH(Column1)+Column2,DAY(Column1))	Add 25 months to 12/10/2008 (1/10/2011)

To add a number of years to a date, use the DATE, YEAR, MONTH, and DAY functions.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
6/9/2007	3	=DATE(YEAR(Column1)+Column2,MONTH(Column1),DAY(Column1))	Add 3 years to 6/9/2007 (6/9/2010)
12/10/2008	25	=DATE(YEAR(Column1)+Column2,MONTH(Column1),DAY(Column1))	Add 25 years to 12/10/2008 (12/10/2033)

To add a combination of days, months, and years to a date, use the DATE, YEAR, MONTH, and DAY functions.

COLUMN1	FORMULA	DESCRIPTION
6/9/2007	=DATE(YEAR(Column1)+3,MONTH(Column1)+1,DAY(Column1)+5)	Add 3 years, 1 month, and 5 days to 6/9/2007 (1/14/2009)
12/10/2008	=DATE(YEAR(Column1)+1,MONTH(Column1)+7,DAY(Column1)+5)	Add 1 year, 7 months, and 5 days to 6/9/2007 (7/15/2010)

Calculate the difference between two dates

Use the DATEDIF function to do this task.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
01-Jan-1995	15-Jun-1999	=DATEDIF(Column1, Column2,"d")	Return the number of days between the two dates (1626)
01-Jan-1995	15-Jun-1999	=DATEDIF(Column1, Column2,"ym")	Return the number of months between the dates, ignoring the year part (5)
01-Jan-1995	15-Jun-1999	=DATEDIF(Column1, Column2,"yd")	Return the number of days between the dates, ignoring the year part (165)

Calculate the difference between two times

For presenting the result in the standard time format (hours:minutes:seconds), use the subtraction operator (-) and the TEXT function. For this method to work, hours must not exceed 24, and minutes and seconds must not exceed 60.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
06/09/2007 10:35 AM	06/09/2007 3:30 PM	=TEXT(Column2-Column1,"h")	Hours between two times (4)
06/09/2007 10:35 AM	06/09/2007 3:30 PM	=TEXT(Column2-Column1,"h:mm")	Hours and minutes between two times (4:55)
06/09/2007 10:35 AM	06/09/2007 3:30 PM	=TEXT(Column2-Column1,"h:mm:ss")	Hours,minutes, and seconds between two times (4:55:00)

For presenting the result in a total based on one time unit, use the INT function, or HOUR, MINUTE, and SECOND functions.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
06/09/2007 10:35 AM	06/10/2007 3:30 PM	=INT((Column2-Column1)*24)	Total hours between two times (28)
06/09/2007 10:35 AM	06/10/2007 3:30 PM	=INT((Column2-Column1)*1440)	Total minutes between two times (1735)
06/09/2007 10:35 AM	06/10/2007 3:30 PM	=INT((Column2-Column1)*86400)	Total seconds between two times (104100)
06/09/2007 10:35 AM	06/10/2007 3:30 PM	=HOUR(Column2-Column1)	Hours between two times, when the difference does not exceed 24. (4)
06/09/2007 10:35 AM	06/10/2007 3:30 PM	=MINUTE(Column2-Column1)	Minutes between two times, when the difference does not exceed 60. (55)
06/09/2007 10:35 AM	06/10/2007 3:30 PM	=SECOND(Column2-Column1)	Seconds between two times, when the difference does not exceed 60. (0)

Convert times

To convert hours from standard time format to a decimal number, use the INT function.

COLUMN1	FORMULA	DESCRIPTION
10:35 AM	=(Column1-INT(Column1))*24	Number of hours since 12:00 AM (10.583333)
12:15 PM	=(Column1-INT(Column1))*24	Number of hours since 12:00 AM (12.25)

To convert hours from a decimal number to the standard time format (hours:minutes:seconds), use the divisor operator and the TEXT function.

COLUMN1	FORMULA	DESCRIPTION
23:58	=TEXT(Column1/24, "hh:mm:ss")	Hours, minutes, and seconds since 12:00 AM (00:59:55)
2:06	=TEXT(Column1/24, "h:mm")	Hours and minutes since 12:00 AM (0:05)

Insert Julian dates

The phrase "Julian date" is sometimes used to refer to a date format that is a combination of the current year, and the number of days since the beginning of the year. For example, January 1, 2007 is represented as 2007001 and December 31, 2007 is represented as 2003356. This format is not based on the Julian calendar.

To convert a date to a Julian date, use the TEXT and DATEVALUE functions.

COLUMN1	FORMULA	DESCRIPTION
6/23/2007	=TEXT(Column1,"yy")&TEXT((Column1-DATEVALUE("1/1/"& TEXT(Column1,"yy"))+1),"000")	Date in "Julian" format, with a two-digit year (07174)
6/23/2007	=TEXT(Column1,"yyyy")&TEXT((Column1-DATEVALUE("1/1/"&TEXT(Column1,"yy"))+1),"000")	Date in "Julian" format, with a four-digit year (2007174)

To convert a date to a Julian date used in astronomy, use the constant 2415018.50. This formula only works for dates after 3/1/1901, and if you are using the 1900 date system.

COLUMN1	FORMULA	DESCRIPTION
6/23/2007	=Column1+2415018.50	Date in "Julian" format, used in astronomy (2454274.50)

Show dates as the day of the week

To convert dates to the text for the day of the week, use the TEXT and WEEKDAY functions.

COLUMN1	FORMULA	DESCRIPTION
19-Feb-2007	=TEXT(WEEKDAY(Column1), "dddd")	Calculates the day of the week for the date and returns the full name of the day (Monday)
3-Jan-2008	=TEXT(WEEKDAY(Column1), "ddd")	Calculates the day of the week for the date and returns the abbreviated name of the day (Thu)

Math formulas

Add numbers

To add numbers in two or more columns in a row, use the addition operator (+) or the SUM function.

COLUMN1	COLUMN2	COLUMN3	FORMULA	DESCRIPTION
6	5	4	=Column1+Column2+Column3	Add the values in the first three columns (15)
6	5	4	=SUM(Column1,Column2,Column3)	Add the values in the first three columns (15)
6	5	4	=SUM(IF(Column1>Column2, Column1-Column2, 10), Column3)	If Column1 is greater than Column2, add the difference and Column3. Else add 10 and Column3. (5)

Subtract numbers

Use the subtraction (-) operator to do this task.

COLUMN1	COLUMN2	COLUMN3	FORMULA	DESCRIPTION
15000	9000	-8000	=Column1-Column2	Subtract 9000 from 15000 (6000)
15000	9000	-8000	=SUM(Column1, Column2, Column3)	Add numbers in the first three columns, including negative values (16000)

Calculate the difference between two numbers as a percentage

Use the subtraction (-) and division (/) operators, and the ABS function.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
2342	2500	=(Column2-Column1)/ABS(Column1)	Percentage change (6.75% or 0.06746)

Multiply numbers

Use the multipliation (*) operator or the PRODUCT function to do this task.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
5	2	=Column1*Column2	Multiplies the numbers in the first two columns (10)
5	2	=PRODUCT(Column1, Column2)	Multiplies the numbers in the first two columns (10)
5	2	=PRODUCT(Column1,Column2,2)	Multiplies the numbers in the first two columns and the number 2 (20)

Divide numbers

Use the division operator (/) to do this task.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
15000	12	=Column1/Column2	Divides 15000 by 12 (1250)
15000	12	=(Column1+10000)/Column2	Adds 15000 and 10000, and then divides the total by 12 (2,083)

Calculate the average of numbers

The average is also called the mean. To calculate the average of numbers in two or more columns in a row, use the AVERAGE function.

COLUMN1	COLUMN2	COLUMN3	FORMULA	DESCRIPTION
6	5	4	=AVERAGE(Column1, Column2,Column3)	Average of the numbers in the first three columns (5)
6	5	4	=AVERAGE(IF(Column1>Column2, Column1-Column2, 10), Column3)	If Column1 is greater than Column, calculate the average of the difference and Column3. Else calculate the average of the value 10 and Column3. (2.5)

Calculate the median of numbers

The median is the value at the center of an ordered range of numbers. Use the MEDIAN function to calculate the median of a group of numbers.

A	B	C	D	E	F	FORMULA	DESCRIPTION
10	7	9	27	0	4	=MEDIAN(A, B, C, D, E, F)	Median of numbers in the first 6 columns (8)

Calculate the smallest or largest number in a range

To calculate the smallest or largest number in two or more columns in a row, use the MIN and MAX functions.

COLUMN1	COLUMN2	COLUMN3	FORMULA	DESCRIPTION
10	7	9	=MIN(Column1, Column2, Column3)	Smallest number (7)
10	7	9	=MAX(Column1, Column2, Column3)	Largest number (10)

Count values

To count numeric values, use the COUNT function.

COLUMN1	COLUMN2	COLUMN3	FORMULA	DESCRIPTION
Apple		12/12/2007	=COUNT(Column1, Column2, Column3)	Counts the number of columns that contain numeric values. Excludes date and time, text, and null values.(0)
12	#DIV/0!	1.01	=COUNT(Column1, Column2, Column3)	Counts the number of columns that contain numeric values, but excludes error and logical values (2)

Increase or decrease a number by a percentage

Use the percentage (%) operator to do this task.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
23	3%	=Column1*(1+5%)	Increases number in Column1 by 5% (24.15)
23	3%	=Column1*(1+Column2)	Increase number in Column1 by the percent value in Column2: 3% (23.69)
23	3%	=Column1*(1-Column2)	Decrease number in Column1 by the percent value in Column2: 3% (22.31)

Raise a number to a power

Use the exponent (^) operator or the POWER function to do this task.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
5	2	=Column1^Column2	Calculates five squared (25)
5	3	=POWER(Column1, Column2)	Calculates five cubed (125)

Round a number

To round up a number, use the ROUNDUP, ODD, and EVEN functions.

COLUMN1	FORMULA	DESCRIPTION
20.3	=ROUNDUP(Column1,0)	Rounds 20.3 up to the nearest whole number (21)
-5.9	=ROUNDUP(Column1,0)	Rounds -5.9 up (-6)
12.5493	=ROUNDUP(Column1,2)	Rounds 12.5493 up to the nearest hundredth, two decimal places (12.55)
20.3	=EVEN(Column1)	Rounds 20.3 up to the nearest even number (22)
20.3	=ODD(Column1)	Rounds 20.3 up to the nearest odd number (21)

To round down a number, use the ROUNDDOWN function.

COLUMN1	FORMULA	DESCRIPTION
20.3	=ROUNDDOWN(Column1,0)	Rounds 20.3 down to the nearest whole number (20)
-5.9	=ROUNDDOWN(Column1,0)	Rounds -5.9 down (-5)
12.5493	=ROUNDDOWN(Column1,2)	Rounds 12.5493 down to the nearest hundredth, two decimal places (12.54)

To round a number to the nearest number or fraction, use the ROUND function.

COLUMN1	FORMULA	DESCRIPTION
20.3	=ROUND(Column1,0)	Rounds 20.3 down, because the fraction part is less than .5 (20)
5.9	=ROUND(Column1,0)	Rounds 5.9 up, because the fraction part is greater than .5 (6)
-5.9	=ROUND(Column1,0)	Rounds -5.9 down, because the fraction part is less than -.5 (-6)
1.25	=ROUND(Column1, 1)	Rounds the number to the nearest tenth (one decimal place). Because the portion to be rounded is 0.05 or greater, the number is rounded up (result: 1.3)
30.452	=ROUND(Column1, 2)	Rounds the number to the nearest hundredth (two decimal places). Because the portion to be rounded, 0.002, is less than 0.005, the number is rounded down (result: 30.45)

To round a number to the significant digit above 0, use the ROUND, ROUNDUP, ROUNDDOWN, INT, and LEN functions.

COLUMN1	FORMULA	DESCRIPTION
5492820	=ROUND(Column1,3-LEN(INT(Column1)))	Rounds the number to 3 significant digits (5490000)
22230	=ROUNDDOWN(Column1,3-LEN(INT(Column1)))	Rounds the bottom number down to 3 significant digits (22200)
5492820	=ROUNDUP(Column1, 5-LEN(INT(Column1)))	Rounds the top number up to 5 significant digits (5492900)

Text formulas

Change the case of text

Use the UPPER, LOWER, or PROPER functions to do this task.

COLUMN1	FORMULA	DESCRIPTION
nancy Davolio	=UPPER(Column1)	Changes text to uppercase (NANCY DAVOLIO)
nancy Davolio	=LOWER(Column1)	Changes text to lowercase (nancy davolio)
nancy Davolio	=PROPER(Column1)	Changes text to title case (Nancy Davolio)

Combine first and last names

Use the ampersand (&) operator or the CONCATENATE function to do this task.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
Nancy	Fuller	=Column1&Column2	Combines the two strings (NancyFuller)
Nancy	Fuller	=Column1&" "&Column2	Combines the two strings, separated by a space (Nancy Fuller)
Nancy	Fuller	=Column2&","&Column1	Combines the two strings, separated by a comma (Fuller,Nancy)
Nancy	Fuller	=CONCATENATE(Column2, ",", Column1)	Combines the two strings, separated by a comma (Fuller,Nancy)

Combine text and numbers from different columns

Use the CONCATENATE and TEXT functions, and the ampersand (&) operator to do this task.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
Buchanan	28	=Column1&" sold "&Column2&" units."	Combines contents above into a phrase (Buchanan sold 28 units)
Dodsworth	40%	=Column1&" sold "&TEXT(Column2,"0%")&" of the total sales."	Combines contents above into a phrase (Dodsworth sold 40% of the total sales). NOTE The TEXT function appends the formatted value of Column2 instead of the underlying value, which is .4.
Buchanan	28	=CONCATENATE(Column1," sold ",Column2," units.")	Combines contents above into a phrase (Buchanan sold 28 units)

Combine text with a date or time

Use the TEXT function and the ampersand (&) operator to do this task.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
Billing Date	5-Jun-2007	="Statement date: "&TEXT(Column2, "d-mmm-yyyy")	Combine text with a date (Statement date: 5-Jun-2007)
Billing Date	5-Jun-2007	=Column1&" "&TEXT(Column2, "mmm-dd-yyyy")	Combine text and date from difference columns into one column (Billing Date Jun-05-2007)

Compare column contents

To compare one column to another column or a list of values, use the EXACT function.

COLUMN1	COLUMN2	FORMULA	DESCRIPTION
BD122	BD123	=EXACT(Column1,Column2)	Compare contents of first two columns (No)
BD122	BD123	=EXACT(Column1,"BD122")	Compare contents of Column1 and the string "BD122" (Yes)

Check if a column value or a part of it matches specific text

To check if a column value or a part of it matches specific text, use the IF, FIND, SEARCH, and ISNUMBer functions.

COLUMN1	FORMULA	DESCRIPTION
Davolio	=IF(Column1="Davolio", "OK", "Not OK")	Checks to see if Column1 is Davolio (OK)
Davolio	=IF(ISNUMBER(FIND("v",Column1)), "OK", "Not OK")	Checks to see if Column1 contains the letter v (OK)
BD123	=ISNUMBER(FIND("BD",Column1))	Checks to see if Column1 contains BD (Yes)

Count nonblank columns

Use the COUNTA function to do this task.

COLUMN1	COLUMN2	COLUMN3	FORMULA	DESCRIPTION
Sales	19		=COUNTA(Column1, Column2)	Counts the number of nonblank columns (2)
Sales	19		=COUNTA(Column1, Column2, Column3)	Counts the number of nonblank columns (2)

Remove characters from text

Use the LEN, LEFT, and RIGHT functions to do this task.

COLUMN1	FORMULA	DESCRIPTION
Vitamin A	=LEFT(Column1,LEN(Column1)-2)	Return 7 (9-2) characters, starting from left (Vitamin)
Vitamin B1	=RIGHT(Column1, LEN(Column1)-8)	Return 2 (10-8) characters, starting from right (B1)

Remove spaces from the beginning and end of a column

Use the TRIM function to do this task.

COLUMN1	FORMULA	DESCRIPTION
Hello there!	=TRIM(Column1)	Remove the spaces from the beginning and end (Hello there!)

Repeat a characater in a column

Use the REPT function to do this task.

FORMULA	DESCRIPTION
=REPT(".",3)	Repeats a period 3 times (...)
=REPT("-",10)	Repeats a dash 10 times (----------)

Other formulas

Hide error values in columns

To display a dash, #N/A, or NA in place of an error value, use the ISERROR function.

COLUMN1	FORMULA	DESCRIPTION
10	=Column1/Column2	Results in an error (#DIV/0)
10	=IF(ISERROR(Column1/Column2),"NA",Column1/Column2)	Returns NA when the value is an error
10	=IF(ISERROR(Column1/Column2),"-",Column1/Column2)

Extended Content Query Web Part - 2 Column Box Layout

2011-02-28T17:41:00.002Z

Before extending Content Query Web Parts (CQWP) in SharePoint refer to the following related blogs:

MSDN, Configuring and Customizing the Content Query Web Part
Heather Solomon, Customizing the Content Query Web Part and Custom Item Styles
Glyn Clough, Viewing raw data in a Content Query Web Part
My previous blog, Content Query Web Part - Custom Item Style

The following example creates a 'Highlight Box' two column layout output from a SharePoint list by applying custom XSLT styles using the Content Query Web Part. The result looks like this:

Make a copy of the SharePoint XSL stylesheets 'ItemStyle.xsl' and 'ContentQueryMain.xsl' located in the portal root Style Library (http://hostheader/Style%20Library/) and place the copies in a folder called 'Custom' within the Style Library (http://hostheader/Style%20Library/XSL%20Style%20Sheets/Custom/). Rename as 'ItemStyleExtended.xsl' and 'ContentQueryMainExtended.xsl'.
Open ContentQueryMainExtended.xsl in notepad:

Add the following new variables:

<xsl:variable name="BeginListItemHighlightBoxLeft" select="string('<li class="dfwp-item highlightbox-item left">')" />

<xsl:variable name="BeginListItemHighlightBoxRight" select="string('<li class="dfwp-item highlightbox-item right">')" />
Inside the OuterTemplate.CallItemTemplate insert a new xsl choose:

<xsl:choose>
<xsl:when test="@Style='HighlightBoxTable'">
    <xsl:choose>
      <xsl:when test="$CurPosition mod 2 = 1">
        <xsl:value-of disable-output-escaping="yes" select="$BeginListItemHighlightBoxLeft" />
      </xsl:when>
         <xsl:otherwise>
      <xsl:value-of disable-output-escaping="yes" select="$BeginListItemHighlightBoxRight" />
    </xsl:otherwise>
    </xsl:choose>
</xsl:when>
<xsl:otherwise>
    <xsl:value-of disable-output-escaping="yes" select="$BeginListItem" />
</xsl:otherwise>
</xsl:choose>

Open the ItemStyleExtended.xsl in notepad and create a new template at the end of the existing xsl:

<xsl:template name="HighlightBoxTable" match="Row[@Style='HighlightBoxTable']" mode="itemstyle">

<xsl:variable name="SafeLinkUrl">
    <xsl:call-template name="OuterTemplate.GetSafeLink">
      <xsl:with-param name="UrlColumnName" select="'LinkUrl'"/>
    </xsl:call-template>
</xsl:variable>

<xsl:variable name="SafeImageUrl">
    <xsl:call-template name="OuterTemplate.GetSafeStaticUrl">
      <xsl:with-param name="UrlColumnName" select="'ImageUrl'"/>
    </xsl:call-template>
</xsl:variable>

<xsl:variable name="DisplayTitle">
    <xsl:call-template name="OuterTemplate.GetTitle">
      <xsl:with-param name="Title" select="@Title"/>
      <xsl:with-param name="UrlColumnName" select="'LinkUrl'"/>
    </xsl:call-template>
</xsl:variable>

<xsl:variable name="LinkTarget">
    <xsl:if test="@OpenInNewWindow = 'True'" >_blank</xsl:if>
</xsl:variable>

<xsl:variable name="ImageClass" select="@Class" />

<div class="highlight">
    <div class="highlightHead">
      <h3><a href="{$SafeLinkUrl}"><xsl:value-of select="@Title"/></a></h3>
    </div>
    <div class="highlightContentCtr">
      <a href="{$SafeLinkUrl}" target="{$LinkTarget}"><img align="left" class="{@Class}" src="{$SafeImageUrl}" alt="{@ImageUrlAltText}" /></a>
      <div class="highlightContent">
        <xsl:value-of select="substring(@Description,1,300)" disable-output-escaping="yes"/></div>
    </div>
</div>

</xsl:template>
Update Custom.css with the following styles:

<style type="text/css">
li.highlightbox-item {
   width:49%;
}
li.highlightbox-item.left {
   float:left;
   margin-right:10px;
}
li.highlightbox-item.right {
   float:right;
   margin-right:0;
}
div.highlight {
   background-color: #f7f7f7;
   padding: 0;
   border: 0;
   margin-bottom:10px;
   border-radius-top-left:5px;
   border-radius-top-right:5px;
   -moz-border-radius-topleft:5px;
   -moz-border-radius-topright:5px;
   -webkit-border-top-left-radius:5px;
   -webkit-border-top-right-radius:5px;
}
div.highlight div.highlightHead {
   padding: 0.5em;
   font-weight:bold;
   background-color: #e4e4e4;
   border-radius-top-left:5px;
   border-radius-top-right:5px;
   -moz-border-radius-topleft:5px;
   -moz-border-radius-topright:5px;
   -webkit-border-top-left-radius:5px;
   -webkit-border-top-right-radius:5px;
}
div.highlight div.highlightHead h3 {
   margin:0;
}
div.highlight div.highlightContentCtr {
   min-height:50px;
   border: 1px solid #e4e4e4;
   border-top:0;
}
div.highlight div.highlightContentCtr img {
   margin: 0 10px 0 0;
   border: 0;
   padding: 0;
}
div.highlight div.highlightContentCtr img.icon {
   width:50px;
   height:50px;
}
div.highlight div.highlightContentCtr img.image {
   width:75px;
   height:50px;
}
div.highlight div.highlightContent {
   padding: 10px 10px 4px 10px;
}
</style>
Add a Content Query Web Part (CQWP) to a page. Do not configure it in any way.
Export the Content Query Web Part to your desktop.
Open the exported CQWP in notepad and edit the following properties:

<property name="Title" type="string">Extended Content Query</property>

<property name="ItemXslLink" type="string">/Style%20Library/XSL%20Style%20Sheets/Custom/ItemStyleExtended.xsl</property>

<property name="MainXslLink" type="string">/Style%20Library/XSL%20Style%20Sheets/Custom/ContentQueryMainExtended.xsl</property>
On the web part page where you would like the CQWP displayed, select Edit, Add a Web Part, Upload a Web Part:
On the web part page where you would like the CQWP displayed, select Edit, Add a Web Part, Imported Web Parts, Extended Content Query
Edit the Extended CQWP properties:

In the properties panel expand the Query node. Select the radio button Show items from the following list and enter the path to the associated SharePoint list, (which requires six columns including: Title, Image, Description, URL, Class and Order). Apply these changes by selecting the Apply button at the bottom of the properties panel.
Expand the Presentation node and in the Grouping and Sorting section set the Sort items by to ‘Order’.
In the Styles section set the Item style to HighlightBoxTable.
In the Fields to display section set as in the screenshot.
Expand the Appearance node and set the Chrome to none.
Select Ok.

XSL disable-output-escaping

2011-02-14T18:02:00.002Z

Render HTML using 'disable-output-escaping':

<xsl:value-of select="expression" disable-output-escaping="yes|no" />

http://www.w3schools.com/xsl/el_value-of.asp

Attribute	Value	Description
select	expression	Required. An XPath expression that specifies which node/attribute to extract the value from. It works like navigating a file system where a forward slash (/) selects subdirectories.
disable-output-escaping	yes no	Optional. "yes" indicates that special characters (like "<") should be output as is. "no" indicates that special characters (like "<") should be output as "<". Default is "no"

Add GUIDGEN to Visual Studio 2010

2011-01-31T15:47:00.000Z

To add GUIDGEN to the Visual Studio 'Tools' menu:

Open Visual Studio 2010
Select 'Tools' / 'External Tools'
Click 'Add'
Enter 'Title' for the command like 'Create GUID'
Click on the browse button named and navigate to C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\bin\guidgen.exe
Click OK

Customising My Site in MOSS 2010

2011-01-25T14:23:00.002Z

http://blogs.msdn.com/b/spsocial/archive/2010/03/30/customizing-my-sites-in-microsoft-sharepoint-2010.aspx

Viewing Documents Checked Out to Me

2011-01-21T17:37:00.000Z

To view documents that are checked out to you navigate to the page: /_layouts/sitemanager.aspx and select the view 'Checked out to me'

Open a Closed Web Part

2011-01-16T15:33:00.001Z

To open a 'closed' web part:

Open the page in 'Edit' mode.
Click on a zone 'Add a web part' link.
In the 'Categories' list select 'Closed Web Parts'
Add the web part to the page.

Hide list web part column headers

2011-01-07T16:37:00.003Z

To hide list column headers add the following CSS to a hidden content editor web part on the page:

<style>

.ms-viewheadertr { display: none;}

</style>

Creating Web Part Pages with a Quick Launch

2011-01-07T10:46:00.005Z

Web Part Pages in Team Sites by default do not show the Quick Launch left navigation. Basically the panel is hidden by a CSS style written into the page <head>:

<style type="text/css">
body #s4-leftpanel {
display:none;
}
.s4-ca {
margin-left:0px;
}
style>

and two placeholders in the <body>, which override the masterpage placeholders:

<asp:Content ContentPlaceHolderId="PlaceHolderLeftNavBar" runat="server"></asp:Content>
<asp:Content ContentPlaceHolderId="PlaceHolderNavSpacer" runat="server"></asp:Content>

To show the Quick Launch open the page in SharePoint Designer and remove the style and the placeholders.

Warning: The HTML source you entered might have been modified

2011-01-06T16:31:00.000Z

In Content editor Web Parts editing the HTML source is now accessed via "Edit HTML" in the ribbon - this replaces the old "Source Editor” option.

The following warning will occur if you insert code that SharePoint doesn't like: Warning: The HTML source you entered might have been modified.

To get around this problem one solution is to put your code into a text file in the Site Assets document library.

MOSS 2010 Team Site Pages

2011-01-05T22:45:00.006Z

First impressions of MOSS 2010 Team Sites

MOSS 2010 Team sites are slightly different from their 2007 counterparts in that they are based more on Wiki pages, meaning that you can mix content and web parts within a rich text area.

By default when a team site is created it contains a default.aspx file (located as before in the site root directory) and a home.aspx file. The home.aspx is now the site homepage and is located in a document library called "Site Pages" (/sitepages/home.aspx), generated by a feature dependency of the "WikiPageHomePage" feature called "WebPageLibrary" (see: 14\TEMPLATE\FEATURES).

New pages created using the "Site Actions / New Page" button by default will create new Wiki pages, which will reside in the "Site Pages" document library. If the "Site Pages" document library does not exist you will be prompted to create one before new pages can be created.

New pages created via "View All Site Content / Create" or "View All Site Content / Pages / ... ribbon ... New Page" allow editors the choice to create either a basic page or a web part page. Selecting a web part page prompts choices of page layouts (one col, two col etc) and available document libraries (Pages, Site Pages, Documents, Custom etc). Note that these Web part pages do not display the Quick Navigation panel on the left side of the website, which if integral to your site navigation / heirachy display will pose some important decision making with regards whether or not to activate publishing.

Where's Hannah? Autumn 2010.

2010-09-08T09:13:00.006Z

I am currently working on a new creative project in the West of England - visit my Art Forms website for more details: http://www.hannahscott.com

If you want to get in touch regarding SharePoint or web design please visit my professional website, which includes a full client list and examples of previous work: http://www.bytelab.co.uk

Last summer I drove 10,000 miles from Hyde Park, London to Ulaanbaatar, Mongolia. For more information and to find out what happened visit my website: http://www.drivingdotty.com

After Mongolia I travelled overland through China, Tibet, SE Asia, India, Nepal & the US. Check out my travel blog here: http://outofoffice.bytelab.co.uk

Out Of Office

2009-07-10T14:00:00.003Z

On the 18th July 2009 I set off driving 10,000 miles from Hyde Park, London to Ulaanbaatar, Mongolia. For more information and what happened visit my website www.drivingdotty.com

I will be out of office, travelling until August 2010 so appologies for the lack of new posts but if you are inclined check out my travel blog here: http://outofoffice.bytelab.co.uk

And I do also have a professional website with full client list and examples of past work. If you want to get in touch this is probably the easiest way to find me: http://www.bytelab.co.uk

MOSS July Infrastructure Update

2009-07-01T15:54:00.002Z

http://sharepointnotes.wordpress.com/2009/01/10/updating-from-moss-sp1-to-the-infrastructure-update/

Download the infrastructure updates for both WSS and MOSS
- WSS: x86 – x64
- MOSS: x86 – x64
Install the WSS infrastructure update on all the servers in the farm. Do not run the Wizard at the end
Install the MOSS infrastructure update on all servers in the farm. Again, do not run the Wizard at the end
Run the Wizard on the server hosting the Central Administration Web Site
Run the Wizard on the remaining servers in the farm one at a time
Once all the servers are upgraded, verify in Central Administration that the version number is bumbed to 12.0.0.6318

Connecting PPS to MOSS Sub Site Master Pages

2009-04-01T16:14:00.003Z

When you deploy a dashboard from Performance Point Server you have the option of choosing which master page you want to use. By default you will see all the master pages in the SharePoint master page gallery of the site collection you are publishing too.

If you are in a subsite of your portal unless you have copied your custom master pages to the site collection master page gallery you will only see the default.master in the PPS dropdown since this is the only master page in the subsite master page gallery.

For example:

http://moss/_catalogs/masterpage/Forms/AllItems.aspx contains all portal master pages
http://moss/mysubsite/_catalogs/masterpage/Forms/AllItems.aspx contains only default.master

To solve this simply copy your custom master page to the subsite master page gallery.

Ping Commands!

2009-03-31T16:25:00.010Z

This comes from: http://www.computerhope.com/pinghlp.htm

ping

[-t] [-a] [-n count] [-l size] [-f] [-i TTL] [-v TOS]
[-r count] [-s count] [[-j host-list] | [-k host-list]]
[-w timeout] destination-list

Options

-t - Pings the specified host until stopped.

To see statistics and continue - type Control-Break;
To stop - type Control-C.

-a - Resolve addresses to hostnames.
-n - countNumber of echo requests to send.
-l - sizeSend buffer size.
-f - Set Don't Fragment flag in packet.
-i TTL Time To Live.
-v TOS - Type Of Service.
-r count - Record route for count hops
-s count - Timestamp for count hops.
-j host-list - Loose source route along host-list.
-k host-list - Strict source route along host-list.
-w timeout - Timeout in milliseconds to wait for each reply.

Examples

ping localhost

Pings the local host, this will allow you to see if the computer is able to send information out and receive the information back. Note that this does not send information over a network but may allow you to see if the card is being seen.

ping xxx.xxx.xxx.xxx

Allows you to ping another computer where the x's are located are where you would place the IP address of the computer you are attempting to ping. If this is not able to complete this should relay back an unsuccessful message which could be an indication of cable issues, network card issues, hub issue, etc.

ping computerhope.com

PING computerhope.com (204.228.150.3) 56(84) bytes of data.
64 bytes from www.computerhope.com (204.228.150.3): icmp_seq=1 ttl=63 time=0.267 ms

--- computerhope.com ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.267/0.267/0.267/0.000 ms

Adding users to Project Server PWA site

2009-03-27T14:02:00.006Z

To grant users access to the PS PWA site they need to be added via the Server Settings / Manage Users page in the PWA site. Simply adding them through Site Settings / Advanced Permissions will not work.

Installing Project Server 2007 on an existing MOSS farm with Kerberos enabled

2009-03-27T12:08:00.009Z

I have a medium server farm running MOSS 2007. There are three servers (2 WFE, 1 Index & 1 SQL).

Note - Project Server cannot be uninstalled from a joint MOSS / PS installation

To install Project Server 2007:

Copy Project Server installer on to each server - i put them in C:\Temp
Quiesce the MOSS farm via Central Administration / Operations
Run the PS install files on each server in the farm
Unquiesce the farm
Run the MOSS configuration wizard on each server one by one

Start the Project Server Service:

Open Central Administration and select the Operations tab
Select Services on Server
Select the server you want to run the Project Server service
If the Project Server Service is not dispayed change the server role to Custom
Start the Project Server service

Provision the Project Server site:

Open Central Administration and navigate to Shared Services Administration
Open the SSP that on to which you want to provsion Project Web Access (PWA)
On the SSP homepage select Project Web Access Sites
Select Create Project Web Access Site
Select the MOSS web application to host the PWA
Assign a PWA path for example: projectserver
Assign the Administrator Account for the PS instance
Assign the primary database SQL server
Name the four PS databases
Click OK
When provisioning is complete Provisioned will appear in the status column - to refresh the status click Refresh Status
To enable access you must ensure that you have registered the server SPNs for Kerberos delegation and for the web application process accounts. Until you do this you will get an access denied error when you try to access the PWA site.

A theme with the name "CustomMySite 1011" and version already exists on the server.

2009-02-12T14:48:00.003Z

You receive this error when trying to apply a custom theme to your SharePoint site:

"A theme with the name "CustomMySite 1011" and version already exists on the server. "

Open your site in SharePoint Designer.
Expand _themes and delete the CustomMySite theme folder
Re-apply the custom theme to your site.

Enabling MOSS Anonymous Access

2009-01-15T11:41:00.003Z

From Central Administration > Application Management > Application Security > Authentication Providers, select a Web application and the zone you want to modify. This is usually default.
In the middle of the page, check Enable Anonymous Access and choose Save
All site collections in that Web application can now have anonymous access enabled.
Go to a site collection in the Web application you just enabled anonymous access for
From Site Actions > Site Settings, open Advanced Permissions
From the Settings drop-down menu, select Anonymous Access
For this example, enable anonymous access for Lists and Libraries and click OK
Browse to any document library in this site collection
From the Settings drop-down menu, select Document Library Settings
In the Permissions and Management column, select Permissions for this document library
From the Actions menu, select Edit Permissions to break inheritance
From the newly appeared Settings drop-down menu, select Anonymous Access
Check View Items and click OK.

Issues after restoring MOSS to a previous VM snapshot

2009-01-12T15:20:00.014Z

We restored our VM MOSS farm this morning from a snapshot taken a couple of months ago. Various issues occurred. Please note i am still working through some of the errors and will update this post as i find the answers.

I could no longer login to the server because the snapshot was older than 30 days - the computer account for the server had expired and so needed to be reset and reconnected to the domain. See this blog for steps to fix this.
The MOSS environment although appearing correct in Central Administration was not configured in IIS. The Central Administration site was the only site appearing in IIS even though all the web applications were still there.

To fix this:

Delete the old web application using Central Administration.
Delete all the SSP web apps & DBs, apart from the default SSP which cannot be deleted.
Recreate the web applications with Temp DB names.
Recreate the SSPs with new DBs.
Change the default SSP to one of the newly created SSPs, then delete the original default SSP inc DB, then recreate it's web app and set back to the default updating any associations as required.

At this point I ran in to some issues recreating the SSP with the following errors. First of all the SSP failed to provision with the error:

Provisioning failed: A transport-level error has occurred when sending the request to the server.

Looking in the Event Log i found the following related errors:

Event ID 5554
Failure during sweep synch. Exception was A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.).

Event ID 7888
A runtime exception was detected. Details follow.
Message: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Event ID 5586
Unknown SQL Exception 10054 occured. Additional error information from SQL Server is included below.

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Solution:
http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/0671c03b-5488-4be4-bc5a-579849fa0950
Reboot the server and kill any remaining connections (delete the Admin accounts from local users & groups, reboot, add the Admin accounts back in).

Also in the event log were the following errors:

Event ID 10016
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{3D42CCB1-4665-4620-92A3-478F47389230}

Solution:
http://sharemypoint.wordpress.com/2007/12/18/error-event-id-6398-and-6482-about-security-rights-of-osearch-service/
Add the WSS_WPG, WSS_ADMIN_WPG, Search & Admin accounts to the OSearch DCOM Service

Event ID 6141
The site /ssp/admin could not be created. The following exception occured: This page has encountered a critical error. Contact your system administrator if this problem persists.

Event ID 6610
Safe mode did not start successfully. This page has encountered a critical error. Contact your system administrator if this problem persists.

Event ID 5629
Failed to load the SafeControl assembly paths for web.config. C:\Inetpub\wwwroot\wss\VirtualDirectories\ssp180

Error importing WebPart. Assembly Microsoft.Office.Server.Search, Version=OAssemblyAssemblyVer, Culture=neutral, PublicKeyToken=OAssemblyPublicKey, TypeName. Microsoft.Office.Server.Search.WebControls.ActiveCrawls

I deleted the SSP web apps again.
Stop the search query & index services.
Start the search query & index services.
Restart IIS.
Recreate the SSP web app.
Recreate the SSP & set back to default with any associations required.

Success - the SSP provisioned correctly.

Restore the DB from by opening the Content Database page in Central Administration. Delete the Temp DB then in STSADM associate the original DB:

cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN

stsadm.exe -o addcontentdb -url http://portal -databasename MOSS_MyDB_WSS_Content -databaseserver MyServer

If you receive the error 'An unexpected error has occured' open the web.config and update as follows:
http://blog.thekid.me.uk/archive/2007/02/15/a-solution-to-quot-an-unexpected-error-has-occurred-quot-in-wss-v3.aspx

Change <SafeMode MaxControls=“200“ CallStack=“false“ to <SafeMode MaxControls=“200“ CallStack=“true“…>
Set custom errors to 'Off' <customErrors mode=“Off“/>

Adding New SSP Administrators

2009-01-09T17:00:00.003Z

http://blogs.msdn.com/sgoodyear/archive/2007/06/20/adding-new-ssp-administrators.aspx

When you add a new user account to the SSP site, even if you grant them Full Control permissions or add them as a Site Collection Administrator, initially they will experience access denied error messages when they click on any of the following links on the SSP Admin page:

* User profiles and properties
* Profile services policies
* My Site settings
* Personalization services permissions
* Audiences
* Import application definition
* Business Data Catalog permissions

These sections need to have permissions explicitly set. Initially, the setup account will have full access to the SSP, so use that account to grant rights to new SSP administrators you wish to delegate SSP administrative duties to.

Notice the items highlighted in bold in the list above. These are where you assign the remaining SSP permissions. Adding new SSP administrators to the "Personalization services permissions" section and granting appropriate rights will grant rights related to the first five links in the list above. Repeating the process in the "Business Data Catalog permissions" section will grant rights related to the last two links.

At this point, the new SSP administrator has all the appropriate access permissions they need to administrate the SSP.

Event ID 0 - The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be found

2008-11-10T14:08:00.005Z

The Problem:

Event ID 0

The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Unable to open shim database version registry key - v2.0.50727.00000.

The Solution:

KB918642 - A .NET 2.0 application may require Read/Write permission to a registry

Download the hotfix and apply to the server displaying the error - in my case this was the Index server.

Event ID 7888

2008-11-10T13:52:00.008Z

The Problem:

I found the following error on my Index Server:

Event ID 7888

A runtime exception was detected. Details follow.
Message: Access Denied! Only site admin can access Data Source object from user profile DB.

Techinal Details:
System.UnauthorizedAccessException: Access Denied! Only site admin can access Data Source object from user profile DB.
at Microsoft.Office.Server.UserProfiles.SRPSite.
AdminCheck(String message)
at Microsoft.Office.Server.UserProfiles.DataSource.
_LoadDataSourceDef(IDataRecord rec)
at Microsoft.Office.Server.UserProfiles.DataSource.
_LoadDataSourceDef(String strDSName)
at Microsoft.Office.Server.UserProfiles.
DataSource..ctor(SRPSite site, Boolean fAllowEveryoneRead)
at Microsoft.Office.Server.UserProfiles.
DataSource..ctor(SRPSite site)
at Microsoft.Office.Server.UserProfiles.
UserProfileConfigManager.GetDataSource()
at Microsoft.Office.Server.UserProfiles.
BDCConnector.RefreshConfiguration(String sspName)

The Solution:

Open your SSP and navigate to Personalization Services Permissions.
Select Add User and add your SSP process account with Manage User Profiles permissions.

Crawl Scheduling Error - Access Denied

2008-11-10T12:00:00.010Z

When you set up your SSPs one of the things you will come across is Crawl Scheduling. This comes under Search Settings and allows you to configure Incremental Crawls and Full Crawls to the frequency you would like. For example, Full crawl once a day, Incremental Crawl every 5 minutes of each day.

The problem:

I received an error whilst building a new farm this week when trying to set the Crawl Schedules.

When I hit Ok I received the error:

ACCESS is DENIED. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

The Solution:

To fix this you need to add the account WSS_WPG to the C:\Windows\Tasks folder on your Index server and apply modify rights.

If you cannot see the Security tab on the Tasks folder you need to open a command prompt and type is:

attrib -s %windir%\tasks

When you right click on the tasks folder having done this you should be able to see the Sharing & Security option.

To remove the option once you have applied the changes to the folder open command prompt again and type:

attrib +s %windir%\tasks

Moving SharePoint Database Data and Log Files

2008-11-06T18:16:00.008Z

1. Quiesce the Farm
2. Backup all of the databases that you are looking to move.
3. Turn off SharePoint Services (via Services console) to stop the connections to the databases

a. Office SharePoint Search Service
b. Windows SharePoint Services Administration
c. Windows SharePoint Services Search
d. Windows SharePoint Services Timer
e. Windows SharePoint Services Tracing
f. World Wide Web Publishing Service

4. Detach the databases that need to be moved.
5. Navigate to where the data and log files are stored and copy them to your destination.
6. Reattach your databases.
7. Restart your services.
8. Un-quiesce the farm.