Issue Details (XML | Word | Printable)

Key: JRA-9994
Type: New Feature New Feature
Status: Open Open
Priority: Critical Critical
Assignee: Unassigned
Reporter: Bettina Zucker
Votes: 17
Watchers: 11
Operations

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

Extend CSV import to update already imported issues

Created: 26/Apr/06 05:30 AM   Updated: 26/May/08 06:10 AM
Component/s: Import / Export
Affects Version/s: None
Fix Version/s: None

Time Tracking:
Not Specified

File Attachments: 1. Zip Archive Csv-Jira-XML-RPC.zip (93 kB)

Issue Links:
Reference
 

Participants: Anton Mazkovoi [Atlassian], Baerrach bonDierne, Bettina Zucker, Jed Meade, Matt Brown and Pamela Chow
Since last comment: 44 weeks, 5 days ago
Support reference count: 3
Labels:


 Description  « Hide
We use the CSV importer to regularly import new issues from the bug tracking system of a customer.
With the wizard it was very easy to initially define a mapping between the 2 systems.

The problem is, the CSV importer of Jira can do only INSERT, no UPDATE.
So we have to manually update Jira to keep it in sync with the customers bug tracker.
Our customers do not change very often the issues after we get them, but sometimes they do
and as projects are getting bigger this is becoming too much to handle manually.

Are there any plans to add to the CSV importer the capability to update already imported issues?

Or are there any other solutions to this problem?
Are there any "standard" Jira solutions?

As I see the Jira CSV importer was created as a tool to import data from another system once,
not to keep data in sync between two systems. But with a small extension it could be made into one.
I just could not find this issue anywhere here in Jira's Jira. We need a solution quite urgently.

Regards
Bettina Zucker



 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Anton Mazkovoi [Atlassian] added a comment - 28/Apr/06 04:26 AM
Bettina,

I must admit that no one has actually asked for this before.

One way to programmatically update issues is to write a SOAP client that does this. The client can parse the CSV file and then update the necessary fields through SOAP. For more information on the SOAP acess to JIRA please see:
http://confluence.atlassian.com/display/JIRAEXT/JIRA+RPC+plugin

Would this work for you?

I guess getting CSV to update issues would be possible, but given the nuber of feature requests that we have, it might take us a long while ot get to this.

I hope this helps.

Thanks,
Anton


Jed Meade added a comment - 29/Jun/06 08:21 AM
I would find this useful as well. I am using Microsoft Project to schedule projects. I use it mainly for it's ability to level resources and manage moving tasks with interdependencies. In any case, I export task info (summary, description, assignee, due date) from MS Project into a CSV file that I import into JIRA. It would be great if JIRA's CSV import process could identify duplicate issues by summary and update each associated field.

Matt Brown added a comment - 26/Jul/06 01:29 PM
If this is implemented, it would be nice if the Excel output of the Issue Navigator could, when saved as CVS, be correctly read by the CVS importer.

That way, you could export to Excel, edit the file in a meeting away from the server, and then just import it to update with the changes.

Side Note
Would that be a subtask to this issue or a separate issue linked to this one? It doesn't seem like a separate issue since it's really only an issue if the import updates.


Bettina Zucker added a comment - 27/Jul/06 03:34 AM
Hello Matt,

there is already an issue for your request, but without the excel stage.
The issue asks to make a native jira csv export which can be imported in jira again without reformatting:
JRA-8580

Cheers

Bettina


Pamela Chow added a comment - 08/Sep/06 09:02 PM
Hi vote for this feature!

Absolutely a time saver. My use case is as follows:

We use Agile methodology called scrum, and need to manage user stories in JIRA. I find that I refactor the stories quite frequently - touch a lot of stories and often they have to be updated/rewritten in groups based on new information.

This workflow is much more efficient but also superior in that you can edit the user stories in context:

1: find all the related stories
2: export into an excell sheet
3: refactor the user stories, prioritize in context of the exported lit,
4: then import back into JIRA.

Please up the priority on this request. A rough ETA would be nice. Thanks.

Cheers


Baerrach bonDierne added a comment - 11/Jun/07 07:44 PM
I've hacked together a python client that can update the export CSV Jira issues using XML-RPC.

We are using it internally, but the "paint is still a bit wet".

There should be adequate unit tests to enable others to extend this to support their needs. I believe that after you have configured it as per the README it should just work for your environment and that you won't have to write any more code for it.

Ideally I see Atlassian providing a web based tabular update capability which would reduce the need for this tool.

Is this something that Atlassian wont to pick up and provide support for?
Or is this something that should be hosted elsewhere?


Baerrach bonDierne added a comment - 04/Dec/07 10:48 PM
Ideally I would like a web based spreadsheet opened for selection issues and specific values from those issues.

Then I can make adjustments in the spreadsheet and "apply" the changes in one go.