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
Thanks in advance.
these are two last lines. This is the content:
2095 Import Tool 8.4 Import Tool H 8.4.3 Ablauf des Importvorgangs -> 184.108.40.206.4 Verwendete Logik bei der Übername der Daten -> 220.127.116.11.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.
@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.
Does the full import work if you remove the last 2 lines? If so, I would suggest just removing those 2 lines and manually creating them.
For those 2 lines, do you have tabs/commas to represent all the columns? You specify that the are 10 fields. From you screenshot and provided data for the 2 lines with issues, I don't see where all 10 columns are represented. Can you provide those two lines with the double quotes and delimited by commas?
No it doesn't. The thing is, the same error appears, indicatintg the last two lines:
"unexpected end of file while reading quoted column beginning on line 1648 and ending on line 1649"
If it is of interes, at the first screen of the import-task, there is a warning message:
"The uploaded CSV file contains non-ASCII characters. Make sure you have the correct encoding." (free translation from German)
Here are the last two lines as requested:
2081,Support,"Wiedenmann-Seile GmbH, E-Mail am 16.10.18",B,"C:\APPS\CONMAN_DITU\Support\2018\1016\Wiedenmann-Seile GmbH\contractLösung:Option "E-Mail Versand beim Programmstart" abschalten",08.12.2018,1,2,,Closed
2083,Web-Hosting,"Fehlermeldung "Invalid Token"Auf dem PC von Fr. Wolf:1. Anmeldemaske - ok2. Geburtstags-Tool - ok3. Nach dem Schließen des Geburtstags-Tools kommt Fehlermeldung "Invalid Token"Auf dem THOR-Server:Programmstart funktioniert",W,"Fehlermeldung "Invalid Token"Auf dem PC von Fr. Wolf:1. Anmeldemaske - ok2. Geburtstags-Tool - ok3. Nach dem Schließen des Geburtstags-Tools kommt Fehlermeldung "Invalid Token"Auf dem THOR-Server:Programmstart funktioniert einwandfreiLösung:Option "E-Mail Versand beim Programmstart" abschalten26.10.2018:Wiedenmann-Seile GmbH, Fr. Wolf",27.10.2018,1,2,,Closed
For the ASCII error, you need to comb through the CSV and remove those. It will cause issues but, it shouldn't cause a complete failure.
As for the last 2 lines.
I copied them to NotePadd++ and saved as CSV. Then I opened the file in excel
Double check these two items and see if that solves the issue.
Remember that time you realized it was possible to refresh your Jira data in Google sheets with just one click? What if we told you that you can now get the latest data with no clicks at all?! Zero! ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events