Merge lp:~gs.clearcorp/openerp-costa-rica/7.0_l10n_cr_account_banking into lp:openerp-costa-rica

[Glen Sojo]

[FIX] l10n_cr_account_banking_cr_davivienda: Fixed missing line importing DaVivienda's bank statements file

[lp:~gs.clearcorp/openerp-costa-rica/7.0_l10n_cr_account_banking]

259. By Ronald Rubi on 2013-12-05

[MRG] l10n_cr_account_banking_cr_davivienda: Fixed missing line importing DaVivienda's bank statements file

=== removed directory 'TODO-7.0/l10n_cr_account_banking_cr_bac'
=== removed file 'TODO-7.0/l10n_cr_account_banking_cr_bac/__init__.py'
--- TODO-7.0/l10n_cr_account_banking_cr_bac/__init__.py	2012-07-12 00:37:04 +0000
+++ TODO-7.0/l10n_cr_account_banking_cr_bac/__init__.py	1970-01-01 00:00:00 +0000
@@ -1,23 +0,0 @@
-# -*- encoding: utf-8 -*-
-##############################################################################
-#
-#    Copyright (C) 2011 credativ Ltd (<http://www.credativ.co.uk>).
-#    All Rights Reserved
-#
-#    This program is free software: you can redistribute it and/or modify
-#    it under the terms of the GNU Affero General Public License as
-#    published by the Free Software Foundation, either version 3 of the
-#    License, or (at your option) any later version.
-#
-#    This program is distributed in the hope that it will be useful,
-#    but WITHOUT ANY WARRANTY; without even the implied warranty of
-#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-#    GNU Affero General Public License for more details.
-#
-#    You should have received a copy of the GNU Affero General Public License
-#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
-#
-##############################################################################
-
-import bac_mt940
-# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== removed file 'TODO-7.0/l10n_cr_account_banking_cr_bac/__openerp__.py'
--- TODO-7.0/l10n_cr_account_banking_cr_bac/__openerp__.py	2012-07-12 00:37:04 +0000
+++ TODO-7.0/l10n_cr_account_banking_cr_bac/__openerp__.py	1970-01-01 00:00:00 +0000
@@ -1,40 +0,0 @@
-# -*- coding: utf-8 -*-
-##############################################################################
-#
-#    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
-#    published by the Free Software Foundation, either version 3 of the
-#    License, or (at your option) any later version.
-#
-#    This program is distributed in the hope that it will be useful,
-#    but WITHOUT ANY WARRANTY; without even the implied warranty of
-#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-#    GNU Affero General Public License for more details.
-#
-#    You should have received a copy of the GNU Affero General Public License
-#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
-#
-##############################################################################
-
-{
-    'name': 'BAC Account Banking',
-    'version': '0.5',
-    'license': 'AGPL-3',
-    'author': 'CLEARCORP S.A.',
-    'website': 'http://www.clearcorp.co.cr',
-    'category': 'Account Banking',
-    'depends': ['account_banking'],
-    'init_xml': [],
-    'update_xml': [
-    ],
-    'demo_xml': [],
-    'description': '''
-    Module to import BAC CR format transation files (S.W.I.F.T MT940).
-    ''',
-    'active': False,
-    'installable': True,
-}

