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.
Attached is my source code and power point presentation of today's webcast on custom fields and lookup tables:
We will be publishing the presentation to the web in the next few days. Once it is available, I will post a link to it.
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.
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: 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?
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: email@example.com
Q: Will this tool be distributed in other ways (i.e. DVDs)?
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
Christophe just passed along some information about a new solution starter on CodePlex:
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:
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
This solution starter was created for a presentation I delivered at the 2008 Office Developer Conference.
A: Customers and Partners can use both. Please point them to CodePlex as they have to agree on the license terms
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.
Leveraging the development aspects of Project Server 2007 spans a wide range of skills. PWA customizations (ASP.NET), workflow development, line of business applications integration using the PSI, extending Project Server functionality using server side events, specialized reporting from the Project Server databases and experience using VSTO are all areas of discussion.
The Project Server Product Group currently supports these efforts through channels such as the this Blog, Project Support WebLog, Project.Server Discussion, Project.Developer Discussion, and the Project 2007 Team Blog.
To streamline and augment the existing efforts, we are seeking developers to join the already established Project.Developer Discussion Group.
By joining we invite you to share and discover knowledge about Project Server 2007's highly extensible out-of-the-box developer's platform, access Project Server Developer best practices, utilize a technical window back to the MS Project Server Development Group, and take part in several specialized webcasts on Development topics coming up in the next couple months.
To identify yourself as someone that would like to join the Development Community, please contact Joyce Bileau, v-joyceb@microsoft for more information.
To join, go to http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.project.developer.
The Project Portfolio Server 2007 SP1 is now available:
For a list of what is fixed in SP1, check out:
Tags: Project Portfolio Server SP1
Just got an e-mail from Jim that Version 2 of the Microsoft Office Interactive Developer Map was published today, by the Office Developer Center folks.
The new version includes lots of new stuff (new products and new interactive links) – such as VS2008, Communications Server, Performance Point Server, Office Business Application (OBA) resources, and more.
After you install it, the shortcut is in the 2007 Microsoft Office System Developer Resources folder in your Start menu.
Just a small update to the Statusing Transaction (Partial Documentation) post. The ASSN_TRANS_ACTION_ENUM enum was missing a couple of values:
/// <summary>Saved by team member.</summary>
Saved = 0,
/// <summary>Submitted by team member, awaiting action by manager.</summary>
Submitted = 1,
/// <summary>Submitted for processing by manager, awaiting processing by message handler.</summary>
InProcess = 2,
/// <summary>Applied to working store.</summary>
ApplySuccessful = 3,
/// <summary>Failed to be applied to working store.</summary>
ApplyFailed = 4
There have been a number of people that have asked me about connecting Project Server to VSTS. Here is a pointer to a CodePlex project that will do just that:
"The Visual Studio Team System Project Server 2007 Connector is designed to integrate the project management capabilities of VSTS with Project Server 2007. It's been developed by the Visual Studio Team System Rangers in response to significant customer demand for a connector solution. Future versions of Team System will have native integration with Project Server, in the meantime this Connector solution is the best way to integrate the two Microsoft products. This solution builds on the previous PS2003 VSTS Connector, published on GotDotNet. This solution is intended to provide guidance, provided as source code that can be used "as is," extended, or modified by developers to use on enterprise development projects."