Importing XML to P6 error

thanks both Toms 

Perfect diagnosis from Zoltan.  One clarification:

There is no need to repeat the process for different calendars.  DaysPerMonth in MSP is a singular property of a Project, not of a Calendar, and it only occurs once in a project xml file.  (P6's XML importer multiplies the Project|HoursPerDay by the Project|DaysPerMonth to arrive at an HoursPerMonth that it then writes to each non-elapsed-duration calendar in P6.)

The issue is caused by the incorrect calendar setting inside Microsoft Project.



The total working hours per year in P6  is 

 

366 Days *24 hours / day = 8784 hours / year

The Microsoft Project XML file defined more then 31 working days per week.  This violation of the business rules hence P6 import function stopped and report the above error. 

 

31 days X 12 months x 24 hours = 8928 hours /year

This problem can be fixed either in Microsoft Project (MSP) or in MSP XML file



A. Microsoft Project method

1. Open the problem project in Microsoft Project

2. Select Tools -> "Change Working Time" from the pull down menu to open the "Change Working Time" window

3. Select a calendar from the "For Calendar" drop down section.

4. Single Click Options icon at the bottom in the "Change Working Time" window.

5. Click the "Calendar" tab in the top of Options window

6. Modify the days per month to 30.5 then click OK

Repeat 3 to 7 to check all calendars setting.

7. Export the project to XML format then import it to P6.

B. Without MSP installed

1. Open the XML file in a text editor.

2. Search for "<DaysPerMonth>" XML attribute.

3. Change the value in between the <DaysPerMonth> and </DaysPerMonth> to 30.5 

ie <DaysPerMonth>30.5</DaysPerMonth>

4. Repeat step 2 and 3 until all values had modified

5. Save the XML file.

6. Import into P6.