=== removed file 'TODO-7.0/l10n_cr_account_banking_cr_bac/bac_mt940.py'
--- TODO-7.0/l10n_cr_account_banking_cr_bac/bac_mt940.py	2013-02-22 22:35:48 +0000
+++ TODO-7.0/l10n_cr_account_banking_cr_bac/bac_mt940.py	1970-01-01 00:00:00 +0000
@@ -1,261 +0,0 @@
-# -*- encoding: utf-8 -*-
-##############################################################################
-#
-#    Copyright (C) 2011 credativ Ltd (<http://www.credativ.co.uk>).
-#    All Rights Reserved
-#
-#    This program is free software: you can redistribute it and/or modify
-#    it under the terms of the GNU Affero General Public License as
-#    published by the Free Software Foundation, either version 3 of the
-#    License, or (at your option) any later version.
-#
-#    This program is distributed in the hope that it will be useful,
-#    but WITHOUT ANY WARRANTY; without even the implied warranty of
-#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-#    GNU Affero General Public License for more details.
-#
-#    You should have received a copy of the GNU Affero General Public License
-#    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 BACParser
-import re
-import osv
-import logging
-import datetime
-
-bt = models.mem_bank_transaction
-logger = logging.getLogger('bac_mt940')
-
-def record2float(record, value):
-    if record['creditmarker'][-1] == 'C':
-        return float(record[value])
-    return -float(record[value])
-
-class transaction(models.mem_bank_transaction):
-
-    mapping = {
-        'execution_date' : 'valuedate',
-        'effective_date' : 'valuedate',
-        'local_currency' : 'currency',
-        'transfer_type' : 'bookingcode',
-        'reference' : 'custrefno',
-        'message' : 'furtherinfo',
-        'name' : 'infoline1'
-    }
-
-    type_map = {
-        'NTRF': bt.ORDER,
-        'NMSC': bt.ORDER,
-        'NPAY': bt.PAYMENT_BATCH,
-        'NCHK': bt.CHECK,
-        'NCLR': bt.ORDER,
-    }
-
-    def __init__(self, record, *args, **kwargs):
-        '''
-        Transaction creation
-        '''
-        super(transaction, self).__init__(*args, **kwargs)
-        for key, value in self.mapping.iteritems():
-            if record.has_key(value):
-                setattr(self, key, record[value])
-
-        self.transferred_amount = record2float(record, 'amount')
-
-        # Set the transfer type based on the bookingcode
-        if record.get('bookingcode','ignore') in self.type_map:
-            self.transfer_type = self.type_map[record['bookingcode']]
-        else:
-            # Default to the generic order, so it will be eligible for matching
-            self.transfer_type = bt.ORDER
-
-        if not self.is_valid():
-            logger.info("Invalid: %s", record)
-    def is_valid(self):
-        '''
-        We don't have remote_account so override base
-        '''
-        return (self.execution_date
-                and self.transferred_amount and True) or False
-
-class statement(models.mem_bank_statement):
-    '''
-    Bank statement imported data
-    '''
-
-    def import_record(self, record,**kwargs):
-        def _transmission_number():
-            self.id = record['transref']
-        def _account_number():
-            # The wizard doesn't check for sort code
-            self.local_account = record['sortcode'] + record['accnum']
-        def _statement_number():
-            self.id = self.local_account + '-' + record['statementnr']
-        def _opening_balance():
-            self.start_balance = record2float(record,'startingbalance')
-            self.local_currency = record['currencycode']
-        def _closing_balance():
-            self.end_balance = record2float(record, 'endingbalance')
-            today = datetime.datetime.today() 
-            dateString = today.strftime("%Y-%m-%d %H:%M:%S")
-            self.id = dateString + '-' + self.id
-        def _transaction_new():
-            self.transactions.append(transaction(record))
-        def _transaction_info():
-            self.transaction_info(record)
-        def _not_used():
-            logger.info("Didn't use record: %s", record)
-        def _forward_available():
-            self.end_balance = record2float(record, 'endingbalance')
-            self.date = record['bookingdate']
-
-        rectypes = {
-            '20' : _transmission_number,
-            '25' : _account_number,
-            '28' : _statement_number,
-            '28C': _statement_number,
-            '60F': _opening_balance,
-            '62F': _closing_balance,
-            '64' : _forward_available,
-           #'62M': _interim_balance,
-            '61' : _transaction_new,
-            '86' : _transaction_info,
-            }
-
-        rectypes.get(record['recordid'], _not_used)()
-
-    def transaction_info(self, record):
-        '''
-        Add extra information to transaction
-        '''
-        # Additional information for previous transaction
-        if len(self.transactions) < 1:
-            logger.info("Received additional information for non existent transaction:")
-            logger.info(record)
-        else:
-            transaction = self.transactions[-1]
-            #transaction.id = ','.join([record[k] for k in ['infoline{0}'.format(i) for i in range(2,5)] if record.has_key(k)])
-            transaction.id = record['infoline1']    
-
-def raise_error(message, line):
-    raise osv.osv.except_osv(_('Import error'),
-        'Error in import:%s\n\n%s' % (message, line))
-
-class parser_bac_mt940(models.parser):
-    code = 'BAC-MT940'
-    name = _('BAC Swift MT940 statement export')
-    country_code = 'CR'
-    doc = _('''\
-            This format is available through
-            the BAC web interface.
-            ''')
-
-    def parse(self, cr, data,**kwargs):
-        '''
-            ** Kwargs parameter is used for a dynamic list of parameters. 
-            The wizard imported extracts used in all parsers and not all parsers have all the necessary information in your file, 
-            so get information from the wizard and passed by the ** kwargs. 
-            Then in the parses that are needed, are extracted from the ** kwargs and if needed, 
-            the parser still works the same way without this parameter.
-            
-            The rest of the methods must receive this parameter. (As the method that parse the header and the lines).
-        '''
-        result = []        
-        parser = BACParser()
-        list_record = []
-        inversion_colocada = 0
-        
-        # Split into statements
-        statements = [st for st in re.split('[\r\n]*(?=:20:)', data)]
-        # Split by records
-        statement_list = [re.split('[\r\n ]*(?=:\d\d[\w]?:)', st) for st in statements]
-
-        for statement_lines in statement_list:
-            stmnt = statement()
-            
-            """EXTRACCION DE DATOS """
-            for record in statement_lines:               
-                records = parser.parse_record(record)
-
-                if records is not None:
-                    ############START PAGO CAPITAL INVERSION
-                    if records['recordid'] == '60F':
-                        start_balance = float(records['startingbalance'])
-                    if records['recordid'] == '61':
-                        amount = float(records['amount'])
-                    if records['recordid'] == '86' and records['infoline1'] == 'PAGO CAPITAL INVERSION':
-                        start_amount = amount
-                        start_balance += amount #con la suma ya realizada.
-                    ############END PAGO CAPITAL INVERSION
-                    
-                    ############START INVERSION COLOCADA
-                    if records['recordid'] == '86':
-                        cad = records['infoline1']
-                        if cad.find('INVERSION COLOCADA') > 0:
-                            inversion_colocada = amount
-                            
-                    if records['recordid'] == '62F':                                         
-                        ending_balance = (inversion_colocada + float(records['endingbalance']))
-
-            if records is not None:            
-                """ACTUALIZACION DE DATOS """
-                for record in statement_lines:   
-                    if record is not None:             
-                        records = parser.parse_record(record)    
-                
-                        if (records['recordid'] == '60F'):
-                            dic = {'startingbalance':start_balance}
-                            records.update(dic)
-                        
-                        if (records['recordid'] == '62F'):
-                            dic = {'endingbalance': ending_balance}
-                            records.update(dic)
-
-                        if (records['recordid'] == '64'):
-                            dic = {'endingbalance': ending_balance}
-                            records.update(dic)
-                            
-                        #SI LA LINEA NO ES INVERSION COLOCADA O PAGO CAPITAL INVERSION, SE AGREGA A LA LISTA
-                        #PAGO_CAPITAL
-                        if (records['recordid'] == '86'):
-                            cad = records['infoline1']
-                            
-                            if (cad != "PAGO CAPITAL INVERSION") and (cad.find("INVERSION COLOCADA") < 0): 
-                                list_record.append(records)
-                                
-                        if (records['recordid'] == '61'):
-                            try:
-                                if float(records['amount']) != start_amount and float(records['amount']) != inversion_colocada:
-                                    list_record.append(records)
-                            except:
-                                list_record.append(records)
-                        #####################################################################
-                        
-                        if (records['recordid'] != '61' and records['recordid'] != '86' ):
-                            list_record.append(records)                
-                
-                [stmnt.import_record(r) for r in list_record if r is not None]
-                
-                if stmnt.is_valid():
-                    result.append(stmnt)
-                    list_record = []
-                    inversion_colocada = 0
-                    start_balance = 0
-                else:
-                    logger.info("Invalid Statement:")
-                    logger.info(records[0])
-                    logger.info(records[1])
-                    logger.info(records[2])
-                    logger.info(records[3])
-                    logger.info(records[4])
-                    list_record = []
-
-        return result
-
-# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== removed file 'TODO-7.0/l10n_cr_account_banking_cr_bac/mt940_parser.py'
--- TODO-7.0/l10n_cr_account_banking_cr_bac/mt940_parser.py	2013-02-22 22:35:48 +0000
+++ TODO-7.0/l10n_cr_account_banking_cr_bac/mt940_parser.py	1970-01-01 00:00:00 +0000
@@ -1,153 +0,0 @@
-#!/usr/bin/env python
-# -*- encoding: utf-8 -*-
-##############################################################################
-#
-#    Copyright (C) 2011 credativ Ltd (<http://www.credativ.co.uk>).
-#    All Rights Reserved
-#
-#    This program is free software: you can redistribute it and/or modify
-#    it under the terms of the GNU Affero General Public License as
-#    published by the Free Software Foundation, either version 3 of the
-#    License, or (at your option) any later version.
-#
-#    This program is distributed in the hope that it will be useful,
-#    but WITHOUT ANY WARRANTY; without even the implied warranty of
-#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-#    GNU Affero General Public License for more details.
-#
-#    You should have received a copy of the GNU Affero General Public License
-#    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
-"""
-import re
-from datetime import datetime
-
-class BACParser(object):
-
-    def __init__( self ):
-        recparse = dict()
-        patterns = {'ebcdic': "\w/\?:\(\).,'+{} -"}
-
-        # MT940 header
-        recparse["20"] = ":(?P<recordid>20):(?P<transref>.{1,16})"
-        recparse["25"] = ":(?P<recordid>25):(?P<sortcode>\d{6})(?P<accnum>\d{1,29})"
-        recparse["28"] = ":(?P<recordid>28C?):(?P<statementnr>.{1,8})"
-
-        # Opening balance 60F
-        recparse["60F"] = ":(?P<recordid>60F):(?P<creditmarker>[CD])" \
-                + "(?P<prevstmtdate>\d{6})(?P<currencycode>.{3})" \
-                + "(?P<startingbalance>[\d,]{1,15})"
-
-        # Transaction
-        recparse["61"] = ":(?P<recordid>61):" \
-                + "(?P<valuedate>\d{6})(?P<bookingdate>\d{4})?" \
-                + "(?P<creditmarker>R?[CD])" \
-                + "(?P<amount>[\d,]{1,15})" \
-                + "(?P<bookingcode>[A-Z]{4})" \
-                + "(?P<custrefno>[\d,]{1,16})" \
-                + "(?P<bankref>[%(ebcdic)s]{1,16})?" \
-                + "(?:\n(?P<furtherinfo>[%(ebcdic)s]))?" \
-        % (patterns)
-
-        # Further info
-        recparse["86"] = ":(?P<recordid>86):" \
-                + "(?P<infoline1>.{1,80})?" \
-                + "(?:\n(?P<infoline2>.{1,80}))?" \
-                + "(?:\n(?P<infoline3>.{1,80}))?" \
-                + "(?:\n(?P<infoline4>.{1,80}))?" \
-                + "(?:\n(?P<infoline5>.{1,80}))?"
-
-        # Forward available balance (64) /  Closing balance (62F) / Interim balance (62M)
-        recparse["64"] = ":(?P<recordid>64|62[FM]):" \
-                + "(?P<creditmarker>[CD])" \
-                + "(?P<bookingdate>\d{6})(?P<currencycode>.{3})" \
-                + "(?P<endingbalance>[\d,]{1,15})"
-
-        for record in recparse:
-            recparse[record] = re.compile(recparse[record])
-        self.recparse = recparse
-
-
-    def parse_record(self, line,**kwargs):
-        """
-        Parse record using regexps and apply post processing
-        """
-        for matcher in self.recparse:
-            matchobj = self.recparse[matcher].match(line)
-            if matchobj:
-                break
-        if not matchobj:
-            print " **** failed to match line '%s'" % (line)
-            return
-        # Strip strings
-        matchdict = matchobj.groupdict()
-
-        # Remove members set to None
-        matchdict=dict([(k,v) for k,v in matchdict.iteritems() if v])
-
-        matchkeys = set(matchdict.keys())
-        needstrip = set(["transref", "accnum", "statementnr", "custrefno",
-            "bankref", "furtherinfo", "infoline1", "infoline2", "infoline3",
-            "infoline4", "infoline5", "startingbalance", "endingbalance"])
-        for field in matchkeys & needstrip:
-            matchdict[field] = matchdict[field].strip()
-
-        # Convert to float. Comma is decimal separator
-        needsfloat = set(["startingbalance", "endingbalance", "amount"])
-        for field in matchkeys & needsfloat:
-            matchdict[field] = float(matchdict[field].replace(',','.'))
-
-        # Convert date fields
-        needdate = set(["prevstmtdate", "valuedate", "bookingdate"])
-        for field in matchkeys & needdate:
-            datestring = matchdict[field]
-
-            post_check = False
-            if len(datestring) == 4 and field=="bookingdate" and matchdict.has_key("valuedate"):
-                # Get year from valuedate
-                datestring = matchdict['valuedate'].strftime('%y') + datestring
-                post_check = True
-            try:
-                matchdict[field] = datetime.strptime(datestring,'%y%m%d')
-                if post_check and matchdict[field] > matchdict["valuedate"]:
-                    matchdict[field]=matchdict[field].replace(year=matchdict[field].year-1)
-            except ValueError:
-                matchdict[field] = None
-
-        return matchdict
-
-    def parse(self, cr, data):
-        records = []
-        # Some records are multiline
-        for line in data:
-            if len(line) <= 1:
-                continue
-            if line[0] == ':' and len(line) > 1:
-                records.append(line)
-            else:
-                records[-1] = '\n'.join([records[-1], line])
-
-        output = []
-        for rec in records:
-            output.append(self.parse_record(rec))
-
-        return output
-
-def parse_file(filename):
-    bacfile = open(filename, "r")
-    p = BACParser().parse(bacfile.readlines())
-
-def main():
-    """The main function, currently just calls a dummy filename
-
-    :returns: description
-    """
-    parse_file("testfile")
-
-if __name__ == '__main__':
-    main()

=== removed directory 'TODO-7.0/l10n_cr_account_banking_cr_bcr'
=== removed file 'TODO-7.0/l10n_cr_account_banking_cr_bcr/__init__.py'
--- TODO-7.0/l10n_cr_account_banking_cr_bcr/__init__.py	2012-07-18 03:20:08 +0000
+++ TODO-7.0/l10n_cr_account_banking_cr_bcr/__init__.py	1970-01-01 00:00:00 +0000
@@ -1,24 +0,0 @@
-# -*- encoding: utf-8 -*-
-##############################################################################
-#
-#    Copyright (C) 2011 credativ Ltd (<http://www.credativ.co.uk>).
-#    All Rights Reserved
-#
-#    This program is free software: you can redistribute it and/or modify
-#    it under the terms of the GNU Affero General Public License as
-#    published by the Free Software Foundation, either version 3 of the
-#    License, or (at your option) any later version.
-#
-#    This program is distributed in the hope that it will be useful,
-#    but WITHOUT ANY WARRANTY; without even the implied warranty of
-#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-#    GNU Affero General Public License for more details.
-#
-#    You should have received a copy of the GNU Affero General Public License
-#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
-#
-##############################################################################
-
-import bcr_format
-
-# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== removed file 'TODO-7.0/l10n_cr_account_banking_cr_bcr/__openerp__.py'
--- TODO-7.0/l10n_cr_account_banking_cr_bcr/__openerp__.py	2012-07-06 05:08:02 +0000
+++ TODO-7.0/l10n_cr_account_banking_cr_bcr/__openerp__.py	1970-01-01 00:00:00 +0000
@@ -1,37 +0,0 @@
-# -*- coding: utf-8 -*-
-##############################################################################
-#
-#    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
-#    published by the Free Software Foundation, either version 3 of the
-#    License, or (at your option) any later version.
-#
-#    This program is distributed in the hope that it will be useful,
-#    but WITHOUT ANY WARRANTY; without even the implied warranty of
-#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-#    GNU Affero General Public License for more details.
-#
-#    You should have received a copy of the GNU Affero General Public License
-#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
-#
-##############################################################################
-
-{
-    'name': 'BCR Account Banking',
-    'version': '0.5',
-    'license': 'AGPL-3',
-    'author': 'CLEARCORP S.A.',
-    'website': 'http://www.clearcorp.co.cr',
-    'category': 'Account Banking',
-    'depends': ['account_banking'],
-    'init_xml': [],
-    'update_xml': [],
-    'demo_xml': [],
-    'description': '',
-    'active': False,
-    'installable': True,
-}

=== removed file 'TODO-7.0/l10n_cr_account_banking_cr_bcr/bcr_format.py'
--- TODO-7.0/l10n_cr_account_banking_cr_bcr/bcr_format.py	2013-02-22 22:35:48 +0000
+++ TODO-7.0/l10n_cr_account_banking_cr_bcr/bcr_format.py	1970-01-01 00:00:00 +0000
@@ -1,174 +0,0 @@
-# -*- coding: utf-8 -*-
-##############################################################################
-#
-#    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
-#    published by the Free Software Foundation, either version 3 of the
-#    License, or (at your option) any later version.
-#
-#    This program is distributed in the hope that it will be useful,
-#    but WITHOUT ANY WARRANTY; without even the implied warranty of
-#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-#    GNU Affero General Public License for more details.
-#
-#    You should have received a copy of the GNU Affero General Public License
-#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
-#
-##############################################################################
-
-from account_banking.parsers import models
-from tools.translate import _
-from bcr_parser import BCRParser
-import re
-import osv
-import logging
-import pprint
-from datetime import datetime
-
-bt = models.mem_bank_transaction
-logger = logging.getLogger( 'bcr_mt940' )
-
-def record2float(record, value):
-    if record == 'C':
-        return float (value)
-    else:
-        return -float(value)
-
-class transaction(models.mem_bank_transaction):
-
-    mapping = {
-        'execution_date' : '',
-        'effective_date' : '',
-        'local_currency' : '',
-        'transfer_type' : '',
-        'reference' : '',
-        'message' : '',
-        'name' : '',
-        'amount': '',
-        'creditmarker': '',
-    }
-
-    def __init__(self, record, *args, **kwargs):
-        
-        '''
-        Transaction creation
-        '''
-        super(transaction, self).__init__(*args, **kwargs)
-        #for r in record:
-        for key, value in record.iteritems():
-            if record.has_key(key):
-                setattr(self, key, record[key])
-
-        if not self.is_valid():
-            logger.info("Invalid: %s", record)
-    
-    def is_valid(self):
-        '''
-        We don't have remote_account so override base
-        '''
-        return (self.execution_date
-                and self.transferred_amount and True) or False
-
-class statement(models.mem_bank_statement):
-    '''
-    Bank statement imported data    '''
-      
-    def _transmission_number(self, record):
-        self.id = record['transref']
-        
-    def _account_number(self, record):
-        self.local_account = record['account_number']
-        
-    def _statement_number(self, record):
-        self.id = record['id']
-        
-    def _opening_balance(self, record):
-        self.start_balance = float(record['startingbalance'])
-        self.local_currency = record['currencycode']
-    
-    def _closing_balance(self, record):
-        self.end_balance = float(record['endingbalance'])
-        self.date = record['bookingdate']
-     
-    def _transaction_new(self, record):
-        parser = BCRParser()
-        sub_record = parser.statement_lines(record) #dictionary
-        for sub in sub_record:
-            self.transactions.append(transaction(sub))
-    
-    #def _transaction_info():
-        #self.transaction_info(record)
-    
-    def _not_used():
-        logger.info("Didn't use record: %s", record)
-        
-    def _forward_available(self, record):
-        self.end_balance =  float(record['endingbalance'])
-        self.date = record['bookingdate'] 
-    
-    def _execution_date_transferred_amount (self, record):        
-        self.execution_date = record['bookingdate']       
-        self.transferred_amount = float(record['ammount'])
-
-    def transaction_info(self, record):
-        '''
-        Add extra information to transaction
-        '''
-        # Additional information for previous transaction
-        if len(self.transactions) < 1:
-            logger.info("Received additional information for non existent transaction:")
-            logger.info(record)
-        else:
-            transaction = self.transactions[-1]
-            transaction.id = ','.join([record[k] for k in ['infoline{0}'.format(i) for i in range(2,5)] if record.has_key(k)])
-
-def raise_error(message, line):
-    raise osv.osv.except_osv(_('Import error'),
-        'Error in import:%s\n\n%s' % (message, line))
-
-class parser_bcr_mt940( models.parser ):
-    code = 'BCR-MT940'
-    name = _( 'BCR statement import' )
-    country_code = 'CR'
-    doc = _('''\
-            This format is available through
-            the BCR  web interface.
-            ''')
-
-    def parse(self, cr, data, **kwargs):
-        
-        '''
-            ** Kwargs parameter is used for a dynamic list of parameters. 
-            The wizard imported extracts used in all parsers and not all parsers have all the necessary information in your file, 
-            so get information from the wizard and passed by the ** kwargs. 
-            Then in the parses that are needed, are extracted from the ** kwargs and if needed, 
-            the parser still works the same way without this parameter.
-            
-            The rest of the methods must receive this parameter. (As the method that parse the header and the lines).
-        '''
-        
-        result = []
-        parser = BCRParser()
-        stmnt = statement()
-        
-        records = parser.parse_stamenent_record(data)        
-        
-        stmnt._transmission_number(records)
-        stmnt._account_number(records)
-        stmnt._statement_number(records)
-        stmnt._opening_balance(records)
-        stmnt._closing_balance(records)
-        stmnt._forward_available(records)
-        stmnt._execution_date_transferred_amount (records)
-        stmnt._transaction_new(data)
-                  
-        if stmnt.is_valid():
-            result.append(stmnt)
-                      
-        return result
-
-# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== removed file 'TODO-7.0/l10n_cr_account_banking_cr_bcr/bcr_parser.py'
--- TODO-7.0/l10n_cr_account_banking_cr_bcr/bcr_parser.py	2013-02-22 22:35:48 +0000
+++ TODO-7.0/l10n_cr_account_banking_cr_bcr/bcr_parser.py	1970-01-01 00:00:00 +0000
@@ -1,366 +0,0 @@
-# -*- coding: utf-8 -*-
-##############################################################################
-#
-#    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
-#    published by the Free Software Foundation, either version 3 of the
-#    License, or (at your option) any later version.
-#
-#    This program is distributed in the hope that it will be useful,
-#    but WITHOUT ANY WARRANTY; without even the implied warranty of
-#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-#    GNU Affero General Public License for more details.
-#
-#    You should have received a copy of the GNU Affero General Public License
-#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
-#
-##############################################################################
-"""
-Parser for BCR format files
-"""
-import re
-from datetime import datetime
-from dateutil import parser
-from pprint import PrettyPrinter
-from copy import copy
-
-class BCRParser( object ):
-    """
-    Para noviembre de 2012 se cambia el formato del archivo del BCR. Se cambia el encabezado del archivo
-    así como el final del mismo. Además en la parte de abajo cambia el formato y visualización de los
-    saldos finales. 
-    
-    El cambio más evidente es el formato de la cuenta de banco, pasa de 1-246447-0 a 001-0246447-0
-    Revisión # 1                                                                         Revisión#2
-    Encabezado anterior:                                                                 Encabezado nuevo
-        BANCO DE COSTA RICA                                                              BANCO DE COSTA RICA
-        Movimiento de Cuenta Corriente 1-246447-0 Colones (puede ser Dólares o Dolares)  MOVIMIENTO DE LA CUENTA  CORRIENTE No. 001-0246447-0  COLONES (DOLARES)
-        Dueño: COMPA IA INMOBILIARIA CENTROA                                             DUENO: COMPA IA INMOBILIARIA CENTROAMERICANA CICCR S                            
-        Movimiento realizado el periodo del 01-10-2012 al 31-10-2012                     MOVIMIENTO REALIZADO                           DEL 01-11-2012 AL 30-11-2012
-    
-    Final de archivo
-    Revisión # 1                                                        Revisión #2
-    TOTALES DEL MOVIMIENTO CONTABILIZADO                                TOTALES DEL MOVIMIENTO CONTABILIZADO 
-          Cantidad  -------Monto--------                                CANTIDAD    -------MONTO-------- 
-    Débitos       239       81,876,681.22                               DEBITOS       209        67,553,414.30                                                                                                                                
-    Créditos       27       92,636,599.01                               CREDITOS        8        66,086,326.53
-
-    Saldo Inicial            21,682,799.04                              -------- SALDOS --------                            
-    Saldo Final              33,992,829.43                              INICIAL             33,992,829.43
-                                                                        FINAL               32,525,741.66
-    Solicitado el 01/11/2012 20:03:34                                   SOLICITADO EL 01-12-2012 A LAS 15:36:15:17                                       
-    """
-    def statement_record ( self, rec, **kwargs):
-        lines = []
-        line_dict = {}
-
-        line_dict = {
-            'transref': 0.0, # _transmission_number
-            'account_number': '', #_account_number
-            'statementnr':'', # statement_number
-            'startingbalance': 0.0, #_opening_balance
-            'currencycode': 'CRC', #currencycode
-            'endingbalance': 0.0, #_closing_balance
-            'bookingdate': '', #moving_date
-            'ammount': 0.0,
-            'id': '',
-        }
-
-        cad = ''
-        list_split = rec.split('\r\n')
-
-        for l in list_split:
-            
-            # _transmission_number -> FIRST REVISION
-            if (l.find('Movimiento realizado el periodo', 0, len('Movimiento realizado el periodo')) > -1):
-                line_dict['statementnr'] = self.extract_number(l)
-            # _transmission_number -> SECOND REVISION
-            elif (l.find('MOVIMIENTO REALIZADO', 0, len('MOVIMIENTO REALIZADO')) > -1):
-                line_dict['statementnr'] = self.extract_number(l)   
-                           
-            #_account_number -> FIRST REVISION
-            if l.find('Movimiento de Cuenta Corriente', 0, len('Movimiento de Cuenta Corriente')) > -1:
-                line_dict['account_number'] = self.extract_number(l)                
-                if (l.find('D',0,len(l)) > -1):
-                    line_dict['currencycode'] = 'USD'
-                else:
-                    line_dict['currencycode'] = 'CRC'
-            #_account_number -> SECOND REVISION        
-            elif (l.find('MOVIMIENTO DE LA CUENTA  CORRIENTE No.', 0, len('MOVIMIENTO DE LA CUENTA  CORRIENTE No.')) > -1):
-                account_str = self.extract_number(l)   
-                #001-0246447-0
-                account_1 = account_str[2:3] #1
-                account_2 = account_str[4:]  #246447-0
-                account_complete = account_1+self.extract_number(account_2)#12464470
-                line_dict['account_number'] = self.extract_number(account_complete)
-                if (l.find('DOLARES',0,len(l)) > -1):
-                    line_dict['currencycode'] = 'USD'
-                else:
-                    line_dict['currencycode'] = 'CRC'                      
-             
-            #FECHA Y HORA -> FIRST REVISION 
-            if (l.find('Solicitado el', 0, len('Solicitado el'))  > -1):
-                date =  hour = cad = ''
-                date = self.extract_date_regular_expresion(l)
-                if len(date) > 0:                   
-                    hour = self.extract_hour_regular_expresion(l)
-                cad = date + ' ' + hour                
-                line_dict['transref'] = cad
-                line_dict['bookingdate'] = cad
-            #FECHA Y HORA -> SECOND REVISION 
-            elif (l.find('SOLICITADO EL', 0, len('SOLICITADO EL'))  > -1):
-                date =  hour = cad = ''
-                date = self.extract_date_regular_expresion(l)
-                if len(date) > 0:                   
-                    hour = self.extract_hour_regular_expresion(l)
-                cad = date + ' ' + hour                
-                line_dict['transref'] = cad
-                line_dict['bookingdate'] = cad        
-                               
-            #_opening_balance -> FIRST REVISION
-            if l.find('Saldo Inicial', 0, len('Saldo Inicial'))  > -1:
-                line_dict['startingbalance'] = self.extract_float(l)
-            #_opening_balance -> SECOND REVISION   
-            elif l.find('INICIAL', 0, len('INICIAL'))  > -1:
-                line_dict['startingbalance'] = self.extract_float(l)
-                    
-            #_closing_balance -> FIRST REVISION
-            if l.find('FINAL', 0, len('FINAL'))  > -1:
-                line_dict['endingbalance'] = self.extract_float(l)
-            #_closing_balance -> SECOND REVISION    
-            elif l.find('Saldo Final', 0, len('Saldo Final'))  > -1:
-                line_dict['endingbalance'] = self.extract_float(l)
-                    
-        line_dict['ammount'] = float( line_dict['startingbalance'] ) + float( line_dict['endingbalance'] )
-        line_dict['id'] = line_dict['bookingdate'] + ' - ' + line_dict['account_number']
-        self.line_dict = line_dict
-      
-        return line_dict
-            
-    def statement_lines ( self, rec ):
-        parser = BCRParser()
-        mapping = {
-            'execution_date' : '',
-            'effective_date' : '',
-            'local_currency' : '',
-            'transfer_type' : '',
-            'reference' : '',
-            'message' : '',
-            'name' : '',
-            'transferred_amount': '',
-            'creditmarker': '',
-        }
-        
-        lines = []
-        line_dict = {}
-        currencycode = ''
-        
-        list_split = rec.split('\r\n')
-        entrada = False
-        start = 0
-        end = 0
-        
-        for l in list_split: 
-            if l.find('TOTALES DEL MOVIMIENTO CONTABILIZADO', 0, len('TOTALES DEL MOVIMIENTO CONTABILIZADO')) <= -1:
-                end += 1
-            else:
-                break                
-        end = end - 1
-        
-        for l in list_split:           
-            if l.find('-CONTABLE-', 0, len('-CONTABLE-')) <= -1:
-                start += 1
-            else:
-                break
-        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
-            
-            elif l.find('MOVIMIENTO DE LA CUENTA  CORRIENTE No.', 0, len('MOVIMIENTO DE LA CUENTA  CORRIENTE No.')) > -1:
-                if (l.find('DOLARES',0,len(l)) > -1):
-                    currencycode = 'USD'
-                else:
-                    currencycode = 'CRC'
-                break
-            
-        sub_list = list_split [start:end]
-        for sub in sub_list:
-            #effective_date
-            date_str = ''
-            date_str = self.extract_date_regular_expresion_line(sub,0)
-            date= datetime.strptime(date_str, "%d-%m-%y")               
-            mapping['effective_date'] = date #fecha_contable.
-            
-            #execution_date
-            date_str = self.extract_date_regular_expresion_line(sub,1)
-            date = datetime.strptime(date_str, "%d-%m-%y")
-            mapping['execution_date'] = date #fecha_movimiento                       
-           
-            mapping['local_currency'] = currencycode
-            mapping['transfer_type'] = 'NTRF'
-            mapping['reference'] = parser.extract_number(sub[18:26])
-            mapping['message'] = sub[27:80]                
-            mapping['name'] = sub[27:80]
-            mapping['id'] = sub[27:80]
-            
-            amount = sub[106:]
-            amount.replace('\t',' ')
-            debit = amount[0:16]
-            credit = amount[16:]
-            
-            if (parser.extract_float(debit) is not ''): #debit
-                cad = parser.extract_float(debit)
-                mapping['transferred_amount'] = -float(cad)      
-                mapping['creditmarker'] = 'C'
-                                      
-            else: #credit
-                cad = parser.extract_float (credit)
-                mapping['transferred_amount'] =  float(cad)
-            
-            lines.append(copy(mapping))
-                            
-        return lines    
-    
-    def parse_stamenent_record( self, rec, **kwargs):
-
-        matchdict = dict()
-
-        matchdict = self.statement_record( rec, **kwargs );
-
-        # Remove members set to None
-        matchdict = dict( [( k, v ) for k, v in matchdict.iteritems() if v] )
-
-        matchkeys = set( matchdict.keys() )
-        needstrip = set( [ 'transref', 'account_number', 'statementnr', 'currencycode', 'endingbalance', 'bookingdate'] )
-
-        for field in matchkeys & needstrip:
-            matchdict[field] = matchdict[field].strip()
-
-        # Convert to float. Comma is decimal separator
-        needsfloat = set( ["startingbalance", "endingbalance", "amount"] )
-        for field in matchkeys & needsfloat:
-            matchdict[field] = float( matchdict[field].replace( ',', '.' ) )
-
-        # Convert date fields
-        needdate = set( ["bookingdate"] )
-                
-        for field in matchkeys & needdate:            
-            datestring = matchdict[field]
-            date = self.extract_date_regular_expresion(datestring)
-            hour = self.extract_hour_regular_expresion(datestring)
-            
-            date_complete = date + ' ' + hour
-            try:
-                #FORMAT DATE REVISION # 1
-                date_obj= datetime.strptime(date_complete, "%d/%m/%Y %H:%M:%S")
-            except:
-                #FORMAT DATE REVISION # 2
-                date_obj= datetime.strptime(date_complete, "%d-%m-%Y %H:%M:%S")
-            matchdict[field] = date_obj
-        
-        return matchdict
-                    
-    def extract_number( self, account_number ):
-        cad = ''
-        result = re.findall(r'[0-9]+', account_number)
-               
-        for character in result:
-            cad = cad + character
-        return cad
-
-    def extract_float ( self, ammount ):
-        cad = ''
-        result = re.findall(r"[-+]?\d*\.\d+|\d+",ammount)
-        
-        for character in result:
-            cad = cad + character       
-        return cad
-    
-    def extract_date_regular_expresion(self, date):
-        cad = ''
-        result = []
-        date_string = ''
-        #re.findall('[0-9]{1,2}-[0-9]{1,2}-[0-9]{4}',str)[0]+' '+re.findall('[0-9]{2}:[0-9]{2}:[0-9]{2}',str)[0]
-        #FORMAT DATE FIRST REVISION
-        result = re.findall('[0-9]{1,2}/[0-9]{1,2}/[0-9]{4}', date)
-       
-        if len(result) == 0:
-            #FORMAT DATE SECOND REVISION
-            result = re.findall('[0-9]{1,2}-[0-9]{1,2}-[0-9]{4}',date)      
-        
-        for character in result:
-            cad = cad + character       
-        return cad
-    
-    #with the pos parameter is said which of the two dates must be brought
-    #result brings a list of two elements, the post tells us to choose    
-    def extract_date_regular_expresion_line(self, date, pos):
-        cad = ''
-        result = []
-        date_string = ''
-        result = re.findall('([0-9]{2}-[0-9]{2}-[0-9]{2})[\s]*',date)      
-        date_str = result[pos]
-        
-        for character in date_str:
-            cad = cad + character       
-        return cad
-    
-    def extract_hour_regular_expresion(self, date):
-        cad = ''
-        result = []
-
-        result = re.findall('[0-9]{2}:[0-9]{2}:[0-9]{2}',date)             
-        
-        for character in result:
-            cad = cad + character       
-        return cad
-
-    def extract_currency_code_USD(self, currency):
-        cad = ''
-        result = re.findall('[D.lares]',currency)
-        for character in result:
-            cad = cad + character
-        return cad
-
-    def parse( self, cr, data ):
-        records = []
-        # Some records are multiline
-        for line in data:
-            if len(line) <= 1:
-                continue
-            if line[0] == ':' and len(line) > 1:
-                records.append(line)
-            else:
-                records[-1] = '\n'.join([records[-1], line])
-                
-        output = []
-
-        for rec in records:
-            output.append( self.parse_stamenent_record( rec ) )
-                
-        return output
-
-def parse_file( filename ):
-    bacfile = open( filename, "r" )
-    p = BCRParser().parse( bacfile.readlines() )
-
-def main():
-    """The main function, currently just calls a dummy filename
-
-    :returns: description
-    """
-    parse_file("testfile")
-
-if __name__ == '__main__':
-    main()
-

=== modified file 'l10n_cr_account_banking_cr_davivienda/davivienda_parser.py'
--- l10n_cr_account_banking_cr_davivienda/davivienda_parser.py	2013-12-04 17:39:51 +0000
+++ l10n_cr_account_banking_cr_davivienda/davivienda_parser.py	2013-12-05 22:58:17 +0000
@@ -148,12 +148,11 @@
         #last line can be blanck, find the last line with data.
         if last_line == "":
             while True:
-                end -= 1
                 last_line = list_split[end]
                 if last_line is not "":
                     break
-                    
-        sub_list = list_split [start:end]
+                end -= 1
+        sub_list = list_split [start:end+1]
         for sub in sub_list:
             line = sub.split(';')
             #effective_date