Answered by:
Importing an XML and getting "An unexpected problem occurred when opening the file

Question
-
Hello
I am using MS Project 2007 and I am getting an error message "an unexpected problem occurred while opening the file. The file may be damaged. Try using a backup copy."
I did get rid of any &,',",<, > That I had. Also placed this out on the other forum but no one responded.
Just wondering if anyone ran across this or know what I can do here....
I did a "Save as" selecting Microsoft excel workbook.*.xls and went through the export wizard to produce the file out of MS Project 2007. I had no selection for a 2007 version of excel. I built a MAP selecting TASKS.
When I produce the excel file I get "You are trying to save afile to an older file format. This file may be less secure than a file saved in the new file format. I than select YES to save the file. Like I said it was the only option to select.
I open up excel and create the XML file doing a save type of xml spreadsheet 2003(*.xml)
I than get a message that the excel file may contain features that are not compatible with XML spreadsheet 2003. I reply YES to keep the format which leaves out inncompatible features.
I than go to MS Project opening up a blank project and than go to FILE OPEN slect tyhe file type of XML...find my xml file OPEN get the wizard... open as a new project...click finish and get the message
1) Why when I am using MS Project 2007 do I only get a selection for the 2003 v ersion of excel
2) what is wrong here...how do I get this IMported XML file into MS Project
Thanks
Sunday, September 26, 2010 12:50 PM
Answers
-
Hi Hotmail1,
1. We are not using any specific features of 2007 so Excel 2003 is just taken as a sensible default.
2. The format Excel uses to save a spreadsheet as XML is not the the same XML schema that Project would read. Please either just try to read the Excel format or read the article at http://msdn.microsoft.com/en-us/library/bb968621(office.12).aspx regarding the use of XML with Project.
If you can give me an idea of what you are trying to acheive then more than happy to give more guidance.
Best regards,
Brian.
Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page- Proposed as answer by Christophe FiessingerMicrosoft employee Monday, September 27, 2010 6:02 PM
- Marked as answer by Christophe FiessingerMicrosoft employee Tuesday, October 5, 2010 3:29 AM
Monday, September 27, 2010 5:59 PM
All replies
-
Yep I get the same problems
Yep NO ONE from microsoft seems interested or they are "avoiding the issue" until enough of us unofficial beta testers file a complaint.
I am fed up with MS's marketing hype not being followed up with robust, stable products and the user having to spend hours and hours and hours trying to figure stuff out when it is clear that there are BUGS which need to be fixed.
Good luck
I am recommending to ALL my clients who have not committed to Project to go with Oracle Primavera, a robust,stable and well supported product !!
Tom in Australia
Sunday, September 26, 2010 11:22 PM -
Hi Hotmail1,
1. We are not using any specific features of 2007 so Excel 2003 is just taken as a sensible default.
2. The format Excel uses to save a spreadsheet as XML is not the the same XML schema that Project would read. Please either just try to read the Excel format or read the article at http://msdn.microsoft.com/en-us/library/bb968621(office.12).aspx regarding the use of XML with Project.
If you can give me an idea of what you are trying to acheive then more than happy to give more guidance.
Best regards,
Brian.
Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page- Proposed as answer by Christophe FiessingerMicrosoft employee Monday, September 27, 2010 6:02 PM
- Marked as answer by Christophe FiessingerMicrosoft employee Tuesday, October 5, 2010 3:29 AM
Monday, September 27, 2010 5:59 PM -
Tom if you have any issue with our product you should engage MSFT officially via Microsoft support to get it resolved and not just the public Forums.
Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
Project Server TechCenter | Project Developer Center | Project Server Help | Project Product PageMonday, September 27, 2010 6:09 PM -
Hi Tom,
Sorry to hear you have the same issue - but as described above this would be expected behavior if you are also trying to read XML that is not in the same schema format that Project is expecting.
If you have some other related issue then I am certainly interested and more than happy to help. If you can give me the repro steps that is causing your problem for you then I'll take a look.
Best regards,
Brian.
Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
Project Server TechCenter | Project Developer Center | Project Server Help | Project Product PageMonday, September 27, 2010 6:17 PM