MintJoomlaMintJoomla

Error when trying to import csv "Error decoding JSON data"

Question Question | Reviewed Reviewed | Cobalt 8 | Просмотров: 540 | Комментарии: 3 | В закладках: 0 | Следят: 9

Xtream VIP
Total posts: 129
03 Апр 2019 21:21

Hello Maybe someone have the same problem with import of csv file? Import process stops with error "0 Error decoding JSON data: Control character error, possibly incorrectly encoded"

Joomla 3.9.4 Cobalt 8.762 PHP 7.2.16

Последние изменения: 05 Апр 2019

Цитата

Sergey
Total posts: 13,748
04 Апр 2019 03:58

How big is the file?

Цитата

Xtream VIP
Total posts: 129
04 Апр 2019 17:47

Hello First file was 2.81mb. Contain 213 rows and 46 columns. After your answer I start experiments with file size and problem is not with size. Problem is with data in row 41, namely, with 2 columns in which are text in Finnish and Norwegian. After clean data in this 2 problem columns I can import this row without problem. Can it be conflict with some special letters of Finnish and Norvegian language? In attachment is csv file with this problem line file. Problem text are in columns "Apraksts FIN" and "Apraksts NOR". For me text looks normal, as other, which was imported before line 41. export-ugunsaizsardziba-2-p1

Цитата

Sergey
Total posts: 13,748
05 Апр 2019 06:34

Your file is not formated properly. If you open it in Excel or in text editor. First line is headers. But there is not new line after head line and data start right after it. Other rows have new lines in it with is not allowed. I mean there are too many errors. Just make your file nice format.

How do you get that file?

Работает на Cobalt