Monday, November 22, 2010

SharePoint subsite size

Easily get subsite using sharepoint designer. This is helpful when you need to estimate backup/restore and import/export activities.

Monday, October 25, 2010

Wednesday, October 20, 2010

CQWP ItemXslLink XSL

SharePoint 2007 CQWP ItemStyle and XSL properties need to be set to a relative path if the root site collection is under /sites managed path.

else it adds dot s and slash in the xsl property after pointing to a valid xsl file in itemxsllink property.

/../../Style Library

hence set itemxsllink to /sites/sitename/style library and everything should work fine.

Friday, October 15, 2010

Monday, September 27, 2010

Wednesday, September 1, 2010

OOTB SharePoint Approval Workflow Task Edit


Monday, August 23, 2010

Sharepoint URL field Cannot complete action

When declaring a URL field using xml definition do not use StaticName attribute otherwise it will not allow you to add the site url field to a list !!

Monday, June 28, 2010

SharePoint workflow based on WSP Builder.

Engine RunWorkflow: System.Workflow.ComponentModel.Compiler.WorkflowValidationFailedException


Thursday, June 3, 2010

SP 2010 PRO 71-576 exam - killing topics

Managed Metadata Service
Service Application Architecture

Clear CSS from browser cache - SharePoint

in theme.css where we reference all the .css files for the project add a unique parameter per build

Thursday, May 27, 2010

Monday, May 24, 2010

Configure Kerberos for SharePoint

Setup spns for the host headers, e.g. http/

ensure that the kerberos buffer size on IIS is greater than the max that could possibly be sent from a client. this may also need a buffer size change on client IE

ensure that host file entries on each wfe, point to itself, i.e.

ensure that F5 or any load balancer is configured for sticky sessions, i.e. once a client makes a request on server X, it remains on server X for sometime (predefined timeout) and does not get load balanced onto other servers in the F5 pool

bypass proxy in web.config of the applications on all wfe's: attached image

Wednesday, May 19, 2010

troubleshoot cqwp

If you think cqwp is getting unexpected results then start troubleshooting as below,
1. check query - especially all its fields
2. check viewfieldsoverride or commonfields - for all fields used in query.

Thursday, May 13, 2010

SPBasePermissions bitwise OR sharepoint

Very useful

Trim Hide controls based on permission

Sharepoint:SPSecurityTrimmedControl runat="server" PermissionsString="AddAndCustomizePages" PermissionContext="CurrentSite"

Any HTML or controls between these tags will only show for users who have the 'AddAndCustomizePages' permission.


Tuesday, April 27, 2010

cqwp listname listGuid

cqwp targetted to a specific list in a subsite will not work unitl we specify the listGuid.

Sunday, April 25, 2010

CQWP Mystery

if you are using cqwp with query override property, always set either commonviewfields or viewsfieldsoverride.

commonviewfields just requires the additional fields whereas viewfieldsoverride need the existing fields and the new fields.

Monday, April 12, 2010

search server name mapping

you can replace the server name from the crawled results with a user defined value.

e.g. can be mapped to

hence all people results will get mapped,

Username -> ->

simply create / provision a page at the root of site collection

Sunday, April 11, 2010

DNS Overview

All about DNS

MVP Pattern - SP Web Part

Thursday, April 1, 2010

dropdownlist postback selectedindex 0 dropdownlist should have unique value item, i.e.

ddl.items.add(new listitem(key, value)) -> here value should be unique
otherwise on postback you get incorrect selectedindex.

ddl -> America, 1
Europe, 2
Asia, 3
is correct


ddl -> America 1
Europe 1
Asia 2

is not correct

Wednesday, March 31, 2010

spquery and user field

Tuesday, March 30, 2010

Incoming email sharepoint

Monday, March 29, 2010

Saturday, March 27, 2010

web part properties custom

Wednesday, March 24, 2010

MPS Save to server dialog box

After connecting project professional to server 2007 if you still do not get the save to server dialog box when you click on save button,

choose the option below,

Connect Project Professional to Server 2007

Connect Project Professional to Server 2007

Monday, March 22, 2010

