Merge XML file into an active project - Column 54 Error

[J Baird]

Has anyone ever seen this merge error before, and if so, what data is in
"column 54"? (No, we don't have any views with 54 columns in them.)

Here's what produced this error:
1) Create a new schedule from a template (any template produced this for us,
so we know it's not the template)
2) Open a schedule file that's saved in Xml format (schedulename.xml)
3) Select the "Merge the data into the active project" option (in the Import
Wizard)
4) Click finish

Error message text:
An import error ocurred.
Check Row 1 Column 54
Enter an actual work value that is less than the total work on the
summary task
To continue importing with additional error messages, click Yes.
To continue importing with no error messages, click No.
To stop importing, click Cancel.

Obviously, [Acutal Work] is often less than [Work], unless the assignment is
100% complete. If the task is 100% complete, then the amounts are even. I
don't know if the error message is referring to a task, assignment or
resource. In MSP, I can't find any task, assignment or resource that has
[Actual Work] that is greater than "Total Work", or even equal to Total
Work, unless the task is 100% in both [Work complete] and [% Complete].

I know the XML spec pretty well, so I started looking at the XMl code, but I
can't figure this error out.

 

[Gary L. Chefetz \(MVP\)]

Jill:

Without seeing the data, it's difficult to say, but the error message is
referring to a "summary task." Do you have a summary task that shows less
total work than one of the tasks below it shows for actual work? I suspect
that if this is the case, the system will import the data as presented and
then update the summary task when you first open the project.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts

-

 

[J Baird]

Gary,

No, there are only three summary tasks (and the project summary task) in the
schedule. No summary tasks show less work than any of the tasks below them.
No summary tasks show less work than all of their respective sub-tasks tasks
added together.

There has to be some sort of corruption in the XML file. I just want to
know what MSP is referring to when it displays the "column 54" error (when
imserting the XML file into a new file), so I can find the corruption and
possibly fix it.

Here's the data, with the summary task displayed. There are only 18 lines
in this test file, and the test file produces the error.

ID Summary Outline Level Actual Work Work
0 Yes 0 1,070.12 1,500
1 Yes 1 1,070.12 1,500
2 Yes 1.1 0 0
3 No 1.1.1 0 0
4 Yes 1.2 0 0
5 No 1.2.1 0 0
6 No 1.2.2 0 0
7 No 1.2.3 0 0
8 No 1.2.4 0 0
9 No 1.2.5 0 0
10 Yes 1.3 1,070.12 1,500
11 No 1.3.1 0 0
12 No 1.3.2 0 0
13 No 1.3.3 485 500
14 No 1.3.4 0 0
15 No 1.3.5 0 0
16 No 1.3.6 481.12 496
17 No 1.3.7 0 240
18 No 1.3.8 104 264

Jill:

Without seeing the data, it's difficult to say, but the error message is
referring to a "summary task." Do you have a summary task that shows less
total work than one of the tasks below it shows for actual work? I suspect
that if this is the case, the system will import the data as presented and
then update the summary task when you first open the project.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts

-

Has anyone ever seen this merge error before, and if so, what data is in
"column 54"? (No, we don't have any views with 54 columns in them.)

Here's what produced this error:
1) Create a new schedule from a template (any template produced this for us,
so we know it's not the template)
2) Open a schedule file that's saved in Xml format (schedulename.xml)
3) Select the "Merge the data into the active project" option (in the Import
Wizard)
4) Click finish

Error message text:
An import error ocurred.
Check Row 1 Column 54
Enter an actual work value that is less than the total work on the
summary task
To continue importing with additional error messages, click Yes.
To continue importing with no error messages, click No.
To stop importing, click Cancel.

Obviously, [Acutal Work] is often less than [Work], unless the

assignment

is
100% complete. If the task is 100% complete, then the amounts are even. I
don't know if the error message is referring to a task, assignment or
resource. In MSP, I can't find any task, assignment or resource that has
[Actual Work] that is greater than "Total Work", or even equal to Total
Work, unless the task is 100% in both [Work complete] and [% Complete].

I know the XML spec pretty well, so I started looking at the XMl code,

but

I
can't figure this error out.