Import from CSV into existing projects

[Jason]

I want to create several similar Jira tasks in Excel, tweak them slightly in Excel, and then import them to create different Jira tickets which I can modify further directly in Jira.

I already have several existing Projects in my Jira instance. I want to import these Excel tickets into one of those specific projects.

There are warnings in the documentation that importing from CSV will wipe out all existing data in the project. The existing Jira projects are actively used and I can't afford to have all that wiped out. I just want to enable ticket-writers a quicker way of creating tickets.

Is the documentation overly-cautious and/or incorrect?

Would creating a dummy project and importing these CSV records into that file and then moving them to the target project be a way to avoid this problem? I'm afraid even doing this will wipe out data and settings in projects across my Jira instance.

[Peter Van de Voorde · Accepted solution]

Jason

Take a look at this document, it explains it step by step :

https://confluence.atlassian.com/display/JIRA/Importing+Data+from+CSV

Importing issue will not change any configuration settings, so you don't have to worry about that.

If you are worried about overwritting data you can first create a demo project with 1 or 2 issues in it and import your csv to this project first, after the import you can check if your original issues still exist. You can then just delete the project after a succesful test and import the data into your correct project.

Best regards,

Peter

[Jason]

This thread has answered the question

[Jason]

In this document (https://confluence.atlassian.com/display/AOD/Importing+Issues) it makes the statement "This import procedure overwrites all the existing data and configuration in JIRA OnDemand and cross-application settings." but I guess that's specific to "Importing issues from JIRA and other third-party issue trackers"

[Erik Saline [BlackPearl PDM]]

I am looking at this doc about importing from CSV,https://confluence.atlassian.com/display/JIRA/Importing+Data+from+CSV and I do not see anything about wiping out data. If you are unsure use the Altlassian SDK to setup a quick JIRA instance, create a few test project and then run the CSV import. If anything goes wrong there are no worries as it was just a test enviroment.

https://developer.atlassian.com/display/DOCS/Set+up+the+Atlassian+Plugin+SDK+and+Build+a+Project

[Dave]

That's correct, it's related to the system restore when importing the backup XML file. CSV imports will not overwrite your data.

[Bob Swift]

Consider using the JIRA Command Line Interface for this. Reference is: How to import JIRA issues using CSV