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; } } }

Cannot import CSV files

GilK

Hi,

We're going to purchase your product, so I'm now working on importing some issues into JIRA.

I've already done that few times ago.

Currently, when I try to import csv file (attached) via configuration template (attached), I get the following warning (see screenshot):

Failed to read CSV file, you may decide to ignore the error: java.io.IOException: Malformed CSV stream. Missing , near offset 212 after field 0 on line 2719

If I ignore the warning and try to import I get an exception.

Please help.

Thanks,

Janiv/

Accepted answers

Jerome Chadee

yes, I did Michael... The problem actaully had to do with my cvs file. The decription column in my clearquest database use quotes "" in some instances. A replace was done to fix this accordingly, and the import into JIRA worked perfectly. Some characters in your csv file may be used as a delimiter for the JIRA import tool. I will suggest opening this file in some text editor of your choice to find out which character is causing the issue and make the change accordingly.

Hope this helps.

All comments

Jerome Chadee

I get the same error with a different offset and line number. Currently looking for a solution. Will update if I find anything.

BTW: for the QA folks, note the "ingore" spelling.

Michael I.

Hi, Jerome.

Did you find a solution?

Jerome Chadee

Hope this helps.

Shriya Chhajed

Hi,

I am facing the same issue, but when i open the file in some text editor, i cannot find the missing or extra double quotes. And as a delimiter i have used comma(,) which is causing no trouble i guess.

Can you help please?

Thanks and Regards

Shriya Chhajed

Welcome!

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

Quick Links

Find more posts tagged with

jira