Project Importer

From DotProjectWiki

Jump to: navigation, search

Contents

Project Importer allows users to import their Microsoft Project files directly into dotProject keeping the dates, durations, user assignments, and percent allocations. It is known to work with Microsoft Project versions '98 - '03 and dotProject 2.0.4+.

1 Release Available from

http://caseysoftware.com/microsoft-project-dotproject-importer

2 Known Issues

2.1 Fixed in 2.0 (latest)

  • Fixed the parent/child relationship error. In the v1.5 release, a bug was introduced which could cause parent/child relationships to be lost.
  • Fixed the User case mismatch error. Previously, when the Importer created Users, it would use the same capitalization from the Microsoft Project file's Resources. Unfortunately, this often created sitatuations wherea a new User named "Keith" was created while "keith" was an existing User. The Importer now makes all usernames lowercase to match the rest of the system.
  • Improved overall memory management. Previously, with 64M allocated to PHP, approximately 100 tasks in a single project plan could be imported. With the new memory management, 64M has proven sufficient to import 450+ tasks.
  • Adjusted the install() and remove() functions in the setup procedure to automatically attempt to install the translation files (English and German currently) to their proper locations within dotProject. This ensures that all language changes via the Translation Management are reflected.
  • It uses the "extended" keyword to implement the class hierarchy. Yes, real OO in preparation for multiple XML structures.
  • Finally, the memory/stack management has been rewritten to increase the size of files supported. Current testing shows that with 64M for PHP, projects ranging from 450-600 tasks can be imported. Further optimization will occur as a result of SimpleXML usage but is no longer a priority.

2.2 Fixed in 1.5

  • The Importer would always round down to the nearest hour due to an oddity in how durations are determined. Resolved in v1.5.
  • Due to how PHP4 handles XML parsing and cdata blocks, special characters were triggering the parser to treat the single cdata node as multiple nodes therefore causing only the last of the text segments to be imported. Resolved in v1.5.
  • There was an issue releated to not always capturing the parent/child task relationships correctly. This was introduced in v1.4 and resolved in v1.5.

2.3 All Versions

  • When the Importer creates a User, no permissions/Role information is attached. If you attempt to delete this new User you will receive an error with the message Failed to remove user permission object despite the fact that the User will be deleted successfully. This was an issue within core dotProject and has been resolved in both Stable_2 and Head and should be resolved in the v2.1 release of dotProject.
  1. Open file in Project 2007
  2. Save file in Project 2003 format
  3. Close the 2007 formatted file and open the 2003 formatted file
  4. Export as XML
  5. Import using the Project Importer as normal

3 Compatibilities

3.1 Version 2.0

Due to the new class structure and a number of smaller tweaks, you must use PHP5. In order to simplify support issues, the module will detect your version of PHP and dotProject and display a warning message noting the version problems.

3.2 Version 1.4 and above

This has the security modifications from the dotProject 2.1 Release Candidate, therefore it is not compatible with any previous version of dotProject. No further development will occur on this version.

3.3 Version 1.2

If you are using any version of dotProject prior to the 2.1 Release Candidate, it is strongly encouraged that you upgrade as soon as possible. In the meantime, you can still use v1.2 of the Project Importer. No further development will occur on this version.

4 Status

This is considered a stable release and will be reviewed shortly before the next release of dotProject for compatibility and functionality. The most recent releases are available here: http://caseysoftware.com/microsoft-project-dotproject-importer

  • v2.0 Major Update Release: 2007 October (requires PHP5 and dotProject v2.1 rc1 or above)
  • v1.5 Update Release: 2007 July (last PHP4-compatible release)
  • v1.4 Update Release: 2007 May
  • v1.2 Update Release: 2006 October (last dotProject 2.0.x-compatible release)
  • v1.1 Update Release: 2006 September
  • v1.0 Initial Release: 2005 December

5 Support Forum

Questions, comments, concerns should be sent to Keith Casey via CaseySoftware, LLC - http://caseysoftware.com/blog. The dotProject forums are not monitored for support issues.

Personal tools
System Administration
Conversion