Skip to main content

Divers

Export Adh Odoo

select t1.name,t1.membership_start,t1.membership_stop,t1.ref,t1.membership_state,t2.name from res_partner AS t1 INNER JOIN res_partner AS t2 ON t2.id=t1.orga_choice
copy (select t1.name,t1.membership_start,t1.membership_stop,t1.ref,t1.membership_state,t2.name from res_partner AS t1 INNER JOIN res_partner AS t2 ON t2.id=t1.orga_choice) To '/tmp/test.csv' With CSV DELIMITER ',' HEADER;

Configuration Odoo

Mettre à jour le module lcc_members
systemctl stop odoo12
su - odoo12
python3 -m venv odoo-venv
source odoo-venv/bin/activate
cd /opt/odoo12/odoo
./odoo-bin -u lcc_members -c /etc/odoo12.conf
Suppression du 2ème menu Membres

Aller dans Configuration puis Activer le mode développeur

Aller ensuite dans Configuration puis dans le menu Technique puis dans le sous-menu interface utilisateur aller dans Eléments de menu

Ajouter un Filtre Membres et Archiver le dernier Membres.

Actions automatisés

Installer le module "Règles d'action automatisées" ou "Automated Action Rules"

partners = model.search([])
for partner in partners:
  if ((partner.ref != False) and (partner != record)):
    if partner.ref == record.ref:
      raise Warning('Num adh deja existant')

image.png

Purger les factures et les paiements
select id,ref,partner_id from account_move_line;
delete from account_move_line where partner_id=829;
delete from account_move where partner_id=829;

select * from account_payment;
select * from account_invoice;
select id,credit,debit,partner_id from account_move_line;
select credit_move_id,debit_move_id from account_partial_reconcile;


delete from account_partial_reconcile where id=2;
delete from account_move_line where partner_id=829;
delete from account_move where partner_id=829;
delete from account_invoice where id=2;

ALL PURGE: 
delete from account_invoice;
delete from account_partial_reconcile;
delete from account_move_line;
delete from account_move;

delete from res_partner where id>15;
delete from res_partner where email!='tech@florain.fr' and email!='odoobot@example.com'
Changer le prix de la facture
update account_invoice set amount_untaxed=12 where partner_id=2810;
update account_invoice set amount_untaxed_signed=12 where partner_id=2810;
update account_invoice set amount_total=12 where partner_id=2810;
update account_invoice set amount_total_signed=12 where partner_id=2810;
update account_invoice set amount_total_company_signed=12 where partner_id=2810;
---
update account_invoice set residual=12 where partner_id=2810;
update account_invoice set residual_signed=12 where partner_id=2810;
update account_invoice set residual_company_signed=12 where partner_id=2810;
Procédure pour importer les utilisateurs odoo :

  • Importer les utilisateurs pros qui ont adhérés en 2022

  • Importer le reste des utilisateurs pros

  • Vérifier la présence des associations

    • (attention changer "Recyclerie la benne idée" en association

    • attention compagnie des anes accent sur le A ?

    • pas de michto ?

    • "NANCY CURIEUX", "CLAIMM", "AVEC NANCY", "ASSOCIATION GASPAR","HATHA YOGARMONIE","ROUGGE", "OLA (ORGANISATION LOCALE D’AUTOSUFFISANCE)", "ASSOCIATION CULTURELLE DU VAL DE LORRAINE","NANCY JAZZ PULSATIONS","MJC DES 3 MAISONS","MJC LILLEBONNE",

INSERT INTO res_partner (name, display_name, firstname, lastname, ref, phone, email, active, lang, customer, supplier, employee, is_company, is_published, to_renew, is_volunteer, currency_exchange_office, is_adhered_member, free_member) VALUES ('Guigui Roro', 'Guigui Roro', 'Guigui', 'Roro', '3999', '0606060606', 'truc@toto.fr', 't', 'fr_FR', 't', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f');

Ajouter des droits SQL (odoo v12)

GRANT SELECT ON res_partner TO florain;
grant insert, select, update on res_partner to florain;

grant insert,select,update on membership_membership_line to florain;
grant insert,select,update on account_invoice to florain;
grant insert,select,update on account_invoice_line to florain;
grant select,usage on account_invoice_id_seq to florain;
grant select,usage on account_invoice_line_id_seq to florain;

grant select,usage on res_partner_id_seq to florain;
SELECT grantee, privilege_type 
FROM information_schema.role_table_grants 
WHERE table_name='membership_membership_line';

Ajouter des droits SQL (odoo v16)

grant insert,select,update on res_partner to florain;
grant insert,select,update on account_move to florain;
grant insert,select,update on account_move_line to florain;
grant insert,select,update on account_move_line_account_tax_rel to florain;
grant insert,select,update on membership_membership_line to florain;

grant select,usage on account_move_id_seq to florain;
grant select,usage on account_move_line_id_seq to florain;
grant select,usage on membership_membership_line_id_seq to florain;

 

Ajouter des droits SQL

ALTER USER user_name WITH PASSWORD 'xxxx';


Upgrade la database Odoo

./odoo-bin --addons-path=/opt/odoo12/odoo/addons,/opt/odoo12/odoo-custom-addons --database=odoo --upgrade-path=/opt/OpenUpgrade/scripts/ --update
./odoo-bin -d migration --update all --stop-after-init --data-dir=/tmp --database=odoo

https://www.syncoria.com/blog/blog-6/how-can-you-upgrade-odoo-11-to-14-the-best-way-to-do-it-62

Bug après restauration d'un LXC Odoo

Feb 06 15:01:43 cyclos postgresql@13-main[570]: Examine the log output.
Feb 06 15:01:43 cyclos postgresql@13-main[570]: pg_ctl: could not start server
Feb 06 15:01:43 cyclos postgresql@13-main[570]: 2024-02-06 14:01:43.262 UTC [575] LOG:  database system is shut down
Feb 06 15:01:43 cyclos postgresql@13-main[570]: 2024-02-06 14:01:43.262 UTC [575] FATAL:  could not access private key file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied
Feb 06 15:01:43 cyclos postgresql@13-main[570]: Error: /usr/lib/postgresql/13/bin/pg_ctl /usr/lib/postgresql/13/bin/pg_ctl start -D /var/lib/postgresql/13/main -l /var/log/postgresql/postgresql-13-main.log -s -o  -c config_file="/etc/postgresql/13/main/postgresql.conf"  exited with status 1:
gpasswd -a postgres ssl-cert
chown root:ssl-cert /etc/ssl/private/ssl-cert-snakeoil.key
chmod 740 /etc/ssl/private/ssl-cert-snakeoil.key
/etc/init.d/postgresql start


Back to top