Unable to read Custom field values

[manoj]

HI,

I am using project server 2007 environment.

My environment is using RBS,location and Resource group as custom fields. I
am able to read Resource table columns like RES_Name,RES_Cost
Center,WRES_Email etc. , but unable to read above mentioned custom fields.
Actually i am not sure which database and which datatable the resource custom
fields are stored.

the code i use follows:

//resource dataset
resourceDsCustom = resource.ReadResource(resourceRow.RES_UID);
//resource.ReadResource() should give all of the information present in
Resource and ResourceCustom fields. I am getting 42 column information in
all. But none gives me my required column info(RBS, location and resource
group)

any sort of help will be deeply appreciated.

Thanks in advance...

 

[Rod Gill]

If you are using PSI, then you need to thoroughly digest the SDK for
Project. Personally I always read directly from the reporting database. Try
reading the EPM_ResourceUserView View in the reporting database.

--

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