split task

[kamiar]

I have some split task in my Ms. Project file, and I need to export the
information to an access file. But I don’t know in which fields I can find
the information about the split tasks such as start and finish date of each
portion of the task or the interruptions.

 

[John]

I have some split task in my Ms. Project file, and I need to export the
information to an access file. But I don’t know in which fields I can find
the information about the split tasks such as start and finish date of each
portion of the task or the interruptions.

kamiar,
Properties of Split Tasks is not available in any field but it can be
accessed through the SplitParts Collection Object in VBA or from the
Project database directly using SQL. For example, using VBA the Start
and Finish dates for the first split part of Task 5 has the snytax:
ActiveProject.Tasks(5).SplitParts(1).Start
ActiveProject.Tasks(5).SplitParts(1).Finish

Check the VBA help file for more properties of SplitParts. For
information on the Project database, look for the file:
prjdb.htm on your hard drive.

Hope this helps.
John
Project MVP

 

[kamiar]

Hi John,
Thanks a lot for your response.
kamiar

kamiar,
Properties of Split Tasks is not available in any field but it can be
accessed through the SplitParts Collection Object in VBA or from the
Project database directly using SQL. For example, using VBA the Start
and Finish dates for the first split part of Task 5 has the snytax:
ActiveProject.Tasks(5).SplitParts(1).Start
ActiveProject.Tasks(5).SplitParts(1).Finish

Check the VBA help file for more properties of SplitParts. For
information on the Project database, look for the file:
prjdb.htm on your hard drive.

Hope this helps.
John
Project MVP

 

[kamiar]

Hi John,
Your response was perfect in this level, but now I have the same question
about baseline
For more clarification about my question:
If you have split task and you save the project as baseline you will have
this information in baselines data, but how you can access to this data? For
example start date of second portion of baseline (or baseline3).
May I have your command line in VBA?
Best regards
kamiar

 

[John]

Hi John,
Your response was perfect in this level, but now I have the same question
about baseline
For more clarification about my question:
If you have split task and you save the project as baseline you will have
this information in baselines data, but how you can access to this data? For
example start date of second portion of baseline (or baseline3).
May I have your command line in VBA?
Best regards
kamiar

Kamiar,
Baseline data does not exist for parts of a split task. Remember that
baseline data is simply a snapshot of limited task data at a point in
time. It is static data. For example, when a task is baselined, Project
records the Start and Finish in separate fields. In the newest versions
of Project several separate baselines can be set but they are also for
the task Start and task Finish. Since the purpose of a baseline is to
provide a basis for measuring performance to the original plan only the
task Start and task Finish are relevant. However, the schedule is
dynamic and a task may be or get split during execution of the plan.
Nonetheless, for measuring performance the only important parameters is
when the task started and when it finished. How it got there is not
important.

Just for reference, spare fields could be dedicated to take a snapshot
of task split starts and stops using VBA. With VBA virtually anything
can be done but that doesn't mean the result has any value. In my
opinion, capturing "baseline" data for task split starts and stops would
be useless.

Hope this helps.
John
Project MVP

 

[kamiar]

Hi John,
Thanks a lot for your explanation.
You are right about the measuring performance in overall (the important
things is start and finish), but something is miss and it is the trend of
progress for long task(as you mention by S_Curve). Furthermore when you save
project as baseline and you set Gantt chart layout you can see the split
portions of a task in the graphic part of Gantt chart and if you change the
data of baseline (such as start and finish) you can follow the change such as
real task for example if you change the baseline start duration of first
portion is fixed and the portion just will move. So this is why I think that
somewhere the information must be exist, but maybe there isn’t any way to
capture this data , in this case it is lack of ms.project.
If you find any thing in this regard say me
My personal e_mail is (e-mail address removed)
Best regards
Kamiar

 

[John]

Hi John,
Thanks a lot for your explanation.
You are right about the measuring performance in overall (the important
things is start and finish), but something is miss and it is the trend of
progress for long task(as you mention by S_Curve). Furthermore when you save
project as baseline and you set Gantt chart layout you can see the split
portions of a task in the graphic part of Gantt chart and if you change the
data of baseline (such as start and finish) you can follow the change such as
real task for example if you change the baseline start duration of first
portion is fixed and the portion just will move. So this is why I think that
somewhere the information must be exist, but maybe there isn’t any way to
capture this data , in this case it is lack of ms.project.
If you find any thing in this regard say me
My personal e_mail is (e-mail address removed)
Best regards
Kamiar

kamiar,
If you are referring to the split that can be seen in the baseline bar
in the Tracking Gantt view, I know of no way other than what I suggested
previously to get the split part start and finish for the baseline. Just
because something shows on Gantt graphic doesn't mean that data is
accessible either in a Project field or via VBA. In this case I do not
agree that the lack of this information is a fault of Project.

I just don't see the value in tracking baseline splits. Splits are an
interruption in the task work flow. If a task is baselined and then the
task splits, the performance measurement is against the original plan.
For the standpoint of performance to plan, who cares if the task split?
The fact is, the performance metric is likely to be negative because the
split will generally cause the Finish date to move out. The only
important question I can see is, does the reason for the split justify a
re-set of the baseline? Perhaps, but generally not. The task slipped and
the performance metric should show that.

John
Project MVP

 

[kamiar]

John
As I realized from your explanation, there is no access to split parts data
of baseline (start and finish) even via VBA.
Anyway thanks a million for your help, even though I am failed.

Best regards
Kamiar