TASK DURATION(extra task in table)

[Sreejith]

hi,
While publishing a project into the project server one
extra task is going to the project table(MSP_TASKS).(ie;if
i am publishing a project with two tasks using Microsoft
project professional then in the table(MSP_TASKS) three
entries are going with TASK_UID 0,1,2).Why this is
happening.What is the meaning of TASK_BASE_DUR_FMT value
21.How can I find out the sum of actual duration of all
published tasks of a project .I am unable to find out this
because one extra task is going to the table while
publishing a project.

Please help

 

[Jack D.]

hi,
While publishing a project into the project server one
extra task is going to the project table(MSP_TASKS).(ie;if
i am publishing a project with two tasks using Microsoft
project professional then in the table(MSP_TASKS) three
entries are going with TASK_UID 0,1,2).Why this is
happening.What is the meaning of TASK_BASE_DUR_FMT value
21.How can I find out the sum of actual duration of all
published tasks of a project .I am unable to find out this
because one extra task is going to the table while
publishing a project.

Please help

Task 0 is the project summary task. Its duration is the project duration.
You only need to query it to determine the sums of the tasks in the project.
Note that the sum of durations for all tasks is not necessarily equal to the
project duration because tasks can be done in parallel. The sum of the work
is additive though.
To see the project summary task in project go to tools menu / options/ view
tab and check the box titles "show project summary task".

I suggest you read the document titled projdb.htm to find out about working
with the database. I consider it REQUIRED reading if you are going to work
with the database. You would be a fool to skip it. Search your HD or your
project cd for the file.


--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++