Resource Standard rate

[Jose X Perez]

Hi every one,
I have a PS2007 eviroment with SQL2000
I need to update the standard rate of a resource, using the PSI or the sdk,
from the HHRR system of my company.
I already do that with a macro but it is a manual solution to update the
data, i need to do this without user manipulation.

What is the best way to do this?

Thank for your help,

Jose X Perez

 

[Rod Gill]

If there are less than 10 updates, open the Enterprise Resource Pool and do
it manually.

More than 10 and I might create a VBA Macro to update the Resources with the
Enterprise Resource Pool open. New rates can be read from any oledb
database.

PSI is an option, but requires high skills and would take much longer and so
cost more (to support as well). PSI might well be the best bet however if
you want to sell the solution to 3rd parties (though you could convert the
VBA macro to a Project Add-in as well).

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Jose X Perez]

I have around 8000 resources so i can not create them manually or uodate them,
And the rates of my resources change regularly.

Can you guide me how use psi or sdk to update the resources?

 

[Rod Gill]

I can't guide you on using psi. You need to be a skilled and experienced C#
programmer with knowledge of web services (which I'm not!) and the Project
SDK.

Development in VBA for updating Resources in the Enterprise Resource pool
from a database such as SQL Server is a fairly easy solution as usually only
one or two people would need to use the code. You can get the basics of
updating a resource from recording a macro and there are many examples of
how to read data from a database on the web.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Ray McCoppin]

Look in the Project 2007 SDK hrlp file. Look at the example code for the
topic "Resource.UpdateResources Method". You will need to change this code
to update the "ResourceDataSet.ResourceRatesRow" they your rates.

Hope this Helps
--
Ray McCoppin

http://www.randsmanagement.com
Project Server Mass Resource Tool
SRS gantt charts