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

    The future is here! Project 2010 is announced at the Project Conference!

    • 0 Comments

    Ladies and gentlemen – if you were not able to come in person to see the Chris Capossela’s keynote at the Project Conference in Phoenix – please check this out http://www.microsoft.com/project/2010/.

  • Project Programmability and Business Intelligence

    Importing SharePoint List Data into Project Server 2007 Custom Fields

    • 0 Comments

    Check this out - http://msdn.microsoft.com/en-us/library/ee460779.aspx by Stephen C. Sanderlin, MSProjectExperts. Awesome real-world project article, extensive sample code!

     

    If you are heading to Project Conference – Steve has a 3 sessions about PSI – they span from 200 to 400 level. Worth attending…


    DEVDM 200: Project Server Programmability Overview

    Speaker(s):  Stephen Sanderlin, MSProjectExperts | 200 - Intermediate Level
    This session will provide an overview of the Project Server Interface (PSI) and the Reporting Database (RDB), along with discussions concerning their capabilities, usage, and limitations. This session seeks to build a foundational understanding of these components for the new Project Server developer.


    DEVDM 303: Best Practices: Consuming the PSI

    Speaker(s):  Stephen Sanderlin, MSProjectExperts | 300 - Experienced Level
    The Project Server Interface (PSI) contains a wealth of functionality spread across numerous components. Developers who are new to Project Server often find the sheer complexity and depth of the PSI to be extremely intimidating. In this session, we will show you how to build a basic PSI consumer application and provide some best practices. This session seeks to increase the new developer’s comfort level with the PSI.

    DEVDM 401: Building a PSI Wrapper for Application Integration

    Speaker(s):  Stephen Sanderlin, MSProjectExperts | 400 - Advanced/Expert Level
    When developing an interface between Project Server and an external Line of Business (LoB) application, the depth and complexity of the Project Server Interface (PSI) can present a whole host of issues. One of the most challenging issues is the substantial effort required for a developer that is unfamiliar with Project Server to gain solid experience and comfort with the PSI. One possible approach is to assign a small team to encapsulate the PSI interactions inside of a custom API. In this session, we will demonstrate and discuss various strategies and best practices for PSI encapsulation.

    See you at Project Conference!

    Jan

  • Project Programmability and Business Intelligence

    Project Conference – T-2W update! What? Oh – less than 2 weeks before the conference!

    • 0 Comments
    DEV


    All the developer sessions have this icon – please check the session list! http://www.msprojectconference.com/sessions.html

     

    Also just would like to attract your attention to Hands-on labs – very cool dual monitor setup with the following experience:

    HOL-Blog  

    Yes – it includes the following Project 2010 self paced Hands-on Labs and Instructor Led Labs:

     

    Project Professional 2010 Hands On Lab Explore the major improvements of Project Professional 2010:
    • Scheduling capabilities that makes it easier as well as supports a broader set of planning scenarios from user-controlled scheduling
    • Top-down planning
    • Resource leveling improvements
    • Team Planner feature
    • Leverage SharePoint for collaboration even when EPM hasn’t been deployed

    Project Server 2010 Hands On Lab

    Explore the major improvements of Project Server 2010:
    • Demand Management
    • Portfolio Analysis
    • Timesheets and task progress tracking
    • Business Intelligence and Reporting
    In this lab we will walk you through entering proposals, running workflow, discussing portfolio analysis, drilling into online project editing. We will also help you uncover timesheeting and reporting and describe richness of the Reporting and Data Analysis area in Project Server 2010.
    Project 2010 Migration Deep Dive These labs give you hands-on experience on tools and best practices for migration from Project 2003 and Project 2007 to Project 2010. In case you are migrating from 2003 you need to migrate your data to 2007 first in order to continue to 2010.
    In the first part of the lab we show the "Virtual Migration Environment" (VME) along with comprehensive documentation that helps you to accomplish the first part of your migration easily without necessity to install or configure new 2007 farm.
    The second part uses the pre-configured 2010 image and shows steps how to attach set of 2007 databases and provision PWA instance. This part also talks about new 2010 feature Backwards Compatibility Mode.
    Financial Project Server Add-On to Project 2010 Overview The Financial Project Server add-on to Project 2010 integrates seamlessly with Project Server 2010 and enables organizations to effectively manage project financials throughout the project lifecycle. It leverages exciting new Microsoft technology such as the JS Grid and fluent UI to provide a greatly enhanced user experience to managing project financials. It enables ‘top-down’ cost budgeting, forecasting, and tracking (actuals and variances), as well as benefits estimation and realization tracking. Built on the Project 2010 infrastructure, it leverages the platform capabilities to provide workflow driven financial management governance including approvals, transitions, validations, and support for user and role level security/permissions.
    The lab scenario takes you through creating a project’s cost budget and benefits estimates with the ability to refine and add increasing detail to estimates as the project proposal moves thorough a project governance lifecycle. You will create, update, and approve project cost and benefits data, submit project cost actuals, synchronize project plan detail cost estimates with top-down estimates and view Portfolio financials data using the cube.

    Learn | Connect | Grow @ The Microsoft Project Conference

    Phoenix, AZ ® September 14-17, 2009

    Jan

  • Project Programmability and Business Intelligence

    Using formulas in custom fields

    • 5 Comments
     

    Using formulas within custom fields has been a part of Microsoft Project for a long time, but typically they are used by the more advanced project managers and by developers of Project applications and add-ons.

     

    That doesn't mean that you shouldn't learn how to use them. After all, of all the ways you can use to customize and automate Project, formulas within custom fields remain one of the simpler ones.

     

    The first question that arises to those new to Project programming is, Why use a formula within a custom field in the first place?

     

    The primary reason is that too often Project's default fields aren't displaying information precisely as you want. The second reason is that using formulas within custom fields is a much quicker and easier way to customize and automate Project than using VBA, VSTO, PowerShell, or C#.

     

    Some Examples

    • For reporting purposes, if you'd rather have a text field and not a number field  to display on the Gantt chart how much work resources are assigned to, you could create a custom text field, and then attach this formula to it:

     

        [work]/60/8 & "hours"

     

    1. To add the above formula, click Customize on the Tools menu, and then click Fields.
    2. Select a text field to customize, such as "Text1", and click Rename to give it a meaningful name, like "Work Time".
    3. Once you've renamed the field, click Formula.
    4. Copy and paste the above formula into the Edit Formula box.
    5. You're not done yet. After the formula has been added, go back to the Gantt chart and add the "Work Time" field.

     

     

    • Here's another example,  When added to a custom number field, the following formula returns a numerical value that indicates the number of days between the current date and the finish date of the tasks in your schedule:

     

       DateDiff("d",NOW(),[Finish])

     

    This example uses another method to customize Project fields by using functions. (don't confuse formulas with functions). Learn more about Project funcitons here.

     

     

    • A more complicated example: When added to a custom text field, the following formula (with functions included) returns a value of "No baseline," "Overbudget by 20% or more," or "Under budget":

    Switch(Len(CStr([Baseline Finish]))<3, "No baseline", ([Cost]+1)/
    ([Baseline Cost]+1)>1.2,"Overbudget by 20% or more", ([Cost]+1)/([Baseline Cost]+1)>1,
    "Overbudget",True,"Under budget")

     

    An Example using VBA

     

    Here is VBA code that does the same as the first example above. You might do this if you have numerous reports that need columns set in a specific way. The code could be added as a toolbar button. Adding custom fields using formulas within VBA is a four-step process. Here is an example that adds a "Work Value" column to the Gantt chart, with work values that are calculated by a formula.

     

    1. First, set up the custom formula that the custom field should use. In this example, the constant, pjCustomTaskText1, is being used to specify that a Text1 field is being customized to contain a formula.

     

       CustomFieldSetFormula FieldID:=pjCustomTaskText1, _

        Formula:="[Work]& "" hours"""

     

    1. Now calculate the formula.

     

       CustomFieldProperties FieldID:=pjCustomTaskText1, _

        Attribute:=pjFieldAttributeFormula, _

        SummaryCalc:=pjCalcFormula

     

    1. Now add the field to a view.  "NewFieldName" indicates that Text1, will be used, which is equivalent to the pjCustomTaskText1 used in the CustomFieldProperties method above.

     

    TableEdit name:="Entry", TaskTable:=True, NewName:="", fieldName:="", _ 

    NewFieldName:="Text1", Title:="Work Table", ColumnPosition:=1

     

       

    1. Now apply the table to a view. I know, it sounds odd to apply the table when all you want to do is add a field, but that's the way it is with VBA code.

     

       TableApply name:="Entry"

     

    There you have it. Not so difficult. And you saved the weekend.

     

  • Project Programmability and Business Intelligence

    Project Server 2007 Report Pack II - "The Top Reports"

    • 0 Comments

    We are proud to announce that the  Project Server 2007 Report Pack II - "The Top Reports" a collection of best practices reports for SQL Server Reporting Services is available on MSDN Code Gallery.

    Project Server 2007 Report Pack II - "The Top Reports"

    This Project Server 2007 Report Pack II - "The Top Reports" addresses questions "what" reports to run in your Project Server 2007 environment and "why". It comprises of 40 reports divided into Management and Governance sections. The pack was designed by top Microsoft Consultants who deploy and enhance the Enterprise Project Management Solution (EPM) for individual customers and thus contains very valuable know-how that they have collected over the years.

    More information

    · Download: http://code.msdn.microsoft.com/EPMReportPack

    · Recorded webcast: https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032423031


    Other available solutions for Enterprise Project Management (EPM) solution

    MSDN Code Gallery

    http://code.msdn.microsoft.com/Project/ProjectDirectory.aspx?ProjectSearchText=epm

    MSDN Code Gallery solutions

     

    Project Server 2007 Sample Databases

    Project Server 2007 sample databases. The zip contains the following five databases: * Archive * Draft * Published * Reporting * Content

    EPM 2007 Project Updater InfoPath Form

    A web-enabled InfoPath 2007 Form using Project Server 2007 PSI .Net web services. The form allows project managers to easily mark tasks as complete in a sequential, process-like project plan…

    Solution Connector for Microsoft Office Project 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 …

    Building an AJAX Web Part for Microsoft Office Project Server 2007

    This sample contains a Project Server 2007 PSI Extension that retrieves geo data based on a custom field, and then the main feature is an AJAX Web Part that uses Virtual Earth to display the …

    Microsoft Office Project Server 2007 PSI Extension Generator

    PSI Extensions are custom web services that execute within the Project Server Interface infrastructure, sharing the same security context as other PSI web services. PSI Extensions can be very …

    Project Server 2007 Migration Rename Tool

    During a Project Server 2003 to Project Server 2007 migration, projects have "_Published" appended at the end of their name. This tool will enable you to "bulk" rename all projects and removed …

    Project Server 2007 Lookup Table Update Control

    Out of the box you cannot enforce control updates of specific lookup tables in Project Server 2007. This code sample leverages the standard Project Server interface API to limit who and what…

    Microsoft Project Fx (mPfx) for Microsoft Project 2007

    Microsoft® Office Project 2007 (Microsoft Project) underscores Microsoft’s continued commitment to developers concerned with creating robust planning and scheduling tools for organizations with…

    Project Server Interface 101 Development Samples

    10 samples of how to do 101-level PSI development tasks

    Project Server 2007 Performance Lab Kit

    The Project Server 2007 Performance Lab Kit contains two Visual Studio solutions/tools to help you test your farm environment for capacity planning purposes: the “EPMTestTools” and the “EPM Stress …

    Project Server 2007 Report Pack II - "The Top Reports"

    The Project Server 2007 Report Pack II - published in August 2009 - provides reports that can be run in your EPM environment and enable easier access to EPM information that organization can …

    CodePlex

    http://www.codeplex.com/site/search?projectSearchText=epm

    CodePlex EPM solutions

     

    Project Server 2007 Timesheet & Statusing Customization Samples

    Code samples that demonstrate how EPM (Project Server) 2007 Timesheet and Statusing functionalities could be customized using custom event handlers and Project Server Interface calls. These samples leverage the Timesheeting and Statusing API documented in the EPM 2007 SDK

    Project Server 2007 VSTS Connector

    Connector solution for Project Server 2007 and Team Foundation Server

    Project Server 2007 Timesheet Tied-Mode Service and Event Handler

    This project is used with Microsoft Project Server 2007. It consists of an NT service, an event handler, a test app and installer. The event handler is fired when a tiemsheet is saved. The handler saves the timesheet info in a SQL table. The NT service (TSAutoStatus) polls...

    EPMSync Utility

    Microsoft Office Project Server 2007 (Project Server) and Microsoft Office Project Portfolio Server 2007 (Portfolio Server) integrate via the Portfolio Server gateway. Data is exchanged by running either an import or an export from Portfolio Server. But this exchange is done...

    Project Server 2007 Test Data Population Tool

    The EPM (Project Server) 2007 Test Data Population Tool enables you to load large amounts of EPM data: resources, projects, tasks, assignments into a Project Server 2007 database. You can then use this data to test loads and help your organization plan for your Project Server 2

    Project Server 2007 Queue Watch Tool

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

    Project Server 2007 Log File Report Tool

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

    Project Server and InfoPath 2007

    This solution starter demonstrates how to leverage InfoPath and Forms Services as well Windows Workflow Foundation (WWF) hosted by SharePoint to create your own project initiation phase. The project initiation phase is different for every customers and organizations. It typic...

    EPM Custom Fields Copy

    The principal function of this project is to provide Project Server 2007 custom fields and lookuptables migration from development environment to production environment, using some PSI methods. I want to increase my inicial project, adding more funcionallities and solve some ...

    Project Server 2007 Timesheet data population tool

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

    Search Project Server data using SharePoint Server's BDC and Enterprise Search

    Search Project Server data using SharePoint Server's BDC and Enterprise Search

    Project Reportcard

    The Project Reportcard was developed as a tool to help Project Managers assess their projects based on organizational standards implemented by their PMO. Understanding what the organizational KPIs are going to look like before their project update is published, can help a pro...

    Project Server 2007 Auditing Solution Starter

    EPM Auditing makes it easier to auditing and debug Projec Server 2007 activities. You can audit multiple activities and output them to multiple sources. It's developed in C#.

    Project Server Workspace Sync

    This tool works with Project Server. It is a very simple tool that iterates over the list of Project Workspaces and triggers user sync for the members in the WSS site and triggers the sync for issue, risks and deliverables with the reporting database.

    Earned Value Add-In

    The Earned Value Add-In has been developed as a tool to help project managers assess and visualize projects using earned value analysis.

    Project Server 2007 AD/Resource Sync Utility

    Demonstrates how to sync additional AD fields to resource custom fields for Project Server 2007.

    Persisting SSAS OLAP Roles In Project Server 2007

    During the standard Cube Building process in Project Server 2007, any manually added OLAP Roles in an OLAP database are deleted. The Cube building creates a default Role ProjectServerViewOlapDataRole that automatically adds all the Project Server users to this Role. This customiz

    Project Server 2007 Bulk Edit

    The purpose of this project is to allow the bulk edit of resource data. With large numbers of resources Resource Center can take a long time to load, primarily due to the security checks required. This tool goes directly against the Project Server Reporting store to pull back t

    Project Server 2007 Event Handler Admin Tool

    This project contains code demonstrating how to use the PSI to add and remove event handler associations for Project Server 2007. Instead of displaying all possible event handlers like the PWA admin screens, this tool uses reflection to show only the implemented handlers and all

    Project 2007 Test Framework

    Controller/client test framework can be used to test any assembly or .exe with and object model (any MS Office app).

    Project Server 2007 Timesheet AutoStatus Plus

    Project Server 2007 Timesheet AutoStatus Plus is a major rewrite of Christophe Fiessinger's EPM tied-mode work. Planned enhancements are: multiple instance support, farm support, and elimination of the Windows Service in favor of a SharePoint Timer Job.

  • Project Programmability and Business Intelligence

    Upcoming WebCasts and available On Demand developer training (a.k.a. EPMU)

    • 0 Comments

    Reporting (BI and Data Analysis)

    Date

    Name

    Description

    Presenters

    Registration

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

    Microsoft Office Enterprise Project Management (EPM) 2007 Report Pack II - The top reports

    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.

    Bulent Guzel  and T.R. Sloan -  Microsoft Corporation

    link

    Real World Solutions

    This upcoming Webcast series is unique – it just does not talk about particular feature for the sake of describing it, but it introduces a particular customer scenario and discusses a way to address customer need by extending Project Server by development project... Every WebCast will be accompanied by an extensive MSDN article with code samples! Very exciting! Delivered and presented by Microsoft Project MVP - Stephen C. Sanderlin from MSProjectExperts!

    Month Name Scenario Description Presenter
    Registration
    September 2009 Importing Workspace Data into Project Server Custom Fields A client has requested a Project Center view that displays the number of active issues for each project. This is not possible out of the box. Discusses a method of importing data from Project Workspaces (PWS) into a Project-level custom field Stephen C. Sanderlin, MSProjectExperts TBD*
    November 2009 Leveraging Project Server Security within SQL Reporting Services Reports A client has requested a SQL Reporting Services report that displays sensitive financial data. However, they only want executors of the report to see information on projects to which they have access. Discusses a method of leveraging Project Server security in SRS Reports Stephen C. Sanderlin, MSProjectExperts TBD*
    February 2010 Filter Resource and Project data based on Custom Fields You are creating a custom Windows application for a client that extracts and displays Project and Resource information. Because the PSI provides no way to filter these entities prior to retrieval from the PSI, you must retrieve all of the projects or resources in order to filter them by Custom Field value. Because this client has some international users on slow WAN links, you must minimize the payload sent to the user by the PSI call. Discusses a method of extending the PSI to enable the filtering of Resources or Projects by Custom Field values Stephen C. Sanderlin, MSProjectExperts TBD*
    April 2010 Exporting Project Server Data to CSV A client would like to export data from Project Server into a legacy Line of Business system. This system only accepts data in a CSV format. Discusses a method of exporting Project Server data into CSV files Stephen C. Sanderlin, MSProjectExperts TBD*

    *Registration URLs would be also announced at the Project Developer Portal and at this blog.

    On Demand EPM University Training       

    Remember the EPM University and the wonderful Developer course? It’s available as an on demand recording free of charge right here!

    Other Resources

    · Project Developer Portal on MSDN

    · Upcoming Project Conference http://www.msprojectconference.com/

    · Questions or feedback on Project Developer-related content? mailto:epmdev@microsoft.com

    Regards

    Jan Kalis

  • Project Programmability and Business Intelligence

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

    • 0 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

    VPC v4 behind the scenes – the release process

    • 0 Comments

    You may have read the recent post on the VPC v4 announcement.

    Wanted to give you a small glimpse behind the scenes. This update was fully done on Windows 7 RC in the Virtual PC for Windows 7. I also was testing new SSD OCZ Vertex. In practice the SSD gives you approx half time for boot and application launches and at least 3-times as fast “warm-up” script execution. But it’s also very good for compacting the image and merging “undo” disks. So this was very handy. Christophe did a blog post on various benchmarks using Samsung SSD (DELL ships them as OEM) with very similar results. The only thing to keep in mind while using SSD is not to limit the bandwidth by the connection to the computer – SATA or eSATA are perfect solutions. USB 2.0 is not sufficient. USB on my desktop (DELL Optiplex 755) gives the “theoretical” limit of 60MB/s but on the laptop (DELL E6500) it’s just about a half – have not gone to the bottom of this…

    The SSD *may* compensate for lack of RAM on your PC for running Virtual Images – e.g. you have multiple images DC and APP server –or- you have a very greedy image to run on one 4GB Laptop. Try this option before saying – I can’t I need to get 8GB Laptop. It really works. :)

    Another nice feature on Windows 7 I used was the ability to mount and edit VHD files. The task was to increase the size of the primary partition in the VHD. The solution is easy – mount it in Win7 using Disk Management and then “Extend Volume…”. Cool :) I also used another VHD for data exchange – I have created this VHD in Win7, mounted it, uploaded all necessary files (including new EULA :)), then dismounted and added this “helper VHD” as HardDrive 2 in the VPC. You may argue why not to use “Virtual Machine Additions”? Good point – the goal was to have a minimal impact on the state of the VPC (if it works – don’t touch it) and the installed additions did not work with the version of the VirtualPC I was using. I could have grabbed the required files from a network share – yeah but all the work with network credentials…

    There’s also an option to convert this image to Hyper-v. For this purpose I have added “Loopback Network Adapter” that always sits in the image and has the right internal address and all services start no matter what happens outside. So if you wan to run this in Hyper-v just remove the “Virtual Machine additions” and install “Hyper-v Integration Services” and you are good to go! Christophe did a blog post on this as well.

  • 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

    Project Conference 2009 Announcements

    • 0 Comments

    Session Content Announced!

    Offering 75+ sessions for Project Conference 2009 – view all session details including speakers, titles and abstracts here. Stay tuned for more details on instructor led and hands on labs, “ask the experts” and additional networking opportunities.

    Special Registration Offer

    No other conference will come close to delivering the quantity and quality of content and experiences found at Project Conference 2009, nor the number of value added benefits and offers that will resonate throughout the year. We’re delighted to announce:

    · Receive a free licensed copy of Project Professional 2010! The offer is extended to all registered attendees by PMPI, a Microsoft Certified Partner in the EPM Specialization. Stay tuned for more details.

    · Receive free Project Professional 2007 e-learning! The offer is extended to all registered attendees by PMPI, a Microsoft Certified Partner in the EPM Specialization. Stay tuned for more details.

    · Free certification testing! Take the Project 2007 Technical Specialist exam 70-632 and/or 70-633 for free at Project Conference 2009.

    · PMI Credential Holders: earn up to 32.25 PDUs with Project Conference 2009 registration!

    · Save over 15%. We’ve extended our lowest registration offer to make it more affordable to attend!

    Register Now!

    Project Conference 2009 is the one conference your company should attend this year!  For more information and to register, please visit the Project Conference Website at http://www.msprojectconference.com.

  • Project Programmability and Business Intelligence

    Sneak peak into 2010 (updated)

    • 0 Comments

    Microsoft Project 2010 Technical Preview
    Project 2010 Investment Areas

    You might be interested in the following links as well:

    SharePoint 2010 Technical Preview
    Microsoft Office 2010 Technical Preview

  • Project Programmability and Business Intelligence

    Project Server - Service Pack 2 Update

    • 0 Comments

    A recent post from the SharePoint Team Blog.

    The public update for the Service Pack 2 expiration date issue is now available for download. 

    The update can be applied before or after Service Pack 2 installation.  If the update is applied prior to installing Service Pack 2 it will prevent the expiration date from being improperly activated during installation of Service Pack 2, if it is applied after Service Pack 2 it will remove the expiration date incorrectly set during installation of Service Pack 2.

    The update is applicable to all of the products that this issue affected (see the list in the KB linked below).

    Installation instructions and download links for x86 and x64 are available in this KB: http://support.microsoft.com/kb/971620

    The direct download link for x86 is: http://download.microsoft.com/download/2/F/5/2F51AB71-1325-49D2-9CB9-18DEC4780E99/office2007-kb971620-fullfile-x86-glb.exe

    And for x64: http://download.microsoft.com/download/5/B/B/5BBD34A9-C528-42B0-8A5F-9A8997B25C32/office2007-kb971620-fullfile-x64-glb.exe

    We will be updating the existing Service Pack 2 download package with a new package that includes this fix within the next 4-6 weeks.

    Thank you for your patience.

  • 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

    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

    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

    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

    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

    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

    MSDN Webcast: PSI Programming Overview, Demos and Q&A

    • 2 Comments

    This is a little late, I missed that I didn’t post this.  Q&A and demos from the March 12th webcast.

    Question Answer
    Microsoft has BPOS (Business Productivity Online Services) which includes hosted Outlook and Hosted SharePoint, can SharePoint Server be installed on premise with its SharePoint components in BPOS and can the user extend this configuration using the things you are showing in this series? Project Server is not hosted in the BPOS. We are looking into this for the next release of Project Server
    Could you please send the link for good documentation on registering project server events in a farm environment. An event is failing in a farm environment but working in a single server environment The SDK has good documentation on registering events.  But there is one little detail that doesn’t jump out in the documentation, I’m not even positive it’s in there.  Events are registered with SharePoint, so when you scale out the information is in the config database and goes to all servers in the farm.  What doesn’t happen is the binary is not copied to each machine in the farm, you have to do that manually.
    Why don't I have the option of add Microsoft.office.project.server in the using? I added reference to Microsoft.office. The Project Server assemblies are deeper than Microsoft.Office.  Assemblies you would typically add then reference via “Using” when working with Project Server would be:
    Microsoft.Office.Project.Schema
    Microsoft.Office.Project.Server.Library
    Microsoft.Office.Project.Server.Events.Receivers
    So does the SDK tell me or instruct me as to what prerequistists have to exist in order to be able to use the PSI? meaning, do I have to be developing on the box that has PServer installed? or can I simply reference a few dll's pointing my uri to the project dev environment? Yeah there is a pretty good overview:
    http://msdn.microsoft.com/en-us/library/bb456485.aspx.

    The way I develop is with a client machine and a VM (with Project Server installed).  I go into the VM and run this command:
    regsvr32 /u C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\shfusion.dll
    That allows you to look at the GAC as files.  Then I copy everything that has Microsoft.Office to my client machine.  I tend to work with all the different Office products so I pull a lot of stuff I don’t necessarily need.  Once I have the files on my client machine, then I register them in the GAC.  Remember if you apply a service pack to your VM you’ll need to grab the files again.
    Oh and remove the /u from the above command and rerun to get the files system back to normal.
    Most of the samples of PSI I have seen are developed using c#, not much on VB. Do you recommend to use C# over VB? VB.Net is just as good for this as C#.  Actually any .NET language will work great.  I “cut my teeth” in C.  So my natural progression was from C to C++ to C#.
    Hi, Resource demo...did I understand correctly? You read DS of all resources, check out and update one, and send "whole' DS back across web services for one resource update? I read the DS for one resource, check it out, then send the complete dataset for the single resource back.
  • 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

    MSDN Webcast: Project Server Events and Workflows, Demos & Q&A

    • 2 Comments

    Hi All,

    Thank you for attending my MSDN webcast Project Server Events and Workflows.  Don’t forget about next weeks webcast on Project Client programmability.   Below is some of the Q&A I got during the webcast.  Attached is the demos from the webcast.

    Question Answer

    Will you chat at all about Project Server 2010? Are there any plans for changes in the new version?

    Still too early to talk about Project Server 2010 other than to to say I’m looking forward to it.  We’re a few months away from announcing the features. 

    What should you be thinking about as a developer?  Project is committed to the PSI and designed it to be extensible.  The new functionality will be extensions to existing functionality.  This means your work today should be backward compatible.  I did say should so please don’t shoot me if there are a couple “gotchas.”

    Is the command (i.e save project) already queued, when an event is raised?

    The event will be raised when the call executes from the queue.

    Based on your description of pre and post, the "project published" event is raised after save to the db. Would you say its best to eval business rules afterward, log violations, notify user and delete from db? is there an ability to only delete from PDB and leave in DDB so user can correct and attempt re-publish?

    I hate to waffle in my answers, but in this case it depends on the context.  I put together a little matrix below to help with this question.

    Is it microsoft.office.project.schema.dll or microsoft.office.project.server.schema.dll?

    microsoft.office.project.schema.dll is the correct DLL.

    Is there anything to pay special attention for (i.e. concurrency, locking, etc.) with events on heavy loaded systems or is this solved by "serialized" execution through the project server queue?

    The queue helps to solve issues with heavily loaded systems.  Specifically with events you need to pay attention to the length of processing in pre-events.  In a pre-event you are disrupting the flow of Project Server, you should keep your processing to a minimum.

    Using events to enforce business rules

      Easy Rollback Difficult Rollback
    Short Business Rule Evaluation Evaluate in pre-event, rollback unnecessary. Evaluate in pre-event, rollback unnecessary.
    Long Business Rule Evaluation Consider using a post event. This is the hardest case.  You’ll really need to evaluate the complexity of the rollback.  Maybe you could break the business rule evaluation in phases?
  • Project Programmability and Business Intelligence

    Migrating from Project Server 2003 to 2007 – best practices white paper

    • 0 Comments

    As Christophe pointed out in this blog post, we have now a very comprehensive white paper “Best Practices for Migrating to Project Server 2007” that provides guidance, references, and best practices to observe when migrating to Microsoft Office Project Server 2007 from Project Server 2003.

    But how does it apply to you as a developer? 

    Project Server 2007 has a new API - Project Server Interface (PSI) that is a managed code interface opposed to the older Project Data Service (PDS) XML message interface found in previous versions of Project Server. And yes this means a lot :)

    I’m pretty sure you have already investigated the content in the Project Server 2007 SDK (http://msdn.microsoft.com/en-us/library/ms512767.aspx), so let me point you to this chapter in the 2007 SDK “PDS Parity in PSI Web Services” - http://msdn.microsoft.com/en-us/library/ms197081.aspx. It has 3 articles inside, including equivalence table and code examples.

    We would love to hear your feedback on the “PDS Parity in PSI Web Services” or any other feedback on the developer documentation and resources could be shared via EPMDev@microsoft.com. Thanks!

  • Project Programmability and Business Intelligence

    MSDN Webcast: PSI Review, Demos and Q&A

    • 2 Comments

    Hi All,

    Thank you for attending my PSI review MSDN webcasts, I really enjoyed delivering them.  I think if I deliver again it’ll need to be three webcasts, I barely finished part A, and left out three web services in part B.  Below is some of the Q&A I’ve gotten.

    Question Answer

    Create a custom timesheet import UI. So create timesheet from data in Excel for example (each row as a new timesheet maybe?)

    This is totally possible through the timesheet and statusing web services. The biggest challenge will be keeping your external line items names in sync with internal ones you define in Project Server.
    Right now the rates table, you can only put 5 rates in there. Explore ways to put more than 5 rates per resource. Your right that there are only 5 rate available. There are a couple possibilities, all involving custom fields. You would save your extra rate information in a custom field. Then by some event triggering (either client or server side) you could move the appropriate cost information into the table. It’s not the best solution, but could be the start of a workaround for you.

    I want to work on top of various projects that have a certain CustomField value. Going into every project's dataset takes waaaay too long. Is there a better way to do this with PSI?

    There really is no shortcut.  My best advice is to write some helper methods that get you to the values you want.

    Is it ok to use VB for all this stuff or is it much better to use C#?

    VB.Net is just as good for this as C#.  Actually any .NET language will work great.  I “cut my teeth” in C.  So my natural progression was from C to C++ to C#.

    I am trying to sync the values in a Look up table with an external SQL table so the two stay in sync. What is the best way to do this? the table is a customer table from the accounting system

    Going from the accounting system to Project Server should be easy with all the PSI calls available to update the business entities (Project, Resource, etc.).  Going from Project Server to the accounting system is more challenging.  The event system in Project Server will only tell you an entity changed, not the specifics of what changed.  So you’ll need to detect the change and then go into the entity to check for changes.

    What types of programming tasks are going to take existing GUIDs, and what tasks will require us to generate our own GUID? Queueing? Object Creation? It would seem like Project Server would want to own the GUID, for sync'ing and stuff, right?

    Calls that create new entities will have you create a new Guid, for instance QueueCreateProject.  The most common thing you’ll create a new Guid for is the JobUid that’ll you’ll pass to queue enabled calls.

    I don't mean to oversimplify, but if we have an admin backup scheduled daily, isn't that what you are referring to as the 'archive' (although with code you can have more control rather than an all or nothing).

    Archiving is moving entities to the archive database so they are no longer taken into account in the operational system.  BUT… they are available to restore when you need.  It’s way more complicate than that, you should look at the books online to get a good handle on the archive process.

    Do you have any customers that are automatically tweaking the queue configuration settings in a production environment?

    None that I know of.

    For AD Credentials, I use the NetworkCredentials class, which class do I use for the Forms logins? I don’t use it, just curious.... It blocks my outbound webservices connection, I can't seem to authenticate properly, any tips?

    Use the LoginForms web service and pass the username and password via that.
  • Project Programmability and Business Intelligence

    Do you EPMU?

    • 3 Comments

    Microsoft EPM University offers a comprehensive 4 to 5 days educational package for customers and partners who want to quickly ramp-up with EPM solution via rich instructor led online experience.

    The courses are designed to build and enhance the required knowledge to successfully plan, deploy, configure and extend Microsoft Office EPM solution. You can review course details, schedules and register for the course of your choice. The courses currently being offered are:

    You get access to EPMU’s virtual classroom environment that includes a professional instructor and hosted computer environment to run your labs on.

    Check out the schedule and  be sure to register soon to get a spot in the class! The very last class begins in June 2009!

  • 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

Page 6 of 11 (255 items) «45678»