Check user in group

private bool IsMember()
bool isMember;
SPSite site = new SPSite(SiteURL);
SPWeb web = site.OpenWeb();
isMember = web.IsCurrentUserMemberOfGroup(web.Groups["GroupName"].ID); web.Close();
return isMember;

Friday, March 12, 2010

sp internal fields

cqwp raw xml

Thursday, March 11, 2010

Wednesday, March 10, 2010

Disable Sharepoint designer on site

Monday, March 8, 2010

Administration Task - Moving Farm environments

Scenario : A web application hosted on a multi server farm needs to be moved to a single server farm using the same shared database instance.

Implementation :
1. Build the single server farm environment from scratch and bring it upto the service pack level of the multi-server farm
2. Create the new web application
3. Install all solutions, perform custom farm configurations required by the web application
4. Detach the databases from the source farm (multi-server) web application.
5. Attach the databases to the destination farm (single server) web application

Test, Test, Test.

Sunday, March 7, 2010

MOPS - Life Cycle

1. Project Manager saves Project plan in MOPS. It is always saved to draft db and not visible in project center and assignments are also not visible

2. After publish -> project data is written to Published and Reporting databases.
If notification service is enabled each resource(Team Members) is sent an email.

3. Team members can update their tasks and submit timesheets(if enabled). These updates are not visible until manager approves them.

4. manager accepts or rejects updates from team members.

**Rules can be set to process updates. These rules cannot be run automatically.

5. After reviewing changes the latest scheduling changes are saved to draft.

6.manager publishes changes.

7. Using Project Center, executives can view all/individual projects in portfolio.
Report analysis can also be done.

1. Status Reports
2. Automated alerts and reminders
3. Outlook Integration
4. Task delegation
5. Ad hoc reporting
6. Issues log
7. Risks log
8. Documents
9. Proposals
10. Resource plans
11. Activity plans
12. Time sheets
13. Deliverables

MOPS 2007 provides 14 cubes OOTB.
Control over specific fields to be introduced as a part of a dimension in a OLAP cube. It also includes task data in cubes.

no default data analysis views ship with the product.

multidimensional view of a project, task and resource data. The relational database structure is 2D. OLAP consists of,
a. preprocessed 3D data
b. typically time-phased and
c. aggregated by business dimension.

MOPS - Infrastructure

1. Stand Alone - does not have analysis service and so you loose reporting capabilities. Not scalable
2. Server farm

Recommended / Based on requirement :
seperate data and application (with NLB and multiple boxes in each.)

1. Draft - All changes until publishing
2. Published - all published content, security and timesheet information
3. Archive - backup project plans
4. Reporting - After project data is published, system write info to reporting db. Near real time information for reporting.

Project Server 2007 - Overview

1. Enterprise capable project management automation system.
2. compliant with PMI
3. used for project assignment and tracking system ootb and customizable business specific configuration
4. Office Project -> .mpp files (local plans, non shared resources, versioning issues with emails, project must be installed on client, cross project dependencies)
5. Solution is Project Server - PWA(web access) and server hosting of project plans

1. project : A temporary endeavor undertaken to create a unique product or service.
has start and end time defined. It is always unique.
2. program : is a collection of related projects
3. portfolio : is a collection of programs/projects withing organization(BU or enterprise)
depends on size of organization
Model these in Project Server

Microsoft Office Project Server 2007 specific terminology:

Enterprise project : Create a project using MS Project client and save it to Project Server db or imported projects

Enterprise Resource : Create / Import resource in Enterprise Resource Pool

Check in / Check out

Resource Pool:
1. contains resources and resource attribution that drive functionality.
2. e.g. resource attribution: dept, location, practice groups
3. Resource substitution wizard : analyzes resources in pool to identify skills and avilability of staff for all projects. they can be used as recommendations or final results in the plan.

Global Overview:
1. Global.mpt file and enterprise global file (Views, Tables, Filters, Groups, Reports etc.)

