[PYTHON] ~clean client name

[burette/etudesetchantiersidf.git] / wizard / account_export_csv.py

diff --git a/wizard/account_export_csv.py b/wizard/account_export_csv.py
index 790e793..547c151 100644 (file)
--- 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: