Import not working on Dolibarr 14.0.2

I am not able to import say product items on version 114.0.2 because the functions are greyed out.
Can anyone please support

Hello,

Where Dolibarr is installed ? What is the PHP version ?

Thanks for your assistance.
it is installed on windows and php\s version is 8

:warning: Dolibarr is compatible PHP V7.4 Maximum

1 Like

Thanks a lot. You saved me lots of troubles with this info.

I did changed to php 7.4 with same outcome. Any further assistance would be appreciated

Hi,

Could you check the apache logs ?

Good evening Ksar,

lease find below the logs as i an not nota bale to attach because i still restricted as a new user

::1 - - [30/Sep/2021:19:17:45 +0100] "GET /dolibarr/core/js/lib_head.js.php?lang=en_US&layout=classic&version=14.0.2 HTTP/1.1" 200 32335
::1 - - [30/Sep/2021:19:17:45 +0100] "GET /dolibarr/viewimage.php?cache=1&modulepart=mycompany&file=logos%2Fthumbs%2Fmarismart+logo_small.png HTTP/1.1" 200 10127
::1 - - [30/Sep/2021:19:17:48 +0100] "GET /dolibarr/theme/common/fontawesome-5/webfonts/fa-solid-900.woff2 HTTP/1.1" 200 79444
::1 - - [30/Sep/2021:19:17:48 +0100] "GET /dolibarr/theme/eldy/manifest.json.php HTTP/1.1" 200 557
::1 - - [30/Sep/2021:19:17:51 +0100] "GET /dolibarr/public/theme/common/user_anonymous.png HTTP/1.1" 200 15184
::1 - - [30/Sep/2021:19:17:51 +0100] "GET /dolibarr/theme/common/flags/us.png HTTP/1.1" 200 385
::1 - - [30/Sep/2021:19:17:50 +0100] "POST /dolibarr/index.php?mainmenu=home HTTP/1.1" 200 112102
::1 - - [30/Sep/2021:19:17:55 +0100] "GET /dolibarr/theme/eldy/img/refresh.png HTTP/1.1" 200 205
::1 - - [30/Sep/2021:19:17:51 +0100] "GET /dolibarr/theme/eldy/style.css.php?lang=en_US&theme=eldy&userid=1&entity=1&layout=classic&version=14.0.2&revision=47&dol_hide_topmenu=&dol_hide_leftmenu=&dol_optimize_smallscreen=&dol_no_mouse_hover=&dol_use_jmobile= HTTP/1.1" 200 224315
::1 - - [30/Sep/2021:19:17:55 +0100] "GET /dolibarr/core/js/lib_foot.js.php?lang=en_US&layout=classic&version=14.0.2 HTTP/1.1" 200 7748
::1 - - [30/Sep/2021:19:17:55 +0100] "GET /dolibarr/theme/common/fontawesome-5/webfonts/fa-regular-400.woff2 HTTP/1.1" 200 13584
::1 - - [30/Sep/2021:19:18:13 +0100] "GET /dolibarr/core/tools.php?mainmenu=tools&leftmenu= HTTP/1.1" 200 35136
::1 - - [30/Sep/2021:19:18:13 +0100] "GET /dolibarr/theme/eldy/style.css.php?lang=en_US&theme=eldy&userid=1&entity=1&layout=classic&version=14.0.2&revision=47 HTTP/1.1" 200 224315
::1 - - [30/Sep/2021:19:18:13 +0100] "GET /dolibarr/theme/eldy/img/logo_setup.svg HTTP/1.1" 200 31584
::1 - - [30/Sep/2021:19:18:15 +0100] "GET /dolibarr/imports/import.php?leftmenu=import HTTP/1.1" 200 46036
::1 - - [30/Sep/2021:19:18:20 +0100] "GET /dolibarr/imports/import.php?step=2&datatoimport=produit_1&excludefirstline=1&separator=%2C&enclosure=%22 HTTP/1.1" 200 25911
::1 - - [30/Sep/2021:19:19:13 +0100] "-" 408 -

error log

[Thu Sep 30 13:57:33.131000 2021] [mpm_winnt:notice] [pid 3840:tid 632] AH00455: Apache/2.4.49 (Win64) PHP/7.4.24 configured -- resuming normal operations
[Thu Sep 30 13:57:33.131000 2021] [mpm_winnt:notice] [pid 3840:tid 632] AH00456: Apache Lounge VS16 Server built: Sep 12 2021 10:23:43
[Thu Sep 30 13:57:33.131000 2021] [core:notice] [pid 3840:tid 632] AH00094: Command line: 'C:\\Apache24\\bin\\httpd.exe -d C:/Apache24'
[Thu Sep 30 13:57:33.146624 2021] [mpm_winnt:notice] [pid 3840:tid 632] AH00418: Parent: Created child process 4648
[Thu Sep 30 13:57:34.215318 2021] [mpm_winnt:notice] [pid 4648:tid 644] AH00354: Child: Starting 64 worker threads.
[Thu Sep 30 19:18:21.609754 2021] [php7:error] [pid 4648:tid 1104] [client ::1:8581] PHP Fatal error:  Uncaught Error: Call to undefined function PhpOffice\\PhpSpreadsheet\\Shared\\mb_strlen() in C:\\Apache24\\htdocs\\dolibarr\\includes\\phpoffice\\phpspreadsheet\\src\\PhpSpreadsheet\\Shared\\StringHelper.php:469\nStack trace:\n#0 C:\\Apache24\\htdocs\\dolibarr\\includes\\phpoffice\\phpspreadsheet\\src\\PhpSpreadsheet\\Worksheet\\Worksheet.php(469): PhpOffice\\PhpSpreadsheet\\Shared\\StringHelper::countCharacters()\n#1 C:\\Apache24\\htdocs\\dolibarr\\includes\\phpoffice\\phpspreadsheet\\src\\PhpSpreadsheet\\Worksheet\\Worksheet.php(855): PhpOffice\\PhpSpreadsheet\\Worksheet\\Worksheet::checkSheetTitle()\n#2 C:\\Apache24\\htdocs\\dolibarr\\includes\\phpoffice\\phpspreadsheet\\src\\PhpSpreadsheet\\Worksheet\\Worksheet.php(351): PhpOffice\\PhpSpreadsheet\\Worksheet\\Worksheet->setTitle()\n#3 C:\\Apache24\\htdocs\\dolibarr\\includes\\phpoffice\\phpspreadsheet\\src\\PhpSpreadsheet\\Spreadsheet.php(476): PhpOffice\\PhpSpreadsheet\\Worksheet\\Worksheet->__construct()\n#4 C:\\Apache24\\htdocs\\dolibarr\\core\\modules\\import\\import_xlsx.modules.php(118): PhpOffice\\PhpSpreadsheet\\Spreadsheet-> in C:\\Apache24\\htdocs\\dolibarr\\includes\\phpoffice\\phpspreadsheet\\src\\PhpSpreadsheet\\Shared\\StringHelper.php on line 469, referer: http://localhost/dolibarr/imports/import.php?leftmenu=import

Hello,

Your installation doesn’t have the PHP extension mbstring

Please install it.