Importing csv data to jira by Users (not admins)

[Rahul Aich [Nagra]]

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

[Nic Brough -Adaptavist-]

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.

[Peter Van de Voorde]

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

[Udo Brand]

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.

[Bob Swift OSS (Bob Swift Atlassian Apps)]

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

[Rahul Aich [Nagra]]

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

[Peter Van de Voorde]

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

[Rahul Aich [Nagra]]

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

[Rahul Aich [Nagra]]

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

[Udo Brand]

What do you mean by

> it cannot be used for incremental additions to a project