Sign in
Microsoft.com
 
Microsoft
 
 
 
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
Microsoft >
> 
> 
> 
How change the resource using SQL Server

Answered How change the resource using SQL Server

  • Thursday, July 08, 2010 3:05 PM
     
     
    Sign In to Vote
    0

    Hi guys... 

    I'm doing a customization in PWA 2010, and I need change the resource of the task using a simple update in SQL Server. Currently I'm updating MSP_ASSIGNMENTS table, but it isn't sufficient to change de resource, anyone can help me?

    I could use the Project Web Services, but I cant found anything like that.

     

    Cheers

     

    PS: I enabled the trace of SQL Server to discovery all tables that can be update, and changed the resource by pwa interface, but I can't discovery anything.

    PS2: Sorry about my english, I'm brazilian and I don't speak english very well. =D

     

All Replies

  • Thursday, July 08, 2010 11:41 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

     In general, we don't support changes to the data going directly to the database. You will miss out on any business rule logic that we have in the app tier. If you can shed some light on what you need to change, we may be able to help out pointing you to samples or code snippets that will help you accomplish what you need.

    Thanks,

    Boaz Lev

    MSFT

     
  • Monday, July 12, 2010 6:03 PM
     
     
    Sign In to Vote
    0

    Hi, tks for your help.

     

    So, I'll explain about my app. I created a webPart that have a vizualization look like My Tasks of PWA, but this tasks don't have anyone resource, when I loggin in PWA I can get any tasks, but I don't found anything like that, so I created the new WebPart, but I have this problem.

     

    Tks

     
  • Monday, July 12, 2010 7:54 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Your Web Part needs to call the PSI to change the task assignment to the current user, or to another resource. Depending on what you want to do, the methods might include DelegateAssignments, ReadProject, ReadProjectEntities, QueueUpdateProject, and others (CheckOutProject, QueuePublishProject, CheckInProject, GetCurrentUserUid, and so forth).

    You should use the WCF interface with the ProjectServerServices.dll proxy assembly, and programmatically configure the service, as explained in Walkthrough: Developing PSI Applications Using WCF.

    Whatever you do, don't directly change the Draft or Published databases, or you could corrupt Project Server data. See About Accessing the Project Server Databases in Project Server Programmability.

    --Jim