Project Programmability

This blog focuses on customizations and programming for Project Web App, Project Server, Project Professional and Project Standard. Includes User Interface (UI) customizations, Project Server Interface (PSI) and Visual Basic for Applications (VBA) Programming. It also covers Business Intelligence.
 
 

  • Project Programmability and Business Intelligence

    Project Initiation Phase using InfoPath & Forms Services

    • 1 Comments

    Christophe just passed along some information about a new solution starter on CodePlex:

    Hello,

    A new solution starter that demonstrates how to leverage InfoPath & Forms Services as well Windows Workflow Foundation (hosted by SharePoint) to create your own project initiation phase has been released on CodePlex.

    The project initiation phase is different for every customers and organizations. It typically requires a set of custom attribute to be filled in a web based custom form; and then it needs to go through a custom approval process workflow reviewed by all key decision makers. InfoPath Forms services combined with a SharePoint’s sequential workflow enables you to achieve this business need. This solution starter also demonstrates the added value of deploying Project Server 2007 in a SharePoint Server farm (using InfoPath Forms Services).

    The goal of this solution starter is thus to provide the following two code samples:

    • InfoPath Form with managed code that issues Project Server Interface calls to populate and submit form data
    • SharePoint sequential workflow that leverages the form created earlier to create a custom workflow

    This solution starter requires Project Server 2007, InfoPath and Forms Services 2007, and Visual Studio 2008.

    Step 1 – Fill out and submit Project Initiation Form

    Step 2 – Approve data submitted in Step 1 and create Project in PS 2007

    Resulting data in Project Server 2007

    clip_image001 clip_image002 clip_image003

    This solution starter was created for a presentation I delivered at the 2008 Office Developer Conference.

    If you are aware of any useful tools/solutions for Project and Portfolio Server 2007 and you would like to share them with the community via CodePlex please send me an email.


    About CodePlex

    CodePlex is Microsoft's open source project hosting web site. You can use CodePlex to create new projects to share with the world, join others who have already started their own projects, or use the applications on this site and provide feedback. A word about Microsoft’s role: Microsoft does not control, review, revise, endorse or distribute the third party projects on this site. Microsoft is hosting the CodePlex site solely as a web storage site as a service to the developer community.

    Q&A

    Q: Is the tool supported?

    A: There is no support in terms of CSS/PSS. We expect the support being a CodePlex community effort. Please note that the customization code uses standard supported web service calls available out of the box in EPM2007.

    Q: Is the tool free?

    A: Yes.

    Q: Can I distribute the tool and the source code to customers and partners?

    A: Customers and Partners can use both. Please point them to CodePlex as they have to agree on the license terms

    Q: Can a partner distribute the tool and code as is?

    A: No, but he can point his customer to the website to download it, so he makes sure that the customer agrees with the license terms.

    Q: Can a customer install the customization and use it?

    A: Yes the customer can, but he/she is responsible for testing it and running it.

    Q: Can I suggest changes to it?

    A: Yes, join the CodePlex community or send us an email: epmssdev@microsoft.com

    Q: Will this tool be distributed in other ways (i.e. DVDs)?

    A: No.

    Q: What skills do I need to modify or change the tool?

    A: C#, Project Server Interface, and a good understanding of the EPM 2007 data schema.

    Q: I’m trying to modify the code and do have questions. Who do I ask?

    A: Go to the Discussions forums on CodePlex.

    Q: What are all the EPM projects released on CodePlex?

    A. Check this: http://www.codeplex.com/Project/ProjectDirectory.aspx?ProjectSearchText=epm

    Regards,

    Christophe Fiessinger

  • Project Programmability and Business Intelligence

    Project Portfolio Server 2007 SP1

    • 1 Comments

    Hello,

    The Project Portfolio Server 2007 SP1 is now available:

    http://www.microsoft.com/downloads/details.aspx?FamilyID=7cf44f2c-49d5-4431-bd3e-a10035ec1a39&displaylang=en

    For a list of what is fixed in SP1, check out:

    http://support.microsoft.com/?kbid=942722

    Chris

    Tags:

  • Project Programmability and Business Intelligence

    Project Server 2007 Timesheet Data Population Tool

    • 1 Comments
    Technorati tags: , ,

    Bonjour,

    The Project Server 2007 timesheet data population tool has been released on CodePlex: http://www.codeplex.com/EPMTSdatapop

    The Project Server 2007 Timesheet Data Population Tool enables you to simulate timesheet entries in your farm. This tool can help you perform scalability studies of your PS architecture and validate the sizing of an existing architecture (by measuring timesheet queue throughput for instance). This tool can also be used to test timesheet customization, for instance the Timesheet Tied-mode code sample on Codeplex. This powerful tool should not be run a production environment!

    The Timesheet Data Population tool is a console application written in C#.  It uses standard PSI (Project Server Interface) web service methods to populate timesheets.

    Please refer to the latest version of the Project Server Software Development Kit (SDK) for more information on the PSI methods and how to use them.

    This solution starter was written initially to perform Project Server 2003 vs. Project Server 2007 benchmarks, and has been used since to perform scalability studies and to test timesheet customizations.

    A special thank you to Isabel Bernardos and Steven Haden for helping me write and test the tool during PS 2007 scalability studies for large European customers. 

    If you are aware of any useful tools/solutions for Project and Portfolio Server 2007 and you would like to share them with the community via CodePlex please send me an email.


    About CodePlex

    CodePlex is Microsoft's open source project hosting web site. You can use CodePlex to create new projects to share with the world, join others who have already started their own projects, or use the applications on this site and provide feedback. A word about Microsoft’s role: Microsoft does not control, review, revise, endorse or distribute the third party projects on this site. Microsoft is hosting the CodePlex site solely as a web storage site as a service to the developer community.

    Q&A

    Q: Is the tool supported?

    A: There is no support in terms of CSS/PSS. We expect the support being a CodePlex community effort. Please note that the customization code uses standard supported web service calls available out of the box in EPM2007.

    Q: Is the tool free?

    A: Yes.

    Q: Can I distribute the tool and the source code to customers and partners?

    A: Customers and Partners can use both. Please go to CodePlex to agree on the license terms

    Q: Can a partner distribute the tool and code as is?

    A: No, but partners can point their customer to the website to download it.

    Q: Can a customer install the customization and use it?

    A: Yes the customer can, but he/she is responsible for testing it and running it.

    Q: Can I suggest changes to it?

    A: Yes, join the CodePlex community or send us an email: epmssdev@microsoft.com

    Q: Will this tool be distributed in other ways (i.e. DVDs)?

    A: No.

    Q: What skills do I need to modify or change the tool?

    A: C#, Project Server Interface, and a good understanding of the EPM 2007 data schema.

    Q: I’m trying to modify the code and do have questions. Who do I ask?

    A: Go to the Discussions forums on CodePlex.

    Q: What are all the EPM projects released on CodePlex?

    A. Check this: http://www.codeplex.com/Project/ProjectDirectory.aspx?ProjectSearchText=epm

    Regards,

    Christophe Fiessinger

  • Project Programmability and Business Intelligence

    Implementing My Tasks “Read Only Custom Fields”

    • 1 Comments

    Using Project Server 2007’s Reporting Database and SQL Server Reporting Services 2005

    The attached report illustrates how to safely query the RDB to allow team members to see a read only view of task assignment data. We’ve picked a random task custom field to illustrate the concept. I’ve deliberately defined the report to use “drill down” by Project Name to mimic the My Tasks grid behavior and to (UI) scale for users with lots of task assignments.

    The figure below illustrates the My Tasks web part placed above the Report Viewer web part which is displaying the sample report.

    image

    Customizing and Installing the Report

    1. Use the SQL Server 2005 Business Intelligence Workbench (available with SQL Server 2005) to customize the report to add the fields and custom fields that you want to display to your users.
    2. Customize the report’s data source to connect to your Reporting Database.

      Note that when you deploy this report to the server you should ensure that the data source is customized with a cached userid and password that has access to read the Reporting Database. These credentials are used to avoid prompting the user for credentials and are stored securely in SQL Server.

       image
    3. Add the Reporting Services Report Viewer web part to the My Tasks page and edit the web part properties to point to the report.

      image

      Note the non-default web part settings for the report viewer:

      - Tool Bar: Small (the user needs to be able to enter the date filter)
      - Fixed Height: 12 Inches

    Notes on Implementation

    The report has two parameters that are used in the query:

    1. (Hidden) UserAccount is the userid – this is used to get the caller’s ResourceUID and hence filter assignments correctly, this should never be “unhidden” as the user could then enter any userid with the risk of information disclosure.
    2. TimeFilter – defaults to two weeks previous from “now”, but can then be set by the caller to any date via the calendar picker. It filters out all task assignments that started before that date. [Note that you could get creative here and add different/additional filters if you want]. Use Report/Report Parameters to edit the default setting if required.
    3. Note that the query filters out “unpublished” task assignments – when a project is published its data moves to the Reporting database. Task assignments only move to the My Tasks “statusing” tables if the Project Manager has decided that they be published.

    Other notes on deployment

    To maximize performance we avoided use of the _Userview SQL Views and referenced the underlying tables. If you want to access Task Assignment custom fields (the example show Task Custom Fields) then the query in the report will need to be reworked slightly, this should be trivial.

    The RDB is only minimally indexed. We strongly recommend the addition of secondary indexes on the following tables:

    Msp_Epm_Resource (Composite on ResourceNTAccount, ResourceUID)

    Msp_Epm_Assignment (Composite on ResourceUID, AssignmentStartDate)

    Finally…

    And if you are delivering a small sub set of custom fields you could consider an indexed view over those fields to maximize performance.

    Patrick Conlan

  • Project Programmability and Business Intelligence

    December update of the Project 2007 SDK

    • 1 Comments

    Hello,

    Jim Corbin has just passed along the following:

    The December update of the Project 2007 SDK download and the MSDN online release are both published. This is the third SDK update published since the RTM release of the SDK in November 2006. The first update was published in April and the second in July, 2007.

    Project Developer Portal: http://msdn2.microsoft.com/en-us/office/aa905469.aspx

    SDK Online:  Project 2007 SDK in MSDN online library: http://msdn2.microsoft.com/en-us/library/ms512767.aspx

    SDK Download:  http://www.microsoft.com/downloads/details.aspx?FamilyId=2672F6F9-7028-4B30-99A2-18CB1EED1ABE&displaylang=en

    What’s New

    In addition to several documentation fixes, the following content is new or extensively updated.

    Articles:

    · ERP Connector Solution Starter (20 topics)

    · How to: Customize E-Mail for Project Server Notifications  – this is an update of the project_programmability blog post.

    · Project XML Data Interchange Schema Reference includes the following topics:

    · New XML Elements

    · Custom Field Data in XML

    · Saving and Opening Projects in XML Format

    · How to: Use XSLT Transformations with Project XML Data Interchange Files

    · Project Data Interchange Elements includes reference topics for all of the schema sections, XML structure, and XML elements.

    PSI Managed Code Reference:

    · Additional descriptions of row properties in the following datasets in the Project Server Interface (PSI): LookupTableDataSetLookupTableMultiLangDataSet, AlertSubscriptionInfoDataSet, ReminderSubscriptionInfoDataSet, QueueStatusDataSet, QueueStatusRequestDataSet, StatusingSettingsDataSet.

    · Additional descriptions for event receiver methods.

    Download:

    · ERP Connector:   Complete sample source code and test application for the ERP Connector.

    · XML Schema:  Revised XML data interchange schema, mspdi_pj12.xsd.
    Note: The Project XML schema is also now published on http://schemas.microsoft.com/project/2007.

    · ProjTool:   Now includes a dialog box for backup and restore of selected projects.

    · SP1 library assembly: Redistribution license for the SP1 build of the Microsoft.Office.Project.Server.Library.dll assembly, and 32- and 64-bit copies of the assembly.

  • Project Programmability and Business Intelligence

    Update on the ODC 2008

    • 1 Comments

    Hello,

    This is a follow up from my previous post about the ODC 2008. Just wanted to let you know that the ODC 2008 will have some specific Project Server sessions:

    Session Title Speaker Name Abstract
    Building a custom Webservice to query the EPM datastore and render the data in Excel 2007 Christophe Fiessinger This session will teach you how to develop a custom wss webservice querrying the Project Server database and displaying the resulst in an Excel 2007 AddIn
    Creating projects in Project Server using Forms Server and WinWF Christophe Fiessinger This session will show you how to develop a solution that creates projects in Project Server using Forms Server and WinWF
    Displaying Project Server data in an Ajax.NET WebPart Boris Scholl This session shows you how to develop an Ajax webpart displaying data from Project Server in a Windows Live Map.


    You can view all the session abstracts by track following these links:

    Client Track - http://blogs.msdn.com/odc2008clienttrackblog/archive/2007/11/30/list-of-sessions-in-odc-client-track.aspx

    Architect Track - http://blogs.msdn.com/odc2008architecture/archive/2007/11/07/breakout-session-abstracts.aspx

    Real World Track - http://blogs.msdn.com/odcrealworldtrackblog/archive/2007/11/30/odc-2008-real-world-session-tracks-ready-for-review-a-work-in-progress.aspx

    Server Track - http://blogs.msdn.com/odcservertrackblog/archive/2007/12/01/server-track-draft-session-list.aspx

    Services Track - http://blogs.msdn.com/rbarker/archive/2007/12/03/99-7-there-for-the-odc-services-track-sessions.aspx

    Chris Boyd

  • Project Programmability and Business Intelligence

    Two new Project Server 2007 tools have been released on CodePlex today

    • 1 Comments

    Hello,

    Two new Project Server 2007 tools have been released on CodePlex today:

    EPM 2007 Log File Report tool EPM 2007 Queue Watch tool
    http://www.codeplex.com/EPMLogFileReport http://www.codeplex.com/EPMQueueWatch
    The Project Server 2007 Log File Report Tool enables the import and the reporting of log file generated by your EPM & SharePoint farm. The Log File Report Tool will import log files (in an SQL database) from all servers in your farm with the ability to filter them by date. Once the import is complete you can easily search for specific log file messages using the following filtering criteria: Area, Category, Level, Process, Server as well as date and created reports.

    The Project Server 2007 Queue Watch Tool will help you monitor all queue activities for a specific Project Web Access (PWA) instance. This tool leverages the standard Project Server Interface publically documented web services to query and retrieve jobs in the Project Server queues, further you can configure the tool to filter the information retrieved by Message Types and Job types.

    The Queue Watch Tool is available as a WinForms application. It was written by EPM World Wide Center of Excellence (WW COE) to efficiently monitor and troubleshoot queue activities for Project Server 2007 farms.

    MWSnap052 2007-12-12, 10_44_28 MWSnap071 2007-12-14, 12_45_33
    This release contains documentation, setup, and source code. This release contains documentation, setup, and source code.


    About CodePlex

    CodePlex is Microsoft's open source project hosting web site. You can use CodePlex to create new projects to share with the world, join others who have already started their own projects, or use the applications on this site and provide feedback. A word about Microsoft’s role: Microsoft does not control, review, revise, endorse or distribute the third party projects on this site. Microsoft is hosting the CodePlex site solely as a web storage site as a service to the developer community.

    Q&A

    Q: Is the tool supported?

    A: There is no support in terms of CSS/PSS. We expect the support being a CodePlex community effort. Please note that the customization code uses standard supported web service calls available out of the box in EPM2007.

    Q: Is the tool free?

    A: Yes.

    Q: Can I distribute the tool and the source code to customers and partners?

    A: Customers and Partners can use both. Please point them to CodePlex as they have to agree on the license terms

    Q: Can a partner distribute the tool and code as is?

    A: No, but he can point his customer to the website to download it, so he makes sure that the customer agrees with the license terms.

    Q: Can a customer install the customization and use it?

    A: Yes the customer can, but he/she is responsible for testing it and running it.

    Q: Can I suggest changes to it?

    A: Yes, join the CodePlex community or send us an email: epmssdev@microsoft.com

    Q: Will this tool be distributed in other ways (i.e. DVDs)?

    A: No.

    Q: What skills do I need to modify or change the tool?

    A: C#, Project Server Interface, and a good understanding of the EPM 2007 data schema.

    Q: I’m trying to modify the code and do have questions. Who do I ask?

    A: Go to the Discussions forums on CodePlex.

    Q: What are all the EPM projects released on CodePlex?

    A. Check this: http://www.codeplex.com/Project/ProjectDirectory.aspx?ProjectSearchText=epm

    Regards,

    Christophe Fiessinger

  • Project Programmability and Business Intelligence

    Microsoft Office Project Conference 2007 – Security Wiper

    • 1 Comments
    NOTE: Please do not run this on a production environment without careful thought and planning. Always test it on a backup and verify everything is okay before doing anything

    Hi, Phil Smail here again. Again some more code I wrote for the MOPC that I wanted to put up onto the blog.

    This code originally came about because a internal Microsoft group had got to the stage where their security permissions were out of control. This was mainly due to an initial lack of understanding of the security model and they wanted to get to a state where all the users, other than Admins have their permissions wiped so a proper security model can be put in place.

    The tool looks like the following when run:

    image

    First thing is to enter the URL of the site you want to connect to then click on the 'Connect to Server' button.

    This then populates the 'Admin Group' dropdown with the list of Groups on the server. When you click 'Reset Perms' then it will run through every user and remove them from all Groups and Categories they belong to as well as removing all Global Permissions set on users directly. This is the case except for the group that you select as the Admin group. All users that belong to that group will continue to belong to that group.  Once the tool is run then the Admins, who should still belong to the chosen 'Admin Group' can go about giving users the permissions following security best practice.

    A Dry Run checkbox is checked by default and this will run the test to see how much will be removed and display it in the textbox below. You should definitely run it in Dry Run mode before removing any permissions for real.

    In this case the output would look something like the following:

    image

    NOTE: Please do not run this on a production environment without careful thought and planning. Always test it on a backup and verify everything is okay before doing anything
  • Project Programmability and Business Intelligence

    Update of Impersonation Article and Code for Project Server 2010

    • 1 Comments

    Because there have been several recent changes in the post-beta version of Project Server 2010 and Office SharePoint Server 2010, the article How to: Use Impersonation with WCF in the January 2010 release of the SDK is not correct for the 4730.1010 and later builds of Project Server. The article in the March 2010 release of the SDK is correct. The attached Impersonation_PSIProxy.zip file includes the following:

    • Revised article: How to: Use Impersonation with WCF.docx
      • Changes required to use a Project Server installation that has multi-authentication (both Windows and Forms authentication)
      • Procedures for setting permissions for impersonation (requires permissions in both the SharePoint Service application and in Project Web App)
    • Complete Visual Studio 2008 solution (can be opened and converted with Visual Studio 2010)
    • Proxy files for the PSI services (build 4730.1010), including:
      • Scripts to update the proxy files on a Project Server computer and build a PSI proxy assembly
      • Intellisense files
      • Temporary web.config file and instructions, to use when updating the proxy files

     

  • Project Programmability and Business Intelligence

    MSDN WebCasts – Project Programmability Series and Other Updates

    • 1 Comments

    We are getting into the middle of the Project Server Programmability series by Larry Duff – this is the newest agenda and dates:

    Name

    Description

    Presenter

    Date/Time

    MSDN Webcast: Office Project Server Programmability (Part 1 of 4): Project Server 2007 Architecture for Developers (Level 400)

    During this webcast, we analyze all of the components that make up Project Server 2007. Once we examine the components, we discuss their importance in programming Microsoft Office Project Server 2007.

    Larry Duff, Microsoft

    On Demand Recording

    MSDN Webcast: Office Project Server Programmability (Part 2 of 4): Project Server Interface Programming Overview (Level 300)

    In this webcast, we provide an overview of what the Microsoft Project Server Interface (PSI) is and how the PSI is built. We also discuss the concepts of using Web services, custom datasets, and error handling.

    Larry Duff, Microsoft

    On Demand Recording

    Revised: MSDN Webcast: Office Project Server Programmability (Part 3 of 4): Review of the Project Server Interface Web Services – PART A (Level 400)

    In this webcast, we walk you through each of the Microsoft Project Server Interface (PSI) Web services, identify key usage of each of the Web services, and provide tips and tricks for working with PSI Web services. 

    Part A of this WebCast covers the following Administrative PSIs: Admin, Archive, CubeAdmin, Events, LoginForms, LoginWindows, Notifications, ObjectLinkProvider, QueueSystem, WssInterop.

    Larry Duff, Microsoft

    Thursday, March 26, 2009

    8:00 A.M.–9:30 A.M. Pacific Time

    Revised: MSDN Webcast: Office Project Server Programmability (Part 3 of 4): Review of the Project Server Interface Web Services – PART B (Level 400)

    In this webcast, we walk you through each of the Microsoft Project Server Interface (PSI) Web services, identify key usage of each of the Web services, and provide tips and tricks for working with PSI Web services.

    Part B of this WebCast covers the following Project PSIs: Calendar, CustomFields, LookupTable, Project, Resource, ResourcePlan, Security, Statusing, TimeSheet.

    Larry Duff, Microsoft

    Thursday, April 2, 2009

    8:00 A.M.–9:30 A.M. Pacific Time

    New Date: MSDN Webcast: Office Project Server Programmability (Part 4 of 4): Project Server 2007 Events and Workflow (Level 400)

    During this webcast, we describe how events extend Microsoft Office Project Server 2007, build handlers for different events explaining when or when not to use them, and demonstrate how to use workflow as a way to illustrate event usage.

    Larry Duff, Microsoft

    Thursday, April 16, 2009

    8:00 A.M.–9:30 A.M. Pacific Time

  • Project Programmability and Business Intelligence

    Sweeten your Project 2010 environment with Custom Fields

    • 1 Comments

    The Project 2010 SDK nicely documents Custom Field functionality – very important functionality for customizing Project 2010 - Custom Fields enable you to capture and calculate additional metadata for Projects, Resources, Tasks and Assignments. Project 2010 SDK: “You can filter, group, sort, and create OLAP cubes and reports based on custom field values. Project 2010 extends the functionality and ease of use of custom fields compared to previous versions of Project.” – lot of power and relatively easy to do! However – proper planning is strongly advised :)

    Project 2010 SDK: Custom Fields in Project 2010 (http://msdn.microsoft.com/en-us/library/ee767683(office.14).aspx)

    Many executives like graphical indicators – that simple graphically show the values in your Custom Fields (Visual Studio not required, all could be configured via PWA or Project Desktop User Interface, even when an advanced calculation formula is required) -

    Using Formulas and Graphical Indicators with Custom Fields (http://msdn.microsoft.com/en-us/library/ee767700(office.14).aspx)

    Using graphical indicators in Project

  • Project Programmability and Business Intelligence

    Upcoming “Project Server Report Pack II - The top reports” WebCast

    • 1 Comments

    Please mark your calendar if you are interested! Are you asking what is the difference between the SDK Report Pack and this one? Think about the SDK version as the starter on “HOW” to write queries against Reporting database. This should go one step further – once you know HOW – you are interested in “WHAT” to bubble into your reports and “WHY” :)  This report pack has been built by top Microsoft Consultants who deploy/manage and enhance the “our” EPM solution for individual customers and contains very valuable know-how that they have collected over the years...

    Start Date: Wednesday, August 19, 2009 8:00 AM Pacific Time (US & Canada)

    Overview

    The “Microsoft Office Enterprise Project Management (EPM) 2007 Report Pack II -  The top reports” provides rich reports for common information needs. The EPM 2007 Report Pack II is a collection of 12 Microsoft SQL Server Reporting Services (SSRS) reports designed for various user groups of the EPM solution. In this webcast, we provide an overview and demonstration of the EPM 2007 Report Pack. We discuss the different usage scenarios the reports are tailored to fit and review the components used to move, store, and render the reports. With this information, you should have a better understanding of how to use the EPM 2007 Report Pack II to provide business value for your organization.

    Presenters: Bulent Guzel, Senior Consultant, Microsoft Corporation and T.R. Sloan, Solutions Architect, Microsoft Corporation

    Registration: https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032423031

    Enjoy!

  • Project Programmability and Business Intelligence

    TechED Europe - Microsoft Project 2010 Overview PowerPoint Deck

    • 1 Comments

    We did two Project 2010 sessions at TechEd Europe – Christophe (thanks!) posted the decks on SkyDrive here as he mentioned here http://blogs.msdn.com/chrisfie/archive/2009/12/22/microsoft-project-2010-overview-powerpoint-deck.aspx

    We have also shot two short videos on the 2010 news for Developers and  IT Professionals as mentioned here.

    Happy holidays!

  • Project Programmability and Business Intelligence

    Two More MSDN Webcasts Coming

    • 1 Comments

    It seems like I’ve been doing Project Programmability webcasts for months… oh yeah I have :).  There are still two more left, check them out:

    Date

    Session Title

    April 23, 2009 Office Project Client Programmability
    May 14, 2009

    EPMAuditing Solution Starter Drilldown

    Both start at 8:00 AM PDT.

  • Project Programmability and Business Intelligence

    Project and Portfolio Management (PPM/EPM) VPC v4 – based on Project 2007

    • 1 Comments

    Hi there! Just released the next version of the VPC based on Project 2007. It also includes Visual Studio 2008!

    Highlights:

    • New SSRS reports to showcase the upcoming report pack (will be announced later in August)
    • SP2 and April Cumulative Update for Project, Project Server, WSS, and SharePoint Server
    • Usage must adhere to EULA terms: “…You may use the software in the virtual hard disk image only to demonstrate and internally evaluate it.  You may not use the software in a live operating environment…
    • Recommended HW configuration is 2 GB RAM (available for the VPC) and performance Hard Drive

    Hosted Version

    VPC and script are accessible as hosted TechNet Virtual Lab http://go.microsoft.com/?linkid=9665059

    Image download

    Please email Proj2007@microsoft.com for download links.

    Q&A:

    • Q: Where is the demo script?
      • A: It’s part of the compressed archive. Alternatively you can use the original v2 demo script.
    • Q: Is the SP2 for Project Portfolio Server 2007 installed in this VPC final?
      • A: Project Portfolio Server (PPS) SP2 installed in this VPC v4 is not the version of officially released SP2 for PPS, but on parity feature-wise.
    • Q: Why is the http://epm2007demo URL not in the IE’s Trusted sites anymore?
      • A: Feel free to add the server URL into the IE Trusted sites list, especially if you are demoing the “out-of-the-box” reporting capabilities of Project Server that are using the Office Web Components. Else we discourage you to  do so as you might get prompted for credentials on every time you try to access any sub-site in the http://epm2007demo location.
    • Q: Where can I learn more about Project 2010?

    Thanks!

    JKalis

  • Project Programmability and Business Intelligence

    Japanese Project Server 2007 SDK

    • 1 Comments

    The Project Server 2007 SDK is now available in Japanese:

    http://msdn.microsoft.com/ja-jp/library/bb187370.aspx

    Chris Boyd

  • Project Programmability and Business Intelligence

    Project Developer Center has a new design!

    • 1 Comments

    Our “very” own Project Developer Center got a new design by the MSDN writers – it means richer and more discoverable content for you! Check it out, it’s really stunning!

    Thanks for the hard work to Jim and Verna! As always any feedback, comments, ideas could be directed to EPMDev@microsoft.com.

    Jan

  • Project Programmability and Business Intelligence

    Project SP2!

    • 1 Comments

    We have released SP2. For more details, check out Christophe's blog: 

    http://blogs.msdn.com/chrisfie/archive/2009/04/28/announcing-service-pack-2-sp2-for-microsoft-project-2007-and-microsoft-project-server-2007.aspx

    Chris

  • Project Programmability and Business Intelligence

    MSDN Webcast: EPM Auditing Solution Starter Drilldown (Level 300)

    • 1 Comments

    Dear Project developers! Let me remind you about Larry Duff’s WebCast on Thursday, May 14, 2009 8:00 AM PST.

    “During this webcast we will explore a new solution starter for Microsoft Office Project Server 2007, EPM Auditing. EPM Auditing provides a framework to capture event data from Project Server 2007 and use the data for reporting, debugging, auditing, or whatever use you find. We will analyze all of the components that make up EPM Auditing. We’ll then dive into the code, because this solution is made to be extended and customized.”

  • Project Programmability and Business Intelligence

    Last Microsoft driven “EPM University” Developer course on schedule from May 26th

    • 1 Comments

    Larry Duff is an instructor for this Developer Course that is part of the EPM University education.

    This is the last interactive, instructor-led Developer training delivered by Microsoft. If you want to invest in EPM specific developer training – this should be one of your strong candidates!

    Also keep in mind that the spots are limited.

    Questions or feedback? epmdev@microsoft.com.

  • Project Programmability and Business Intelligence

    Microsoft Project Conference 2009 Update

    • 1 Comments

    If you are heading to Phoenix in September to attend the Project Conference, or if you are still considering it – please check the following update from Christophe.

    And yes we plan developer sessions as well – like:

    • Application Lifecycle Management with Project Server 2010
    • EPM Solutions 2010 – Programmability
    • Project Desktop 2010 – Programmability
    • … and much more real-world examples and best practices!

    “This year’s conference will exclusively disclose the powerful capabilities included in Microsoft Project 2010 and Microsoft Enterprise Project Management (EPM) Solutions while providing real world guidance on how Microsoft Project 2007 and Microsoft EPM Solutions are helping customers today with Project and Portfolio Management to save money, enhance efficiency and prepare for future growth. With in-depth content and hands-on opportunities to learn about Microsoft Project 2010 and Microsoft EPM Solutions, obtain unique insights into how the next release will continue to support your business tomorrow.” – from http://www.msprojectconference.com/

    Hope to see you in Phoenix!

    Jan

  • Project Programmability and Business Intelligence

    UPDATED: Webcast: Communication between Project Professional and Project Server - Active Cache processes and Architecture drill down (Level 300)

    • 1 Comments

    Great attendance – thank you!

    WebCast Overview
    This webcast will uncover processes and key messaging between Microsoft Office Project Professional 2007 and Microsoft Office Project Server 2007. From first logon, through operations like project open, save and publish, we will describe in detail the ‘cache’ folder structure and registry settings. Network traffic between client and server will also be explained. Finally, we will discuss enhancements made to increase client/server communication scalability and reliability.

    Jan

  • Project Programmability and Business Intelligence

    Identifying Surrogate Timesheets in the Reporting Database

    • 1 Comments

    When we shipped Project Server 2007 we made sure that timesheet data was readily available to query in the Reporting Database, however one thing that we didn't do was make it super easy to spot a surrogate timesheet (defined as a timesheet entered on a team member's behalf by another Project Server user who has the surrogate timesheet permissions) - one reason was that we wanted mainline timesheet reports to not have to care, and be able to aggregate/report on the data without special case code.

    If you are faced with the need to identify surrogate timesheets the query below, run against the RDB, will help:

    SELECT DISTINCT TS.OwnerResourceNameUID AS N'Team Member'

                  , TSA.LastChangedResourceNameUID AS N'Surrogate Team Member'

                  , TS.TimesheetUID

    FROM dbo.msp_timesheet AS TS

    INNER JOIN dbo.msp_timesheetline AS TSL

      ON TS.TimesheetUID = TSL.TimesheetUID

    INNER JOIN dbo.msp_timesheetactual AS TSA

      ON TSL.TimesheetLineUID = TSA.TimesheetLineUID WHERE TSA.AdjustmentUID = N'00000000-0000-0000-0000-000000000000' -- Not an adjustment

      AND TS.OwnerResourceNameUID <> TSA.LastChangedResourceNameUID -- Submitter <> TS Owner

    We are basically looking at the timesheet lines that haven't been adjusted - if the person who last saved them isn't the same as the person who owns the timesheet then we know its a surrogate - the lines were submitted by another user.

    Usage Note: The two resource UID can be used to join to other timesheet tables - don't join on these directly to the MSP_EPMResource_UserView or other tables in the EPM schema as you won't get a match - instead you should join though the RDB slowly changing resource name table (MSP_TimesheetResource) to get the base ResourceUIDs and use these for the EPM schema. 

    Hope this helps - if you are struggling to get a question answered from RDB data feel free to post a response to this article and we'll see what we can do.

    Happy New Year for 2009 (Chris - first post!) 

     

  • Project Programmability and Business Intelligence

    The full list of Project Server / EPM developer-related WebCasts and Videos

    • 1 Comments

    We are posting full list of Project Server/EPM developer On Demand Recordings and upcoming WebCasts so you can mark your calendar. Some are in process of publishing, as soon as they are out, we will post an update J

     

    Office Project Server Programmability WebCast series

    Name

    Description

    Presenter

    Date/Time

    MSDN Webcast: Office Project Server Programmability (Part 1 of 4): Project Server 2007 Architecture for Developers (Level 400)

    During this webcast, we analyze all of the components that make up Project Server 2007. Once we examine the components, we discuss their importance in programming Microsoft Office Project Server 2007.

    Larry Duff, Microsoft

    On Demand Recording

    MSDN Webcast: Office Project Server Programmability (Part 2 of 4): Project Server Interface Programming Overview (Level 300)

    In this webcast, we provide an overview of what the Microsoft Project Server Interface (PSI) is and how the PSI is built. We also discuss the concepts of using Web services, custom datasets, and error handling.

    Larry Duff, Microsoft

    On Demand Recording

    Revised: MSDN Webcast: Office Project Server Programmability (Part 3 of 4): Review of the Project Server Interface Web Services – PART A (Level 400)

    In this webcast, we walk you through each of the Microsoft Project Server Interface (PSI) Web services, identify key usage of each of the Web services, and provide tips and tricks for working with PSI Web services. 

    Part A of this WebCast covers the following Administrative PSIs: Admin, Archive, CubeAdmin, Events, LoginForms, LoginWindows, Notifications, ObjectLinkProvider, QueueSystem, WssInterop.

    Larry Duff, Microsoft

    Thursday, March 26, 2009

    8:00 A.M.–9:30 A.M. Pacific Time

    Revised: MSDN Webcast: Office Project Server Programmability (Part 3 of 4): Review of the Project Server Interface Web Services – PART B (Level 400)

    In this webcast, we walk you through each of the Microsoft Project Server Interface (PSI) Web services, identify key usage of each of the Web services, and provide tips and tricks for working with PSI Web services.

    Part B of this WebCast covers the following Project PSIs: Calendar, CustomFields, LookupTable, Project, Resource, ResourcePlan, Security, Statusing, TimeSheet.

    Larry Duff, Microsoft

    Thursday, April 2, 2009

    8:00 A.M.–9:30 A.M. Pacific Time

    New Date: MSDN Webcast: Office Project Server Programmability (Part 4 of 4): Project Server 2007 Events and Workflow (Level 400)

    During this webcast, we describe how events extend Microsoft Office Project Server 2007, build handlers for different events explaining when or when not to use them, and demonstrate how to use workflow as a way to illustrate event usage.

    Larry Duff, Microsoft

    Thursday, April 16, 2009

    8:00 A.M.–9:30 A.M. Pacific Time

    MSDN Webcast: Office Project Client Programmability (Level 300)

    We show you how to develop against the Microsoft Office Project client object model. We look at using Microsoft .NET and Microsoft Visual Studio Tools for the Microsoft Office System (VSTO) for programming to supplement standard Microsoft Visual Basic for Applications (VBA), and we examine connecting to Microsoft Office Project Server via the Project client object model.

    Larry Duff, Microsoft

    Thursday, April 23, 2009

    8:00 A.M.–9:30 A.M. Pacific Time

    Other Office Project Server Programmability and solutions-related WebCasts

    Newly scheduled: MSDN WebCast: EPMAuditing Solution Starter Drilldown (Level 300)

    During this webcast, we will explore a new solution starter for Microsoft Office Project Server 2007, EPMAuditing. EPMAuditing provides a framework to capture event data from Project Server 2007 and use the data for reporting, debugging, auditing, or whatever use you find. We will analyze all of the components that make up EPMAuditing. Then we’ll dive into the code, because this solution is made to be extended and customized.

    Larry Duff, Microsoft

    Thursday, May 14, 2009

    8:00 A.M.–9:30 A.M. Pacific Time

    Working with the Project Server 2007 Reporting Database

    This video provides strategies for locating and using the data in the Project Server 2007 Reporting database. The session walks through three examples of building relatively complex queries from the ground up. Note: This video is recorded from a WebCast session, with a logon through Microsoft Office Live Meeting. The meeting audio is interrupted in the first two slides by the logon.

    Patrick Conlan, Microsoft

    On Demand Recording

    Project Server 2007 Timesheet Customizations

    This video covers all options around timesheet customizations in Project Server 2007. The following CodePlex projects are used during the webcast:

    · EPM Timesheet & Statusing Customization Samples

    · Project Server 2007 Timesheet Tied-Mode Service and Event

    · Project Server 2007 Timesheet Data Population Tool

    Christophe Fiessinger, Microsoft

    On Demand Recording

    Project Server 2007 Integration with Team Foundation Server for EPM Specialists

    Watch an overview of the Visual Studio Team Foundation Server - Project Server 2007 Connector to understand how this solution uses features within Project Server 2007 to enable this integration.

    Lenny Fenster, Microsoft

    On Demand Recording

    MSDN Webcast: Project Server and Project Portfolio Server Advanced Customization (Level 100)

    Present two of the latest solution starters produced for Project and Portfolio Server 2007:

    * The Solution Connector is an ASP.NET web service and .NET class library which provides a set of methods for programmatically creating, updating or deleting projects and their attributes in Microsoft Office Project Portfolio Server 2007

    * Project Server audit framework: this solutions give you the ability to audit specific Project Server events within a farm.

    Larry Duff, Microsoft

    On Demand Recording

  • Project Programmability and Business Intelligence

    EPM Developer Community update - January 2009

    • 1 Comments

    Thank you for your interest and involvement - and - all the best to all of you in 2009! 

     

    We continue our focus on growing collaboration amongst those with the following skills as they relate to Microsoft enterprise Project Management.

     

    ·        .NET Developers familiar with Project Server Interface (PSI)

    •    Integration with Line of Business applications using the PSI

    •    Developing Server Side events and Workflows

    •    Project Web Access (PWA) Customizations

    •    Custom report building

    •    Experience with Visual Studio Tools for Office (VSTO)

     

    Collaboration opportunity

    We hope that the Microsoft Project Developer Discussion - microsoft.public.project.developer newsgroup gives value to you and also enables you to share your knowledge with your peers. 

     

    Developer blog

    In order to help you navigate through the various blogs sponsored by the Microsoft Office Project Product Group, please recognize the Project Programmability Blog (http://blogs.msdn.com/project_programmability/) as the “official” blog when it comes to Microsoft Project communicating to the Developer community.

     

    CodePlex solutions   

    We want to remind you that CodePlex remains the place to submit and share code snippets as well as explore and reuse tools that have been posted for your consumption! 

     

    EPM University Training

    Following is the link to the EPMU Developer Training courses -  EPMU Training Course Schedule.

     

    OnDemand and Upcoming WebCasts

    ·        Business, Developer and Technical webcasts on Microsoft Project are listed on Microsoft Events and Webcast page dedicated to Microsoft Project (http://www.microsoft.com/events/series/epm.aspx). 

     

    ·        Developer on demand and upcoming webcasts on Microsoft Project are available on Project Developer Portal’s Videos and WebCasts page (http://msdn.microsoft.com/en-us/office/dd334415.aspx). 

     

    Thank you!

    Jan Kalis and Joyce Bileau

    EPM Developer Community Leads

     

    Questions, comments, feedback? Ask us!

    We welcome any feedback on developer content for Microsoft Project - suggestions on content that you are missing or content that you want to share or deliver!

     

     

    e-mail: epmdev@microsoft.com

    web: http://msdn.microsoft.com/office/project/

Page 5 of 11 (255 items) «34567»