The Microsoft® Project 2002 Software Development Kit (SDK) is designed for solution providers (SPs), value-added resellers (VARs), and other developers who are interested in extending Microsoft Project 2002 and Microsoft Project Server. It features articles (including several that comprise larger scenarios) that describe using the Microsoft Project Data Service (PDS), customizing the Microsoft Project Guide, and analyzing Microsoft Project data using Microsoft Office XP Web components and OLE DB.
See the Microsoft Project 2002 SDK legal information.
Section 1: Working with Microsoft Project Data
The articles in this section discuss ways to work with the Microsoft Project 2002 database and the information stored within it.
Automating the Project Proposal Process
This article describes how to extend the Microsoft Project Server database schema and customize Microsoft Project Web Access so you can automate the project proposal and creation process in your organization.
Read the article, Automating the Project Proposal Process.
Creating Data Access Pages for Microsoft Project 2002 Projects
This article describes how you can use data access pages in Microsoft Access 2002 to connect to Microsoft Project data and display the data in Web pages by using Microsoft Office XP Web Components. In addition, this article provides information about designing data pages, and provides links to additional information and resources for creating data pages.
Read the article, Creating Data Access Pages for Microsoft Project 2002 Projects.
Creating Microsoft Project 2002 Reports Using XML and XSL
Microsoft Project 2002 provides the ability to import and export files in Extensible Markup Language (XML). You can use exported XML files in many ways, including creating macros that apply Extensible Stylesheet Language (XSL) style sheets to generate Hypertext Markup Language (HTML) reports based on project data. This article describes how you can use XML and XSL to create Web page reports that contain Microsoft Project 2002 data.
Read the article, Creating Microsoft Project 2002 Reports Using XML and XSL.
Extracting Timephased Data from the Microsoft Project Database
This article describes three SQL script files you can use to extract timephased data from the Microsoft Project or Microsoft Project Server database tables. You can use the SQL script files to extract information from the MSP_TIMEPHASED_DATA table in Microsoft Project, as well as the MSP_WEB_WORK table or the MSP _VIEW_PROJ_ASSN_TP_BY_DAY table in Microsoft Project Server. In addition, this article describes how to normalize the timephased data for display.
Read the article, Extracting Timephased Data from the Microsoft Project Database.
Microsoft Project Server Components and Authentication
This article describes the server- and client-side components for Microsoft Project Server 2002 and the application-level authentication layer for Microsoft Project Server 2002. The article also includes diagrams showing the interaction between Microsoft Project Server 2002, Microsoft Project 2002 (both Professional and Standard editions), and Microsoft Internet Explorer.
Read the article, Microsoft Project Server Components and Authentication.
Microsoft Project Server Data Reporting
The Microsoft Project Server database is the repository for an enterprise's project management data. The new view tables that are included in the Microsoft Project Server database serve as an excellent source for reporting data about the entire portfolio of projects in the enterprise. These tables present stable snapshots of each project plan based on the last time a project was published to Microsoft Project Server and include a multitude of de-normalized timephased data, allowing for advanced reporting capabilities outside the Microsoft Project client.
Read the article, Microsoft Project Server Data Reporting.
Section 2: The Project Data Service, Automation, and OLAP
The articles in this section discuss working with Microsoft Project 2002 and Microsoft Project Server 2002 by using Component Object Model (COM) add-ins, the Microsoft Project Data Service, online analytical processing (OLAP), and the Microsoft Project object model.
Automation Using the Microsoft Project 2002 Object Model
This article contains information about how you can automate Microsoft Project 2002 using Microsoft Visual Basic for Applications (VBA), COM add-ins, OLE DB, and Extensible Markup Language (XML). In addition, this article contains information about how you can use XML and PDS to automate Microsoft Project Server.
Read the article, Automation Using the Microsoft Project 2002 Object Model.
Create a COM Add-in for Microsoft Project
Developing and distributing a Component Object Model (COM) add-in is one way to provide users with a custom solution for Microsoft Project 2002. An add-in extends Microsoft Project by adding functionality that is not in the core product. For example, an add-in might add new menu commands or toolbar buttons that display custom forms to add new features.
This article describes how you can use a Microsoft Visual Basic® designer template to quickly create a COM add-in for Microsoft Project 2002. The template allows you to add features to customize the add-in for your needs.
Read the article, Create a COM Add-in for Microsoft Project.
COM Add-ins for Microsoft Project 2002
Compare Project Versions COM Add-in for Microsoft Project 2002
With the Compare Project Versions COM add-in for Microsoft Project 2002, you can compare two versions of the same project file and display the resulting information in a detailed, customized report. This add-in allows you to review differences between a current version and an earlier version, or to contrast two possible projections.
Read the article, Compare Project Versions COM Add-in for Microsoft Project 2002.
Database Upgrade Utility COM Add-in for Microsoft Project 2002
If you saved projects to a database format in Microsoft Project 98 or Microsoft Project 2000, you can easily upgrade them to the Microsoft Project 2002 database format by using the Database Upgrade Utility.
Read the article, Database Upgrade Utility COM Add-in for Microsoft Project 2002.
Euro Currency Converter COM Add-in for Microsoft Project 2002
You can use the Euro Currency Converter COM add-in with Microsoft Project 2000 or later to display costs in more than one currency at the same time. This is especially helpful if you need to report costs in your own currency as well as in the euro (or other currency).
Read the article, Euro Currency Converter COM Add-in for Microsoft Project 2002.
Visio WBS Chart Wizard COM Add-in for Microsoft Project 2002
If you have Microsoft Visio® 2000 or later installed, you can use the Visio WBS Chart Wizard COM add-in for Microsoft Project 2002 to create a work breakdown structure (WBS) chart in Visio from Microsoft Project data.
Read the article, Visio WBS Chart Wizard COM Add-in for Microsoft Project 2002.
XML Reporting Wizard COM Add-in for Microsoft Project 2002
You can use the XML Reporting Wizard COM add-in to create customizable, Web-based reports from Microsoft Project 2002. For ease of use, this XML Reporting tool provides several examples of report formats.
Read the article, XML Reporting Wizard COM Add-in for Microsoft Project 2002.
Extending OLAP Cube Services in Microsoft Project Server
This article provides an overview of the process used to build the Portfolio Analyzer OLAP cube in Microsoft Project Server, and its architecture. In addition, it explains how to extend the cube-building process to either add data to the cube, such as a new dimension, or to set up security in the cube. Finally, this article describes how to customize the user interface in Microsoft Project Web Access to allow you to create Portfolio Analyzer views that point to a different OLAP cube from the one generated by Microsoft Project Server.
Read the article, Extending OLAP Cube Services in Microsoft Project Server.
Object Link Provider Concepts and Architecture
The Object Link Provider (OLP) is the component used to control the relationship between objects in Microsoft Project (such as projects and tasks) and external objects, such as issues and documents. This article is designed for software developers who want to customize the collaborative features of Microsoft Project Server 2002.
Read the article, Object Link Provider Concepts and Architecture.
Object Link Provider Reference for Microsoft Project Server
This section of the SDK contains information about the properties, methods, and interfaces of the Object Link Provider for Microsoft Project Server.
Read the reference material, Object Link Provider Reference for Microsoft Project Server.
Using the Project Data Service
This article provides developers with generic tools for calling the PDS via SOAP, which can be useful for testing solutions that use the PDS.
Read the article, Using the Project Data Service.
The Project Data Service and Microsoft Project Server Security Architecture
This article provides developers with the background and details of the Microsoft Project Server security architecture, and explains the role of the PDS in accessing project data.
Read the article, The Project Data Service and Microsoft Project Server Security Architecture.
Writing a Project Data Service Extender
This article describes how PDS Extenders allow you to easily develop solutions with Microsoft Project Server.
Read the article, Writing a Project Data Service Extender.
Project Managers PDS Extender
This article describes how to use the Project Managers PDS Extender sample application for Microsoft Project Server.
Read the article, Project Managers PDS Extender.
ProjectUtilities PDS Extender
This article describes how to use the ProjectUtilities PDS Extender sample application for Microsoft Project Server.
Read the article, ProjectUtilities PDS Extender.
PDS Reference for Microsoft Project Server
This reference explains how to use the PDS application programming interface (API) to allow client applications to access Microsoft Project Server portfolio data. Client applications can programmatically log on to Microsoft Project Server and use Simple Object Access Protocol (SOAP) to call PDS API methods. The PDS implements a SOAP listener, which receives method calls in Extensible Markup Language (XML) format and returns an XML response.
Read the reference material, PDS Reference for Microsoft Project Server.
PDS Permissions
This article lists the global permissions that can be accessed using the Project Data Service, for example when using the PermissionCheck method to verify whether a user has a given permission.
Read the article, PDS Permissions.
Section 3: Customizing the Client User Interface
The articles in this section discuss ways of modifying the user interface of Microsoft Project.
Customizing the Microsoft Project Guide
This article shows how to extend the Microsoft Project 2002 user interface by customizing the Project Guide. Custom Project Guides are powerful tools that can present Microsoft Project functionality to users in terms of their individual business methods. This article will walk through common steps in the customization process, and explain the basics of the Project Guide's structure in the process. At the end of this article, you should be able to go from modifying existing side panes to creating entire custom Project Guides.
Read the article, Customizing the Microsoft Project Guide.
Customizing the Microsoft Project Guide for Enterprise Team Builder Light
In Microsoft Project Professional 2002, you can use the Build Team from Enterprise feature to create a team from the enterprise resource pool. As the enterprise resource pool grows in size, however, it may be advantageous to have a faster way available to build a team. This article shows you how to customize the Project Guide to create a "light" version of the Enterprise Team Builder, which offers a faster way to build a team from the enterprise.
Read the article, Customizing the Microsoft Project Guide for Enterprise Team Builder Light.
Microsoft Windows Messenger Integration Custom Project Guide
This code sample embeds the Microsoft Windows Messenger object in a custom Project Guide for a fully integrated Windows Messenger experience. The custom Project Guide contains content and functionality for synchronizing your contacts with project resources, creating group conversations with team members, and logging of text from instant message conversations.
Read the article, Microsoft Windows Messenger Integration Custom Project Guide.
The Interviewer Wizard Custom Project Guides
The Interviewer Wizards are custom Project Guides that walk users through a series of questions, and based on their responses, generates an appropriately scheduled project plan which is a stripped-down version of the master plan. There are two wizards; one for a Product Launch, and the other for a Microsoft BizTalk Server Deployment. For the user's convenience, after completing an interview, the responses are stored in the master plan and can be edited or deleted at any time.
Read the article, The Interviewer Wizard Custom Project Guides.
Default Project Guide Files
This article lists the default files for the Project Guide included with Microsoft Project 2002, and describes the behavior or function of each file. In addition, this article describes each goal area and all of the tasks within those goal areas.
Read the article, Default Project Guide Files.
Creating a Custom Project Guide with the Project Guide Editor
This sample provides files and instructions for using a Microsoft Project Guide editing tool. It has the functionality for creating goals and tasks, specifying related tasks, and adding view and page changes. It also has the ability to add the content of an existing Project Guide to the one you're editing.
Read the article, Creating a Custom Project Guide with the Project Guide Editor.
The Task Auditor Custom HTML View
This article includes a download for a custom Microsoft Project Guide called Task Auditor, which allows you to customize a list of tasks based on responses to wizard questions.
Read the article, The Task Auditor Custom HTML View.
Customizing Microsoft Project Server E-mail Notifications and Reminders
This article shows you how to add custom e-mail notification and reminder data to the Microsoft Project Server database, as well as how to customize Microsoft Project Web Access so that the notifications and reminders are available for members of your organization. This article also describes how you can use three Microsoft Project methods to enable Microsoft Project Web Access e-mail notifications and reminders in a third-party timesheet application.
Read the article, Customizing Microsoft Project Server E-mail Notifications and Reminders.
Enhancing Microsoft Project Web Access with Print My Timesheet
This article describes how to construct a customized Timesheet view for Microsoft Project Web Access. The sample view is formatted for printing, and is accessible through a menu item added to the Activities in Tasks view.
Read the article, Enhancing Microsoft Project Web Access with Print My Timesheet.
Extending Microsoft Project Functionality with Custom Views and LoadWebBrowserControl
In past versions, Microsoft Project has been limited by the range of parts available for its views. This article and its code samples show how to fix that in Microsoft Project 2002 with custom views made from Web services and custom Internet Explorer content. This article explains what custom views offer, how to create custom views, and how to integrate them into Microsoft Project using the LoadWebBrowserControl object model call.
Read the article, Extending Microsoft Project Functionality with Custom Views and LoadWebBrowserControl.
Section 4: Microsoft Project Server and Web Technologies
The articles in this section discuss analyzing Microsoft Project data with Office XP Web components and OLE DB.
Analyzing Microsoft Project 2002 Data with Microsoft Office XP Web Components and OLE DB
This article demonstrates how to bind Office XP Web Components (OWC) to Microsoft Project through OLE DB to provide customized, advanced reporting and analysis of project data. The examples use two of the controls to display data from a project file and provide high-level information about the summary tasks. If the project file is a master project, high-level information about the subprojects is displayed.
Read the article, Analyzing Microsoft Project 2002 Data with Microsoft Office XP Web Components and OLE DB.
Microsoft Project Server Security Enhancements
This article describes how to extend Microsoft Project Server to support new security features and control access to those features using the Microsoft Project Server security system.
Read the article, Microsoft Project Server Security Enhancements.
Understanding Microsoft Project Web Access Grid Controls
Microsoft Project Web Access controls can be customized for use with another data source, such as a Microsoft Access database (*.mdb). By using Microsoft Project Web Access ActiveX controls, you can develop custom solutions for use in your own applications, or for use in a digital dashboard.
Read the article, Understanding Microsoft Project Web Access Grid Controls.
Microsoft Project Server Grid Control API Reference
This portion of the article describes in detail the different properties, methods, and events used in the PjGrid.ocx control for Microsoft Project Server. Each property, method, and event might also include a list of constants and an example.
Read the reference material, Microsoft Project Server Grid Control API Reference.