Differences between Project XML and MPP files

%3CLINGO-SUB%20id%3D%22lingo-sub-2121242%22%20slang%3D%22en-US%22%3EDifferences%20between%20Project%20XML%20and%20MPP%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121242%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Project%20Standard%202016%20(Version%201908%20Build%2011929.20300)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20experienced%20an%20issue%20where%20I%20am%20getting%20differences%20in%20data%20between%20an%20original%20*.mpp%20file%2C%20and%20an%20*.xml%20that%20I%20exported%20from%20that%20mpp%20file.%20The%20differences%20then%20continue%20to%20occur%20if%20I%20then%20save%20the%20first%20XML%20file%20as%20an%20XML%20file%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20the%203%20Project%20files%20in%20the%20.Zip%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThese%20are%20my%20steps%3A%3C%2FP%3E%3COL%3E%3CLI%3EOpened%20the%20%22Sample.MPP%22%2C%20and%20took%20a%20screenshot%20of%20the%20first%2023%20tasks%3C%2FLI%3E%3CLI%3ESaved%20the%20file%20as%20%22Sample.XML%22.%3C%2FLI%3E%3CLI%3EOpened%20that%20%22Sample.XML%22%20file%2C%20selecting%20'Import%20as%20New%20Project'%20when%20prompted.%20Took%20a%20screenshot%20of%20the%20same%20Tasks.%3C%2FLI%3E%3CLI%3ESaved%20that%20as%20a%20second%20XML%20file%20%22Sample_2%22.XML%20(no%20changes%20were%20made%20to%20it).%3C%2FLI%3E%3CLI%3EOpened%20that%20%22Sample_2%22.XML%20file%2C%20selecting%20'Import%20as%20New%20Project'%20when%20prompted.%20Took%20a%20screenshot%20of%20the%20same%20Tasks.%3C%2FLI%3E%3C%2FOL%3E%3CP%3EI%20compared%20the%20screenshots%20between%20all%203%20files%2C%20and%20noticed%20that%20Dates%20and%20Durations%20were%20continuously%20changing%20from%20the%20original%20MPP%20file%20(see%20attached%20file%20Differences.png)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20checked%20the%20Calendar%20Options%20and%20Working%20Time%20settings%20after%20each%20file%20is%20opened%2C%20and%20they%20seem%20all%20the%20same%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.screencast.com%2Ft%2F7RdF3B0BdW%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.screencast.com%2Ft%2F7RdF3B0BdW%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20also%20check%20what%20the%20Calendar%20Options%20were%20for%20'New%20Projects'%20and%20they%20were%20slightly%20different%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.screencast.com%2Ft%2F3DOPdG9y%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.screencast.com%2Ft%2F3DOPdG9y%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20causing%20these%20differences%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EDoes%20the%20XML%20Export%20have%20certain%20limitations%20%2F%20not%20support%20certain%20settings%3F%3C%2FLI%3E%3CLI%3EIs%20there%20something%20else%20that%20is%20adjusting%20the%20dates%20when%20the%20XML%20file%20is%20being%20opened%2Fimported%20as%20a%20new%20Project%3F%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUpdates%3A%3C%2FP%3E%3CUL%3E%3CLI%3EI%20also%20tested%20in%20MS%20Project%202019%2C%20and%20the%20issue%20still%20happens.%3C%2FLI%3E%3CLI%3EI%20think%20it%20may%20be%20related%20to%20the%20fact%20that%20the%20project%20is%20using%20the%20'24%20Hour'%20calendar.%20I%20had%20another%202%20Project%20files%20which%20were%20exporting%20%2F%20loading%20XMLs%20fine%2C%20but%20as%20soon%20as%20i%20changed%20the%20calendar%20in%20the%20MPP%20files%20to%20use%20%2224%20Hour%22%2C%20and%20then%20exported%20the%20XML%2C%20once%20that%20XML%20was%20opened%20in%20Project%20again%2C%20the%20dates%2Ftimes%20changed.%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121733%22%20slang%3D%22en-US%22%3ERe%3A%20Differences%20between%20Project%20XML%20and%20MPP%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121733%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F962948%22%20target%3D%22_blank%22%3E%40Estate_Master%3C%2FA%3E%26nbsp%3B--%20I%20am%20not%20surprised%20at%20all%20by%20the%20fact%20that%20you%20see%20differences%20between%20the%20original%20project%20and%20a%20new%20project%20created%20from%20the%20exported%20XML%20file.%26nbsp%3B%20Based%20on%20my%20personal%20experience%2C%20the%20XML%20file%20does%20not%20capture%20the%20timephasing%20of%20task%20Work%20and%20Cost%20values%20on%20tasks.%26nbsp%3B%20And%20I%20suspect%20your%20use%20of%20the%2024%20Hour%20calendar%20is%20at%20least%20partially%20the%20source%20of%20the%20errors.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20me%2C%20the%20Save%20to%20XML%20option%20is%20a%20last%20resort%20to%20try%20to%20fix%20a%20corrupted%20project.%26nbsp%3B%20I%20know%20that%20using%20this%20feature%20will%20capture%20the%20%22guts%22%20of%20the%20project%2C%20but%20not%20the%20exact%20duplicate%20project.%26nbsp%3B%20Out%20of%20curiosity%2C%20why%20are%20you%20using%20the%20Save%20to%20XML%20feature%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20let%20us%20know%20and%20we%20will%20try%20to%20help%20you.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2123990%22%20slang%3D%22en-US%22%3ERe%3A%20Differences%20between%20Project%20XML%20and%20MPP%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2123990%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F112666%22%20target%3D%22_blank%22%3E%40Dale%20Howard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20exporting%20to%20XML%2C%20because%20we%20are%20developing%20a%20C%23%20app%20that%20uses%20a%20.Net%20Gantt%20control.%20That%20control%20allows%20users%20to%20import%20MS%20Project%20XML%20files%2C%20not%20MPP%20format.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am using Project Standard 2016 (Version 1908 Build 11929.20300)

 

