PS2003 - How to fill out Enterprise Custom Fields

[g_andrey]

I am trying to do a number of things programmatically with Project Server
2003. I am already using PDS and ProjectTasksCreate XML to create a project
and add tasks with it, but now I need to do more and having problems.

I am trying to, programmatically, fill out Enterprise Custom Fields (that
were made mandatory) after a new project is created. Fields appear under
Project/Project Information. I know that selected fields are kept in
MSP_CODE_FIELDS table for each project and once the data is there I can
manipulate it using UPDATE SQL code. But, when I INSERT new items to that
table they are not displayed in the front end: Project/Project Information
screen. What am I missing? Am I supposed to use
EnterpriseCustomFieldsUpdate Method to insert data? If yes, how? I have
not been able to find any good description of how to do that.

Option 2: Is there a way to fill all this out using VBA and publish a
project (also using VBA)? How? Please provide example.

Thanks in advance

 

[Rod Gill]

Hi,

Can't help with PDS (you also need to be aware that PDS has been completely
replaced by PSI in PS 2007)

VBA can do this easily. Record a macro in Project Professional of you
opening a file, editing a custom field and then saving and publishing it.
The recorded code provides your answer and VBA help has lots of good
examples as well under each topic.

--

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

 

[g_andrey]

Rod,

PS2007 is not an option right now.

I have tried to record a macro, but for Enterprise Custom Fields nothing
shows up in the macro but the name to the procedure: ProjectSummaryInfo.
That's it.

When I fill out other(default) fields within Project/Project Information
screen the macro shows : ProjectSummaryInfo StatusDate:="Thu 5/17/07", but
nothing for the custom fields. Any other way to do it?

Thanks

 

[Rod Gill]

Try

activeproject.ProjectSummaryTask.EnterpriseText1
activeproject.Tasks(1).EnterpriseProjectText1

etc.
--

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