Can importing a CSV file in production JIRA corrupt JIRA data?

[Ankit Rathi]

I have to test whether importing ISSUES in my JIRA board will work or not?

When I see the documentation, it says that we should take backup of existing data and then only proceed.

Is it because of the fact that importing a CSV file in production JIRA can corrupt the JIRA data ?

Thanks in advance

[Alexey Matveev · Accepted solution]

Hello,

If you load data from a csv file and there are issue keys in your file, then if an issue with the same key exists, then this issue will be updated. There is a chance that the update will be wrong (I mean logically wrong), and you will have to rollback changes. If you only add issues to Jira, then there should not be any problems.

Anyway it is a good practice to create backups, before doing bulk changes to any software, you work with.

[Ankit Rathi]

Thanks @Alexey Matveev , for quick help.

Please take the following points into consideration as well.

1) Initially I would just test with 3 tickets at max.

2)The following is the sample data.

Project Name,Project Key,Issue Type,Summary,Description,Assignee,Product,Airline Code,Sprint,Fix Version/s,Reporter,Environment,Planned Start Date,Priority
SCM Project,SP1,Task,Bulk Upload Ticket 1,Bulk Upload Desc 1,Automatic,**,**,SP1 Sprint1,**,Ankit Singh Rathi,TF,02/26/2019 04:00:00,Medium
SCM Project,SP1,Task,Bulk Upload Ticket 2,Bulk Upload Desc 2,Automatic,**,**,SP1 Sprint1,**,Ankit Singh Rathi,TF,02/26/2019 04:00:00,Medium

Please share you viewpoint on this ?

Thanks and Regards,

[Alexey Matveev]

I do not think that 3 tickets can cause much damage to your system. You can always revert back manually. You will have history for each ticket to revert data.

Also I noticed that you try to import sprints. You should provide ids of sprints, not sprint names and sprints must be already created in Jira. During an import of a csv file, Jira does not create sprints or versions.

[Ankit Rathi]

thanks again @Alexey Matveev .

1) When you say revert back manually, I assume the that this means 'editing the tickets after the import process is completed'?  [Correct me please If I am wrong here]

2)"You should provide ids of sprints", -> Duly noted Alexey. 

   "sprints must be already created in Jira" -> Yes sprint exists.

   Can I leave the "SPRINT" field and still import the tickets ?

[Alexey Matveev]

1. Yes. I mean if you do not like changes, you can edit issues. But the history will stay. If you want to make your Jira as if the csv import never existed, then you would need to restore from a backup.

2. You can import without sprints. 

[Ankit Rathi]

Thanks @Alexey Matveev  for you help :)

[Alexey Matveev]

You are most welcome!