Error displaying record: Inconsistent num of fields, header: 19, this line: 2

Closed

Import WP Updated 2 years ago 3 Replies

Konstantin asked 2 years ago on January 22, 2023 at 11:52 am

During import, in the “File Settings” tab, the error “Error displaying record: Inconsistent num of fields, header: 19, this line: 2” appears. What should I do? Help.

J

James replied Support Agent

2 years ago on January 22, 2023 at 12:19 pm

Hi Konstantin,

This error appears when the csv file does not have the same number of columns on each row.

I woudl recommend re attaching the file to the importer to see if the error goes away?

If it does not, could you please attach the csv file you are having issues with so i can have a futher look.

James

KC

Konstantin replied

2 years ago on January 22, 2023 at 12:28 pm

Thank you! The point is that this is not a file, but a Remote Url

J

James replied Support Agent

2 years ago on January 22, 2023 at 12:40 pm

It suggests the file downloaded from the remote url is not formatted correctly.

The best way to see what is going on is to enable debug mode (Go to settings / Tools > "Enable debug mode") , and click on importer "1. Select file" tab, view the existing files option and you should see the full path to the downloaded file, then access your server via ftp/ssh and view the file to confirm the contents of the file are a valid csv / xml file.