From 41dc75f3e98ded3722031150354b54c7348c7f8b Mon Sep 17 00:00:00 2001 From: Ludovic CHEVALIER Date: Tue, 13 Sep 2022 21:06:03 +0200 Subject: [PATCH] [PYTHON] ~clean client name --- wizard/account_export_csv.py | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) diff --git a/wizard/account_export_csv.py b/wizard/account_export_csv.py index 790e793..547c151 100644 --- a/wizard/account_export_csv.py +++ b/wizard/account_export_csv.py @@ -30,6 +30,7 @@ import csv import codecs import calendar import datetime +import string import openerp.exceptions from openerp.osv import osv @@ -77,7 +78,7 @@ class AccountCSVExport(osv.osv_memory): } def _get_header_sage(self, cr, uid, ids, context=None): - """docstring for _get_header_sage""" + """Return header for SAGE export""" return [_(u'Code du journal'), _(u'N° de pièce'), _(u'Date'), @@ -91,7 +92,7 @@ class AccountCSVExport(osv.osv_memory): ] def format_row_sage(self, dico, numero_piece, side): - """docstring for format_row_sage""" + """Return a formatted row for SAGE export""" if side == "D": debit = dico['debit'] credit = 0 @@ -170,7 +171,10 @@ class AccountCSVExport(osv.osv_memory): dico['date'] = datetime.datetime(year, month, day).strftime("%d/%m/%Y") account = account_obj.browse(cr, uid, line[2], context=context) dico['account_code'] = account.code - dico['client_name'] = journal.name.split(" - ", 1)[1].upper() + preformatted_client_name = journal.name.split(" - ", 1)[1].upper().replace(' ','') + for char in string.punctuation: + preformatted_client_name = preformatted_client_name.replace(char,'') + dico['client_name'] = preformatted_client_name if account.type in ("receivable", "payable"): dico['compte_tiers'] = dico['client_name'] else: -- 2.20.1