JIRA issue excel import - External User

Hi

I know the process where by we can import issues from excel into JIRA by going through import excel from admin panel.

I have users who have excel files with issues, is there a way they can upload excel file and it gets imported to JIRA as issues.

Please let me know.

Abraham

3 answers

1 accepted

JIRA Command Line Interface allows you to import CSV (Excel) into projects. See How to import data from external systems or databases and release notes. This is useful for bulk loading of a number of issues documented in a speadsheet for some other process reason. In our case it is testcase definitions where it is convenient to get them all ready at once, then when work is complete load them into JIRA. You don't need to be an administrator to do this. In our case, we have Confluence, we so it was easy to wrap the CLI function onto a more easy to use page with a button to upload using the Run Plugin

Hi guys,

With JExcel  you can import issues from Excel using the usual Ctrl+C, Ctrl+V

https://marketplace.atlassian.com/plugins/com.moresimp.jexcel

I hope it helped,

Regards,

Janos

Can JIRA CLI import the CreateDate, ResolutionDate, UpdateDate information ?

The use case is I have several product lab tests and each lab has its own issue report.

I hope to keep all the original date information to have a unique report. Is it possible to use JIRA CLI runFromCSV to keep the source date information?

No. JIRA does not allow creation/resolution/update date to be changed. They are set by JIRA. It is a royal pain for situations like this.

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 Thursday in Marketplace Apps

Tips on how to choose the best estimation method for your planning

Planning and grooming sessions all come with their own sets of rules. Team members meet to estimate stories or other work items, all according to an agreed-upon process. And with every session comes ...

68 views 0 11
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