Solved

MSProject - error opening exported XML file

Posted on 2012-03-21
2
473 Views
Last Modified: 2012-03-22
I exported a large (4,000 tasks) mpp to xml and when I attempt to open it with Project I get the error "An unexpected error occurred... The file may be damaged." I tried exporting it several times but get the same error each time. I don't see anything obvious in the xml, but it is huge and something could be lurking someplace that's not apparent. Does anybody have any ideas?
0
Comment
Question by:dgmoore1
2 Comments
 
LVL 10

Accepted Solution

by:
pfrancois earned 500 total points
Comment Utility
We have to discover what is failing: the export or the import part of the process.

There are several open source programs to check if a XML file is valid. If the XML file is found to be invalid, you know there is a bug in the export process.

If you are not afraid of command line interfaces (this has future, also in MS environments), xmllint can be a good tool to validate XML.
0
 

Author Closing Comment

by:dgmoore1
Comment Utility
The problem turns out to be the formatting of the exported xml, which in turn is due to some stray characters in various mpp fields. When I open the xml in Excel it gives me the offset of the offending character, then I open the xml in HxD, go to the offset, and fix the xml. There are numerous errors, which I have to identify and fix one at a time. The file is enormous, so this is going to take a while, but I think it will ultimately work. I can also use the results of this exercise to go back and fix the mpp. Thanks for your comments.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now