importX icon indicating copy to clipboard operation
importX copied to clipboard

FYI - File Import Error

Open nicboyde opened this issue 13 years ago • 1 comments

"Element count do not match. Please check for correct syntax on line 220"

Kept getting this one: Line 220 didn't exist: the last recorde in the file was 219 - not counting the title line. Solved by copying entire csv into clipboard and pasting into manual import box. I need to try to create a csv file without a final empty line - if that is the problem.

Since tested - yes, original input file created by Excel (or Calc) came with an empty last line. Edited this blank line out with Notepad++, file then accepted by ImportX.

This is a head's up for newcomers to the package - and perhaps worthy of including in the documentation.


Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

nicboyde avatar Jan 13 '12 06:01 nicboyde

Had the same problem but removing the last line did not fix it.
I've spent a lot of time reviewing my csv file thinking that the problem was there. It wasn't in the file. The issue is with ImportX.

Even the simple test file like this:

parent;pagetitle;longtitle;menutitle 20;test;test;test

resulted in "Element count do not match ...." error. It just would not import a csv file. Copying and pasting the same into the text box worked without any issues. There's a problem with reading from file.

KirilOkun avatar Jul 24 '14 13:07 KirilOkun