Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with external CSV import

Israel Dvorsky March 22, 2014

I am trying to import issues from a CSV and i get the following message:

java.io.IOException: Malformed CSV stream. Missing ["] near offset 62 after field 0 on line 169

I am using JIRA 5.0.4

See CSV attached

Thanks! ()

3 answers

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 22, 2014

The error message you're getting really is telling you what is wrong - there is at least one " mark in your csv that doesn't match up, and is breaking the format.

You'll need to escape the extra " marks in order to import them. I think it's just using "" instead of "

Israel Dvorsky March 23, 2014

How can I find it?

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 23, 2014

The error message tells you what line is failing, although the character reference might not be that helpful - it's often "the next thing I couldn't read" instead of "where you've got something wrong"

0 votes
Israel Dvorsky March 22, 2014

I can't attach a CSV file

0 votes
Nadir MEZIANI
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 22, 2014

Hi,

there is no file attached.

Suggest an answer

Log in or Sign up to answer
TAGS
Atlassian, Team '25 Europe, Atlassian conference, AI-powered teamwork, Atlassian events, keynote speakers, Barcelona tech conference, Atlassian Williams Racing, Carlos Sainz, Jenson Button, Mike Cannon-Brookes, Anu Bharadwaj, Atlassian Rovo

Atlassian Williams Racing is coming to Team '25 Europe 🏎️

Discover the teamwork and precision behind success on and off the track. See how this high-performing team makes the impossible possible. Be one of the first 100 customers to register for a chance to win 2 tickets to an Atlassian Williams 2026 race.

Register now
AUG Leaders

Atlassian Community Events