Difference of TASK_Start_Date and TASK_Act_Start...

[Eric]

I want to create a graph that will show the difference of when a task is
scheduled to start vs. when it actually started. I checked the DB
documentation of Project server and found the two columns that i need
(Task_start_date [field for scheduled start] and Task_Act_Start [field for
actual start]).

However i noticed that even if the task actually started so late, the
task_act_start is still the same as those of the task_start_date. It does not
actually get the actual date that the task has started.

We want to analyze if the members are working as scheduled.

Any help on these? or am i looking at the wrong tables??

 

[doniy]

When you change actual start,it seems that Task_start_date will change to
actual start date automatically.
if you want to show the difference,you'd better save a baseline before you
put in any actual date. Then compare task_start_date with task_base_start

 

[Eric]

I tried replacating the value of the actual start from the database but the
task_start_date still remains the same. I'm not sure if i did it right but i
thinks it's the only way to change the task_act_start is through the
database. How did you change yours?

When you change actual start,it seems that Task_start_date will change to
actual start date automatically.
if you want to show the difference,you'd better save a baseline before you
put in any actual date. Then compare task_start_date with task_base_start

I want to create a graph that will show the difference of when a task is
scheduled to start vs. when it actually started. I checked the DB
documentation of Project server and found the two columns that i need
(Task_start_date [field for scheduled start] and Task_Act_Start [field for
actual start]).

However i noticed that even if the task actually started so late, the
task_act_start is still the same as those of the task_start_date. It does not
actually get the actual date that the task has started.

We want to analyze if the members are working as scheduled.

Any help on these? or am i looking at the wrong tables??

 

[Jan De Messemaeker]

Hi Eric,

Please read donyi's advice carefully.
It says, and I confirm that whatever, whatever you do, when there is an
actual start it will show the same date as start. You can stop looking for a
way to change that.
If you want to compare to the original plan you have to save this original
plan as a baseline.
Hope this helps.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

I tried replacating the value of the actual start from the database but the
task_start_date still remains the same. I'm not sure if i did it right but i
thinks it's the only way to change the task_act_start is through the
database. How did you change yours?

When you change actual start,it seems that Task_start_date will change to
actual start date automatically.
if you want to show the difference,you'd better save a baseline before you
put in any actual date. Then compare task_start_date with task_base_start

I want to create a graph that will show the difference of when a task is
scheduled to start vs. when it actually started. I checked the DB
documentation of Project server and found the two columns that i need
(Task_start_date [field for scheduled start] and Task_Act_Start [field for
actual start]).

However i noticed that even if the task actually started so late, the
task_act_start is still the same as those of the task_start_date. It does not
actually get the actual date that the task has started.

We want to analyze if the members are working as scheduled.

Any help on these? or am i looking at the wrong tables??

 

[doniy]

I change it in MS-Project.
I think you are update the project using a database software such as MS
access.
The following istruction is pasted from "PROJDB.htm" (you can find it in
help folder of MS-Project), you'd better read it carefully.
-----------------------------------------------------------------------------------------------
" Setting the flags required to enable updating project data in the database
In all cases where project data in a database is edited outside Microsoft
Project, the column PROJ_EXT_EDITED in the table MSP_PROJECTS must be set to
"True."

When editing existing rows in the tables MSP_TASKS, MSP_RESOURCES,
MSP_ASSIGNMENTS and MSP_LINKS, the column EXT_EDIT_REF_DATA must be set to
"1" followed by the values of the columns listed in the table below (all
values delimited by commas). When creating new rows, however, the column
EXP_EDIT_REF_DATA should be set to "1". (Note: It is recommended that the
stored procedures included with Microsoft Project be used to update this
column with the required values. See Ensuring integrity in a project in a
database.)

-----------------------------------------------------------------------------------------------

I tried replacating the value of the actual start from the database but the
task_start_date still remains the same. I'm not sure if i did it right but i
thinks it's the only way to change the task_act_start is through the
database. How did you change yours?

When you change actual start,it seems that Task_start_date will change to
actual start date automatically.
if you want to show the difference,you'd better save a baseline before you
put in any actual date. Then compare task_start_date with task_base_start

I want to create a graph that will show the difference of when a task is
scheduled to start vs. when it actually started. I checked the DB
documentation of Project server and found the two columns that i need
(Task_start_date [field for scheduled start] and Task_Act_Start [field for
actual start]).

However i noticed that even if the task actually started so late, the
task_act_start is still the same as those of the task_start_date. It does not
actually get the actual date that the task has started.

We want to analyze if the members are working as scheduled.

Any help on these? or am i looking at the wrong tables??

 

[staci.bouras]

Hi Eric,
Please read donyi's advice carefully.
It says, and I confirm that whatever, whatever you do, when there is an
actual start it will show the same date as start. You can stop looking for a
way to change that.
If you want to compare to the original plan you have to save this original
plan as a baseline.
Hope this helps.
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Eric" <[email protected]> schreef in bericht
the
i
to
you
task_base_start
is
for
does not

Thank you

(e-mail address removed)

 

[cmonnier]

To be able to do taht you have first to save a baseline in MSP. This will be
your scheduled data. These values are saved in the columns TASK_BASE_START
andTASK_BASE_FINISH. There is already a view "Tracking Gantt" in MSP to
compare the baseline vs. the actual.

"Eric" a écrit :