Retrieving custom fields from MSPS 2003

[lumar]

I've noticed a similar question has been posted fro MSPS 2007; how can I
retrieve the values of project enterprise custom fields from the SQL database?
I've found the custom text and number fields, but not the outline codes
fields.
I've also looked for the reporting database, but I couldn't find it.
Is it available for MSPS 2003 too?

 

[Jack Dahlgren]

The reporting database is new for Project Server 2007. It is not in 2003.

-Jack Dahlgren

 

[lumar]

Thanks.
So, is there another way to retrieve those values?
Are they stored anywhere in the MSPS database?

 

[jrichardson]

Microsoft does not guarantee the persistence of the implemented schema
version to version. With that said, you could use a query like that below to
get a list of custom outline codes with their values from the MSP 2003
database. You could also tie in MSP_CODE_FIELDS to relate those values to
assigned projects, tasks, resources.

SELECT A.AS_VALUE AS FIELD_NAME
,OC_NAME AS FIELD_VALUE
FROM [DBO].MSP_OUTLINE_CODES OC INNER JOIN
[DBO].MSP_PROJECTS P
ON P.PROJ_ID = OC.PROJ_ID INNER JOIN
[DBO].MSP_FIELD_ATTRIBUTES FA
ON FA.ATTRIB_FIELD_ID = OC.OC_FIELD_ID
AND FA.PROJ_ID = OC.PROJ_ID INNER JOIN
[DBO].MSP_ATTRIBUTE_STRINGS A
ON FA.AS_ID = A.AS_ID
AND FA.PROJ_ID = A.PROJ_ID
WHERE P.PROJ_TYPE = 2 AND FA.ATTRIB_ID = 206
ORDER BY A.AS_VALUE

I'm not sure what outline code extraction is available in the MSP API, but
that may be an option, also.

Jason

 

[Chak]

Hello lumar,

Please refer the following URL for SQL query:

http://www.epmcentral.com/pjadmin/entfieldsdbscripts.php

Thanks
Chak
http://www.epmcentral.com