Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Course Of The Month
10 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MSProject - error opening exported XML file
Posted on 2012-03-21
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
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.
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.
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.
Featured Post
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…
Re-planning is just as important as planning. MS Project files need to be updated regularly to reflect the current status of the project and to streamline the upcoming tasks. We have seen a lot of issues where project managers have not updated the p…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 11 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
628 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.