OpenProj/Gantt Project integration

Status as of 11/2011 (]po[ V4.0 Alpha)

• Integration Features
• Stable: Integration with OpenProj v1.3
• Stable: Integration with OpenProj v1.4
• Alpha: Integration with GanttProj v2.0.10
• Beta: Integration with Microsoft Office Project 2007 & 2010
  
• Test Cases

Integration Features

This section detailes the various features/fields that ]po[ will read and process from Microsoft Office Project, GanttProject and OpenProj.

• Task Name:
  Names are supported with UTF-8 characters and full internationalization.
  In contrast to Project clients, ]po[ does not allow for duplicate task names. When finding a duplicate name during an import, ]po[ will append a random string to the task name to guarantee uniqueness.
  
• Resources
  If a resource assigned in MS Project is not a member of the ]po[ Employee Group, the ]po[ import wizard offers creating them during the import
  
• Start & Finish:
  ]po[ accepts the start and finish date directly.
  
• Task Priority:
  Task priorities are stored in ]po[ and used by project schedulers like TaskJuggler etc. (future)
• Milestone:
  Tasks marked as milestone in MS-Project are shown in the ]po[ "Milestones" page.
  
• (WBS) Type:
  ]po[ currently only supports numeric WBS codes (Type=0). Type!=0 will return an error message.
  
• WBS:
  This field contains a hierarchical code (example: 2.1 for the first sub-task of the second task in the project)
  
• Duration:
  Defines the number of working days (or hours, depending on the format) to complete the task with the assigned resources.
  ]project-open[ will store this value in its "estimated_units" field, multiplying the duration value with the assigned resources:
  
• If no resource is assigned to the task, ]po[ assumes that one resource is assigned with 100%.
• If resources are assigned to the task, ]po[ will calculate its "estimated_units" field as duration * (assignments / 100)
  Example: A task of type 'Fixed Unit' with start date 9/1/2012  and end date 9/1/2012 has one resource assigned (100%) will result in 8 'Planned Hours' in ]po[
  
• Duration Format:
  Only Days and Hours are supported as duration formats. Any other value will cause an error.
  
• Work:
  If present, this field will overwrite the calculated Duration time.
• Actual Progress / Percent completed:
  Percent completed (task) will be imported/exported accordingly
  

Features/fields of MS-Project not supported yet. These fields are stored in ]po[, but there is no functionality associated with them:

• IsNull: Ignored
• Create Date: Ignored
• Contact: Ignored
• MS Project Calendars
  

Integration Status

Integration with Microsoft Office Project 2007 & 2010

Status­­:

• Beta
• ]p­o[ V4.0 ALPHA contains a first integration with MS Office Project 2007 & 2010
  
• The same interface should also be able to import most files from other MS Office Project versions, however this is not yet tested.

Known issues:

• There is a few number of known issues with this integration
  

Integration with GanttProj v2.0.10

Known issues:

•  Some user report an unordered task list after upload to ]po[  
  

Integration with OpenProj v1.3

Status:

•  Basic integration with OpenProj V1.3 works

Known issues:

•  tbc.

Integration with OpenProj v1.4

Status:

• Integration with OpenProj V1.4 needs work
  
• Import of xml file created by ]po[ to OpenProj V1.4 hangs no import/error seems to be created
• Fixed table structure should be replaced with a dynamic one to better that adjusts to the ever changing xml structures used by OpenProj

To-do:

• Compare xml structures and adjust xml file as required/accepted by ]po[
  

Test cases

Case 1 - Set start/end date in OpenProj/GanttProject

• Create project of type Consulting-Project
  
• Create two tasks (task_1, task_2) 
• Don't set any task attributes such as start date, end date, etc besides task name
  
• Download OpenProj/GanttProject Schedule
• Set start and end date in OpenProj/GanttProject
• Save as xml and upload xml file to ]po[
• Expected behaviour: Start/end date are set in ]po[

Case 2 - Deleting tasks in OpenProj/GanttProject:  

• Enter 0.5 hours to task_1 in ]po[, export to OpenProj/GanttProject, delete task_1 in OpenProj/GanttProject and re-import xml file to ]po[
• Expected behaviour: ]po[ should resolve conflict, showing a screen
  

Case 3 - Adding tasks in OpenProj/GanttProject:

• Download OpenProj/GanttProject schedule from ]po[
• Add Task task_3 in OpenProj/GanttProject
  
• Upload to ]po[
• Expected behaviour: Task should be created in ]po[
  

Case 4 - Assigning resources in OpenProj/GanttProject:

• Download OpenProj/GanttProject Schedule from ]po[
  
• Assign resource to task_3 in OpenProj/GanttProject
  
• Upload to ]po[
• Expected behaviour: Resource should be assigned to ]po[
  

Case 5 - Changing resources in OpenProj/GanttProject:

• Assign second resource (Add member) to project in ]po[
• Assign resource to task_3
  
• Download OpenProj/GanttProject schedule
  
• Remove resource from task_3
  
• Upload to ]po[
• Expected behaviour: No resource assigned to task_3

Addintinoal information:

•   SourceForge Forum: http://sourceforge.net/projects/project-open/forums/forum/295937/topic/3178149: