Up to Discussions in Jama Backstage (Public)

This Question is Answered

1 "correct" answer available (4 pts) 1 "helpful" answer available (2 pts)
3 Replies Last post: Apr 11, 2008 10:03 PM by tecsisa  
Click to view Louai's profile  
Louai
5 posts since
Jan 2, 2008

Mar 26, 2008 6:59 PM

MS Project


Hi,

I was wondering if anyone was using Contour in tandem with Microsoft Project.

I would be interested in exporting a list of functional requirements into project (I tried going through .xls files). Ideally, I would have a way of updating Contour when my tasks in Project are done, but for now I know this will have to be done manually. Did anyone attempt such an export.

Conversly, is anyone using Contour for time tracking (e.g. task completions woudl be propagated, % complete, etc..). I haven't explored what canbe done in Reports, but I would think one could get quite fancy there.

Thanks

Click to view Eric's profile  
Eric
82 posts since
Jun 11, 2007
1. Mar 27, 2008 6:53 AM in response to: Louai
Re: MS Project
Hi - your post is timely as I was just working on some initial requirements for our MS Project integration. We're planning to start with an export to a MS Project file and then add in updates to Contour based on changes in MS Project. We could go direct via XML or through Java using http://mpxj.sourceforge.net/index.html

A couple of questions...

What is the level of detail you'd want to output to Project (and want to track in Contour) - is it at the requirement level and track detail tasks in MS Project, or would you want those detail sub-tasks in Contour as well? Or, would rolling up and reporting on the requirement level back to Contour be sufficient?

Are you using Project Server - or stand alone?
Click to view Louai's profile  
Louai
5 posts since
Jan 2, 2008
2. Mar 27, 2008 1:58 PM in response to: Eric
Re: MS Project
Thanks for your reply, I'm glad you guys are considering this now.

In my case, I would try to have a 1-to-1 correspondence between functional requirements (which are the broken down version of higher level requirements) and tasks in MS project. I think controling heirarchy is going to be very important, as I would want to choose groups to export to different projects, and would like to have this heirarchy reflected in MS-project (i.e. folder in Contour would be tasks containing subtasks in project).


As for what flows from project to contour, I would think a complete status would be enough, with the propagation happening on project before the info is re-injected to contour (by the way, is there a way of propagating changes up in Contour?).


I'm using stand alone project.


Thanks.

Click to view tecsisa's profile  
tecsisa
1 posts since
Apr 11, 2008
3. Apr 11, 2008 10:03 PM in response to: Eric
Re: MS Project

Hi,

We have done just that using Microsoft Office Project 2003 XML Schema as interchange format, exposing two methods (getProject and a postProject) as web services. MS Project can open XML files that follow the schema, everything can can be mapped.

A MS project template with VBA macros opens a connection to the getProject web service and an action on the MS Project interface calls the web service postProject after modifications.

Native XML to Microsoft Office Project 2003 XM translation is done with XSLT.

Regards

Javier Ruiz
www.tecsisa.com

Actions

More Like This