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

Error "unexpected end of file" while importing a CSV-file

Dimce Tumbov

Hi there,

I have got an error when trying to import a CSV-file with 1673 lines. The complete error message:

"unexpected end of file while reading quoted column beginning on line 1672 and ending on line 1673"

Another test importing the first 10-20 lines works perfectly.

Field separator: TAB

File size: 370 KB

Number of fields: 10

Any ideas?

Thanks in advance.

Dimce

Accepted answers

mrcrandell.sw

what is on line 1672 and 1673?

All comments

mrcrandell.sw

what is on line 1672 and 1673?

Dimce Tumbov

Hi Stephen,

these are two last lines. This is the content:

2095 Import Tool 8.4 Import Tool H 8.4.3 Ablauf des Importvorgangs -> 8.4.48.4.4 Verwendete Logik bei der Übername der Daten -> 8.4.58.4.4 Verwendete Logik bei der Übername der Daten:"dass sie keine doppelte Einträge" -> "dass Sie keine doppelte Einträge" 1 2 Open
2099 Rechnung Marcus Siegel, Wartung R Praten na 11.01.2019 23.02.2019 1 2 Closed

and once again as a screenshot:

The LF-end of line was also present in the file where it worked but only with 10 lines inside.

Cheers,

Dimce

mrcrandell.sw

@Dimce Tumbov On line 1673 it looks like that the "tab" between 2019 and the 1 is not the a full tab from the screenshot. The system might be having issues with the tabs. I would suggest switching the delimiter to a comma and put long text fields in double quotes.

Have you tested just the last 10 lines of the CSV? or maybe the middle 10-20 lines?

Try switching the last 10 lines of the CSV to use commas as the delimiter and see if the error is still generated.

Dimce Tumbov

Hi Stephen, I did several tests with double quotes and comma as delimiter. The common behaviour for all tests is the whole file can not be imported.

Last 10 lines or lines from the middle of the file always worked.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud