Import de Tiers (CSV, Excel)

Bonjour,

Je rencontre un problème lors de l’import de fichier CSV et Excel sur l’assistant import.

Lorsque j’essaye d’importer un fichier, je reçois un message d’erreur à la fin du chargement

https://i.imgur.com/hdH55Sq.png

Les fichiers sont au bon format et la tailles des fichiers ne dépasse pas la limite PHP.

Il y a t-il un moyen de résoudre ce problème ou bien existe t-il une alternative pour importer en masse des tiers ?

Je suis sur la version 8.0.2

Merci d’avance

Pièces jointes :

Bonjour,

A mon avis probléme de droit php sur le dossier temporaire.
Votre Dolibarr est hébergé ou ?

Voir ici : https://wiki.dolibarr.org/index.php/Troubleshooting I can’t upload files

Bonjour,

Le Dolibarr est sur un hébergement Plesk d’OVH

Ok,

Vous pouvez télécharger les logs pour voir ce qui coince ?

:happy: Bonjour

les solutions d’import existent via le menu outils…
mais cela n’est pas forcément simple à mettre en oeuvre, surtout pour un grand nombre d’enregistrements,
pour exemple de nombreux posts existent à ce sujet, pour les produits, les stocks, etc…

ce qu’il vous faut bien comprendre, c’est qu’il faut au minimum une bonne compréhension des structures à prendre en compte
il y a un an, j’ai réalisé pour un client, l’import de toute la gestion commerciale Sage100 : voir la démonstration

je pense que la bonne solution est d’établir les commandes SQL INSERT qui ajouteront toutes vos données à votre outil actuel
ce qui permettra par exemple d’importer aussi vos contacts, etc…

Bonne continuation

Bonjour,

Voici les logs en pj.

Serait-il possible d’ajouter des tiers en masse via une requête SQL si jamais il n’y a pas de solutions ?

Bonjour,

Voici les logs en pj.

Serait-il possible d’intégrer des tiers en masse via une requête SQL si jamais cela ne marche pas via l’assistant import ?

Bonjour,

Voici une partie des logs:

