Project

General

Profile

Bug #8485

Error importando usuarios archivo CSV a Chamilo 1.11.0

Added by Alejandro Mejia about 4 years ago. Updated about 4 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
03/11/2016
Due date:
% Done:

0%

Estimated time:
Complexity:
Normal
SCRUM pts - complexity:
?

Description

Cordial Saludo,

En la funcion deimportar usuarios a la version 1.11.0 se presenta un error 500 en el archivo

/main/admin/user_import.php

Registro de errores de la plataforma:

2016/11/03 22:52:27 [notice] 1262#0: *73 "^/certificates/$" does not match "/main/admin/user_import.php", client: 192.168.2.1, server: chamilo.aulal.com, request: "POST /main/admin/user_import.php HTTP/1.1", host: "chamilo.aulal.com", referrer: "http://chamilo.aulal.com/main/admin/user_import.php"
2016/11/03 22:52:27 [notice] 1262#0: *73 "^/courses/([^/]+)/$" does not match "/main/admin/user_import.php", client: 192.168.2.1, server: chamilo.aulal.com, request: "POST /main/admin/user_import.php HTTP/1.1", host: "chamilo.aulal.com", referrer: "http://chamilo.aulal.com/main/admin/user_import.php"
2016/11/03 22:52:27 [notice] 1262#0: *73 "^/courses/([^/]+)/index.php$" does not match "/main/admin/user_import.php", client: 192.168.2.1, server: chamilo.aulal.com, request: "POST /main/admin/user_import.php HTTP/1.1", host: "chamilo.aulal.com", referrer: "http://chamilo.aulal.com/main/admin/user_import.php"
2016/11/03 22:52:27 [notice] 1262#0: *73 "^/session/([^/]+)/about/?$" does not match "/main/admin/user_import.php", client: 192.168.2.1, server: chamilo.aulal.com, request: "POST /main/admin/user_import.php HTTP/1.1", host: "chamilo.aulal.com", referrer: "http://chamilo.aulal.com/main/admin/user_import.php"
2016/11/03 22:52:27 [notice] 1262#0: *73 "^/badge/(\d{1,})/user/(\d{1,})$" does not match "/main/admin/user_import.php", client: 192.168.2.1, server: chamilo.aulal.com, request: "POST /main/admin/user_import.php HTTP/1.1", host: "chamilo.aulal.com", referrer: "http://chamilo.aulal.com/main/admin/user_import.php"
2016/11/03 22:52:27 [warn] 1262#0: *73 a client request body is buffered to a temporary file /var/lib/nginx/body/0000000002, client: 192.168.2.1, server: chamilo.aulal.com, request: "POST /main/admin/user_import.php HTTP/1.1", host: "chamilo.aulal.com", referrer: "http://chamilo.aulal.com/main/admin/user_import.php"

Registro de Chrome Error 500

General
Request URL:http://chamilo.aulal.com/main/admin/user_import.php
Request Method:POST
Status Code:500 Internal Server Error
Remote Address:192.168.2.29:80

Response Header
Cache-Control:no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Connection:keep-alive
Content-Type:text/html; charset=UTF-8
Date:Thu, 03 Nov 2016 22:52:28 GMT
Expires:Thu, 19 Nov 1981 08:52:00 GMT
Pragma:no-cache
Server:nginx
Transfer-Encoding:chunked
Request Headers
view source

Request Headers
Accept:text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
Accept-Encoding:gzip, deflate
Accept-Language:es,es-419;q=0.8,en;q=0.6
Cache-Control:max-age=0
Connection:keep-alive
Content-Length:14564
Content-Type:multipart/form-data; boundary=----WebKitFormBoundaryCItpunag5BukLaVY
Cookie:ch_sid=cpkfkpkjm41mv387k994sdnqo2; defaultMyCourseView1=0
Host:chamilo.aulal.com
Origin:http://chamilo.aulal.com
Referer:http://chamilo.aulal.com/main/admin/user_import.php
Upgrade-Insecure-Requests:1
User-Agent:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.71 Safari/537.36

Request Payload
------WebKitFormBoundaryCItpunag5BukLaVY
Content-Disposition: form-data; name="import_file"; filename="export_users_2016-07-19_08-40-48.csv"
Content-Type: text/csv

------WebKitFormBoundaryCItpunag5BukLaVY
Content-Disposition: form-data; name="file_type"

csv
------WebKitFormBoundaryCItpunag5BukLaVY
Content-Disposition: form-data; name="sendMail"

0
------WebKitFormBoundaryCItpunag5BukLaVY
Content-Disposition: form-data; name="submit"

------WebKitFormBoundaryCItpunag5BukLaVY
Content-Disposition: form-data; name="_qf__user_import"

------WebKitFormBoundaryCItpunag5BukLaVY
Content-Disposition: form-data; name="formSent"

1
------WebKitFormBoundaryCItpunag5BukLaVY
Content-Disposition: form-data; name="MAX_FILE_SIZE"

134217728
------WebKitFormBoundaryCItpunag5BukLaVY--

El resultado es una pagina en blanco

History

#1

Updated by Julio Montoya about 4 years ago

Try using the portal in "test" mode and copy/paste the error message, after trying again the error.

https://1.11.chamilo.org/main/admin/settings.php?search_field=server_type&submit_button=&_qf__search_settings=&category=search_setting

And please create new tickets here:

https://github.com/chamilo/chamilo-lms/issues

#2

Updated by Alejandro Mejia about 4 years ago

Ticket created at github.

  1. Expected behavior / Resultado esperado / Résultat attendu

After import csv file, existing users on file must be created on Chamilo.

  1. Actual behavior / Resultado real / Résultat réel

csv file did not contain headers (File is unmodified after export it from other Chamilo 1.9.10 )
First two lines...

"49";"Acero Díaz";"Aura";"";"auraacerodiaz";"platform";"5";"AURAACERODIAZ";"";"1";"1";"1";
"1";"Alejandro";"Mejia";"";"admin";"platform";"1";"ADMIN";"xxx";"1";"1";"1";

After click on import users from CSV, Chamillo returns error

Error output on Chamilo in test mode:

Fatal error: Uncaught exception 'Ddeboer\DataImport\Exception\DuplicateHeadersException' with message 'File contains duplicate headers: 1, 1, ' in /var/www/html/chamilo111/vendor/ddeboer/data-import/src/Reader/CsvReader.php:345 Stack trace: #0 /var/www/html/chamilo111/vendor/ddeboer/data-import/src/Reader/CsvReader.php(186): Ddeboer\DataImport\Reader\CsvReader->readHeaderRow(0) #1 /var/www/html/chamilo111/main/inc/lib/import.lib.php(32): Ddeboer\DataImport\Reader\CsvReader->setHeaderRowNumber(0) #2 /var/www/html/chamilo111/main/inc/lib/import.lib.php(60): Import::csv_reader('/tmp/phpJKsmtE') #3 /var/www/html/chamilo111/main/admin/user_import.php(248): Import::csvToArray('/tmp/phpJKsmtE') #4 /var/www/html/chamilo111/main/admin/user_import.php(385): parse_csv_data('/tmp/phpJKsmtE') #5 {main} thrown in /var/www/html/chamilo111/vendor/ddeboer/data-import/src/Reader/CsvReader.php on line 345

If Chamilo is not in Test Mode, returns Error 500

Output in Developers Mode

General
Request URL:http://chamilo.aulal.com/main/admin/user_import.php
Request Method:POST
Status Code:200 OK
Remote Address:192.168.2.29:80
Response Headers
view source
Cache-Control:no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Cache-Control:public
Connection:keep-alive
Content-Encoding:gzip
Content-Type:text/html; charset=UTF-8
Date:Fri, 04 Nov 2016 20:46:44 GMT
Expires:Thu, 19 Nov 1981 08:52:00 GMT
Pragma:no-cache
Server:nginx
Transfer-Encoding:chunked
Request Headers
view source
Accept:text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
Accept-Encoding:gzip, deflate
Accept-Language:es,es-419;q=0.8,en;q=0.6
Cache-Control:max-age=0
Connection:keep-alive
Content-Length:14564
Content-Type:multipart/form-data; boundary=----WebKitFormBoundaryZeXllZGXiz7GyKEV
Cookie:ch_sid=cpkfkpkjm41mv387k994sdnqo2; defaultMyCourseView1=0
Host:chamilo.aulal.com
Origin:http://chamilo.aulal.com
Referer:http://chamilo.aulal.com/main/admin/user_import.php
Upgrade-Insecure-Requests:1
User-Agent:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.71 Safari/537.36
Request Payload
------WebKitFormBoundaryZeXllZGXiz7GyKEV
Content-Disposition: form-data; name="import_file"; filename="export_users_2016-07-19_08-40-48.csv"
Content-Type: text/csv

------WebKitFormBoundaryZeXllZGXiz7GyKEV
Content-Disposition: form-data; name="file_type"

csv
------WebKitFormBoundaryZeXllZGXiz7GyKEV
Content-Disposition: form-data; name="sendMail"

0
------WebKitFormBoundaryZeXllZGXiz7GyKEV
Content-Disposition: form-data; name="submit"

------WebKitFormBoundaryZeXllZGXiz7GyKEV
Content-Disposition: form-data; name="_qf__user_import"

------WebKitFormBoundaryZeXllZGXiz7GyKEV
Content-Disposition: form-data; name="formSent"

1
------WebKitFormBoundaryZeXllZGXiz7GyKEV
Content-Disposition: form-data; name="MAX_FILE_SIZE"

134217728
------WebKitFormBoundaryZeXllZGXiz7GyKEV--

  1. Steps to reproduce / Pasos para reproducir / Étapes pour reproduire

1. Export users from other chamilo version (In this case Chamilo 1.9.10)
2. Open Administration - Import Users from CSV file
3. Click on import

#3

Updated by Yannick Warnier about 4 years ago

Alejandro, por favor reportalo de un solo lado. Igual atendemos ambos (con una ligera preferencia por Github, que será el sistema a futuro), pero reportarlo dos veces causa doble trabajo (y por lo tanto más lentitud para resolver otros problemas reportados).

También mencionar que después de la publicación de 1.11.2, estamos tomando un pequeño descanso así que no vamos a atender muchas solicitudes de la comunidad (como el equipo de BeezNest) en las próximas semanas, ya que hemos dedicado más de 3000 horas a Chamilo solo este año.

Also available in: Atom PDF