Error While Importing CSV

Wappler General Need Help
1

While trying to import a CSV file to a MySQL Database, I cannot locate the cause of the following error. Anyone have an idea of how to decipher this: Both parameters should have an equal number of elements?

What parameters need to have the same number of elements?

Thanks for any assistance.

{
“code”: 0,
“file”: “/home/blaxstud/public_html/practice/dmxConnectLib/modules/import.php”,
“line”: 42,
“message”: “array_combine(): Both parameters should have an equal number of elements”,
“trace”: “#0 [internal function]: exception_error_handler(2, ‘array_combine()…’, ‘/home/blaxstud/…’, 42, Array)\n#1 /home/blaxstud/public_html/practice/dmxConnectLib/modules/import.php(42): array_combine(Array, Array)\n#2 /home/blaxstud/public_html/practice/dmxConnectLib/lib/App.php(195): modules\import->csv(Object(stdClass), ‘csv_import’)\n#3 /home/blaxstud/public_html/practice/dmxConnectLib/lib/App.php(159): lib\App->execSteps(Object(stdClass))\n#4 /home/blaxstud/public_html/practice/dmxConnectLib/lib/App.php(127): lib\App->execSteps(Array)\n#5 /home/blaxstud/public_html/practice/dmxConnectLib/lib/App.php(116): lib\App->exec(Object(stdClass), false)\n#6 /home/blaxstud/public_html/practice/dmxConnectLib/lib/App.php(94): lib\App->exec(Object(stdClass))\n#7 /home/blaxstud/public_html/practice/dmxConnect/api/Imports/csv_import.php(579): lib\App->define(’{\n “meta”: {\n …’)\n#8 {main}”
}

2

I think this is probably because of errors in the CSV format - eg some records have the wrong number of fields (or seem to from the point of view of the import process), because of non-escaped quotation marks or invalid characters etc.

If I have this type of problem, I’ll import the file using a program which will give a detailed log file. (I use Navicat, but I’m sure there are a number of suitable alternatives.)

Another approach is to chop the file in half and import the halves separately, and continue the process (splitting the files/importing) until you track down the record(s) causing the failure.

3

Thank you vey much Tom!