Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To create multiple issues, you need to use the import feature of JExcel.

To do the import, you need to use a Notepad or an Excel.

When wanting to import there are 3 mandatory columns you need to have in Excel:

  • Summary
  • Issue Type
  • Parent Issue Key (Jexcel)
  • Project
Panel
borderColororange
borderStylesolid

Please note!

The Parent Issue Key (Jexcel) is not equivalent with the default Jira Parent Issue Key field! Please, use the Parent Issue Key (Jexcel) column int the import!


After filling out the columns, select the cells you want to import and press Ctrl+C:

Image Removed
Image Added

There are 3 ways to copy them into JExcel:

press
  1. Press Ctrl+M then Ctrl+V in JExcel
or open
  1. Open Workbook menu
(1)
  1. and clicking on
import (2)
  1.  Import... option and press Ctrl+V
or
  1. Or just press Ctrl+V

 

Image Removed 
Image Added

If you choose the way 1 or 2,  you will get a dialog like this with some useful information on it

 

Image Removed 

When you see this dialog,

  • On the top left corner you can find a link to the documentation (Tutorial)
  • A 3-step visual guide presenting the import steps
  • On the bottom of the screen you can see the colour guide of the import process 

To insert your data click in the Paste here cell and press Ctrl+V to preview the import.

Image Added

If there is any problem with the import, you will see the problematic cells

colored red (Please see the picture below)

coloured red. 

If you hover over the red cells, there will be an error message of it, so you will be able to see the problem

(Please see the picture below)

.

Image Removed
Image Added

To fix the problem, go back to your Excel file

,

or change the

problematic values and come back to this screen

value right in the import screen. Just double click in the cell you want to edit and hit Enter when you finished.

(Please make sure that you paste values with correct column names.)


After fixing the problems, you will see the preview without any red cells and you can click on

"

 Create

" (1)

.

 


Image Added

Image Removed






And violá, the issues are created:

Image Removed






Image Added


Panel
borderColororange
borderStylesolid

If you choose the way 3, you have to pay attention to an important thing!

The cells will be imported right where you stand!


Panel
borderColornavy
borderStylesolid

Pro tipp:

The easiest way to import issues is to copy from JExcel to Excel, change values and then to copy back to JExcel.

This will avoid you to make a mistake.