I have experienced an issue where I am getting differences in data between an original *.mpp file, and an *.xml that I exported from that mpp file. The differences then continue to occur if I then save the first XML file as an XML file again.

 

I have attached the 3 Project files in the .Zip file.

 

These are my steps:

  1. Opened the "Sample.MPP", and took a screenshot of the first 23 tasks
  2. Saved the file as "Sample.XML".
  3. Opened that "Sample.XML" file, selecting 'Import as New Project' when prompted. Took a screenshot of the same Tasks.
  4. Saved that as a second XML file "Sample_2".XML (no changes were made to it).
  5. Opened that "Sample_2".XML file, selecting 'Import as New Project' when prompted. Took a screenshot of the same Tasks.

I compared the screenshots between all 3 files, and noticed that Dates and Durations were continuously changing from the original MPP file (see attached file Differences.png)

 

I checked the Calendar Options and Working Time settings after each file is opened, and they seem all the same: https://www.screencast.com/t/7RdF3B0BdW


I also check what the Calendar Options were for 'New Projects' and they were slightly different: https://www.screencast.com/t/3DOPdG9y

 

What is causing these differences?

 

  1. Does the XML Export have certain limitations / not support certain settings?
  2. Is there something else that is adjusting the dates when the XML file is being opened/imported as a new Project?

 

Updates:

  • I also tested in MS Project 2019, and the issue still happens.
  • I think it may be related to the fact that the project is using the '24 Hour' calendar. I had another 2 Project files which were exporting / loading XMLs fine, but as soon as i changed the calendar in the MPP files to use "24 Hour", and then exported the XML, once that XML was opened in Project again, the dates/times changed.
2 Replies

@Estate_Master -- I am not surprised at all by the fact that you see differences between the original project and a new project created from the exported XML file.  Based on my personal experience, the XML file does not capture the timephasing of task Work and Cost values on tasks.  And I suspect your use of the 24 Hour calendar is at least partially the source of the errors.

 

For me, the Save to XML option is a last resort to try to fix a corrupted project.  I know that using this feature will capture the "guts" of the project, but not the exact duplicate project.  Out of curiosity, why are you using the Save to XML feature?

 

Please let us know and we will try to help you.

 

Hi @Dale Howard 

 

I am exporting to XML, because we are developing a C# app that uses a .Net Gantt control. That control allows users to import MS Project XML files, not MPP format.