Hello.
Has anyone having trouble importing files to table?PHP Version - 7.0.33
PHPMaker Version - Last one
Files tested - xls, csvIn advanced options, they are both allowedDo I need to have a column for each field or can I just have an excel file with the columns I want and that match the table?
Please read “Import Data” topic from PHPMaker Help menu for more info and example.
I’ve tried with a smaller table, with only the auto-increment field and a description, to rule out that It wasn’t the fact that I didn’t had all columns for the table in excel, that was giving me the error.
Tried without the column for the primary key (auto-increment), with that column empty and with that column with data… It says briefly upload complete or successful (something like that) and returns the mentioned error.This is the error in my server log when I try to import:
Parse error: syntax error, unexpected ‘=’ in C:\Inetpub\vhosts\ªªªªªªªªªªªª\httpdocs\vendor\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Reader\Xlsx.php on line 1332Any thoughts?
I’ve solved it by changing php version to 7.1. I’ve checked composer.json in phpspreadsheet extension and saw it needed a php more recent version.
Excel files import correctly, csv still giving me errors but will test it further… 