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 
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 
Hi,
 
.dan.g. wrote:
[update] should have looked at the code first. it's way beyond my current skillset to translate it. ps. does anyone know of any online documentation that shows how to create dlls exporting pure virtual interfaces under .NET? i've tried googling but without success. i just want to increase my knowledge in the area since it may be a useful way for me to start using .NET.
 
pure virtual interfaces in VC are nothing but interface in C# you can create a interface and give all the method declarations in that. the class which is implementing the interface has to give a concrete implementations of all the methods defined in the interface. More than that you have to create the pure virtual interface in com and give it to .net it will automatically create a seperation layer between .net and com. And all the calling between the two sections will be taken care of.
 
I will be happy if you can provide just the dll of the IImportTasklist or IExportTasklist pure virtual interface so that i can test my project on that.
 
Thanks
 
Maharishi Cool | :cool:
 
Nothing is Impossible. Even impossible spells "i m possible"
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
Web02 | 2.8.140922.1 | Last Updated 23 Jan 2006
Article Copyright 2005 by maharishi_b
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid