Merci Gaëtan pour ces conseils.
Dans le log j’ai bien quelques lignes qui concernent le ‹ label_compte › mais je doit dire que ça me parle pas beaucoup.
2020-02-22 17:32:59 INFO 127.0.0.1 --- Access to /dolibarr/imports/import.php - action=launchsimu, massaction=
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_CH' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2020-02-22 17:32:59 DEBUG 127.0.0.1 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
2020-02-22 17:32:59 INFO 127.0.0.1 Import::load_arrays user=1 filter=accounting_1
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1)
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'user' AND entity IN (0,1)
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT code, label, description FROM llx_c_action_trigger ORDER by rang
2020-02-22 17:32:59 INFO 127.0.0.1 Import loaded for module modAccounting with index 0, dataset=accounting_1, nb of fields=10
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'societe' AND entity IN (0, 1)
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0, 1)
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llx_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, fieldrequired FROM llx_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1)
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'societe' AND entity IN (0, 1)
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=SELECT name, label, type, param FROM llx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0, 1)
2020-02-22 17:32:59 INFO 127.0.0.1 ModeleImports::liste_modeles
2020-02-22 17:32:59 INFO 127.0.0.1 ImportCsv::open_file file=/usr/share/dolibarr/documents/import/temp/20200220215340-Exemple_de_fichier_import_accounting_1(1).csv
2020-02-22 17:32:59 DEBUG 127.0.0.1 BEGIN Transaction
2020-02-22 17:32:59 INFO 127.0.0.1 ImportCsv::open_file file=/usr/share/dolibarr/documents/import/temp/20200220215340-Exemple_de_fichier_import_accounting_1(1).csv
2020-02-22 17:32:59 INFO 127.0.0.1 Check if table llx_accounting_bookkeeping has an entity field
2020-02-22 17:32:59 DEBUG 127.0.0.1 DoliDBMysqli::DDLDescTable DESC llx_accounting_bookkeeping entity
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=DESC llx_accounting_bookkeeping entity
2020-02-22 17:32:59 DEBUG 127.0.0.1 import_csv.modules
2020-02-22 17:32:59 DEBUG 127.0.0.1 sql=INSERT INTO llx_accounting_bookkeeping(piece_num, doc_date, doc_ref, code_journal, numero_compte, subledger_account, subledger_label, label_operation, debit, credit, doc_type, fk_doc, fk_docdet, fk_user_author, date_creation, import_key, entity) VALUES('123 (!!! use next value not already used)', '2020-02-20', 'My document ABC', 'VTE', '707', null, null, 'Sale of ABC', '0', '100', 'import_from_external', '0', '0', 1, '2020-02-22 17:32:59', '20200222173259', 1)
2020-02-22 17:32:59 ERR 127.0.0.1 DoliDBMysqli::query SQL Error message: DB_ERROR_1364 Field 'label_compte' doesn't have a default value
2020-02-22 17:32:59 DEBUG 127.0.0.1 ROLLBACK Transaction
2020-02-22 17:32:59 INFO 127.0.0.1 --- End access to /dolibarr/imports/import.php
merci d’avance.
Cyril