RESOURCE RATES

[ivan405]

Hi cracks,

First of all; sorry for my english, isn't very well, but i hope that
you could understand me.

My query is about project server 2003 and the Resource Rates:

I want insert automatically from our ERP (Navision) the Resource Rates
for all Resources with their dates when rate is modified, but when i
open MSP_RESOURCE_RATES all rows have PROJ_ID, but if i insert the
rates and dates into res pool anything project is assigned and i can
open the resource with the new rates, ¿where is saved on database the
information for this resource without proj_id?

Now, i only could insert a row into MSP_RESOURCE_RATES for each
Resource and Project in MSP_RESOURCE with the requeriments dates for
the new rate, ¿is the unique solution?

Thank you all.

Greetings

Ivan

 

[Chak]

Hi Ivan,

I posted the similar post two years ago in this group.

Also, please note that it's not safe, if you inserting data in
MSP_Resources table. In general Proj_id for resource pool is 1.

You can also consider PDS approach on this. My posting below here was
based on VBA.

I am giving the URL below:

http://groups.google.com/group/micr...nk=gst&q=chak+resource+rates#9ea894f161cb7b86


Thanks
Chak
http://www.epmcentral.com

 

[ivan405]

Hi Chack,

Thank you for your reply Chack .

I'll check the URL and the data for project id 1 on MSP_RESOURCES for
insert it on MSP_RESOURCE_RATES.

Thank you a lot. I'll tell you.

Greetings

Ivan

 

[Chak]

Hi Ivan,

I would like to alert you on this, try to avoid insert data directly
on MSP_RESOURCES table. Insert data in one table won't be enough for
your need. Few more tables need to be have additional data like
effective dates and cost tables etc. Again, don't insert the data in
to table. Your system may be damaged by doing that.

Try to follow my post by referring the link, in my example I was
saying about SQL Server table on step 1.
In your case, have the same data in one of the ERP table or view. Once
you have the data in that structure, you can use VBA to update the
resource rates in enterprise resource pool. It's most safe and more
reliable way to do updates.

Thanks
Chak
http://www.epmcentral.com

 

[ivan405]

Hi Chak,

Now, I have a DTS that all days transform the rate data from ERP and
copy to a table on ProjectServer Database, and then update the rates
on MSP_RESOURCE table, but update all values for each rate and
resource, then we lost trazability.

Now I am creating a virtual machine with the actual Project Server for
try the VBA code that you posted 2 years ago and i supposed that the
same table on Project Server Database will be modified for the
required object on VBA Macro.

Thank you again... .

Greetings,

Ivan