none
Inserting a Task to (or Deleting a Task from) an active(currently open) Microsoft Project by importing Project XML using import option “Merge the data into active Project”. RRS feed

  • Question

  • I am  trying to change the current Opened (Active) Project using the XML Import and “Merge Data into the Active Project” option

    Initially Project is as follows

    <Image1 >

    This project contains 3 tasks Task 1, Task 2 and Task 3

    Following is the XML created for this project

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <Project xmlns="http://schemas.microsoft.com/project">
    	<SaveVersion>14</SaveVersion>
    	<Name>ProjectImportTest.xml</Name>
    	<Title>ProjectImportTest</Title>
    	<Company>c</Company>
    	<Author>Author, Project</Author>
    	<CreationDate>2015-08-26T08:00:00</CreationDate>
    	<LastSaved>2015-08-31T11:43:00</LastSaved>
    	<ScheduleFromStart>1</ScheduleFromStart>
    	<StartDate>2015-08-26T08:00:00</StartDate>
    	<FinishDate>2015-09-22T17:00:00</FinishDate>
    	<FYStartDate>1</FYStartDate>
    	<CriticalSlackLimit>0</CriticalSlackLimit>
    	<CurrencyDigits>2</CurrencyDigits>
    	<CurrencySymbol>$</CurrencySymbol>
    	<CurrencyCode>USD</CurrencyCode>
    	<CurrencySymbolPosition>0</CurrencySymbolPosition>
    	<CalendarUID>1</CalendarUID>
    	<DefaultStartTime>08:00:00</DefaultStartTime>
    	<DefaultFinishTime>17:00:00</DefaultFinishTime>
    	<MinutesPerDay>480</MinutesPerDay>
    	<MinutesPerWeek>2400</MinutesPerWeek>
    	<DaysPerMonth>20</DaysPerMonth>
    	<DefaultTaskType>0</DefaultTaskType>
    	<DefaultFixedCostAccrual>3</DefaultFixedCostAccrual>
    	<DefaultStandardRate>0</DefaultStandardRate>
    	<DefaultOvertimeRate>0</DefaultOvertimeRate>
    	<DurationFormat>7</DurationFormat>
    	<WorkFormat>2</WorkFormat>
    	<EditableActualCosts>0</EditableActualCosts>
    	<HonorConstraints>0</HonorConstraints>
    	<InsertedProjectsLikeSummary>1</InsertedProjectsLikeSummary>
    	<MultipleCriticalPaths>0</MultipleCriticalPaths>
    	<NewTasksEffortDriven>0</NewTasksEffortDriven>
    	<NewTasksEstimated>1</NewTasksEstimated>
    	<SplitsInProgressTasks>1</SplitsInProgressTasks>
    	<SpreadActualCost>0</SpreadActualCost>
    	<SpreadPercentComplete>0</SpreadPercentComplete>
    	<TaskUpdatesResource>1</TaskUpdatesResource>
    	<FiscalYearStart>0</FiscalYearStart>
    	<WeekStartDay>0</WeekStartDay>
    	<MoveCompletedEndsBack>0</MoveCompletedEndsBack>
    	<MoveRemainingStartsBack>0</MoveRemainingStartsBack>
    	<MoveRemainingStartsForward>0</MoveRemainingStartsForward>
    	<MoveCompletedEndsForward>0</MoveCompletedEndsForward>
    	<BaselineForEarnedValue>0</BaselineForEarnedValue>
    	<AutoAddNewResourcesAndTasks>1</AutoAddNewResourcesAndTasks>
    	<CurrentDate>2015-08-31T08:00:00</CurrentDate>
    	<MicrosoftProjectServerURL>1</MicrosoftProjectServerURL>
    	<Autolink>0</Autolink>
    	<NewTaskStartDate>0</NewTaskStartDate>
    	<NewTasksAreManual>1</NewTasksAreManual>
    	<DefaultTaskEVMethod>0</DefaultTaskEVMethod>
    	<ProjectExternallyEdited>0</ProjectExternallyEdited>
    	<ExtendedCreationDate>1984-01-01T00:00:00</ExtendedCreationDate>
    	<ActualsInSync>0</ActualsInSync>
    	<RemoveFileProperties>0</RemoveFileProperties>
    	<AdminProject>0</AdminProject>
    	<UpdateManuallyScheduledTasksWhenEditingLinks>1</UpdateManuallyScheduledTasksWhenEditingLinks>
    	<KeepTaskOnNearestWorkingTimeWhenMadeAutoScheduled>0</KeepTaskOnNearestWorkingTimeWhenMadeAutoScheduled>
    	<OutlineCodes/>
    	<WBSMasks/>
    	<ExtendedAttributes/>
    	<Calendars>
    		<Calendar>
    			<UID>1</UID>
    			<Name>Standard</Name>
    			<IsBaseCalendar>1</IsBaseCalendar>
    			<IsBaselineCalendar>0</IsBaselineCalendar>
    			<BaseCalendarUID>-1</BaseCalendarUID>
    			<WeekDays>
    				<WeekDay>
    					<DayType>1</DayType>
    					<DayWorking>0</DayWorking>
    				</WeekDay>
    				<WeekDay>
    					<DayType>2</DayType>
    					<DayWorking>1</DayWorking>
    					<WorkingTimes>
    						<WorkingTime>
    							<FromTime>08:00:00</FromTime>
    							<ToTime>12:00:00</ToTime>
    						</WorkingTime>
    						<WorkingTime>
    							<FromTime>13:00:00</FromTime>
    							<ToTime>17:00:00</ToTime>
    						</WorkingTime>
    					</WorkingTimes>
    				</WeekDay>
    				<WeekDay>
    					<DayType>3</DayType>
    					<DayWorking>1</DayWorking>
    					<WorkingTimes>
    						<WorkingTime>
    							<FromTime>08:00:00</FromTime>
    							<ToTime>12:00:00</ToTime>
    						</WorkingTime>
    						<WorkingTime>
    							<FromTime>13:00:00</FromTime>
    							<ToTime>17:00:00</ToTime>
    						</WorkingTime>
    					</WorkingTimes>
    				</WeekDay>
    				<WeekDay>
    					<DayType>4</DayType>
    					<DayWorking>1</DayWorking>
    					<WorkingTimes>
    						<WorkingTime>
    							<FromTime>08:00:00</FromTime>
    							<ToTime>12:00:00</ToTime>
    						</WorkingTime>
    						<WorkingTime>
    							<FromTime>13:00:00</FromTime>
    							<ToTime>17:00:00</ToTime>
    						</WorkingTime>
    					</WorkingTimes>
    				</WeekDay>
    				<WeekDay>
    					<DayType>5</DayType>
    					<DayWorking>1</DayWorking>
    					<WorkingTimes>
    						<WorkingTime>
    							<FromTime>08:00:00</FromTime>
    							<ToTime>12:00:00</ToTime>
    						</WorkingTime>
    						<WorkingTime>
    							<FromTime>13:00:00</FromTime>
    							<ToTime>17:00:00</ToTime>
    						</WorkingTime>
    					</WorkingTimes>
    				</WeekDay>
    				<WeekDay>
    					<DayType>6</DayType>
    					<DayWorking>1</DayWorking>
    					<WorkingTimes>
    						<WorkingTime>
    							<FromTime>08:00:00</FromTime>
    							<ToTime>12:00:00</ToTime>
    						</WorkingTime>
    						<WorkingTime>
    							<FromTime>13:00:00</FromTime>
    							<ToTime>17:00:00</ToTime>
    						</WorkingTime>
    					</WorkingTimes>
    				</WeekDay>
    				<WeekDay>
    					<DayType>7</DayType>
    					<DayWorking>0</DayWorking>
    				</WeekDay>
    			</WeekDays>
    		</Calendar>
    	</Calendars>
    	<Tasks>
    		<Task>
    			<UID>0</UID>
    			<ID>0</ID>
    			<Name>ProjectImportTest</Name>
    			<Active>1</Active>
    			<Manual>0</Manual>
    			<Type>1</Type>
    			<IsNull>0</IsNull>
    			<CreateDate>2015-08-26T17:23:00</CreateDate>
    			<WBS>0</WBS>
    			<OutlineNumber>0</OutlineNumber>
    			<OutlineLevel>0</OutlineLevel>
    			<Priority>500</Priority>
    			<Start>2015-09-15T08:00:00</Start>
    			<Finish>2015-09-22T17:00:00</Finish>
    			<Duration>PT48H0M0S</Duration>
    			<ManualStart>2015-09-15T08:00:00</ManualStart>
    			<ManualFinish>2015-09-22T17:00:00</ManualFinish>
    			<ManualDuration>PT48H0M0S</ManualDuration>
    			<DurationFormat>21</DurationFormat>
    			<Work>PT0H0M0S</Work>
    			<Stop>2015-09-15T08:43:12</Stop>
    			<Resume>2015-09-15T08:43:12</Resume>
    			<ResumeValid>0</ResumeValid>
    			<EffortDriven>0</EffortDriven>
    			<Recurring>0</Recurring>
    			<OverAllocated>0</OverAllocated>
    			<Estimated>0</Estimated>
    			<Milestone>0</Milestone>
    			<Summary>1</Summary>
    			<DisplayAsSummary>0</DisplayAsSummary>
    			<Critical>1</Critical>
    			<IsSubproject>0</IsSubproject>
    			<IsSubprojectReadOnly>0</IsSubprojectReadOnly>
    			<ExternalTask>0</ExternalTask>
    			<EarlyStart>2015-09-15T08:00:00</EarlyStart>
    			<EarlyFinish>2015-09-22T17:00:00</EarlyFinish>
    			<LateStart>2015-09-15T08:00:00</LateStart>
    			<LateFinish>2015-09-22T17:00:00</LateFinish>
    			<StartVariance>0</StartVariance>
    			<FinishVariance>0</FinishVariance>
    			<WorkVariance>0.00</WorkVariance>
    			<FreeSlack>0</FreeSlack>
    			<TotalSlack>0</TotalSlack>
    			<StartSlack>0</StartSlack>
    			<FinishSlack>0</FinishSlack>
    			<FixedCost>0</FixedCost>
    			<FixedCostAccrual>3</FixedCostAccrual>
    			<PercentComplete>16</PercentComplete>
    			<PercentWorkComplete>0</PercentWorkComplete>
    			<Cost>0</Cost>
    			<OvertimeCost>0</OvertimeCost>
    			<OvertimeWork>PT0H0M0S</OvertimeWork>
    			<ActualStart>2015-09-15T08:00:00</ActualStart>
    			<ActualDuration>PT7H29M18S</ActualDuration>
    			<ActualCost>0</ActualCost>
    			<ActualOvertimeCost>0</ActualOvertimeCost>
    			<ActualWork>PT0H0M0S</ActualWork>
    			<ActualOvertimeWork>PT0H0M0S</ActualOvertimeWork>
    			<RegularWork>PT0H0M0S</RegularWork>
    			<RemainingDuration>PT40H30M42S</RemainingDuration>
    			<RemainingCost>0</RemainingCost>
    			<RemainingWork>PT0H0M0S</RemainingWork>
    			<RemainingOvertimeCost>0</RemainingOvertimeCost>
    			<RemainingOvertimeWork>PT0H0M0S</RemainingOvertimeWork>
    			<ACWP>0.00</ACWP>
    			<CV>0.00</CV>
    			<ConstraintType>0</ConstraintType>
    			<CalendarUID>-1</CalendarUID>
    			<LevelAssignments>1</LevelAssignments>
    			<LevelingCanSplit>1</LevelingCanSplit>
    			<LevelingDelay>0</LevelingDelay>
    			<LevelingDelayFormat>8</LevelingDelayFormat>
    			<IgnoreResourceCalendar>0</IgnoreResourceCalendar>
    			<HideBar>0</HideBar>
    			<Rollup>0</Rollup>
    			<BCWS>0.00</BCWS>
    			<BCWP>0.00</BCWP>
    			<PhysicalPercentComplete>0</PhysicalPercentComplete>
    			<EarnedValueMethod>0</EarnedValueMethod>
    			<IsPublished>0</IsPublished>
    			<CommitmentType>0</CommitmentType>
    		</Task>
    		<Task>
    			<UID>3</UID>
    			<ID>1</ID>
    			<Name>Task 1</Name>
    			<Active>1</Active>
    			<Manual>1</Manual>
    			<Type>0</Type>
    			<IsNull>0</IsNull>
    			<CreateDate>2015-08-26T17:23:00</CreateDate>
    			<WBS>1</WBS>
    			<OutlineNumber>1</OutlineNumber>
    			<OutlineLevel>1</OutlineLevel>
    			<Priority>500</Priority>
    			<Start>2015-09-15T08:00:00</Start>
    			<Finish>2015-09-22T17:00:00</Finish>
    			<Duration>PT48H0M0S</Duration>
    			<ManualStart>2015-09-15T08:00:00</ManualStart>
    			<ManualFinish>2015-09-22T17:00:00</ManualFinish>
    			<ManualDuration>PT48H0M0S</ManualDuration>
    			<DurationFormat>7</DurationFormat>
    			<Work>PT0H0M0S</Work>
    			<Stop>2015-09-15T08:43:12</Stop>
    			<Resume>2015-09-15T08:43:12</Resume>
    			<ResumeValid>0</ResumeValid>
    			<EffortDriven>0</EffortDriven>
    			<Recurring>0</Recurring>
    			<OverAllocated>0</OverAllocated>
    			<Estimated>0</Estimated>
    			<Milestone>0</Milestone>
    			<Summary>0</Summary>
    			<DisplayAsSummary>0</DisplayAsSummary>
    			<Critical>1</Critical>
    			<IsSubproject>0</IsSubproject>
    			<IsSubprojectReadOnly>0</IsSubprojectReadOnly>
    			<ExternalTask>0</ExternalTask>
    			<EarlyStart>2015-09-15T08:00:00</EarlyStart>
    			<EarlyFinish>2015-09-22T17:00:00</EarlyFinish>
    			<LateStart>2015-09-15T08:00:00</LateStart>
    			<LateFinish>2015-09-22T17:00:00</LateFinish>
    			<StartVariance>0</StartVariance>
    			<FinishVariance>0</FinishVariance>
    			<WorkVariance>0.00</WorkVariance>
    			<FreeSlack>0</FreeSlack>
    			<TotalSlack>0</TotalSlack>
    			<StartSlack>0</StartSlack>
    			<FinishSlack>0</FinishSlack>
    			<FixedCost>0</FixedCost>
    			<FixedCostAccrual>3</FixedCostAccrual>
    			<PercentComplete>2</PercentComplete>
    			<PercentWorkComplete>0</PercentWorkComplete>
    			<Cost>0</Cost>
    			<OvertimeCost>0</OvertimeCost>
    			<OvertimeWork>PT0H0M0S</OvertimeWork>
    			<ActualStart>2015-09-15T08:00:00</ActualStart>
    			<ActualDuration>PT0H43M12S</ActualDuration>
    			<ActualCost>0</ActualCost>
    			<ActualOvertimeCost>0</ActualOvertimeCost>
    			<ActualWork>PT0H0M0S</ActualWork>
    			<ActualOvertimeWork>PT0H0M0S</ActualOvertimeWork>
    			<RegularWork>PT0H0M0S</RegularWork>
    			<RemainingDuration>PT47H16M48S</RemainingDuration>
    			<RemainingCost>0</RemainingCost>
    			<RemainingWork>PT0H0M0S</RemainingWork>
    			<RemainingOvertimeCost>0</RemainingOvertimeCost>
    			<RemainingOvertimeWork>PT0H0M0S</RemainingOvertimeWork>
    			<ACWP>0.00</ACWP>
    			<CV>0.00</CV>
    			<ConstraintType>0</ConstraintType>
    			<CalendarUID>-1</CalendarUID>
    			<LevelAssignments>1</LevelAssignments>
    			<LevelingCanSplit>1</LevelingCanSplit>
    			<LevelingDelay>0</LevelingDelay>
    			<LevelingDelayFormat>8</LevelingDelayFormat>
    			<IgnoreResourceCalendar>0</IgnoreResourceCalendar>
    			<HideBar>0</HideBar>
    			<Rollup>0</Rollup>
    			<BCWS>0.00</BCWS>
    			<BCWP>0.00</BCWP>
    			<PhysicalPercentComplete>0</PhysicalPercentComplete>
    			<EarnedValueMethod>0</EarnedValueMethod>
    			<IsPublished>1</IsPublished>
    			<CommitmentType>0</CommitmentType>
    			<TimephasedData>
    				<Type>11</Type>
    				<UID>3</UID>
    				<Start>2015-09-15T08:00:00</Start>
    				<Finish>2015-09-15T08:43:12</Finish>
    				<Unit>1</Unit>
    				<Value>1.5</Value>
    			</TimephasedData>
    		</Task>
    		<Task>
    			<UID>1</UID>
    			<ID>2</ID>
    			<Name>Task 2</Name>
    			<Active>1</Active>
    			<Manual>1</Manual>
    			<Type>0</Type>
    			<IsNull>0</IsNull>
    			<CreateDate>2015-08-26T17:23:00</CreateDate>
    			<WBS>2</WBS>
    			<OutlineNumber>2</OutlineNumber>
    			<OutlineLevel>1</OutlineLevel>
    			<Priority>500</Priority>
    			<Start>2015-09-21T08:00:00</Start>
    			<Finish>2015-09-21T17:00:00</Finish>
    			<Duration>PT8H0M0S</Duration>
    			<ManualStart>2015-09-21T08:00:00</ManualStart>
    			<ManualFinish>2015-09-21T17:00:00</ManualFinish>
    			<ManualDuration>PT8H0M0S</ManualDuration>
    			<DurationFormat>7</DurationFormat>
    			<Work>PT0H0M0S</Work>
    			<Stop>2015-09-21T10:24:00</Stop>
    			<Resume>2015-09-21T10:24:00</Resume>
    			<ResumeValid>0</ResumeValid>
    			<EffortDriven>0</EffortDriven>
    			<Recurring>0</Recurring>
    			<OverAllocated>0</OverAllocated>
    			<Estimated>0</Estimated>
    			<Milestone>0</Milestone>
    			<Summary>0</Summary>
    			<DisplayAsSummary>0</DisplayAsSummary>
    			<Critical>0</Critical>
    			<IsSubproject>0</IsSubproject>
    			<IsSubprojectReadOnly>0</IsSubprojectReadOnly>
    			<ExternalTask>0</ExternalTask>
    			<EarlyStart>2015-09-21T08:00:00</EarlyStart>
    			<EarlyFinish>2015-09-21T17:00:00</EarlyFinish>
    			<LateStart>2015-09-22T08:00:00</LateStart>
    			<LateFinish>2015-09-22T17:00:00</LateFinish>
    			<StartVariance>0</StartVariance>
    			<FinishVariance>0</FinishVariance>
    			<WorkVariance>0.00</WorkVariance>
    			<FreeSlack>4800</FreeSlack>
    			<TotalSlack>4800</TotalSlack>
    			<StartSlack>0</StartSlack>
    			<FinishSlack>4800</FinishSlack>
    			<FixedCost>0</FixedCost>
    			<FixedCostAccrual>3</FixedCostAccrual>
    			<PercentComplete>30</PercentComplete>
    			<PercentWorkComplete>0</PercentWorkComplete>
    			<Cost>0</Cost>
    			<OvertimeCost>0</OvertimeCost>
    			<OvertimeWork>PT0H0M0S</OvertimeWork>
    			<ActualStart>2015-09-21T08:00:00</ActualStart>
    			<ActualDuration>PT2H24M0S</ActualDuration>
    			<ActualCost>0</ActualCost>
    			<ActualOvertimeCost>0</ActualOvertimeCost>
    			<ActualWork>PT0H0M0S</ActualWork>
    			<ActualOvertimeWork>PT0H0M0S</ActualOvertimeWork>
    			<RegularWork>PT0H0M0S</RegularWork>
    			<RemainingDuration>PT5H36M0S</RemainingDuration>
    			<RemainingCost>0</RemainingCost>
    			<RemainingWork>PT0H0M0S</RemainingWork>
    			<RemainingOvertimeCost>0</RemainingOvertimeCost>
    			<RemainingOvertimeWork>PT0H0M0S</RemainingOvertimeWork>
    			<ACWP>0.00</ACWP>
    			<CV>0.00</CV>
    			<ConstraintType>0</ConstraintType>
    			<CalendarUID>-1</CalendarUID>
    			<LevelAssignments>1</LevelAssignments>
    			<LevelingCanSplit>1</LevelingCanSplit>
    			<LevelingDelay>0</LevelingDelay>
    			<LevelingDelayFormat>8</LevelingDelayFormat>
    			<IgnoreResourceCalendar>0</IgnoreResourceCalendar>
    			<HideBar>0</HideBar>
    			<Rollup>0</Rollup>
    			<BCWS>0.00</BCWS>
    			<BCWP>0.00</BCWP>
    			<PhysicalPercentComplete>0</PhysicalPercentComplete>
    			<EarnedValueMethod>0</EarnedValueMethod>
    			<IsPublished>1</IsPublished>
    			<CommitmentType>0</CommitmentType>
    			<TimephasedData>
    				<Type>11</Type>
    				<UID>1</UID>
    				<Start>2015-08-26T08:00:00</Start>
    				<Finish>2015-08-26T10:24:00</Finish>
    				<Unit>2</Unit>
    				<Value>30</Value>
    			</TimephasedData>
    		</Task>
    		<Task>
    			<UID>2</UID>
    			<ID>3</ID>
    			<Name>Task 3</Name>
    			<Active>1</Active>
    			<Manual>1</Manual>
    			<Type>0</Type>
    			<IsNull>0</IsNull>
    			<CreateDate>2015-08-26T17:23:00</CreateDate>
    			<WBS>3</WBS>
    			<OutlineNumber>3</OutlineNumber>
    			<OutlineLevel>1</OutlineLevel>
    			<Priority>500</Priority>
    			<Start>2015-09-18T08:00:00</Start>
    			<Finish>2015-09-22T17:00:00</Finish>
    			<Duration>PT24H0M0S</Duration>
    			<ManualStart>2015-09-18T08:00:00</ManualStart>
    			<ManualFinish>2015-09-22T17:00:00</ManualFinish>
    			<ManualDuration>PT24H0M0S</ManualDuration>
    			<DurationFormat>7</DurationFormat>
    			<Work>PT0H0M0S</Work>
    			<Stop>2015-09-21T09:21:36</Stop>
    			<Resume>2015-09-21T09:21:36</Resume>
    			<ResumeValid>0</ResumeValid>
    			<EffortDriven>0</EffortDriven>
    			<Recurring>0</Recurring>
    			<OverAllocated>0</OverAllocated>
    			<Estimated>0</Estimated>
    			<Milestone>0</Milestone>
    			<Summary>0</Summary>
    			<DisplayAsSummary>0</DisplayAsSummary>
    			<Critical>1</Critical>
    			<IsSubproject>0</IsSubproject>
    			<IsSubprojectReadOnly>0</IsSubprojectReadOnly>
    			<ExternalTask>0</ExternalTask>
    			<EarlyStart>2015-09-18T08:00:00</EarlyStart>
    			<EarlyFinish>2015-09-22T17:00:00</EarlyFinish>
    			<LateStart>2015-09-18T08:00:00</LateStart>
    			<LateFinish>2015-09-22T17:00:00</LateFinish>
    			<StartVariance>0</StartVariance>
    			<FinishVariance>0</FinishVariance>
    			<WorkVariance>0.00</WorkVariance>
    			<FreeSlack>0</FreeSlack>
    			<TotalSlack>0</TotalSlack>
    			<StartSlack>0</StartSlack>
    			<FinishSlack>0</FinishSlack>
    			<FixedCost>0</FixedCost>
    			<FixedCostAccrual>3</FixedCostAccrual>
    			<PercentComplete>39</PercentComplete>
    			<PercentWorkComplete>0</PercentWorkComplete>
    			<Cost>0</Cost>
    			<OvertimeCost>0</OvertimeCost>
    			<OvertimeWork>PT0H0M0S</OvertimeWork>
    			<ActualStart>2015-09-18T08:00:00</ActualStart>
    			<ActualDuration>PT9H21M36S</ActualDuration>
    			<ActualCost>0</ActualCost>
    			<ActualOvertimeCost>0</ActualOvertimeCost>
    			<ActualWork>PT0H0M0S</ActualWork>
    			<ActualOvertimeWork>PT0H0M0S</ActualOvertimeWork>
    			<RegularWork>PT0H0M0S</RegularWork>
    			<RemainingDuration>PT14H38M24S</RemainingDuration>
    			<RemainingCost>0</RemainingCost>
    			<RemainingWork>PT0H0M0S</RemainingWork>
    			<RemainingOvertimeCost>0</RemainingOvertimeCost>
    			<RemainingOvertimeWork>PT0H0M0S</RemainingOvertimeWork>
    			<ACWP>0.00</ACWP>
    			<CV>0.00</CV>
    			<ConstraintType>0</ConstraintType>
    			<CalendarUID>-1</CalendarUID>
    			<LevelAssignments>1</LevelAssignments>
    			<LevelingCanSplit>1</LevelingCanSplit>
    			<LevelingDelay>0</LevelingDelay>
    			<LevelingDelayFormat>8</LevelingDelayFormat>
    			<IgnoreResourceCalendar>0</IgnoreResourceCalendar>
    			<HideBar>0</HideBar>
    			<Rollup>0</Rollup>
    			<BCWS>0.00</BCWS>
    			<BCWP>0.00</BCWP>
    			<PhysicalPercentComplete>0</PhysicalPercentComplete>
    			<EarnedValueMethod>0</EarnedValueMethod>
    			<IsPublished>1</IsPublished>
    			<CommitmentType>0</CommitmentType>
    			<TimephasedData>
    				<Type>11</Type>
    				<UID>2</UID>
    				<Start>2015-08-26T08:00:00</Start>
    				<Finish>2015-08-27T08:00:00</Finish>
    				<Unit>2</Unit>
    				<Value>36.91</Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>11</Type>
    				<UID>2</UID>
    				<Start>2015-08-27T08:00:00</Start>
    				<Finish>2015-08-27T09:21:36</Finish>
    				<Unit>2</Unit>
    				<Value>5.67</Value>
    			</TimephasedData>
    		</Task>
    	</Tasks>
    	<Resources>
    		<Resource>
    			<UID>0</UID>
    			<ID>0</ID>
    			<Type>1</Type>
    			<IsNull>0</IsNull>
    			<WorkGroup>0</WorkGroup>
    			<MaxUnits>1.00</MaxUnits>
    			<PeakUnits>0.00</PeakUnits>
    			<OverAllocated>0</OverAllocated>
    			<CanLevel>1</CanLevel>
    			<AccrueAt>3</AccrueAt>
    			<Work>PT0H0M0S</Work>
    			<RegularWork>PT0H0M0S</RegularWork>
    			<OvertimeWork>PT0H0M0S</OvertimeWork>
    			<ActualWork>PT0H0M0S</ActualWork>
    			<RemainingWork>PT0H0M0S</RemainingWork>
    			<ActualOvertimeWork>PT0H0M0S</ActualOvertimeWork>
    			<RemainingOvertimeWork>PT0H0M0S</RemainingOvertimeWork>
    			<PercentWorkComplete>0</PercentWorkComplete>
    			<StandardRate>0</StandardRate>
    			<StandardRateFormat>2</StandardRateFormat>
    			<Cost>0</Cost>
    			<OvertimeRate>0</OvertimeRate>
    			<OvertimeRateFormat>2</OvertimeRateFormat>
    			<OvertimeCost>0</OvertimeCost>
    			<CostPerUse>0</CostPerUse>
    			<ActualCost>0</ActualCost>
    			<ActualOvertimeCost>0</ActualOvertimeCost>
    			<RemainingCost>0</RemainingCost>
    			<RemainingOvertimeCost>0</RemainingOvertimeCost>
    			<WorkVariance>0.00</WorkVariance>
    			<CostVariance>0</CostVariance>
    			<SV>0.00</SV>
    			<CV>0.00</CV>
    			<ACWP>0.00</ACWP>
    			<CalendarUID>2</CalendarUID>
    			<BCWS>0.00</BCWS>
    			<BCWP>0.00</BCWP>
    			<IsGeneric>0</IsGeneric>
    			<IsInactive>0</IsInactive>
    			<IsEnterprise>0</IsEnterprise>
    			<BookingType>0</BookingType>
    			<CreationDate>2015-08-26T17:23:00</CreationDate>
    			<IsCostResource>0</IsCostResource>
    			<IsBudget>0</IsBudget>
    		</Resource>
    	</Resources>
    	<Assignments>
    		<Assignment>
    			<UID>1</UID>
    			<TaskUID>1</TaskUID>
    			<ResourceUID>-65535</ResourceUID>
    			<PercentWorkComplete>30</PercentWorkComplete>
    			<ActualCost>0</ActualCost>
    			<ActualOvertimeCost>0</ActualOvertimeCost>
    			<ActualOvertimeWork>PT0H0M0S</ActualOvertimeWork>
    			<ActualStart>2015-09-21T08:00:00</ActualStart>
    			<ActualWork>PT2H24M0S</ActualWork>
    			<ACWP>0.00</ACWP>
    			<Confirmed>0</Confirmed>
    			<Cost>0</Cost>
    			<CostRateTable>0</CostRateTable>
    			<RateScale>0</RateScale>
    			<CostVariance>0</CostVariance>
    			<CV>-0.00</CV>
    			<Delay>0</Delay>
    			<Finish>2015-09-21T17:00:00</Finish>
    			<FinishVariance>0</FinishVariance>
    			<WorkVariance>0.00</WorkVariance>
    			<HasFixedRateUnits>1</HasFixedRateUnits>
    			<FixedMaterial>0</FixedMaterial>
    			<LevelingDelay>0</LevelingDelay>
    			<LevelingDelayFormat>7</LevelingDelayFormat>
    			<LinkedFields>0</LinkedFields>
    			<Milestone>0</Milestone>
    			<Overallocated>0</Overallocated>
    			<OvertimeCost>0</OvertimeCost>
    			<OvertimeWork>PT0H0M0S</OvertimeWork>
    			<RegularWork>PT8H0M0S</RegularWork>
    			<RemainingCost>0</RemainingCost>
    			<RemainingOvertimeCost>0</RemainingOvertimeCost>
    			<RemainingOvertimeWork>PT0H0M0S</RemainingOvertimeWork>
    			<RemainingWork>PT5H36M0S</RemainingWork>
    			<ResponsePending>0</ResponsePending>
    			<Start>2015-09-21T08:00:00</Start>
    			<Stop>2015-09-21T10:24:00</Stop>
    			<Resume>2015-09-21T10:24:00</Resume>
    			<StartVariance>0</StartVariance>
    			<Units>1</Units>
    			<UpdateNeeded>0</UpdateNeeded>
    			<VAC>0.00</VAC>
    			<Work>PT8H0M0S</Work>
    			<WorkContour>0</WorkContour>
    			<BCWS>0.00</BCWS>
    			<BCWP>-0.00</BCWP>
    			<BookingType>0</BookingType>
    			<CreationDate>2015-08-26T17:23:00</CreationDate>
    			<BudgetCost>0</BudgetCost>
    			<BudgetWork>PT0H0M0S</BudgetWork>
    			<TimephasedData>
    				<Type>1</Type>
    				<UID>1</UID>
    				<Start>2015-09-21T10:24:00</Start>
    				<Finish>2015-09-21T17:00:00</Finish>
    				<Unit>2</Unit>
    				<Value>PT5H36M0S</Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>2</Type>
    				<UID>1</UID>
    				<Start>2015-09-21T08:00:00</Start>
    				<Finish>2015-09-21T10:24:00</Finish>
    				<Unit>2</Unit>
    				<Value>PT2H24M0S</Value>
    			</TimephasedData>
    		</Assignment>
    		<Assignment>
    			<UID>2</UID>
    			<TaskUID>2</TaskUID>
    			<ResourceUID>-65535</ResourceUID>
    			<PercentWorkComplete>39</PercentWorkComplete>
    			<ActualCost>0</ActualCost>
    			<ActualOvertimeCost>0</ActualOvertimeCost>
    			<ActualOvertimeWork>PT0H0M0S</ActualOvertimeWork>
    			<ActualStart>2015-09-18T08:00:00</ActualStart>
    			<ActualWork>PT9H21M36S</ActualWork>
    			<ACWP>0.00</ACWP>
    			<Confirmed>0</Confirmed>
    			<Cost>0</Cost>
    			<CostRateTable>0</CostRateTable>
    			<RateScale>0</RateScale>
    			<CostVariance>0</CostVariance>
    			<CV>-0.00</CV>
    			<Delay>0</Delay>
    			<Finish>2015-09-22T17:00:00</Finish>
    			<FinishVariance>0</FinishVariance>
    			<WorkVariance>0.00</WorkVariance>
    			<HasFixedRateUnits>1</HasFixedRateUnits>
    			<FixedMaterial>0</FixedMaterial>
    			<LevelingDelay>0</LevelingDelay>
    			<LevelingDelayFormat>7</LevelingDelayFormat>
    			<LinkedFields>0</LinkedFields>
    			<Milestone>0</Milestone>
    			<Overallocated>0</Overallocated>
    			<OvertimeCost>0</OvertimeCost>
    			<OvertimeWork>PT0H0M0S</OvertimeWork>
    			<RegularWork>PT24H0M0S</RegularWork>
    			<RemainingCost>0</RemainingCost>
    			<RemainingOvertimeCost>0</RemainingOvertimeCost>
    			<RemainingOvertimeWork>PT0H0M0S</RemainingOvertimeWork>
    			<RemainingWork>PT14H38M24S</RemainingWork>
    			<ResponsePending>0</ResponsePending>
    			<Start>2015-09-18T08:00:00</Start>
    			<Stop>2015-09-21T09:21:36</Stop>
    			<Resume>2015-09-21T09:21:36</Resume>
    			<StartVariance>0</StartVariance>
    			<Units>1</Units>
    			<UpdateNeeded>0</UpdateNeeded>
    			<VAC>0.00</VAC>
    			<Work>PT24H0M0S</Work>
    			<WorkContour>0</WorkContour>
    			<BCWS>0.00</BCWS>
    			<BCWP>-0.00</BCWP>
    			<BookingType>0</BookingType>
    			<CreationDate>2015-08-26T17:23:00</CreationDate>
    			<BudgetCost>0</BudgetCost>
    			<BudgetWork>PT0H0M0S</BudgetWork>
    			<TimephasedData>
    				<Type>1</Type>
    				<UID>2</UID>
    				<Start>2015-09-21T09:21:36</Start>
    				<Finish>2015-09-22T09:21:36</Finish>
    				<Unit>2</Unit>
    				<Value>PT8H0M0S</Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>1</Type>
    				<UID>2</UID>
    				<Start>2015-09-22T09:21:36</Start>
    				<Finish>2015-09-22T17:00:00</Finish>
    				<Unit>2</Unit>
    				<Value>PT6H38M24S</Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>2</Type>
    				<UID>2</UID>
    				<Start>2015-09-18T08:00:00</Start>
    				<Finish>2015-09-19T08:00:00</Finish>
    				<Unit>2</Unit>
    				<Value>PT8H0M0S</Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>2</Type>
    				<UID>2</UID>
    				<Start>2015-09-19T08:00:00</Start>
    				<Finish>2015-09-20T08:00:00</Finish>
    				<Unit>2</Unit>
    				<Value></Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>2</Type>
    				<UID>2</UID>
    				<Start>2015-09-20T08:00:00</Start>
    				<Finish>2015-09-21T08:00:00</Finish>
    				<Unit>2</Unit>
    				<Value></Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>2</Type>
    				<UID>2</UID>
    				<Start>2015-09-21T08:00:00</Start>
    				<Finish>2015-09-21T09:21:36</Finish>
    				<Unit>2</Unit>
    				<Value>PT1H21M36S</Value>
    			</TimephasedData>
    		</Assignment>
    		<Assignment>
    			<UID>3</UID>
    			<TaskUID>3</TaskUID>
    			<ResourceUID>-65535</ResourceUID>
    			<PercentWorkComplete>2</PercentWorkComplete>
    			<ActualCost>0</ActualCost>
    			<ActualOvertimeCost>0</ActualOvertimeCost>
    			<ActualOvertimeWork>PT0H0M0S</ActualOvertimeWork>
    			<ActualStart>2015-09-15T08:00:00</ActualStart>
    			<ActualWork>PT0H43M12S</ActualWork>
    			<ACWP>0.00</ACWP>
    			<Confirmed>0</Confirmed>
    			<Cost>0</Cost>
    			<CostRateTable>0</CostRateTable>
    			<RateScale>0</RateScale>
    			<CostVariance>0</CostVariance>
    			<CV>-0.00</CV>
    			<Delay>0</Delay>
    			<Finish>2015-09-22T17:00:00</Finish>
    			<FinishVariance>0</FinishVariance>
    			<WorkVariance>0.00</WorkVariance>
    			<HasFixedRateUnits>1</HasFixedRateUnits>
    			<FixedMaterial>0</FixedMaterial>
    			<LevelingDelay>0</LevelingDelay>
    			<LevelingDelayFormat>7</LevelingDelayFormat>
    			<LinkedFields>0</LinkedFields>
    			<Milestone>0</Milestone>
    			<Overallocated>0</Overallocated>
    			<OvertimeCost>0</OvertimeCost>
    			<OvertimeWork>PT0H0M0S</OvertimeWork>
    			<RegularWork>PT48H0M0S</RegularWork>
    			<RemainingCost>0</RemainingCost>
    			<RemainingOvertimeCost>0</RemainingOvertimeCost>
    			<RemainingOvertimeWork>PT0H0M0S</RemainingOvertimeWork>
    			<RemainingWork>PT47H16M48S</RemainingWork>
    			<ResponsePending>0</ResponsePending>
    			<Start>2015-09-15T08:00:00</Start>
    			<Stop>2015-09-15T08:43:12</Stop>
    			<Resume>2015-09-15T08:43:12</Resume>
    			<StartVariance>0</StartVariance>
    			<Units>1</Units>
    			<UpdateNeeded>0</UpdateNeeded>
    			<VAC>0.00</VAC>
    			<Work>PT48H0M0S</Work>
    			<WorkContour>0</WorkContour>
    			<BCWS>0.00</BCWS>
    			<BCWP>-0.00</BCWP>
    			<BookingType>0</BookingType>
    			<CreationDate>2015-08-26T17:23:00</CreationDate>
    			<BudgetCost>0</BudgetCost>
    			<BudgetWork>PT0H0M0S</BudgetWork>
    			<TimephasedData>
    				<Type>1</Type>
    				<UID>3</UID>
    				<Start>2015-09-15T08:43:12</Start>
    				<Finish>2015-09-16T08:43:12</Finish>
    				<Unit>2</Unit>
    				<Value>PT8H0M0S</Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>1</Type>
    				<UID>3</UID>
    				<Start>2015-09-16T08:43:12</Start>
    				<Finish>2015-09-17T08:43:12</Finish>
    				<Unit>2</Unit>
    				<Value>PT8H0M0S</Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>1</Type>
    				<UID>3</UID>
    				<Start>2015-09-17T08:43:12</Start>
    				<Finish>2015-09-18T08:43:12</Finish>
    				<Unit>2</Unit>
    				<Value>PT8H0M0S</Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>1</Type>
    				<UID>3</UID>
    				<Start>2015-09-18T08:43:12</Start>
    				<Finish>2015-09-19T08:43:12</Finish>
    				<Unit>2</Unit>
    				<Value>PT7H16M48S</Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>1</Type>
    				<UID>3</UID>
    				<Start>2015-09-19T08:43:12</Start>
    				<Finish>2015-09-20T08:43:12</Finish>
    				<Unit>2</Unit>
    				<Value></Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>1</Type>
    				<UID>3</UID>
    				<Start>2015-09-20T08:43:12</Start>
    				<Finish>2015-09-21T08:43:12</Finish>
    				<Unit>2</Unit>
    				<Value>PT0H43M12S</Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>1</Type>
    				<UID>3</UID>
    				<Start>2015-09-21T08:43:12</Start>
    				<Finish>2015-09-22T08:43:12</Finish>
    				<Unit>2</Unit>
    				<Value>PT8H0M0S</Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>1</Type>
    				<UID>3</UID>
    				<Start>2015-09-22T08:43:12</Start>
    				<Finish>2015-09-22T17:00:00</Finish>
    				<Unit>2</Unit>
    				<Value>PT7H16M48S</Value>
    			</TimephasedData>
    			<TimephasedData>
    				<Type>2</Type>
    				<UID>3</UID>
    				<Start>2015-09-15T08:00:00</Start>
    				<Finish>2015-09-15T08:43:12</Finish>
    				<Unit>1</Unit>
    				<Value>PT0H43M12S</Value>
    			</TimephasedData>
    		</Assignment>
    	</Assignments>
    </Project>

    Now want to add Task 1.1   Under Task 1  (a new sub Task under Task 1) using Project XML Import.

    Project XML created to insert Task 1.1 is as follows.

    For the new Task the next UID is used.  In this case this is 4.   The Task.ID is inserted – for this new task it is 2 and for subsequent tasks the Task.ID is incremented by 1.


    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <Project xmlns="http://schemas.microsoft.com/project">
    	<SaveVersion>14</SaveVersion>
    	<Name>ProjectImportTest.xml</Name>
    	<Title>ProjectImportTest</Title>
    	<Company>c</Company>
    	<Author>Author, Project</Author>
    
    	<Tasks>
    		<Task>
    			<UID>0</UID>
    			<ID>0</ID>
    			<Name>ProjectImportTest</Name>
    			<Manual>0</Manual>										
    			<CreateDate>2015-08-26T17:23:00</CreateDate>
    			<WBS>0</WBS>
    			<OutlineNumber>0</OutlineNumber>
    			<OutlineLevel>0</OutlineLevel>
    			<Start>2015-09-15T08:00:00</Start>
    			<Finish>2015-09-22T17:00:00</Finish>
    			<Duration>PT48H0M0S</Duration>			
    		</Task>
    		<Task>
    			<UID>3</UID>
    			<ID>1</ID>
    			<Name>Task 1</Name>
    			<Manual>0</Manual>			
    			<CreateDate>2015-08-26T17:23:00</CreateDate>
    			<WBS>1</WBS>
    			<OutlineNumber>1</OutlineNumber>
    			<OutlineLevel>1</OutlineLevel>
    			<Start>2015-09-15T08:00:00</Start>
    			<Finish>2015-09-22T17:00:00</Finish>
    			<Duration>PT48H0M0S</Duration>			
    		</Task>
    		<Task>
    			<UID>4</UID>
    			<ID>2</ID>
    			<Name>Task 1.1</Name>
    			<Manual>0</Manual>
    			<CreateDate>2015-08-26T17:23:00</CreateDate>
    			<WBS>1.1</WBS>
    			<OutlineNumber>1.1</OutlineNumber>
    			<OutlineLevel>2</OutlineLevel>
    			<Start>2015-09-15T08:00:00</Start>
    			<Finish>2015-09-17T17:00:00</Finish>
    			<Duration>3d</Duration>				
    		</Task>		
    		<Task>
    			<UID>1</UID>
    			<ID>3</ID>
    			<Name>Task 2</Name>
    			<Manual>0</Manual>				
    			<CreateDate>2015-08-26T17:23:00</CreateDate>
    			<WBS>2</WBS>
    			<OutlineNumber>2</OutlineNumber>
    			<OutlineLevel>1</OutlineLevel>
    			<Start>2015-09-21T08:00:00</Start>
    			<Finish>2015-09-21T17:00:00</Finish>
    			<Duration>PT8H0M0S</Duration>			
    		</Task>
    		<Task>
    			<UID>2</UID>
    			<ID>4</ID>
    			<Name>Task 3</Name>
    			<Manual>0</Manual>			
    			<CreateDate>2015-08-26T17:23:00</CreateDate>
    			<WBS>3</WBS>
    			<OutlineNumber>3</OutlineNumber>
    			<OutlineLevel>1</OutlineLevel>
    			<Start>2015-09-18T08:00:00</Start>
    			<Finish>2015-09-22T17:00:00</Finish>
    			<Duration>PT24H0M0S</Duration>
    		</Task>
    	</Tasks>
     
    </Project>

    This XML is imported to the active Project (Currently Opened) with Merge Option.  [Merge the data into active Project]

    <Image 2>

    After Import the new Task is appended at the end.

    The OutlineNumber for the new Task in the XML file is ignored and it is automatically set to 3.1.

    <Image 3>

    How to create Project XML so that this task is inserted.

    <Image 4>

    Same question for deleting any task from the Existing Project.

    For example if a Project Contains 10 different Tasks and Each task has 3 sub tasks,  then is it possible to delete the 2<sup>nd</sup>  sub task of Task # 6  using XML import with Option ”Merge the Data into Active Project”.

    Tuesday, September 8, 2015 5:56 AM

