Importing csv data to jira by Users (not admins)

Hi All

We have a few users who wish to enter data into jira directly from a csv. Entering data manually is taking an awful lot of time as there are plenty of issues in the csv.

I know we have the importing via csv feature but that is restricted to jira admins.

What are the other options we have?

Rahul

8 answers

Hi Rahul,

Maybe you can have them create issues using the rest api :

https://developer.atlassian.com/display/JIRADEV/JIRA+REST+API+Example+-+Create+Issue

You could even write a small script to automatically create the correct json based on the information in the csv.

Best regards,

Peter

1 votes

Another dirty trick - convert the data into a Jelly script, dump it on the server and have a jelly service that regularly looks for scripts to import.

What do you mean by

> it cannot be used for incremental additions to a project

I meant that if i use the csv import feature on a project which already has data in it then the existing data in the project gets wiped off.

Correct me if my understand is wrong.

Rahul

Yes, you got it wrong. If you use the csv importer you hav two posibilities. The first is to upload data with no ID. The result would be additional new issues. The second one you upload data with existing IDs (issue key) then those issues will be updated.

Rahul,

Importing issues through csv does not wipe out your existing issues. Importing a project requires you to remove all issues from the current project.

You can not give them only this access, only jira admins have this permission.

Can't you just do it once for them and let them add any new issues manual?

Best regards,

Peter

Hi Peter

Unfortunately not, our users want this ability to import issues at least once every week.

Any other solution you can think of?

Rahul

Thanks Udo....I ll update my issue description above...

How to allow users to import JIRA issues from Excel or CSV - this is an example based JIRA together with Confluence.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,852 views 12 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot