How to control Lookup Table updates?

Christophe Fiessinger's Blog

The latest news you need to know about Microsoft Enterprise Social & Project Portfolio Management

How to control Lookup Table updates?

  • Comments 5

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

Leave a Comment
  • Please add 6 and 6 and type the answer here:
  • Post
Page 1 of 1 (5 items)