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.
 
 

January, 2009

  • 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

    Free online courses for developers - MSDN Ramp Up

    • 1 Comments

     

    Check out the Ramp Up program (http://www.myrampup.com/) if you have not done already. It has interesting tracks including SharePoint...

  • 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

    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 1 of 1 (4 items)