Diana Rodríguez Martínez has proposed merging lp:~dr.clearcorp/openerp-costa-rica/6.1-l10n_cr_account_banking_cr_bcr into lp:openerp-costa-rica.
Requested reviews: CLEARCORP drivers (clearcorp-drivers) For more details, see: https://code.launchpad.net/~dr.clearcorp/openerp-costa-rica/6.1-l10n_cr_account_banking_cr_bcr/+merge/115566 [FIX] __init__.py [FIX] Fix for transactions in dollars -- https://code.launchpad.net/~dr.clearcorp/openerp-costa-rica/6.1-l10n_cr_account_banking_cr_bcr/+merge/115566 Your team CLEARCORP development team is subscribed to branch lp:openerp-costa-rica.
=== modified file 'l10n_cr_account_banking_cr_bcr/__init__.py' --- l10n_cr_account_banking_cr_bcr/__init__.py 2012-07-06 05:08:02 +0000 +++ l10n_cr_account_banking_cr_bcr/__init__.py 2012-07-18 14:58:26 +0000 @@ -19,6 +19,6 @@ # ############################################################################## -import bcr_mt940 +import bcr_format # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: === renamed file 'l10n_cr_account_banking_cr_bcr/bcr_mt940.py' => 'l10n_cr_account_banking_cr_bcr/bcr_format.py' --- l10n_cr_account_banking_cr_bcr/bcr_mt940.py 2012-07-06 05:08:02 +0000 +++ l10n_cr_account_banking_cr_bcr/bcr_format.py 2012-07-18 14:58:26 +0000 @@ -1,8 +1,9 @@ -# -*- encoding: utf-8 -*- +# -*- coding: utf-8 -*- ############################################################################## # -# Copyright (C) 2011 credativ Ltd (<http://www.credativ.co.uk>). -# All Rights Reserved +# OpenERP, Open Source Management Solution +# Addons modules by CLEARCORP S.A. +# Copyright (C) 2009-TODAY CLEARCORP S.A. (<http://clearcorp.co.cr>). # # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU Affero General Public License as @@ -18,12 +19,10 @@ # along with this program. If not, see <http://www.gnu.org/licenses/>. # ############################################################################## -# Import of BAC data in Swift MT940 format -# from account_banking.parsers import models from tools.translate import _ -from mt940_parser import BCRParser +from bcr_parser import BCRParser import re import osv import logging @@ -85,7 +84,7 @@ self.local_account = record['account_number'] def _statement_number(self, record): - self.id = self.local_account + self.id = record['id'] def _opening_balance(self, record): self.start_balance = float(record['startingbalance']) === renamed file 'l10n_cr_account_banking_cr_bcr/mt940_parser.py' => 'l10n_cr_account_banking_cr_bcr/bcr_parser.py' --- l10n_cr_account_banking_cr_bcr/mt940_parser.py 2012-07-12 19:58:25 +0000 +++ l10n_cr_account_banking_cr_bcr/bcr_parser.py 2012-07-18 14:58:26 +0000 @@ -1,9 +1,9 @@ -#!/usr/bin/env python -# -*- encoding: utf-8 -*- +# -*- coding: utf-8 -*- ############################################################################## # -# Copyright (C) 2011 credativ Ltd (<http://www.credativ.co.uk>). -# All Rights Reserved +# OpenERP, Open Source Management Solution +# Addons modules by CLEARCORP S.A. +# Copyright (C) 2009-TODAY CLEARCORP S.A. (<http://clearcorp.co.cr>). # # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU Affero General Public License as @@ -19,15 +19,13 @@ # along with this program. If not, see <http://www.gnu.org/licenses/>. # ############################################################################## - """ -Parser for BAC CR MT940 format files -Based on fi_patu's parser +Parser for BCR format files """ import re from datetime import datetime from dateutil import parser -import pprint +from pprint import PrettyPrinter from copy import copy class BCRParser( object ): @@ -45,11 +43,12 @@ 'endingbalance': 0.0, #_closing_balance 'bookingdate': '', #moving_date 'ammount': 0.0, + 'id': '', } #file = open( filename, 'r' ) #line = file.readline() - + cad = '' list_split = rec.split('\r\n') for l in list_split: @@ -59,6 +58,11 @@ #_account_number if l.find('Movimiento de Cuenta Corriente', 0, len('Movimiento de Cuenta Corriente')) > -1: line_dict['account_number'] = self.extract_number(l) + #cad = self.extract_currency_code_USD(l) + if l.find('D',0,len(l)) > -1: + line_dict['currencycode'] = 'USD' + else: + line_dict['currencycode'] = 'CRC' # _transmission_number if l.find('Solicitado el', 0, len('Solicitado el')) > -1 : line_dict['transref'] = self.extract_number(l) @@ -69,12 +73,18 @@ #_closing_balance if l.find('Saldo Final', 0, len('Saldo Final')) > -1: line_dict['endingbalance'] = self.extract_float(l) - + amount_statement = float( line_dict['startingbalance'] ) + float( line_dict['endingbalance'] ) line_dict['ammount'] = amount_statement + + date_str = self.parse_date_stamenent(line_dict['bookingdate']) + name = date_str + ' - ' + line_dict['account_number'] + line_dict['id'] = name self.line_dict = line_dict - + pp = PrettyPrinter() + pp.pprint(line_dict) + return line_dict def statement_lines ( self, rec ): @@ -93,6 +103,7 @@ lines = [] line_dict = {} + currencycode = '' list_split = rec.split('\r\n') entrada = False @@ -111,7 +122,15 @@ start += 1 else: break - start += 1 + start += 1 + + for l in list_split: + if l.find('Movimiento de Cuenta Corriente', 0, len('Movimiento de Cuenta Corriente')) > -1: + if l.find('D',0,len(l)) > -1: + currencycode = 'USD' + else: + currencycode = 'CRC' + break sub_list = list_split [start:end] for sub in sub_list: @@ -129,7 +148,7 @@ mapping['execution_date'] = date mapping['effective_date'] = date - mapping['local_currency'] = 'CRC' + mapping['local_currency'] = currencycode mapping['transfer_type'] = 'NTRF' mapping['reference'] = parser.extract_number(sub[18:26]) mapping['message'] = sub[27:80] @@ -153,6 +172,26 @@ lines.append(copy(mapping)) return lines + + def parse_date_stamenent(self,datestring): + try: + day = datestring[0:2] + month = datestring[2:4] + year = datestring[4:8] + hour = datestring[8:10] + minute = datestring[10:12] + second = datestring[12:14] + except Exception: + day = datestring[2] + month = datestring[4] + year = datestring[4:8] + hour = datestring[8:10] + minute = datestring[10:12] + second = datestring[12:14] + + date = datetime(int(year),int(month),int(day),int(hour),int(minute),int(second)) + date_string = date.strftime("%Y-%m-%d %H:%M:%S") + return date_string def parse_stamenent_record( self, rec ): @@ -214,6 +253,13 @@ for character in result: cad = cad + character return cad + + def extract_currency_code_USD(self, currency): + cad = '' + result = re.findall(r'[D.lares]',currency) + for character in result: + cad = cad + character + return cad def parse( self, cr, data ): records = []
_______________________________________________ Mailing list: https://launchpad.net/~clearcorp Post to : [email protected] Unsubscribe : https://launchpad.net/~clearcorp More help : https://help.launchpad.net/ListHelp
