Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Update Material Cost Resources using psi?

Answered Update Material Cost Resources using psi?

  • Wednesday, 1 September 2010 9:46 PM
     
     
    Sign In to Vote
    0

    Hi :

    I am hoping someone has an answer for this asap.  Can you update Material Resource Cost using psi?   If it can.  Or have some code to show and how this can be done.  Please let me know. 

    I am not updating cost resource type.  Just Material Resource Cost.

    Thanks,

    kkmick

     

     

     

All Replies

  • Friday, 3 September 2010 8:02 PM
    Owner
     
     Answered
    Sign In to Vote
    0

    Hi kkmick,

    Are you just looking to change the rate set for your material resource?  Have you tried using the Resource Web Service?  Must admit I haven't used it for changing material resource costs but can't see why this wouldn't work.  The SDK sample for UpdateResources just changes a name - but you should be able to see how you could change values in the ResourceRatesRow.

    From the SDK:

    The [Resource Web service] namespace is an arbitrary name for a reference to the Resource.asmx web service (or the Resource.svc service) of the PSI in Microsoft Project Server 2010. Methods in the Resource class can check out, check in, update, or create resources and their authorization settings. Resources can be work, material, or cost resources. Methods also can activate or deactivate users and create, read, update, or delete resource delegates. Methods can find resources by name, GUID, or department; read resource or user data and related security information; and get all assignments for a resource.

    Best regards,

    Brian.

    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
     
  • Wednesday, 8 September 2010 6:54 AM
     
     
    Sign In to Vote
    0

    Hi Brian:

    I am currently using project server 2007.  I am trying to tie a legacy accounting system to project server 2007.  Since we can not update cost resource using psi.  I was told to use material cost resources instead.  If the number changes in our accounting sytem, I will need to update the material cost in project server 2007.  I will look for at the resource.asmx again. 

    Thanks,

    kkmick

     
  • Monday, 13 September 2010 7:39 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi kkmick,

    Brian is correct that you need to use the Resource Web Service.

    To change the cost on a material resource, you need to update the resource rate table.
    Resources can be retreived as a ResourceDataSet. For each ResourcesRow in the data set, you can retreive it's cost rate table using GetResourceRatesRows. You need to modify the ResourceRatesRow to update the cost (= rate). For full documentation, see the SDK.

    I hope this helps,
    Hans

    My EPM blog: Projectopolis
     
  • Tuesday, 14 September 2010 7:22 PM
     
     
    Sign In to Vote
    0

    Thank you Hans.  I will definitely take a look at that.  I just came back from vacation.  Trying to catch up some work.