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 the table for work from the event handler. It imports and submits the timesheet. This work is based upon EPM Timesheet tied-mode work done by Christophe Fiessinger (http://blogs.msdn.com/chrisfie).

Bulk Project Delete

A command line .exe that allows the scripted deletion of projects from a Project Server 2007 installation. Useful for bulk project deletes required for retention compliance. Currently, the code requires a plain text file as input for project names.

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

Project Server 2007: search data using SharePoint's BDC and Enterprise Search

EPMBDC.zip (691 kB)
Search Project Server data using SharePoint Server's BDC and Enterprise Search

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 Test Data Population Tool

EPMDatapop.zip (28,4 MB)
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 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. 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.

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

Persisting SSAS OLAP Roles In Project Server 2007

epmssas.zip (6,8 MB)
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 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 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.

Project Server 2007 Timesheet & Statusing Customization Samples

EPMTSST.zip (2,6 MB)
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 AD/Resource Sync Utility

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

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