Community
Q&A
Jira
Questions
Problem with external CSV import

Problem with external CSV import

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes

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 "

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

How can I find it?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

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"

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

0 votes

I can't attach a CSV file

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Reply

0 votes

Hi,

there is no file attached.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Reply

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Was this helpful?

Thanks!

TAGS

Community showcase