Not importing data from spreadsheets; sometimes take a lot and other times I got error 500
Details:
Hello, I tried to use the excel importer with a file that have a lot of columns (21 or 22 columns, but not exceed 2MB). The document has almost 900 files, and it is well configured. If I pickup like 20 files, It have more chance to upload the information, but It takes too much time.
If I pick for example like 50 files, the document will not upload and will remain with Error 500, and must restart the server.
I am having a lot of issues, I really want to use your importer since I need to upload bigger documents (like 20,000 files) but I will never finish if I need to upload just picking up max 20 files.
If If I try to upload a document with less columns, it will upload fine.
I searched in the logs and found this:
Deprecated function: trim(): Passing null to parameter #1 ($string) of type string is deprecated en Drupal\excel_importer\Form\ExcelImporterForm->isRowEmpty() (línea 331 de /var/www/rhsd/web/modules/contrib/excel_importer/src/Form/ExcelImporterForm.php)
#0 /var/www/rhsd/web/core/includes/bootstrap.inc(347): _drupal_error_handler_real()
#1 [internal function]: _drupal_error_handler()
#2 /var/www/rhsd/web/modules/contrib/excel_importer/src/Form/ExcelImporterForm.php(331): trim()
#3 /var/www/rhsd/web/modules/contrib/excel_importer/src/Form/ExcelImporterForm.php(129): Drupal\excel_importer\Form\ExcelImporterForm->isRowEmpty()
#4 [internal function]: Drupal\excel_importer\Form\ExcelImporterForm->submitForm()
I read that I need to install this dependency: phpoffice/phpspreadsheet but I haven't installed it, is that the problem?
Any other information you need, please let me know that I wil provide.
Please help!
Jaafar Abuzid
Active
1.1
User interface
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Hi Jaafar,
Apologies for the late reply.
If you have used composer to install the module then the dependencies will be installed automatically.
The error message you shared is a simple deprecation warning. If you're getting a 500 Error then you should probably look at your web server logs (Apache or Nginx) - I suspect you might need to update some of the server settings.
I'm willing to help out if you still want to explore this.