News arrow Forum
Home    Contacts
Forum Dolibarr
Welcome, Guest
Please Login or Register.    Lost Password?
export (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: export
#9535
sladame (User)
Expert Boarder
Posts: 117
graphgraph
User Offline Click here to see the profile of this user
Gender: Male mon site (joomla) Location: lyon Birthdate: 1984-05-13
export 2008/07/18 15:11 Karma: 1  
les exports avec le modèle excel ne fonctionne pas pour les tiers si il y en a trop.
actuellement j'ai 3000 tiers enregistrés.
 
Logged Logged  
 
  The administrator has disabled public write access.
#9542
grandoc (User)
Gold Boarder
Posts: 184
graphgraph
User Offline Click here to see the profile of this user
Re:export 2008/07/20 18:53 Karma: 2  
Bonjour
C'est peut être juste un problème de réglage du serveur :
voir le fichier php.ini et vers la ligne 256
remplacer :
memory_limit = 8M ; Maximum amount of memory a script may consume (8M
par un memory_limit > 32M
et vers la ligne 524
upload_max_filesize = 2M
peut être augmenter la taille max à 8M par exemple
@+
 
Logged Logged  
 
J\'aime les sirènes,

j\'aime pas les arrêtes dans le poisson !



Version 2.4-dev

sur serveur Linux 2.6.24.2

Apache/1.3.37 (Unix) mod_gzip/1.3.19.1a PHP/5.1.0 mod_ssl/2.8.28 OpenSSL/0.9.6m

Mysql 4.1.20
  The administrator has disabled public write access.
#9579
sladame (User)
Expert Boarder
Posts: 117
graphgraph
User Offline Click here to see the profile of this user
Gender: Male mon site (joomla) Location: lyon Birthdate: 1984-05-13
Re:export 2008/07/28 10:42 Karma: 1  
j'ai modifié

Code:
memory_limit=320M upload_max_filesize = 50M
comme ça je teste si ça vient de la. mais toujours rien page blanche à la création du excel. de plus même avec 3000 tiers le fichier excel ne devrai pas dépasser une taille de 1.5 MO car pour 400 tiers le fichier fait 150 KO.
 
Logged Logged  
 
  The administrator has disabled public write access.
#9589
raphael_bertrand (User)
Senior Boarder
Posts: 49
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: INSA Lyon
Re:export 2008/07/29 10:29 Karma: 2  
Ah ca ca me rapelle les timeouts...
Pour savoir si c'est bien ca, il faudrait changer la valeur de:
max_execution_time
(ou faire un appel à set_time_limit)

PS: changer upload_max_filesize ne devrait rien modifier pour un export, puisque l'on ne fait pas d'upload.
 
Logged Logged  
 
Last Edit: 2008/07/29 10:30 By raphael_bertrand.
 
Raphael Bertrand - (Ex-Stagiaire Société Résultic)

Configuration serveur:

Dolibarr 2.5-dev, PHP 4.4.4 (Apache sur dédié Linux OVH), MySQL 3.23.58
  The administrator has disabled public write access.
#9591
sladame (User)
Expert Boarder
Posts: 117
graphgraph
User Offline Click here to see the profile of this user
Gender: Male mon site (joomla) Location: lyon Birthdate: 1984-05-13
Re:export 2008/07/29 11:50 Karma: 1  
max_execution_time tester a 60 mais de toute façon la pages blanche arrive avant 18 seconde
syslog sans erreur...
Code:
2008-07-29 11:43:17 INFO 192.168.1.181 ??? Session name=DOLSESSID_dolibarr Session id()=ckq6uue5oi1geu1gitff1mv9t6, _SESSION['dol_login']=sladame 2008-07-29 11:43:17 INFO 192.168.1.181 sladame This is an already logged session. _SESSION['dol_login']=sladame 2008-07-29 11:43:17 INFO 192.168.1.181 sladame Access to /exports/export.php 2008-07-29 11:43:17 INFO 192.168.1.181 sladame Export::load_arrays user=1 filter=societe_1 2008-07-29 11:43:18 INFO 192.168.1.181 sladame Export loaded for module modSociete with index 0, dataset=societe_1, nb of fields=0 2008-07-29 11:43:18 INFO 192.168.1.181 sladame Export::build_file excel, societe_1, Array 2008-07-29 11:43:18 INFO 192.168.1.181 sladame Export::build_file sql=SELECT DISTINCT s.nom as name, s.address as address, s.cp as zip, s.ville as town FROM llx_societe as s LEFT JOIN llx_c_typent as t ON s.fk_typent = t.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.rowid 2008-07-29 11:43:19 INFO 192.168.1.181 sladame functions.lib.php::create_exdir: dir=/var/www/html/dolibarr/documents/export/temp/1 2008-07-29 11:43:19 INFO 192.168.1.181 sladame ExportExcel::open_file file=/var/www/html/dolibarr/documents/export/temp/1/export_societe_1.xls
...
 
Logged Logged  
 
  The administrator has disabled public write access.
#9595
raphael_bertrand (User)
Senior Boarder
Posts: 49
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: INSA Lyon
Re:export 2008/07/30 10:48 Karma: 2  
Pour une raison qui m'est inconnue (vu que je n'ai jamais eu l'expérience de la librairie Php_WriteExcel), le xls généré de mon coté est corrompu.
Cependant, avec le csv c'est ok (mais je n'ai pas autant de contacts).

Voici le log (niveau débug) csv puis xls si ca peut t'aider à trouver une différence...

Code:
2008-07-30 10:42:49 DEBUG MON.IP.MON.IP ??? User::Fetch sql=SELECT u.rowid, u.name, u.firstname, u.email, u.office_phone, u.office_fax, u.user_mobile, u.admin, u.login, u.webcal_login, u.phenix_login, u.phenix_pass, u.note, u.pass, u.pass_crypted, u.pass_temp, u.fk_societe, u.fk_socpeople, u.fk_member, u.ldap_sid, u.statut, u.lang, unix_timestamp(u.datec) as datec, unix_timestamp(u.tms) as datem, unix_timestamp(u.datelastlogin) as datel, unix_timestamp(u.datepreviouslogin) as datep FROM llx_user as u WHERE u.login = 'rbertrand' 2008-07-30 10:42:49 INFO MON.IP.MON.IP rbertrand This is an already logged session. _SESSION['dol_login']=rbertrand 2008-07-30 10:42:49 INFO MON.IP.MON.IP rbertrand Access to /exports/export.php 2008-07-30 10:42:49 DEBUG MON.IP.MON.IP rbertrand User::getRights sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND ur.fk_user= 3 AND r.perms IS NOT NULL 2008-07-30 10:42:49 DEBUG MON.IP.MON.IP rbertrand User::getRights sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 3 AND r.perms IS NOT NULL 2008-07-30 10:42:49 INFO MON.IP.MON.IP rbertrand Export::load_arrays user=3 filter=societe_1 2008-07-30 10:42:50 INFO MON.IP.MON.IP rbertrand Export loaded for module modSociete with index 0, dataset=societe_1, nb of fields=0 2008-07-30 10:42:50 INFO MON.IP.MON.IP rbertrand Export::build_file csv, societe_1, Array 2008-07-30 10:42:50 INFO MON.IP.MON.IP rbertrand Export::build_file sql=SELECT DISTINCT s.rowid as socid, s.nom as name, s.prefix_comm as prefix, s.client as iscustomer, s.fournisseur as issupplier, s.datec as datecreation, s.tms as datelastmodification, s.code_client as customercode, s.code_fournisseur as suppliercode, s.address as address, s.cp as zip, s.ville as town, p.libelle as country, p.code as countrycode, s.tel as phone, s.fax as fax, s.url as url, s.email as email, s.siret as idprof1, s.siren as idprof2, s.ape as idprof3, s.idprof4 as idprof4, s.tva_intra as vatintra, s.capital as capital, s.note as note, t.libelle as thirdpartytype FROM llx_societe as s LEFT JOIN llx_c_typent as t ON s.fk_typent = t.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.rowid 2008-07-30 10:42:50 INFO MON.IP.MON.IP rbertrand functions.lib.php::create_exdir: dir=/home/.../documents/export/temp/3 2008-07-30 10:42:50 INFO MON.IP.MON.IP rbertrand ExportCsv::open_file file=/home/.../documents/export/temp/3/export_societe_1.csv 2008-07-30 10:42:50 INFO MON.IP.MON.IP rbertrand Menubase::menuTopCharger sql=SELECT m.rowid, m.mainmenu, m.titre, m.url, m.langs, m.perms, mo.action FROM llx_menu as m LEFT JOIN llx_menu_const as mc ON m.rowid = mc.fk_menu LEFT JOIN llx_menu_constraint as mo ON mc.fk_constraint = mo.rowid WHERE m.type = 'top' AND m.menu_handler in('eldy','all') AND m.user in (0,2) ORDER BY m.position 2008-07-30 10:42:50 INFO MON.IP.MON.IP rbertrand Menubase::menuLeftCharger sql=SELECT m.rowid, m.fk_menu, m.url, m.titre, m.langs, m.perms, m.target, m.mainmenu, m.leftmenu, mo.action FROM llx_menu as m LEFT JOIN llx_menu_const as mc ON m.rowid = mc.fk_menu LEFT JOIN llx_menu_constraint as mo ON mc.fk_constraint = mo.rowid WHERE m.menu_handler in('eldy','all') AND m.user in (0,2) ORDER BY m.position, m.rowid 2008-07-30 10:42:50 INFO MON.IP.MON.IP rbertrand ModeleExport::loadFormat 2008-07-30 10:42:50 INFO MON.IP.MON.IP rbertrand files.lib.php::dol_dir_list /home/.../documents/export/temp/3 PUIS 2008-07-30 10:43:49 DEBUG MON.IP.MON.IP ??? User::Fetch sql=SELECT u.rowid, u.name, u.firstname, u.email, u.office_phone, u.office_fax, u.user_mobile, u.admin, u.login, u.webcal_login, u.phenix_login, u.phenix_pass, u.note, u.pass, u.pass_crypted, u.pass_temp, u.fk_societe, u.fk_socpeople, u.fk_member, u.ldap_sid, u.statut, u.lang, unix_timestamp(u.datec) as datec, unix_timestamp(u.tms) as datem, unix_timestamp(u.datelastlogin) as datel, unix_timestamp(u.datepreviouslogin) as datep FROM llx_user as u WHERE u.login = 'rbertrand' 2008-07-30 10:43:49 INFO MON.IP.MON.IP rbertrand This is an already logged session. _SESSION['dol_login']=rbertrand 2008-07-30 10:43:49 INFO MON.IP.MON.IP rbertrand Access to /exports/export.php 2008-07-30 10:43:49 DEBUG MON.IP.MON.IP rbertrand User::getRights sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND ur.fk_user= 3 AND r.perms IS NOT NULL 2008-07-30 10:43:49 DEBUG MON.IP.MON.IP rbertrand User::getRights sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 3 AND r.perms IS NOT NULL 2008-07-30 10:43:49 INFO MON.IP.MON.IP rbertrand Export::load_arrays user=3 filter=societe_1 2008-07-30 10:43:49 INFO MON.IP.MON.IP rbertrand Export loaded for module modSociete with index 0, dataset=societe_1, nb of fields=0 2008-07-30 10:43:49 INFO MON.IP.MON.IP rbertrand Export::build_file excel, societe_1, Array 2008-07-30 10:43:49 INFO MON.IP.MON.IP rbertrand Export::build_file sql=SELECT DISTINCT s.rowid as socid, s.nom as name, s.prefix_comm as prefix, s.client as iscustomer, s.fournisseur as issupplier, s.datec as datecreation, s.tms as datelastmodification, s.code_client as customercode, s.code_fournisseur as suppliercode, s.address as address, s.cp as zip, s.ville as town, p.libelle as country, p.code as countrycode, s.tel as phone, s.fax as fax, s.url as url, s.email as email, s.siret as idprof1, s.siren as idprof2, s.ape as idprof3, s.idprof4 as idprof4, s.tva_intra as vatintra, s.capital as capital, s.note as note, t.libelle as thirdpartytype FROM llx_societe as s LEFT JOIN llx_c_typent as t ON s.fk_typent = t.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.rowid 2008-07-30 10:43:49 INFO MON.IP.MON.IP rbertrand functions.lib.php::create_exdir: dir=/home/.../documents/export/temp/3 2008-07-30 10:43:49 INFO MON.IP.MON.IP rbertrand ExportExcel::open_file file=/home/.../documents/export/temp/3/export_societe_1.xls 2008-07-30 10:43:50 INFO MON.IP.MON.IP rbertrand Menubase::menuTopCharger sql=SELECT m.rowid, m.mainmenu, m.titre, m.url, m.langs, m.perms, mo.action FROM llx_menu as m LEFT JOIN llx_menu_const as mc ON m.rowid = mc.fk_menu LEFT JOIN llx_menu_constraint as mo ON mc.fk_constraint = mo.rowid WHERE m.type = 'top' AND m.menu_handler in('eldy','all') AND m.user in (0,2) ORDER BY m.position 2008-07-30 10:43:50 INFO MON.IP.MON.IP rbertrand Menubase::menuLeftCharger sql=SELECT m.rowid, m.fk_menu, m.url, m.titre, m.langs, m.perms, m.target, m.mainmenu, m.leftmenu, mo.action FROM llx_menu as m LEFT JOIN llx_menu_const as mc ON m.rowid = mc.fk_menu LEFT JOIN llx_menu_constraint as mo ON mc.fk_constraint = mo.rowid WHERE m.menu_handler in('eldy','all') AND m.user in (0,2) ORDER BY m.position, m.rowid 2008-07-30 10:43:50 INFO MON.IP.MON.IP rbertrand ModeleExport::loadFormat 2008-07-30 10:43:50 INFO MON.IP.MON.IP rbertrand files.lib.php::dol_dir_list /home/.../documents/export/temp/3
 
Logged Logged  
 
Last Edit: 2008/07/31 16:35 By raphael_bertrand.
 
Raphael Bertrand - (Ex-Stagiaire Société Résultic)

Configuration serveur:

Dolibarr 2.5-dev, PHP 4.4.4 (Apache sur dédié Linux OVH), MySQL 3.23.58
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop