Solved

MSProject - error opening exported XML file

Posted on 2012-03-21
2
480 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
ID: 37751253
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
ID: 37752352
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

864 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

25 Experts available now in Live!

Get 1:1 Help Now