1. PWA works in SharePoint
2. Queying service only ships data that changed across the network.
Hence it supports WAN and Internet connectivity without bandwidth and latency limitations
3. PSI (project server interface) programming model.
4. Request and Demand Management :
a. Project proposal & Resource Plans - support project request and predict resource demand.
b. Flow: Project Proposal - allows authorized users to enter project request.
MOSS - used to route proposal through approval workflows
Any actor in the workflow can use Resource Plan to apply time phased work demand by resource type and skill set to proposal.
After publish, data populates to portfolio where data analysis tools assist in project selection.
5. Timesheets
6. WSS is bare minimum required for MOPS.

*** Microsoft Office Project 2007 Standard cannot connect to project server whereas MOP 2007 Professional can.

2003 and 2007 are not compatible.
why MOSS is included in EPM suite:
a. document versioning
b. workflow

Thursday, March 4, 2010

Tuesday, March 2, 2010

Edit url for task item

workflowProperties.TaskList.Forms[PAGETYPE.PAGE_EDITFORM].Url returns incorrect url when the following content types are added to workflow task list,

Office SharePoint Server Workflow Task
Workflow Task
Custom Workflow task content type

Created new task list and assigned only the following content types,
Custom Workflow task content type
Office SharePoint Server Workflow Task

Friday, February 26, 2010

Friday, February 19, 2010

Multiple Upload Page - Assign metadata

1. Create an override for the upload page

2. Do forget to call base.OnLoad(e) in your overriden OnLoad page

3. Set this.ConfirmationURL parameter to absolute path of a custom layouts page in the overriden upload page Onload method.

4. Call the overriden upload page using a custom action on the list and pass the same url parameters that SP passes to an OOTB Multiple file upload page

5. On the new custom page, collect user input and using ListItem.SystemUpdate(false) to set the required metadata fields. Once the metadata is set, navigate back to list default view.

Thursday, February 18, 2010

Extend multiple upload page

SYLK - Excel - First two char ID

Tuesday, February 16, 2010

read initiation data outside workflow context

Not possible so far

Monday, February 15, 2010

Send Email With Attachment

Set value in people editor

PeopleEditor pe = new PeopleEditor();

pe.CommaSeparatedAccounts = "DomainName\\UserName";

PeopleEditor - Select Multiple and include spgroups

SharePoint:PeopleEditor ID="pEditor" runat="server" ValidatorEnabled="true" AllowEmpty="true" MultiSelect="true" SelectionSet="User,DL,SecGroup,SPGroup"

SPLongOperation - thread abort

WSPBuilder resetwebserver avoid iisreset

C:\Program Files\WSPTools\WSPBuilderExtensions\WSPBuilder.exe.config

ResetWebServer = false

SP Delegate Control - MyLinks Quick Links

SharePoint Delegate control and change "My Links" navigation location


Sunday, February 14, 2010

Workflow Dehydrate / Security Validation issues / Persistance

Guid siteID = workflowProperties.Site.ID;
Guid webID = workflowProperties.Web.ID;

using (site = new SPSite(siteID))
using (web = site.OpenWeb(webID))
//write wf code within this.

Friday, February 12, 2010

Backup/Restore vs Import/Export

Backup restore should not be used when we suspect that there is a db corruption and we should be using import/export.

Thursday, February 11, 2010

On creation of new seq workflow using vs 2008 - references not linked

system.workflow.activities, .componentmodel, .runtime are missing.

Solution :
Always remember to create wspbuilder + workflow based project
Change target framerwork to 3.0

Good to go.!

VPC Creation process

Wednesday, February 10, 2010

Pre-requisites for the Wouter - SP Workflow framework

1. Install WIX
2. Install MSBuild Community Tasks
3. Set the configuration to "ReleaseSigned"
4. Enter p Thomson

MSBuild Community

Loopback check - SharePoint web application create access denied host header

Workflow for Access

Assign permissions based on field values, i.e. ColumnName: Person name; Value: Semicoln seperated user names; PermissionValue: Contribute
Each item gets permission based on the above field values.

Idea 1:
Create eventhandler

Idea 2
Use workflow.
Association data - List of fields
- Permission values
Workflow get initiated every time an item is updated or added.
Uses association data and toggles permissions on the item.