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 vote

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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

35 views 0 4
Read article

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