All replies

  • Hi S.Jagatager,

    I've done this before, but merging xls files.  When you merge, are you prompted for a Merge key, and which one to you use - I always figured the UniqueID was the best one to use.


    Ben Howard [MVP] | web | blog | book | P2O

    Tuesday, September 8, 2015 6:27 AM
    Moderator
  • Hi Ben ,

    It shows the Project after I import using the merge option.   I do not see the prompt to select the Merge Key.

    In this case the Original Project is not ordered by Task.UID.   It is Ordered by Task.ID.

    I use the next Task.UID for the task being inserted and I insert the Task.ID and change the Task.ID  for the subsequent tasks (Increment by 1 )

    This is using Microsoft Project 2013.

    Thanks

    S.Jagatagar


    • Edited by S.Jagatagar Tuesday, September 8, 2015 3:41 PM more info
    Tuesday, September 8, 2015 2:15 PM
  • Hi S.Jagatagar,

    It doesn't matter how the project is sorted; however, I am confused.  From your posting it looks like you are using VBA, and yet you say you are using the import wizard?  Can you be more specific about your process please?


    Ben Howard [MVP] | web | blog | book | P2O

    Tuesday, September 8, 2015 8:01 PM
    Moderator
  • Hi Ben,

    Process is as follows

    1. The Project is created using Microsoft Project 2013.
    2. I save this Project in XML format.
    3. Using a C # program I read this Project XML file and update an external ERP application.
    4. This external application allows maintenance of Project and Tasks. This application modified the Project by inserting a new sub task  Task 1.1 under Task 1.
    5. Now I want to make the same change in Microsoft Project , For this I have a C# program which reads this application and creates the Project XML.(it is the second XML in my original post)
    6. Then using this Project XML, I want to update the Microsoft Project .       For this I launch the Microsoft Project and Open the Original Project.  Then I  import this new Project XML and select the last option "Merge the data into active Project"

    When I do this , the new task is appended instead of inserting as a sub task of Task 1.  The new Task is shown as the last task . As a sub Task of Task 3.

    In the XML file the OutlineNumber is set to 1.1 for the new Task.    After import the OutlineNumber is automatically changed to 1.3.

    Thanks

    S.Jagatagar

     

    Tuesday, September 8, 2015 9:43 PM
  • Hi,

    I'm not sure if what you want to do is a supported scenario.  In terms of the ID, this will be generated by MSP during the import, you shouldn't have to specify it.  I would however ensure that the UID is updated by one each time.


    Ben Howard [MVP] | web | blog | book | P2O

    Wednesday, September 9, 2015 2:22 PM
    Moderator
  • Hi Ben,

    This is for the bi-directional Information exchange between Microsoft Project and ERP system. 

    The ERP System can make following changes to the Project 

    1. Change the Task  Dates (Start Date and Finish Date) 
    2. Change the Task Name 
    3. Change the Task PercentComplete
    4. Insert a new Task 
    5. Delete a Task 

    I want to update these changes to Microsoft Project using Project XML.    Import the Project XML with Merge Option. 

    How can this be achieved ? 

    Thanks 

    S.Jagatagar



    Thursday, September 10, 2015 1:16 AM
  • Okay, as I said, I'm not sure if it is a supported option.  I was successful in modifying the XML (creating a new task_ and creating a new project with it and also by merging it into an existing blank project.  It may be that with further work you can find out exactly which fields need updating in the xml (UID, ID and Outline number for sure).  I was unsuccessful merging the xml into an existing project.

    To test this further, I would review exporting and importing to .xls to begin to understand the full process. 


    Ben Howard [MVP] | web | blog | book | P2O

    Thursday, September 10, 2015 8:05 AM
    Moderator