Issue Details (XML | Word | Printable)

Key: JRA-6386
Type: New Feature New Feature
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Benjamin Naftzger [Atlassian]
Votes: 31
Watchers: 23
Operations

If you were logged in you would be able to see more operations.
JIRA

Build JIRA Microsoft Project Plugin for limited integration

Created: 11/Apr/05 11:10 AM   Updated: 18/Nov/07 05:28 PM
Component/s: Extensions
Affects Version/s: None
Fix Version/s: None

Time Tracking:
Not Specified

Issue Links:
Part
 
Reference

Participants: Ahmed Saleh, Benjamin Naftzger [Atlassian], Bernhard Neuhauser, Brian Nguyen, John Allen, lila duken, Lillian Spearing, Mark Johnson and Steven
Since last comment: 48 weeks, 6 days ago
Labels:


 Description  « Hide
It would be nice to be able to import and export between JIRA & MS Project.

Not sure what other functionality users may want... ? (comments please)



 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Brian Nguyen added a comment - 03/May/05 01:59 AM
Hi Brian,

The first two requests seem to stem from the same problem in that you cannot search for linked issues. As you have already know the issue relating to this request ia available at JRA-3101. Further updates will be available from that issue in the future. There is also an issue open on the ability to export to MS Project - JRA-6386.

For No.3 it is possible to create a custom workflow -condition that can check the status of linked issues. However it does require you to configure JIRA from source.
There is a tutorial available at http://confluence.atlassian.com/x/9C0, the logic for your request should be similar to the SubTaskBlockingCondition. The Manager of interest is IssueLinkManager which can be found at ComponentManager.getInstance().getIssueLinkManager();

By creating this workflow condition you should be able to create a new status of "Inactive" that can only be "Activated" if the condition is passed.

I am going to resolve this issue for now if you have any further questions either reopen this issue or comment on any of the related issues above.

Thanks,
Brian


Ahmed Saleh added a comment - 23/Aug/05 01:56 AM
Further to this issue, it would be also good to link (not import/export) the issues in Jira to activities in MS Project. Two types of links are candidates:
  • Tasks/ Activities that are affected by this issue
  • Tasks/ Activities that may be used to resolve the issue.

BR


Steven added a comment - 09/Feb/06 05:00 AM
i'd love to see an integration with MS Project able to do the following:

there is a task A in MS-Project with Bob assigned as a ressource. 1-n according issues are created in jira manually and assigned to developer Bob. Bob has worked 4 hours on that issue and updates the according effort in jira. The project manager opens the project plan and retrieves the newest jira data. the effort spent on the jira issue is updated automatically in the according MS-Project task(s) and the progress bar is visible.

if Bob enters a new estimation for remaining work in jira, the information should be updated in MS-Project as well.


John Allen added a comment - 21/Jun/06 12:05 PM
Tighter integration between JIRA and MS Project is definately on my JIRA wish-list. The CSV importer is a great step forward though. I have seen a company (http://www.mondo.com.br/jiraintegration) offering a MS Project toolbar that claims to import and export from JIRA but I haven't tried it and don't endorse it. I am trying to get JIRA accepted by my company's Project Management and Planning group (some 300 odd project planners (shiver!)) and a tighter link between JIRA and MS Project (the tool they know and love) with the ability to synchronise would definately help. Additionally if i can 'export/merge' into MS project I can then easily 'diff' the baseline plan vs real-world progress using MS Project's compare functionality, a real killer feature for project managers.

lila duken added a comment - 14/Mar/07 04:02 AM
I would love to see a synchronization between MS Project and Jira. Tasks would be entered in MS Project, the respective ressources assigned. These would be imported into Jira. The work log would be synchronized back into MS Project, so that you can easily track the progress and have an overview on the project as a whole. It would be great if you could also synch releases from Project to Jira.

I am actually not a huge fan of MS Project, but it is sometimes simply a requirement.. A synchonization between MS Project and Jira would make the info stored in the project plan available to the team, you have less redundant data, etc..


Bernhard Neuhauser added a comment - 23/Mar/07 05:59 AM
A 2 way ms project integration would be a real benefit for us.

Sometimes its really necessary to work with tools like ms project (For example when issues got a fixed start / end time and other issues are depending on it). This means that such projects will be maintained as ms project files. And every user maintaining his project will simply avoid using jira.

Personally i am also not a fan of ms project, but i see the necessity of such an integration.

I like the idea of this plugin: http://confluence.atlassian.com/display/JIRAEXT/ILOG+Gantt+Bridge
But the problem is, that the gantt bridge does not work with jira 3.7+ and it does not seem like the plugin is maintained.

Please add the ability to use ms project as feature rich jira frontend.


Lillian Spearing added a comment - 31/Oct/07 07:37 AM
We have prototyped an MS Project plugin that can take an XML output from Jira (search and filter the project and tasks you want) and create an MS Project plan from that.

The tasks are grouped under the versions (sprints) and shows the time spent.

Mappings include:

Jira ---------------------------------------- MS Project
title ---------------------------------------- task name
assignee -------------------------------- resource name
remaining estimate ------------------ work
time spent/(spent+remaining) ---- % complete
status= resolved | closed ---------- 100% complete
resolution (if resolved/closed) ---- notes
summary ------------------------------- notes
priority ----------------------------------- priority
"depends on" link -------------------- predecessor
components --------------------------- text1

This is a one way from Jira to MS Project only as we use Jira as the master for our work (and two way synchronisation sounds problematic to me).

We haven't tested it with the latest version of Jira yet but it should work if the RSS feed hasn't changed. A problem exist with getting RSS feeds from Jira for large lists.

Does this sound useful to any of you?


Mark Johnson added a comment - 31/Oct/07 07:53 AM
Yes. It looks very interesting. I will have our team download this and
try it out.

Thanks for pointing it out.

mark


Lillian Spearing added a comment - 31/Oct/07 08:10 AM
Sorry, I'm not working for Atlassian nor MS so this plugin is not yet available online. Just wondered if anyone though that it might be useful for them and then I can check if my company will allow it to be available.