How to control Lookup Table updates?

Brian Smith and I just finished putting together code samples for the Project Server 2007 session we’ll deliver at the TechEd Developer conference next week entitled: Line-of-Business Integration Using Microsoft Office SharePoint Server 2007 and Microsoft Office Project Server 2007

Please find the first piece of code we’ll leverage next week: Project Server 2007 Lookup Table Update Control on MSDN Code Gallery.

Out of the box you cannot control updates of specific lookup tables in Project Server 2007. This code sample leverages the standard Project Server interface API as well as standard event handlers to limit who and what lookup table can be updated. For our presentation we are demonstrating how Project Server 2007 can be integrated with Line Of Business applications; we thus wanted to illustrate the fact the lookup table data in PS might be a “slave” to a “master” system (an ERP application for instance). Therefore we wanted to limit who could make updates to specific LOB lookup table in PS.

The following three Lookup Table Events were overwritten:

  • OnCheckingOut
  • OnUpdating
  • OnUpdated
User can’t checkout LT because he’s not a member of the custom security group Audit the fact that the LT got updated
image image

I would also like to point out another great code sample posted by Jean Donati from Microsoft France that leverages Infopath Forms Services to make project plan updates: EPM 2007 Project Updater InfoPath Form

Comments (5)
  1. This is the first of my pre-TechEd 2008 postings – and you may already have seen one that Christophe

  2. In yesterday’s posting the BDC was used to present data from both Project Server and the AdventureWorks

  3. Boris Scholl, Brian Smith and I will be attending TechEd Developers 2008 in Orlando next week. We’ll

  4. Boris Scholl, Christophe Fiessinger and I will be attending TechEd Developers 2008 in Orlando next week.

  5.   Boris Scholl, Brian Smith and Christophe Fiessinger will be attending TechEd Developers 2008 in

Comments are closed.

Skip to main content