2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = ‹ admin › ORDER BY u.entity ASC
2018-10-26 15:08:18 INFO 193.253.217.150 fetch_name_optionals_label elementtype=user
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ user › ORDER BY pos
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, contrat, com_totalmonth_min, com_total_min, com_percentage, sortie, sosname, sostel, info FROM llx_user_extrafields WHERE fk_object = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 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.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2018-10-26 15:08:18 DEBUG 193.253.217.150 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.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2018-10-26 15:08:18 INFO 193.253.217.150 — Access to /custom/fastupload/js/fastupload.js.php - action=, massaction=
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2018-10-26 15:08:18 DEBUG 193.253.217.150 Menubase::menuLoad mymainmenu=home myleftmenu=admintools type_user=0 menu_handler=eldy tabMenu size=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN (‹ eldy ›,‹ all ›) AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
2018-10-26 15:08:18 INFO 193.253.217.150 — End access to /custom/fastupload/js/fastupload.js.php
2018-10-26 15:08:18 DEBUG 193.253.217.150 - This is an already logged session. _SESSION[‹ dol_login ›]=admin _SESSION[‹ dol_entity ›]=1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = ‹ admin › ORDER BY u.entity ASC
2018-10-26 15:08:18 INFO 193.253.217.150 fetch_name_optionals_label elementtype=user
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ user › ORDER BY pos
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, contrat, com_totalmonth_min, com_total_min, com_percentage, sortie, sosname, sostel, info FROM llx_user_extrafields WHERE fk_object = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 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.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2018-10-26 15:08:18 DEBUG 193.253.217.150 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.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2018-10-26 15:08:18 INFO 193.253.217.150 — Access to /index.php - action=, massaction=
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2018-10-26 15:08:18 DEBUG 193.253.217.150 Menubase::menuLoad mymainmenu=home myleftmenu=admintools type_user=0 menu_handler=eldy tabMenu size=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN (‹ eldy ›,‹ all ›) AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
2018-10-26 15:08:18 INFO 193.253.217.150 HookManager::initHooks Loading hook class for context searchform: actions_domain.class.php
2018-10-26 15:08:18 DEBUG 193.253.217.150 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addSearchEntry of class ActionsDomain, module=domain, action= context=searchform
2018-10-26 15:08:18 DEBUG 193.253.217.150 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printSearchForm of class ActionsDomain, module=domain, action= context=searchform
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position
2018-10-26 15:08:18 DEBUG 193.253.217.150 InfoBox::listBoxes get default box list for mode=activated userid=1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT b.rowid, b.position, b.box_order, b.fk_user, d.rowid as box_id, d.file, d.note, d.tms FROM llx_boxes as b, llx_boxes_def as d WHERE b.box_id = d.rowid AND b.entity IN (0,1) AND b.position = 0 AND b.fk_user IN (0,1) ORDER BY b.box_order
2018-10-26 15:08:18 ERR 193.253.217.150 functions::dol_include_once Tried to load unexisting file: /management/core/boxes/box_projet.php
2018-10-26 15:08:18 WARNING 193.253.217.150 Failed to load box ‹ box_projet › into file ‹ /management/core/boxes/box_projet.php ›
2018-10-26 15:08:18 ERR 193.253.217.150 functions::dol_include_once Tried to load unexisting file: /management/core/boxes/box_task.php
2018-10-26 15:08:18 WARNING 193.253.217.150 Failed to load box ‹ box_task › into file ‹ /management/core/boxes/box_task.php ›
2018-10-26 15:08:18 INFO 193.253.217.150 FactureStats::getNbByMonthWithPrevYear read data from cache file /var/www/vhosts/konverseo.com/httpdocs/preproddolibarr/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1540556359.
2018-10-26 15:08:18 INFO 193.253.217.150 DolGraph::draw_jflot this->type= this->MaxValue=40
2018-10-26 15:08:18 INFO 193.253.217.150 FactureStats::getAmountByMonthWithPrevYear read data from cache file /var/www/vhosts/konverseo.com/httpdocs/preproddolibarr/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1540556359.
2018-10-26 15:08:18 INFO 193.253.217.150 DolGraph::draw_jflot this->type= this->MaxValue=20000
2018-10-26 15:08:18 INFO 193.253.217.150 box_graph_invoices_permonth::showBox
2018-10-26 15:08:18 INFO 193.253.217.150 ModeleBoxes::showBox
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT t.rowid as id, t.ref, t.track_id, t.fk_soc, t.fk_user_create, t.fk_user_assign, t.subject, t.message, t.fk_statut, t.type_code, t.category_code, t.severity_code, t.datec, t.date_read, t.date_close, t.origin_email , type.label as type_label, category.label as category_label, severity.label as severity_label, s.nom as company_name FROM llx_ticket as t LEFT JOIN llx_c_ticket_type as type ON type.code=t.type_code LEFT JOIN llx_c_ticket_category as category ON category.code=t.category_code LEFT JOIN llx_c_ticket_severity as severity ON severity.code=t.severity_code LEFT JOIN llx_societe as s ON s.rowid=t.fk_soc WHERE t.entity = 1 ORDER BY t.datec DESC, t.rowid DESC LIMIT 30
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 ERR 193.253.217.150 Functions.lib::dol_print_date function call with deprecated value of time in page /index.php
2018-10-26 15:08:18 INFO 193.253.217.150 box_last_ticket::showBox
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT p.rowid, p.ref, p.title, p.fk_statut, p.public FROM llx_projet as p WHERE p.entity IN (1) AND p.fk_statut = 1 ORDER BY p.datec DESC
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count() as nb, sum(progress) as totprogress FROM llx_projet as p LEFT JOIN llx_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 202
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(
) as nb, sum(progress) as totprogress FROM llx_projet as p LEFT JOIN llx_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 201
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count() as nb, sum(progress) as totprogress FROM llx_projet as p LEFT JOIN llx_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 199
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(
) as nb, sum(progress) as totprogress FROM llx_projet as p LEFT JOIN llx_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 171
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count() as nb, sum(progress) as totprogress FROM llx_projet as p LEFT JOIN llx_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 158
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(
) as nb, sum(progress) as totprogress FROM llx_projet as p LEFT JOIN llx_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 57
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count() as nb, sum(progress) as totprogress FROM llx_projet as p LEFT JOIN llx_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 53
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(
) as nb, sum(progress) as totprogress FROM llx_projet as p LEFT JOIN llx_projet_task as pt on pt.fk_projet = p.rowid WHERE p.entity IN (1) AND p.rowid = 41
2018-10-26 15:08:18 INFO 193.253.217.150 box_project::showBox
2018-10-26 15:08:18 DEBUG 193.253.217.150 box_comptes::loadBox
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT b.rowid, b.ref, b.label, b.bank,b.number, b.courant, b.clos, b.rappro, b.url, b.code_banque, b.code_guichet, b.cle_rib, b.bic, b.iban_prefix as iban, b.domiciliation, b.proprio, b.owner_address, b.account_number, b.currency_code, b.min_allowed, b.min_desired, comment, b.fk_accountancy_journal, aj.code as accountancy_journal FROM llx_bank_account as b LEFT JOIN llx_accounting_journal as aj ON aj.rowid=b.fk_accountancy_journal WHERE b.entity = 1 AND clos = 0 ORDER BY label LIMIT 30
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT sum(amount) as amount FROM llx_bank WHERE fk_account = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 Translate::loadCacheCurrencies
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = ‹ EUR ›
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT sum(amount) as amount FROM llx_bank WHERE fk_account = 3
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT sum(amount) as amount FROM llx_bank WHERE fk_account = 2
2018-10-26 15:08:18 INFO 193.253.217.150 box_comptes::showBox
2018-10-26 15:08:18 INFO 193.253.217.150 CommandeStats::getNbByMonthWithPrevYear read data from cache file /var/www/vhosts/konverseo.com/httpdocs/preproddolibarr/documents/users/temp/CommandeStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1540556359.
2018-10-26 15:08:18 INFO 193.253.217.150 DolGraph::draw_jflot this->type= this->MaxValue=10
2018-10-26 15:08:18 INFO 193.253.217.150 CommandeStats::getAmountByMonthWithPrevYear read data from cache file /var/www/vhosts/konverseo.com/httpdocs/preproddolibarr/documents/users/temp/CommandeStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1540556359.
2018-10-26 15:08:18 INFO 193.253.217.150 DolGraph::draw_jflot this->type= this->MaxValue=20000
2018-10-26 15:08:18 INFO 193.253.217.150 box_graph_orders_permonth::showBox
2018-10-26 15:08:18 INFO 193.253.217.150 ModeleBoxes::showBox
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(u.rowid) as nb FROM llx_user as u WHERE u.statut > 0 AND u.entity IN (0,1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(s.rowid) as nb, s.client FROM llx_societe as s WHERE s.client IN (1,2,3) AND s.entity IN (1) GROUP BY s.client
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(s.rowid) as nb FROM llx_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(sp.rowid) as nb FROM llx_socpeople as sp WHERE sp.entity IN (1) AND (sp.priv=‹ 0 › OR (sp.priv=‹ 1 › AND sp.fk_user_creat=1))
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(p.rowid) as nb, fk_product_type FROM llx_product as p WHERE p.entity IN (1) GROUP BY fk_product_type
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(p.rowid) as nb FROM llx_propal as p LEFT JOIN llx_societe as s ON p.fk_soc = s.rowid WHERE p.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(co.rowid) as nb FROM llx_commande as co LEFT JOIN llx_societe as s ON co.fk_soc = s.rowid WHERE co.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(f.rowid) as nb FROM llx_facture as f LEFT JOIN llx_societe as s ON f.fk_soc = s.rowid WHERE f.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(c.rowid) as nb FROM llx_contrat as c LEFT JOIN llx_societe as s ON c.fk_soc = s.rowid WHERE c.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(fi.rowid) as nb FROM llx_fichinter as fi LEFT JOIN llx_societe as s ON fi.fk_soc = s.rowid WHERE fi.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(co.rowid) as nb FROM llx_commande_fournisseur as co LEFT JOIN llx_societe as s ON co.fk_soc = s.rowid WHERE co.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(f.rowid) as nb FROM llx_facture_fourn as f LEFT JOIN llx_societe as s ON f.fk_soc = s.rowid WHERE f.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(p.rowid) as nb FROM llx_projet as p WHERE p.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT count(ex.rowid) as nb FROM llx_expensereport as ex WHERE ex.fk_statut > 0 AND ex.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT a.id, a.datep as dp FROM (llx_actioncomm as a) LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid WHERE 1 = 1 AND a.percent >= 0 AND a.percent < 100 AND a.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT p.rowid, p.fk_statut as status, p.fk_opp_status, p.datee as datee FROM (llx_projet as p) LEFT JOIN llx_societe as s on p.fk_soc = s.rowid WHERE p.fk_statut = 1 AND p.entity IN (1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT ctc.rowid, ctc.code FROM llx_c_type_contact as ctc WHERE ctc.element = ‹ project › AND ctc.source = ‹ internal ›
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT DISTINCT p.rowid, p.ref FROM llx_projet as p, llx_element_contact as ec WHERE p.entity IN (1) AND ec.element_id = p.rowid AND ( p.public = 1 OR ( ec.fk_c_type_contact IN (197,161,195,196,160,194) AND ec.fk_socpeople = 1) )
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT p.rowid as projectid, p.fk_statut as projectstatus, t.rowid as taskid, t.progress as progress, t.fk_statut as status, t.dateo as date_start, t.datee as datee FROM llx_projet as p LEFT JOIN llx_societe as s on p.fk_soc = s.rowid, llx_projet_task as t WHERE p.entity IN (1) AND p.fk_statut = 1 AND t.fk_projet = p.rowid AND t.progress < 100
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin FROM llx_propal as p WHERE p.entity IN (1) AND p.fk_statut = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin FROM llx_propal as p WHERE p.entity IN (1) AND p.fk_statut = 2
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.date_livraison as delivery_date, c.fk_statut FROM llx_commande as c WHERE c.entity IN (1) AND ((c.fk_statut IN (1,2)) OR (c.fk_statut = 3 AND c.facture = 0))
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date FROM llx_commande_fournisseur as c WHERE c.entity = 1 AND c.fk_statut IN (1, 2)
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT cd.rowid, cd.date_ouverture_prevue as datefin FROM llx_contrat as c, llx_contratdet as cd, llx_societe as s WHERE c.statut = 1 AND c.rowid = cd.fk_contrat AND cd.statut = 0 AND c.fk_soc = s.rowid AND c.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT cd.rowid, cd.date_fin_validite as datefin FROM llx_contrat as c, llx_contratdet as cd, llx_societe as s WHERE c.statut = 1 AND c.rowid = cd.fk_contrat AND cd.statut = 4 AND cd.date_fin_validite < ‹ 2018-10-26 15:08:18 › AND c.fk_soc = s.rowid AND c.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT f.rowid, f.date_lim_reglement as datefin,f.fk_statut FROM llx_facture as f WHERE f.paye=0 AND f.entity = 1 AND f.fk_statut = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT ff.rowid, ff.date_lim_reglement as datefin, ff.fk_statut FROM llx_facture_fourn as ff WHERE ff.paye=0 AND ff.fk_statut > 0 AND ff.entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT COUNT(ba.rowid) as nb FROM llx_bank_account as ba WHERE ba.rappro > 0 and ba.clos = 0 AND ba.entity IN (1) AND ba.courant != 2
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT b.rowid, b.datev as datefin FROM llx_bank as b, llx_bank_account as ba WHERE b.rappro=0 AND b.fk_account = ba.rowid AND ba.entity IN (1) AND (ba.rappro = 1 AND ba.courant != 2) AND clos = 0
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT b.rowid, b.datev as datefin FROM llx_bank as b, llx_bank_account as ba WHERE b.fk_account = ba.rowid AND ba.entity IN (1) AND b.fk_type = ‹ CHQ › AND b.fk_bordereau = 0 AND b.amount > 0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::load_parentof
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT fk_user as id_parent, rowid as id_son FROM llx_user WHERE fk_user <> 0 AND entity IN (0,1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::get_full_tree get user list
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT DISTINCT u.rowid, u.firstname, u.lastname, u.fk_user, u.fk_soc, u.login, u.email, u.gender, u.admin, u.statut, u.photo, u.entity FROM llx_user as u WHERE u.entity IN (0,1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::get_full_tree call to build_path_from_id_user
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=1 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=2 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=3 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=6 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=9 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=12 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=13 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=15 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=19 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=20 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=21 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::build_path_from_id_user id_user=22 protection=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 User::get_full_tree dol_sort_array
2018-10-26 15:08:18 INFO 193.253.217.150 Build childid for id = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT ex.rowid, ex.date_valid FROM llx_expensereport as ex WHERE ex.fk_statut = 2 AND ex.entity IN (1) AND (ex.fk_user_author IN (3,9,6,22,2,15,21,12,13,1) OR ex.fk_user_validator IN (3,9,6,22,2,15,21,12,13,1))
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT ex.rowid, ex.date_valid FROM llx_expensereport as ex WHERE ex.fk_statut = 5 AND ex.entity IN (1) AND (ex.fk_user_author IN (3,9,6,22,2,15,21,12,13,1) OR ex.fk_user_validator IN (3,9,6,22,2,15,21,12,13,1))
2018-10-26 15:08:18 INFO 193.253.217.150 — End access to /index.php
2018-10-26 15:08:18 DEBUG 193.253.217.150 - This is an already logged session. _SESSION[‹ dol_login ›]=admin _SESSION[‹ dol_entity ›]=1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = ‹ admin › ORDER BY u.entity ASC
2018-10-26 15:08:18 INFO 193.253.217.150 fetch_name_optionals_label elementtype=user
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ user › ORDER BY pos
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, contrat, com_totalmonth_min, com_total_min, com_percentage, sortie, sosname, sostel, info FROM llx_user_extrafields WHERE fk_object = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2018-10-26 15:08:18 DEBUG 193.253.217.150 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.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2018-10-26 15:08:18 DEBUG 193.253.217.150 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.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2018-10-26 15:08:18 INFO 193.253.217.150 — Access to /index.php - action=, massaction=
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2018-10-26 15:08:18 DEBUG 193.253.217.150 Menubase::menuLoad mymainmenu=home myleftmenu=admintools type_user=0 menu_handler=eldy tabMenu size=0
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN (‹ eldy ›,‹ all ›) AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
2018-10-26 15:08:18 INFO 193.253.217.150 HookManager::initHooks Loading hook class for context searchform: actions_domain.class.php
2018-10-26 15:08:18 DEBUG 193.253.217.150 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method addSearchEntry of class ActionsDomain, module=domain, action= context=searchform
2018-10-26 15:08:18 DEBUG 193.253.217.150 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method printSearchForm of class ActionsDomain, module=domain, action= context=searchform
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position
2018-10-26 15:08:18 DEBUG 193.253.217.150 InfoBox::listBoxes get default box list for mode=activated userid=1
2018-10-26 15:08:18 DEBUG 193.253.217.150 sql=SELECT b.rowid, b.position, b.box_order, b.fk_user, d.rowid as box_id, d.file, d.note, d.tms FROM llx_boxes as b, llx_boxes_def as d WHERE b.box_id = d.rowid AND b.entity IN (0,1) AND b.position = 0 AND b.fk_user IN (0,1) ORDER BY b.box_order
2018-10-26 15:08:18 ERR 193.253.217.150 functions::dol_include_once Tried to load unexisting file: /management/core/boxes/box_projet.php
2018-10-26 15:08:18 WARNING 193.253.217.150 Failed to load box ‹ box_projet › into file ‹ /management/core/boxes/box_projet.php ›
2018-10-26 15:08:18 ERR 193.253.217.150 functions::dol_include_once Tried to load unexisting file: /management/core/boxes/box_task.php
2018-10-26 15:08:18 WARNING 193.253.217.150 Failed to load box ‹ box_task › into file ‹ /management/core/boxes/box_task.php ›
2018-10-26 15:08:18 INFO 193.253.217.150 FactureStats::getNbByMonthWithPrevYear read data from cache file /var/www/vhosts/konverseo.com/httpdocs/preproddolibarr/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1540556359.
2018-10-26 15:08:18 INFO 193.253.217.150 DolGraph::draw_jflot this->type= this->MaxValue=40
2018-10-26 15:08:18 INFO 193.253.217.150 FactureStats::getAmountByMonthWithPrevYear read data from cache file /var/www/vhosts/konverseo.com/httpdocs/preproddolibarr/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache 1540556359.
2018-10-26 15:08:18 INFO 193.253.217.150 DolGraph::draw_jflot this->type= this->MaxValue=20000
2018-10-26 15:08:18 INFO 193.253.217.150 box_graph_invoices_permonth::showBox
2018-10-26 15:08:18 INFO 193.253.217.150 ModeleBoxes::showBox

Est-il possible d’importer les tiers en masse via une requête SQL ?

Bonjour :happy:

effectivement un script sql est sans doute une bonne solution…

la partie du fichier log ne contient pas d’erreur concernant les fonctions d’import, mais quelques autres problèmes…
voici une copie d’écran qui en dit plus… avec notepad++

si_err14.png

Bonne continuation

Bonjour,

J’ai refais l’import sur un dolibarr totalement neuf en 8.0.2 et je retombe sur le même problème « Erreur, l’enregistrement du fichier a échoué. »

ERR 193.253.217.150 Files.lib::dol_move_uploaded_file Failed to move to /var/www/vhosts/monsite.com/httpdocs/dolibarrtest/htdocs/documents/import/temp/20181029095139-Classeur1_xlsx.xlsx

J’ai fais les modification que ksar a conseillé. Cependant le problème persiste.
J’ai peut-être mal exécuté ces modifs cela-dit.

Je suis allé dans /dev/setup/codsniffer pour trouver le php.ini et j’y ait saisie ces lignes:
upload_tmp_dir = /var/tmp
sys_temp_dir = /var/tmp

Et dans mon interface plesk j’ai changé dans mes paramètre php open_basedir {WEBSPACEROOT}{/}{:}{TMP}{/}:/var/tmp

Bonjour,

Je up car mon problème est toujours d’actualité. :dry:

Lors de l’envoie d’un fichier j’ai cette erreur là dans mes logs.

ERR 193.253.217.150 Files.lib::dol_move_uploaded_file Failed to move to /var/www/vhosts/monsite.com/httpdocs/dolibarrtest/htdocs/documents/import/temp/20181029095139-Classeur1_xlsx.xlsx

Bjr

Et si vs essayé en ftp avec filezilla ?

Bonjour,

Merci. Avec le transfert par ftp ça fonctionne j’arrive à upload mes fichiers.
Tout se passe bien dans le processus d’import jusqu’à l’étape 5.

Lorsque je fais la simulation d’importation, elle s’effectue mais j’ai aucune possibilité de faire l’importation pour de vrai.
Je reste bloqué sur cette étape je ne peux que faire des simulation d’importation.

Bonjour :happy:

vous pouvez me transmettre une partie de votre fichier
je vous enverrai le fichier sql qui vous permettra d’effectuer l’import via phpmyadmin…

Bonne continuation

J’suis désolé je peux pas communiquer ce fichier c’est des infos confidentielles :dry:

Je voudrai juste pouvoir faire une vrai importation et pas que une simulation sur l’assistant import.

Salut Jigyas,

Il n’y a à priori pas de raisons pour qu’une simulation fonctionne et qu’il ne soit pas possible d’intégrer les données.
as tu un message d’erreur ? peux tu fournir une copie d’écran du point bloquant ?

Au pire, tu peux intégrer ces données directement via un outils d’administration de base de donnée (phpmyadmin par exemple)
Cette manipulation requiert quelques connaissances (en sql, pour le bon formatage et de Dolibarr pour s’assurer de l’intégrité de toutes les tables entre elles) : si tu ne sais pas faire, tu peux contacter un partenaire.
Liste non exhaustive disponible ici : https://wiki.dolibarr.org/index.php/List_of_Dolibarr_partners_and_providers

Bonjour,

Avant de lancer la simulation d’import:

Après la simulation d’import:

Sur un autre dolibarr ça me met carrément une erreur 503 après le lancement de la simulation

Bonsoir :happy:

pour vous éviter les problèmes évoqués dans ma première réponse…
vous pouvez essayer d’importer le fichier joint via phpmyadmin

Bonne continuation

Pièces jointes :

Et ça te te dis pas de créer une base d’essai pour voir ?

Bonjour,

Après plusieurs tentative j’ai réussi à faire marché l’import si on peut dire.

Cependant je rencontre des erreurs d’insertion.

Par exemple:

* Ligne 3
> Mauvaise valeur pour le champ numéro 3 (la valeur ‹ 2 › ne respecte pas la règle ^[0|1])
> Donnée obligatoire non renseignée dans le fichier source, champ numéro 5.
> Mauvaise valeur pour le champ numéro 13 (la valeur ‹ FR › n’est pas une valeur disponible dans le champ code de la table DictionaryState)
> Mauvaise valeur pour le champ numéro 36 (la valeur ‹ Hébergement touristique et autre hébergement de courte durée › ne respecte pas la règle ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9]0-9?$)
* Ligne 4
> Mauvaise valeur pour le champ numéro 3 (la valeur ‹ 2 › ne respecte pas la règle ^[0|1])
> Donnée obligatoire non renseignée dans le fichier source, champ numéro 5.
> Mauvaise valeur pour le champ numéro 13 (la valeur ‹ FR › n’est pas une valeur disponible dans le champ code de la table DictionaryState)
> Mauvaise valeur pour le champ numéro 36 (la valeur ‹ Élevage de vaches laitières › ne respecte pas la règle ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9]0-9?$)

C’est plus ou moins les mêmes erreurs sur toute mes lignes.
J’aurai besoin qu’on m’éclaircisse sur ces erreurs svp :dry:

Merci d’avance