Challenges while importing/ exporting issues in csv

[Pooja]

Hi all,
What are the challenges while importing ang exporting csv file in jira service desk.
Kindly suggest me
Thanks in advance

Regards,
Pooja

[Burak Kocak]

Biggest challanges while exporting are summary and the descritions of the issues. If there is comma or newline or copy pasted text entered there will be a problem to seperate values. Also UTF-8 coding is a problem too. In my instance if there is text with  "ğüşIöç" it will needs special import while using office tools.  

[Petter Gonçalves]

Hello Pooja,

Actually, there are not many challenges to face while import issues on CSV.

The CSV file format is very intuitive, where you will place all the name of the fields in the first row and it's respective value in the second row, always using the comma to separate the fields and its values. E.g:

Assignee, reporter, Status, due date
Petterson, Pooja, In progress, 10/dec/2018

Also, if the field you are importing can receive multiple values (Comments, for example) you can configure it like this:

Assignee, reporter, Status, due date, comment, comment
Petterson, Pooja, In progress, 10/dec/2018, testing comment 1, testing comment 2

That being said, there are no mysteries to configure the file.

To finally import the CSV file, you can navigate to JIRA Settings > System > External system import or simply type GG > External System Import

If you have any questions on how you can map any custom fields in your JIRA, you can perform a simple Export in CSV, so you will generate a template that you can use to properly understand how you can map it. 

To perform a simple export in CSV, navigate to your issue navigator > Click on the Download option > Select Export Excel CSV (All fields):

[Pooja]

Hi @Petter Gonçalves,

Thank you for the suggestion.

Is there a limitation for the csv import/export like attachments or any type of custom fields or any plugin feature?

Regards,

Pooja

[Petter Gonçalves]

Hello Pooja,

You can add attachments to issues created from your CSV file. To do this, you will need to upload the files to a repository (Dropbox, for example) and specify the URL of your attachment in an Attachments column within your CSV file.

I''m also not aware of any custom field that can not be imported/exported using CSV, but it can be possible since there are uncountables plugins developed by third-party developers that provide more functionality and new kind of fields, however, I believe that all system and custom fields native of JIRA can be exported.

You can take a look at the documentation below for more details:

- Importing data from CSV