Creating a custom field in Project Server

[n2singing]

My manager wants to create a new field for a project in order to input an
integer associated to a "bug" (for use with a bug-tracking application). Is
this field added to one of the MS Project tables in the actual SQL Database?
If so, which table? If you don't modify those tables, how would you create
this field? Also, once the field is created in the database, how do you
modify the project form itself to allow the users to input this new integer
value? I'm just trying to get a general scope for whether any of this is
even possible before I start with the process of installing and learning MS
Project.

Signed,
Know nothing about Project Server! :?)

 

[JackD]

1) Yes, the number fields in Project are present in the SQL database.
2) You wouldn't modify the table, you would simply use one of the available
fields (there are 30 number fields available)
3) Modify or develop a table to accept the data. (this can be as simple as
going to the insert menu and selecting column)
4) Very simple.

I suggest that you read the document titled projdb.htm on any machine that
has project installed. It covers working with the database. Custom fields
are a bit more tricky than some as you need to look at / or join to the
MSP_CONVERSIONS table to get the correct field identifier. Once you do this
once it is quite simple.

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

My manager wants to create a new field for a project in order to input an
integer associated to a "bug" (for use with a bug-tracking application).
1)
Is this field added to one of the MS Project tables in the actual SQL Database?
If so, which table?
2)
If you don't modify those tables, how would you create
this field?
3)
Also, once the field is created in the database, how do you
modify the project form itself to allow the users to input this new integer
value?

4) I'm just trying to get a general scope for whether any of this is

 

[Dale Howard [MVP]]

Know nothing --

To create the custom field, your Project Server administrator would need to
complete the following steps:

1. Open the Enteprise Global file
2. Create a new custom enterprise Task number or text field
3. Create a new Table and View through which users can enter data in the
new field
4. Save the Enterprise Global file

The next time that project managers log into Project Server through
Microsoft Project Professional, they will be able to access the new field,
Table, and View. Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"

 

[n2singing]

Thanks!

Know nothing --

To create the custom field, your Project Server administrator would need to
complete the following steps:

1. Open the Enteprise Global file
2. Create a new custom enterprise Task number or text field
3. Create a new Table and View through which users can enter data in the
new field
4. Save the Enterprise Global file

The next time that project managers log into Project Server through
Microsoft Project Professional, they will be able to access the new field,
Table, and View. Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"