RBS field

[alex]

Hi,

I try to find the RBS field. Why?
Because I need to change the value of MSP_LOOKUP_TABLE.* because RBS has
been affected by modification.
So I should modified MSP_LOOKUP_TABLE.
I find how.

But this modification impacts the RBS.
I don't find RBS in the database.

Anyone know where I can find this informations?

Thanks,
Alexandre

 

[alex]

Finally,

I find the field.
Maybe this one can help.

select * from MSP_EpmLookupTable
take the MemberUID
select * from MSP_EpmCPResUid0
take the entity id and that's the ressource_uid.
Now you know the link.

Enjoy

 

[Chris Boyd]

Hello,

You should not go directly to the database. This is not a supported
interface and you may run into unforeseen issues.

You can use the lookup table/custom field PSIs to determine the definition
of the RBS and the associated lookup table and call the Resource PSI to get
at the actual values.

--
Chris Boyd
MS Project
Program Manager

Blog: http://blogs.msdn.com/project_programmability/

 

[alex]

Hi Chris,

In fact, I wis give more informations :
My RBS has this representation :
Manager Section 1 Group1
Manager Section 1 Group2

Know we want to merge the two elements in one :
Manager Section1

If I change the values by the administrative webSite, I think I should
delete the value Manager Section 1 Group2 and rename the Manager Section 1
Group1.
And after that I should correct in all ressources associate to the old
Manager Section 1 Group2.

So I think I should modify the database by query.
Do you think it's good?
Or I should use PSI, I don't see yet every webmethod available.

I find in the sdk a chm explains methods about the structure of the database
reporting but not publishing, do you know a documentation about this one.

Thanks,
Alexandre

 

[Rod Gill]

Hi,

Microsoft reserve the right to change all dbs except the reporting db, so
they haven't released a schema for them. Much safer to open all resources in
Project Professional and do a search replace on the RBS column then save.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx