Importing and Exporting a Split Task

Question

Good day,

I need to import project data from another application to MS project and I need to make use of a Split Task. When using excel to export a MS project with split tasks, the split related information of the task does not export and there does not seem to be a mapping available for split tasks.

When using XML the import/export works but it is not clear which fields are used in the XML file to  "define" the split information.

I would appreciate any suggestions on how to do this. I am proficient in VBA/SQL so a VBA/SQL solution would do as well.

Regards

Joshua

Answer 1

Hi Joshua,

In exported XML the timephased assignment data will show when a resource is has zero hours assigned (and the task is split). 

If you see:

<Value> PT0H0M0S</Value>

That is a period where the task is split a the assignment has zero work.

-<TimephasedData>

<Type>1</Type>

<UID>2</UID>

<Start>2014-02-03T08:00:00</Start>

<Finish>2014-02-03T17:00:00</Finish>

<Unit>2</Unit>

<Value>PT8H0M0S</Value>

</TimephasedData>

-<TimephasedData>

<Type>1</Type>

<UID>2</UID>

<Start>2014-02-03T17:00:00</Start>

<Finish>2014-02-04T17:00:00</Finish>

<Unit>2</Unit>

<Value>PT0H0M0S</Value>

</TimephasedData>

-<TimephasedData>

<Type>1</Type>

<UID>2</UID>

<Start>2014-02-04T17:00:00</Start>

<Finish>2014-02-05T17:00:00</Finish>

<Unit>2</Unit>

<Value>PT8H0M0S</Value>

</TimephasedData>

<T

Answer 2

Joshua,

Because the start and stop points for a split task are not accessible fields, a normal import map will not work for split tasks. If you want to use XML, you might start with the following link:

http://msdn.microsoft.com/en-us/library/bb428843.aspx.

Personally I would use VBA. The split parts are accessible through VBA using the SplitParts Collection Object.

John

Answer 3

Great and thanks for the feedback.

Answer 4

Joshua_748,

You're welcome and thanks for the feedback.

John

Answer 5

Thanks for the info! Both the xml and VBA options will do the job...