Click here to Skip to main content
15,867,141 members
Articles / Programming Languages / XML
Article

Converter for Microsoft Project 2002 XML file to TODOLIST XML file

Rate me:
Please Sign up or sign in to vote.
4.42/5 (12 votes)
23 Jan 2006Ms-PL3 min read 116K   1.3K   35   32
Converter for Microsoft Project 2002 XML file to TODOLIST XML file.

Introduction

I have been using .dan.g.'s ToDoList for a very long time now. It's very easy for me to track things that I have to do and also track the projects on which I am working. But there was always a problem related to the creation of task list. My organization uses Microsoft Project (like many other companies) for tracking projects and the cost of development related to these projects. So, I had to make two tasklists, one for the company and the other for myself. ToDoList is much more simpler when compared to Microsoft Project and for daily tracking you don't need rocket applications (like Microsoft Project) to do the tracking. So, I decided to go ahead and make a converter for ToDoList, but the problem was Microsoft Project 2000 didn't support XML, it supported only CVS or tab separated files. Since there wasn't a standard format for the CSV or tab separated files, I chose to make two task lists. Microsoft Project 2002 version had something different, it supported the whole task list to be converted into an XML file and this XML format was standard. This gave me an idea to convert the Microsoft Project 2002 task list to the ToDoList task list.

Background

Before you start using my converter for Microsoft Project, there are some points to be noted:

  • Although ToDoList is made in VC, I have built this application in .NET Framework. Since I have worked with .NET technologies for the past two years, I am much more comfortable with .NET than with VC. The .NET Framework is Microsoft's latest venture, and all the future OS from Microsoft are inherently going to support it. But for now, you will have to download some software to actually make my converter work. See the Software Required section for more details.
  • I have made this application keeping in mind the current XML format supported by ToDoList version 4.1.8. If there are any changes to the format of XML in the future versions of ToDoList, I take no responsibility for any loss of data or such stuff.
  • There are other data which is been captured by MS Project, but my converter will just take the data required for the todolist application. So the converted XML will never be 100% convertible with the original MS Project XML.

Software required

You will require the following software:

Using the software

The converter is very easy to use. Following are the steps to be taken for using the converter:

  • Save the MS Project 2002 or 2003 file as XML.
  • Pass the XML file as a parameter to the command line utility by typing the following at the command line:
TODOListConverter.exe <XML File of Microsoft Project 2002 or 2003>

The converted XML file will be saved to the same directory as the input XML file with a "TODO_" prefixed to the file name.

History

  • 20th January, 2006 - 1.2
    • Modified the code to adjust to XML changes in MS Project 2003 (Courtesy : ChrisPM)
    • Outputting the file as a ".tdl" file which is the default extension for todolist.
  • 24th May, 2005 - 1.1
    • Added functionality to link predecessors.
    • Mapped hyperlink column data to file reference attribute.
    • Modified the XML to automatically search for xmlns="http://schemas.microsoft.com/project" string and remove it.
    • Signed the assembly.
  • 16th May, 2005 - 1.0
    • Initial release.

License

This article, along with any associated source code and files, is licensed under The Microsoft Public License (Ms-PL)


Written By
Program Manager Capgemini
United States United States
I have been working in software industry for the past 11 years, though i am trained to be a pharmacist. Enjoy working on complex and new technologies. Also cleared my SCJP and MCP certification examinations.

Comments and Discussions

 
QuestionUpdate to current version? Pin
Pierre de la Verre7-Jan-16 1:37
Pierre de la Verre7-Jan-16 1:37 
Questionconverting is not working Pin
Member 1134350610-Jan-15 0:45
Member 1134350610-Jan-15 0:45 
AnswerRe: converting is not working Pin
Maharishi Bhatia5-Feb-15 9:49
Maharishi Bhatia5-Feb-15 9:49 
QuestionBug Report - Invalid Character Translation... Pin
tOPsEEK23-Aug-07 23:07
tOPsEEK23-Aug-07 23:07 
GeneralTODOList XML format Pin
fathibn15-Oct-06 7:02
fathibn15-Oct-06 7:02 
AnswerRe: TODOList XML format Pin
Maharishi Bhatia27-Nov-06 6:38
Maharishi Bhatia27-Nov-06 6:38 
QuestionDowloading last version Pin
Sam Long29-Aug-06 23:27
Sam Long29-Aug-06 23:27 
Questionis there a tool for the other way around? Pin
elhanan19-Jan-06 4:22
elhanan19-Jan-06 4:22 
AnswerRe: is there a tool for the other way around? Pin
Maharishi Bhatia19-Jan-06 22:53
Maharishi Bhatia19-Jan-06 22:53 
GeneralRe: is there a tool for the other way around? Pin
elhanan20-Jan-06 0:24
elhanan20-Jan-06 0:24 
AnswerRe: is there a tool for the other way around? Pin
Maharishi Bhatia23-Jan-06 19:03
Maharishi Bhatia23-Jan-06 19:03 
NewsAlso works for Project 2003 - with one modification Pin
ChrisPM6-Jan-06 6:08
ChrisPM6-Jan-06 6:08 
GeneralRe: Also works for Project 2003 - with one modification Pin
pauljenkins7147-Jan-06 16:57
pauljenkins7147-Jan-06 16:57 
AnswerRe: Also works for Project 2003 - with one modification Pin
Maharishi Bhatia18-Jan-06 1:27
Maharishi Bhatia18-Jan-06 1:27 
GeneralRe: Also works for Project 2003 - with one modification Pin
ChrisPM19-Jan-06 10:44
ChrisPM19-Jan-06 10:44 
GeneralRe: Also works for Project 2003 - with one modification Pin
richardmorgan29-Oct-07 23:22
richardmorgan29-Oct-07 23:22 
GeneralRe: Also works for Project 2003 - with one modification Pin
SlimFast20006-Dec-07 1:07
SlimFast20006-Dec-07 1:07 
GeneralMS Project 2003 XML Option. Pin
mksreenivas28-Jun-05 21:54
mksreenivas28-Jun-05 21:54 
GeneralCould also be written as a TDL Importer Pin
.dan.g.16-May-05 14:13
professional.dan.g.16-May-05 14:13 
GeneralRe: Could also be written as a TDL Importer Pin
Maharishi Bhatia16-May-05 18:58
Maharishi Bhatia16-May-05 18:58 
GeneralGood to see MS Project articles Pin
Miguel Lopes16-May-05 4:10
Miguel Lopes16-May-05 4:10 
GeneralRe: Good to see MS Project articles Pin
Maharishi Bhatia16-May-05 23:12
Maharishi Bhatia16-May-05 23:12 
GeneralRe: Good to see MS Project articles Pin
WillOMalley20-May-05 10:58
sussWillOMalley20-May-05 10:58 
GeneralRe: Good to see MS Project articles Pin
Miguel Lopes20-May-05 14:26
Miguel Lopes20-May-05 14:26 
GeneralRe: Good to see MS Project articles Pin
WillOMalley23-May-05 2:50
sussWillOMalley23-May-05 2:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.