nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Problem facing with CSV file import to JIRA...

Ram Prayaga

Hi,

I am trying to import data from CSV file to JIRA, During the 3 rd step I have encountered with an error shown as below :

Invalid project key PRJA-1: You must specify a unique project key, at least 2 characters long, containing only uppercase letters

And I have changed the key with some new values & tried to import, This time in the first step only I have encountered with error :

java.io.IOException: Malformed CSV stream. Missing [,] near offset 9 after field 0 on line 1

please help me on this.

Thanks in Advance...

Accepted answers

Jobin Kuruvilla [Adaptavist]

Your CSV is not well formatted it seems? Are you able to open it in Excel?

All comments

Jobin Kuruvilla [Adaptavist]

Your CSV is not well formatted it seems? Are you able to open it in Excel?

Ram Prayaga

Thanks for the Response Jobin. And Yes I am able to open it in Excel. By the way I am using JIRA 4.4.3 working on Windows7...

Wojciech Seliga

Could you please paste here first 2 lines of your CSV file?

Another question: which version of JIRA Importers Plugin do you use with JIRA instance? It's probably 3.5.x, but recently we were shuffling with CSV parser libraries used, so this information is quite important.

Ram Prayaga

Hi Wojciech Seliga, thanks for your response. Now it is working fine for me. The 1st issue that I have mentioned is due to invalid format of CSV file.

But for the IOException mentioned above I am still getting that, if I do any modification to the field of the CSV file which I have already used and tried to use again...

I am using JIRA Importers Plugin 3.5.3...

Nic Brough -Adaptavist-

As Wojciech says, we need to see your data to tell you where the problem is? The error message is telling you that the data is incorrectly formatted, so we need to see it to be able to point you at the error.

Ram Prayaga

Project	Key	Summary	Issue Type
ProjectA	PJA	Summary1	Requirement
ProjectA	PJA	Summary2	Defect
ProjectA	PJA	Summary3	Task

Here I am providing my CSV file data...

Nic Brough -Adaptavist-

That's not CSV - could you give us the plain text CSV, not just formatted data? We need to see exactly what Jira is reading from the file, not what you think it should be reading.

Ram Prayaga

Thanks Nic, It is working now. The file is not formatted correctly the fields are seperated by a semicolon instead of comma.

Fernando Horn

I'm having the same problem. This is my two first lines:

Project

Key

Summary

Priority

Created

Component/s

Description

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

csv

import