Microsoft Project Server 2007 Resource Kit


Project Server 2007 resource kit is available for download.

The Project Server 2007 Project Resource Kit tools consist of the following tools:

  • Portfolio Analyzer Views Migration: Allows an administrator to bulk edit the location of an analysis server for multiple data analysis views.
  • Project Server Settings Backup and Restore (Playbooks): Allows an administrator to backup Project Server settings and restore those settings to another Project Server.
  • Project Server Data Populator: Allows an administrator to populate Project Server with projects, resources and other objects. Useful for helping capacity and performance testing.
  • Project Workspace Site Relinker: Allows an administrator to relink the connection between Project Server and Project Workspace sites.
  • View Effective Rights: Allows an administrator to query the Project Server to determine the effective permissions of users against projects or resources.

http://www.microsoft.com/downloads/details.aspx?FamilyId=A33D253C-6424-48E4-B87E-0861D1977BB7&displaylang=en

Send Link in Email can cause problem if site URL has – e.g. my-portal.com


I am not sure but once I saw such post few months back explaining this but if you have a – in your moss portal link or dns, your send link in email functionality will not work properly because IE change the – to %2d.  To fix this issue you need to edit core .JS file

Core.js file is placed at

System Drive:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033

Open Core.js in notepad

If you have customized core.js before this search for L_SendToEmail_Text

if you have not customized core.js simply jump to line 3309

image

all you need to do is to encode the url to show – instead of %2d.  unescapeProperly method encodes the URL.

Simple press enter on line 3309

fileUrl = unescapeProperly(fileUrl);

If you wanted to test it add alert before and after fileURL variable.

Save Core.js and Refresh the page.

Go to a document library and using document drop down click Send To -> Send Link in Email

I hope this will solve your problem.

Jerry

Query to Get Project Assignment Time Phased


Project Server 2003 Query to Get Project Assignments as Timephased

SELECT     dbo.MSP_WEB_ASSIGNMENTS.TASK_NAME AS [Task Name], dbo.MSP_WEB_PROJECTS.PROJ_NAME AS Project,
                      dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeStart, dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeFinish,
                      dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeWork / 60000 AS [Work], dbo.MSP_WEB_RESOURCES.RES_NAME
FROM         dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY INNER JOIN
                      dbo.MSP_WEB_ASSIGNMENTS ON dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentUniqueID = dbo.MSP_WEB_ASSIGNMENTS.ASSN_UID AND
                      dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID = dbo.MSP_WEB_ASSIGNMENTS.WPROJ_ID INNER JOIN
                      dbo.MSP_WEB_PROJECTS ON dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID = dbo.MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN
                      dbo.MSP_WEB_RESOURCES ON dbo.MSP_WEB_ASSIGNMENTS.WRES_ID = dbo.MSP_WEB_RESOURCES.WRES_ID

 

Note: Please do test this query on local development environment before testing in on production.

Jerry

SQL Query to Get Project Resources by Role


I was developing some reports on Project Server 2003 recently, while working I got a Question.

Question : I need to get Projects, Its Resources, Resource Role in Project Server and Project Created by in a report.

The query to get this done is give below.

SELECT     MSP_PROJECTS.PROJ_NAME AS Project, MSP_WEB_RESOURCES.RES_NAME AS Resource,
                      MSP_WEB_SECURITY_GROUPS.WSEC_GRP_NAME AS [Role In Project], MSP_PROJECTS.PROJ_PROP_AUTHOR AS [Project Created By]
                      –MSP_RESOURCES.PROJ_ID, MSP_RESOURCES.RES_EUID, MSP_RESOURCES.RES_UID
FROM         MSP_WEB_SECURITY_GROUP_MEMBERS INNER JOIN
                      MSP_WEB_SECURITY_GROUPS ON
                      MSP_WEB_SECURITY_GROUP_MEMBERS.WSEC_GRP_GUID = MSP_WEB_SECURITY_GROUPS.WSEC_GRP_GUID INNER JOIN
                      MSP_WEB_RESOURCES ON MSP_WEB_SECURITY_GROUP_MEMBERS.WRES_GUID = MSP_WEB_RESOURCES.WRES_GUID INNER JOIN
                      MSP_PROJECTS INNER JOIN
                      MSP_RESOURCES ON MSP_PROJECTS.PROJ_ID = MSP_RESOURCES.PROJ_ID ON
                      MSP_WEB_RESOURCES.RES_EUID = MSP_RESOURCES.RES_UID
WHERE     (MSP_RESOURCES.RES_UID > 0) AND (MSP_RESOURCES.RES_EUID IS NOT NULL) AND (MSP_PROJECTS.PROJ_TYPE = 0)
ORDER BY Project, Resource, [Role In Project]

 

Note: Please do test this query in local server dev before using it on production environments.

Creating and using Multi value Custom Profile Property in MOSS 2007


1 .Go to Shared Services Administration: MOSS Shared Service > User Profile and Properties

2. Click Add Profile Property

3. Enter Profile Property Title and Display name

4. Select Allow Multiple Values and Allow Choice List.

5. Enter Description and Policy settings

6. Next we need to define the choices by clicking on Define Choice List.

7. Click on Add a new choice to create a new entry.

8. Leave the rest of the options as is

9. Click OK

10. To see the property Go to Shared Services Administration: MOSS Shared Service -> User Profile and Properties

11. Under Profile and Import Settings click on View User Profiles

12. Hover near the profile name and click Edit in the menu

13. The property will be visible at the end

14. Type or Click the + button add properties from choice list.

15. Double on a property to make it selected and click OK.

16. Click Save and Close from Profile Edit page

17. You can also type and Click the correction button.

Creating Audience based on Custom Profile Properties

  1. Go to Shared Services Administration: MOSS Shared Service and Click on Audiences

  1. On Manage Audience Page Click Create Audience

  1. Enter Audience Name and description and select audience owner.
  2. Select the rules either all rules or any rule option and click OK

  1. Now Select the Operand as “Property”
  2. Click the property dropdown and select Roles

  1. Select Operator and = or contains
  2. Type the value for Fee Earner

  1. Click OK

  1. Now we need to compile the audience
  2. On the Audience page Click on Compile Audience
  3. The number of member’s item will be filled with the number of members it has.

In the next post I will be posting about how to develop a custom tool that can update this property from any custom data source.

Few Interesting Links about Properties

Adding additional properties to the MOSS People Search

Found it! How to Add Properties To advanced Search in MOSS 2007

SharePoint 2007 Shared Services Provider User Profile Property Replicator

Get/Set custom profile properties in Profile Provider for MOSS

Deployment Tool: MOSS 2007 Utility to Replicate User Profile Schemas/Structure

Setting MOSS User Profile properties

Thanks to all these guys posting about it.

Jerry