# HTTP Error 500 when trying to import a new category listing in tools module

**URL:** <https://www.dolibarr.org/forum/t/http-error-500-when-trying-to-import-a-new-category-listing-in-tools-module/19636>\
**Category:** Other native modules\
**Tags:** v12\
**Created:** [October 10, 2020, 11:11pm UTC](https://www.dolibarr.org/forum/t/http-error-500-when-trying-to-import-a-new-category-listing-in-tools-module/19636 "2020-10-10T23:11:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![leonm2](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/l/d2c977/32.png) [@leonm2](https://www.dolibarr.org/forum/u/leonm2)\
**Post date:** [October 10, 2020, 11:11pm UTC](https://www.dolibarr.org/forum/t/http-error-500-when-trying-to-import-a-new-category-listing-in-tools-module/19636/1 "2020-10-10T23:11:05Z")

</div>

Hello community,

I am writing to you because I am having problems in versions 12.0.x to load new category listings in the tools module for new import. It allows me to load the file up to step 2 but when in step 3 I select the file to import I get the HTTP error 500 message and it won’t let me do anything else.

Thanks in advance for your help.

I look forward to your comments or possible solutions.

Regards,

Leonardo M.

 ![Error_500_importacion](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/f/f81b7816504d497360c27a3599c137e42165fc16.png)

---

<div class="post-metadata">

**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\
**Post date:** [October 11, 2020, 12:24pm UTC](https://www.dolibarr.org/forum/t/http-error-500-when-trying-to-import-a-new-category-listing-in-tools-module/19636/2 "2020-10-11T12:24:46Z")

</div>

Hi,

Error 500 means PHP error

Check your hosting logs

---

<div class="post-metadata">

**Author:** ![leonm2](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/l/d2c977/32.png) [@leonm2](https://www.dolibarr.org/forum/u/leonm2)\
**Post date:** [October 12, 2020, 4:55am UTC](https://www.dolibarr.org/forum/t/http-error-500-when-trying-to-import-a-new-category-listing-in-tools-module/19636/3 "2020-10-12T04:55:36Z")

</div>

Hi ksar,

This is the log error of the moment when I tried to import the Category listing from an Excel file:

```
[11-Oct-2020 23:42:08 America/Bogota] PHP Fatal error: Uncaught PHPExcel_Reader_Exception: Could not open /home/ferreter1/dolibarrdata_pruebas/import/temp/20201010163553-Ejemplo_de_archivo_importación_categorie_1.xlsx for reading! File does not exist. in /home/ferreter1/public_html/dolibarr_pruebas/includes/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel2007.php:348
Stack trace:
#0 /home/ferreter1/public_html/dolibarr_pruebas/core/modules/import/import_xlsx.modules.php(248): PHPExcel_Reader_Excel2007->load('/home/ferreter1...')
#1 /home/ferreter1/public_html/dolibarr_pruebas/imports/import.php(708): ImportXlsx->import_open_file('/home/ferreter1...', Object(Translate))
#2 {main}
  thrown in /home/ferreter1/public_html/dolibarr_pruebas/includes/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel2007.php on line 348

```

This error only occurs in the Category listings import.  
I have imported product listings and it works fine.

Regards,

---

<div class="post-metadata">

**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\
**Post date:** [October 12, 2020, 8:28am UTC](https://www.dolibarr.org/forum/t/http-error-500-when-trying-to-import-a-new-category-listing-in-tools-module/19636/4 "2020-10-12T08:28:00Z")

</div>

Hi,

There is two possibilities :

1. You have a problem with the PHP configuration for temporary files
2. There is some special characters on you file name that cause touble `20201010163553-Ejemplo_de_archivo_importación_categorie_1.xlsx` like `ó`

---

<div class="post-metadata">

**Author:** ![leonm2](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/l/d2c977/32.png) [@leonm2](https://www.dolibarr.org/forum/u/leonm2)\
**Post date:** [October 12, 2020, 8:58am UTC](https://www.dolibarr.org/forum/t/http-error-500-when-trying-to-import-a-new-category-listing-in-tools-module/19636/5 "2020-10-12T08:58:38Z")

</div>

Thanks ksar,

The problem is the special character in the name of the file. I have changed the name and it works. The problem is solved.

I hadn’t known that restriction because it is the standard name of the example file that is included into Dolibarr when is configured in Spanish.

Regards,

---

<div class="post-metadata">

**Author:** ![mikeduke111](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/7ba0ec/32.png) [@mikeduke111](https://www.dolibarr.org/forum/u/mikeduke111)\
**Post date:** [October 12, 2020, 10:21am UTC](https://www.dolibarr.org/forum/t/http-error-500-when-trying-to-import-a-new-category-listing-in-tools-module/19636/6 "2020-10-12T10:21:47Z")

</div>

The HyperText Transfer Protocol (HTTP) 500 Internal Server Error server error response code indicates that the server encountered an unexpected condition that prevented it from fulfilling the request.

This error response is a generic “catch-all” response. Usually, this indicates the server cannot find a better 5xx error code to response. Sometimes, server administrators log error responses like the 500 status code with more details about the request to prevent the error from happening again in the future.