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