导出为 MS-Project xml 格式时出现问题。已完成的作品无法导出
我正在使用 mspdi.xsd 将数据导出到 ms-project xml 文件,并且我能够成功创建 xml 文件,并且它也在 MS Project 中正确打开。 但我无法导出已完成的工作百分比。以下是生成的 xml,如果我们打开该文件,我们可以看到除完成百分比/完成工作百分比/实际工作之外的所有数据。
有人可以帮我解决这个问题吗?
以下是生成的 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>
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>
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
要查看 MS Project 中的完整进度,您需要在 XML 中的任务中授予这些字段:
完成百分比
实际开始
ActualDuration
您还可以使用:
RemainingDuration
我发现这些字段对于进度是必需的,但未能在我的应用程序中正确设置。
To see complete progress in MS Project you need to grant these fields in tasks in XML:
PercentComplete
ActualStart
ActualDuration
You can use also:
RemainingDuration
I've found that these fields are mandatory for progress, but didn't managed to make it correctly in my app.
通过设置以下字段可以解决该问题
以下是工作 xml。
the issue is solved by setting the following fields
Following is the working xml.