Click here to Skip to main content
Click here to Skip to main content
Go to top

Converter for Microsoft Project 2002 XML file to TODOLIST XML file

, 23 Jan 2006
Rate this:
Please Sign up or sign in to vote.
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)

Share

About the Author

maharishi_b
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

 
QuestionBug Report - Invalid Character Translation... PinmembertOPsEEK23-Aug-07 23:07 
GeneralTODOList XML format Pinmemberfathibn15-Oct-06 7:02 
AnswerRe: TODOList XML format Pinmembermaharishi_b27-Nov-06 6:38 
QuestionDowloading last version PinmemberSam Long29-Aug-06 23:27 
Questionis there a tool for the other way around? Pinmemberelhanan19-Jan-06 4:22 
AnswerRe: is there a tool for the other way around? Pinmembermaharishi_b19-Jan-06 22:53 
GeneralRe: is there a tool for the other way around? Pinmemberelhanan20-Jan-06 0:24 
AnswerRe: is there a tool for the other way around? Pinmembermaharishi_b23-Jan-06 19:03 
NewsAlso works for Project 2003 - with one modification PinmemberChrisPM6-Jan-06 6:08 
GeneralRe: Also works for Project 2003 - with one modification Pinmemberpauljenkins7147-Jan-06 16:57 
AnswerRe: Also works for Project 2003 - with one modification Pinmembermaharishi_b18-Jan-06 1:27 
GeneralRe: Also works for Project 2003 - with one modification PinmemberChrisPM19-Jan-06 10:44 
GeneralRe: Also works for Project 2003 - with one modification Pinmemberrichardmorgan29-Oct-07 23:22 
GeneralRe: Also works for Project 2003 - with one modification PinmemberSlimFast20006-Dec-07 1:07 
GeneralMS Project 2003 XML Option. PinmemberSreenivas MK28-Jun-05 21:54 
Hello Everybody,
 
I have a question regarding the usage of Export / Import XML files into MS
Project 2003.
 
I plan to write a client application (VC++ ) which could import a MS Project file
(Importable XML File) into MS Project without opening the MS Project 2003
application.
 
A manual way of reimporting an exported MS Project File is possible. i
wanted this to be done by the client application.
 
* This application should be able to import the project xml file into MS
Project 2003.
 
* also Save the project file in its primitve format ".mpp" automatically if possible.
 
Shall be thankful for any ideas or suggestions, Smile | :)

 

Sreenivas MK

GeneralCould also be written as a TDL Importer Pinmember.dan.g.16-May-05 14:13 
GeneralRe: Could also be written as a TDL Importer Pinmembermaharishi_b16-May-05 18:58 
GeneralGood to see MS Project articles PinmemberMiguel Lopes16-May-05 4:10 
GeneralRe: Good to see MS Project articles Pinmembermaharishi_b16-May-05 23:12 
GeneralRe: Good to see MS Project articles PinsussWillOMalley20-May-05 10:58 
GeneralRe: Good to see MS Project articles PinmemberMiguel Lopes20-May-05 14:26 
GeneralRe: Good to see MS Project articles PinsussWillOMalley23-May-05 2:50 
GeneralRe: Good to see MS Project articles PinmemberMiguel Lopes23-May-05 5:06 
GeneralRe: Good to see MS Project articles PinmemberOMalleyW23-May-05 6:25 
GeneralRe: Good to see MS Project articles PinmemberMiguel Lopes23-May-05 7:18 

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

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

| Advertise | Privacy | Mobile
Web03 | 2.8.140926.1 | Last Updated 23 Jan 2006
Article Copyright 2005 by maharishi_b
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid