Re: Creating a custom field in Project Server

From: JackD (momokuri_at_gmail)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 14:58:18 -0700

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
.
"n2singing" <n2singing@discussions.microsoft.com> wrote in message
news:2F6B300E-2CBD-450A-B562-A2D008DEDF82@microsoft.com...
> 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
> even possible before I start with the process of installing and learning
MS
> Project.
>
> Signed,
> Know nothing about Project Server!  :?)

Relevant Pages

  • Re: Shared v. Exclusive Access
    ... Control Panel, Add/remove programs, find Adobe, click Modify -> create Adobe ... The folder wherein the frontend resides grants Full permissions to the ... When I open the database, however, I don't get the message boxes. ...
    (microsoft.public.access.security)
  • Re: What is wrong or missing if I cant modefy an exisiting workgroup?
    ... 1)I wasn't able to remove admins group form User Admin. ... database and managed to modify the existing newsystem.dmw. ... Allthough I found an application that had security ...
    (microsoft.public.access.security)
  • Re: Multiple users on an Access database
    ... I think version 97 was the last one that allowed you to modify objects while someone else was using the mdb - not any more. ... I've split the database however I'm still encountering problems. ... design of a Report or Form the following message appears " Microsoft ... Access can't save design changes or save to a new database object because ...
    (microsoft.public.access.security)
  • Re: Backend Ldb file
    ... the network rights are EXACTLY the problem. ... work as intended, all users should have Create, Modify, and Delete rights as ... If a user cannot create the LDB, ... > in the database on the previous day, but is not at work on ...
    (microsoft.public.access.setupconfig)
  • Re: [Info-ingres] Replicator and E_US0845
    ... > Having added the replicator catalogs and support objects to a database ... > An attempt to modify or optimize an archive table fails with: ... > Note that I am connecting as the owner of this table. ... > While its probably not a good idea to modify or optimize these tables, ...
    (comp.databases.ingres)