Hi, I am Exporting data to ms-project xml file using the mspdi.xsd and I was able to successfully create the xml file and it is opening properly in the MS Project also. But I am not able to export the percentage work completed. Following is the generated xml and if we open teh file, we can see all the data except the percentage completed/percentage work complete/ actual work.
Can somebody help me to fix the issue?
following is the generated xml.
<?xml version="1.0" encoding="utf-8"?>
<Project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/project">
<UID>105</UID>
<Name>Last task test</Name>
<Title>Last task test</Title>
<Revision>1</Revision>
<CriticalSlackLimit>0</CriticalSlackLimit>
<CurrencyDigits>2</CurrencyDigits>
<Tasks>
<Task>
<UID>1698</UID>
<ID>1</ID>
<Name>First Task</Name>
<OutlineLevel>1</OutlineLevel>
<Start>2010-07-21T09:00:00</Start>
<Finish>2010-07-21T17:00:00</Finish>
<DurationFormat>5</DurationFormat>
<FixedCostAccrual>2</FixedCostAccrual>
<PercentComplete>57</PercentComplete>
<PercentWorkComplete>57</PercentWorkComplete>
<ActualWork>4</ActualWork>
<Baseline>
<Number>0</Number>
<Start>2010-07-21T00:00:00</Start>
<Finish>2010-07-31T00:00:00</Finish>
</Baseline>
</Task>
<Task>
<UID>1700</UID>
<ID>2</ID>
<Name>Task 1-1</Name>
<OutlineLevel>2</OutlineLevel>
<Start>2010-07-21T09:00:00</Start>
<Finish>2010-07-21T12:00:00</Finish>
<DurationFormat>5</DurationFormat>
<FixedCostAccrual>2</FixedCostAccrual>
<PercentComplete>67</PercentComplete>
<PercentWorkComplete>67</PercentWorkComplete>
<ActualWork>2</ActualWork>
</Task>
<Task>
<UID>1701</UID>
<ID>3</ID>
<Name>Task 1-2</Name>
<OutlineLevel>2</OutlineLevel>
<Start>2010-07-21T12:00:00</Start>
<Finish>2010-07-21T17:00:00</Finish>
<DurationFormat>5</DurationFormat>
<FixedCostAccrual>2</FixedCostAccrual>
<PercentComplete>50</PercentComplete>
<PercentWorkComplete>50</PercentWorkComplete>
<ActualWork>2</ActualWork>
</Task>
<Task>
<UID>1699</UID>
<ID>4</ID>
<Name>Second Task </Name>
<OutlineLevel>1</OutlineLevel>
<Start>2010-07-21T09:00:00</Start>
<Finish>2010-07-22T10:00:00</Finish>
<DurationFormat>5</DurationFormat>
<FixedCostAccrual>2</FixedCostAccrual>
<PercentComplete>50</PercentComplete>
<PercentWorkComplete>50</PercentWorkComplete>
<ActualWork>4</ActualWork>
</Task>
<Task>
<UID>1697</UID>
<ID>5</ID>
<Name>Fourth Task</Name>
<OutlineLevel>1</OutlineLevel>
<Start>2010-07-27T09:00:00</Start>
<Finish>2010-07-27T14:00:00</Finish>
<DurationFormat>5</DurationFormat>
<FixedCostAccrual>2</FixedCostAccrual>
<PercentComplete>50</PercentComplete>
<PercentWorkComplete>50</PercentWorkComplete>
<ActualWork>4</ActualWork>
</Task>
<Task>
<UID>1696</UID>
<ID>6</ID>
<Name>Third Task</Name>
<OutlineLevel>1</OutlineLevel>
<Start>2010-07-26T09:00:00</Start>
<Finish>2010-07-26T14:00:00</Finish>
<DurationFormat>5</DurationFormat>
<FixedCostAccrual>2</FixedCostAccrual>
<PercentComplete>100</PercentComplete>
<PercentWorkComplete>100</PercentWorkComplete>
<ActualWork>8</ActualWork>
</Task>
<Task>
<UID>1695</UID>
<ID>7</ID>
<Name>Fifth Task</Name>
<OutlineLevel>1</OutlineLevel>
<Start>2010-07-29T09:00:00</Start>
<Finish>2010-07-29T15:20:00</Finish>
<DurationFormat>5</DurationFormat>
<FixedCostAccrual>2</FixedCostAccrual>
<PercentComplete>75</PercentComplete>
<PercentWorkComplete>75</PercentWorkComplete>
<ActualWork>12</ActualWork>
</Task>
</Tasks>
<Resources>
<Resource>
<UID>446</UID>
<Name>Resource 1</Name>
<Group>Permanent</Group>
<StandardRate>50</StandardRate>
<StandardRateFormat>2</StandardRateFormat>
</Resource>
<Resource>
<UID>445</UID>
<Name>Resource 2</Name>
<Group>Permanent</Group>
<StandardRate>50</StandardRate>
<StandardRateFormat>2</StandardRateFormat>
</Resource>
<Resource>
<UID>444</UID>
<Name>Resource 3</Name>
<Group>Permanent</Group>
<StandardRate>62.5</StandardRate>
<StandardRateFormat>2</StandardRateFormat>
</Resource>
</Resources>
<Assignments>
<Assignment>
<TaskUID>1698</TaskUID>
<ResourceUID>444</ResourceUID>
</Assignment>
<Assignment>
<TaskUID>1698</TaskUID>
<ResourceUID>446</ResourceUID>
</Assignment>
<Assignment>
<TaskUID>1700</TaskUID>
<ResourceUID>446</ResourceUID>
</Assignment>
<Assignment>
<TaskUID>1701</TaskUID>
<ResourceUID>444</ResourceUID>
</Assignment>
<Assignment>
<TaskUID>1699</TaskUID>
<ResourceUID>444</ResourceUID>
</Assignment>
<Assignment>
<TaskUID>1697</TaskUID>
<ResourceUID>444</ResourceUID>
</Assignment>
<Assignment>
<TaskUID>1697</TaskUID>
<ResourceUID>446</ResourceUID>
</Assignment>
<Assignment>
<TaskUID>1696</TaskUID>
<ResourceUID>445</ResourceUID>
</Assignment>
<Assignment>
<TaskUID>1696</TaskUID>
<ResourceUID>446</ResourceUID>
</Assignment>
<Assignment>
<TaskUID>1695</TaskUID>
<ResourceUID>444</ResourceUID>
</Assignment>
<Assignment>
<TaskUID>1695</TaskUID>
<ResourceUID>445</ResourceUID>
</Assignment>
<Assignment>
<TaskUID>1695</TaskUID>
<ResourceUID>446</ResourceUID>
</Assignment>
</Assignments>
</Project>