SharePoint subsite size

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

SPSitedataquery paging rowlimit

http://nivas07.wordpress.com/2010/06/15/paging-using-spsitedataquery/

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.

Hide ListViewWebpart toolbar

http://www.etechplanet.com/blog/addingremoving-toolbar-from-custom-listviewwebpart.aspx

ListViewWebpart custom filter

http://sharepointlinks.blogspot.com/2008/05/listviewwebpart-my-own-filter.html

FBA - SP 2010 - Hell

http://blogs.devhorizon.com/reza/?p=472#more-472

OOTB SharePoint Approval Workflow Task Edit

Solution:
http://blogs.msdn.com/b/malag/archive/2009/05/20/how-to-programmatically-complete-approval-workflow-task.aspx

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 !!

SharePoint workflow based on WSP Builder.

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


Solution:
http://blog.hhebnes.no/post/WSPBuilder-Workflow-Failed-On-Start.aspx

SP 2010 PRO 71-576 exam - killing topics

FBA
BCS
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
/_layouts/.../mycss.css?12122010

Disable Kerberos on IE

One of the methods that default all requests to NTLM.

Configure Kerberos for SharePoint

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

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. 127.0.0.1

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

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.

SPBasePermissions bitwise OR sharepoint

Very useful

http://jamestsai.net/Blog/post/Understand-SharePoint-Permissions-Part-1-SPBasePermissions-in-Hex2c-Decimal-and-Binary-The-Basics.aspx

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.


/SharePoint:SPSecurityTrimmedControl

cqwp listname listGuid

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

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.

search server name mapping

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

e.g. http://mysite.com can be mapped to http://test.com

hence all people results will get mapped,

Username -> http://mysite.com/person.aspx?name=username -> http://test.com/person.aspx

simply create / provision a page at the root of site collection http://test.com

DNS Overview

All about DNS
http://technet.microsoft.com/en-us/library/bb727007.aspx

MVP Pattern - SP Web Part

http://msdn.microsoft.com/en-us/library/ee413740.aspx

http://weblogs.asp.net/bsimser/archive/2006/07/18/Model_2D00_View_2D00_Presenter-Pattern-with-SharePoint-Web-Parts.aspx

dropdownlist postback selectedindex 0

asp.net 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.

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

but

ddl -> America 1
Europe 1
Asia 2

is not correct

spquery and user field

http://www.stum.de/2008/02/06/querying-the-person-or-group-field-using-spquery/

Incoming email sharepoint

http://blogs.msdn.com/neilth/archive/2007/10/26/sharepoint-2007-incoming-email.aspx

Data Table distinct

http://support.microsoft.com/default.aspx?scid=kb;en-us;326176#1

web part properties custom

http://msdn.microsoft.com/en-us/library/dd584174(office.11).aspx

http://wp.rakhama.com/2009/10/saving-personalized-properties-in-a-sharepoint-webpart/

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
http://www.youtube.com/watch?v=3oXmP4o-gjY

MSPS - Project workspace template

http://msdn.microsoft.com/en-us/library/ms503640.aspx

strip html from string c# regex

System.Text.RegularExpressions.Regex.Replace(text, @"<(.|\n)*?>", string.Empty)

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();
site.Close();
return isMember;
}

Desktop experience feature in WIN2008

 

http://social.technet.microsoft.com/Forums/en-US/winservergen/thread/233bae03-4e9f-4dc6-89bc-0b729fbdf64a

Convert WIN2008 to Workstation

 

http://www.win2008workstation.com/

Enable wireless on Windows Server 2008 on laptop

http://sharepoint.microsoft.com/blogs/mikeg/Lists/Posts/Post.aspx?ID=1215

sp internal fields

http://www.tonstegeman.com/Blog/Lists/Posts/Post.aspx?List=70640fe5%2D28d9%2D464f%2Db1c9%2D91e07c8f7e47&ID=32

cqwp raw xml

http://vspug.com/radi/2009/03/17/content-query-web-part-getting-a-full-dump-of-the-raw-xml/

CQWP Date Time Format

ms:format-date
http://msdn.microsoft.com/en-us/library/ms256099.aspx

Disable Sharepoint designer on site

http://www.alpesh.nakars.com/blog/sharepoint-howto-disable-editing-sites-with-sharepoint-designer/

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.

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.

NATIVE PROJECT SERVER FEATURES:
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


DATA ANALYSIS
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.

OLAP:
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

Types:
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.)

Databases:
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

Terminology:
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.)


Architecture:
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

CAML Today

http://www.u2u.info/Blogs/Patrick/Lists/Posts/Post.aspx?ID=1782

Redirect to error page

http://geek.hubkey.com/2007/12/redirecting-to-error-page.html

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
Task
Custom Workflow task content type

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

Events Manager 2007

http://speventsmanager.codeplex.com/releases/view/14470

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.

Extend multiple upload page

http://rajendrashekhawat.blogspot.com/2008/08/redirecting-to-custom-application-page.html

http://msdn.microsoft.com/en-us/library/cc713554.aspx

SYLK - Excel - First two char ID

http://twelvestone.com/forum_thread/view/34186

read initiation data outside workflow context

Not possible so far

http://social.msdn.microsoft.com/Forums/en-US/sharepointworkflow/thread/e187ef89-73d7-4986-9de2-03dee7ecbce4

Send Email With Attachment

http://edwin.vriethoff.net/2007/10/02/how-to-send-an-e-mail-with-attachment-from-sharepoint/

Set value in people editor

PeopleEditor pe = new PeopleEditor();

pe.CommaSeparatedAccounts = "DomainName\\UserName";
pe.Validate();

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

http://jopx.blogspot.com/2008_11_01_archive.html

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

http://www.jamestsai.net/Blog/post/How-to-use-SharePoint-Delegate-Control-to-change-the-navigate-URL-of-Manage-Links-(My-Links).aspx

SPLongOperation

http://blogs.inetium.com/blogs/bcaauwe/archive/2007/12/20/splongoperation-sharepoint-spin-wheel.aspx

Workflow Dehydrate / Security Validation issues / Persistance

http://www.sharepoint-tips.com/2007/09/security-validation-for-this-page-is.html

http://ddkonline.blogspot.com/2009/06/sharepoint-2007-workflow-workflow.html

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.
}
}

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.

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

http://www.pptspaces.com/sharepointreporterblog/Lists/Posts/Post.aspx?List=7537e639%2Db4e5%2D48b6%2D97c0%2Da75e44ee9be3&ID=7

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

http://msbuildtasks.tigris.org/

Loopback check - SharePoint web application create access denied host header

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

Workflow for Access

Task:
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.