Merge lp:~pedro.baeza/banking-addons/7.0-account_statement_ofx_import into lp:banking-addons/bank-statement-reconcile-70

[Pedro Manuel Baeza]

[ADD] account_statement_ofx_import: Allows to import OFX (Open Financial Exchange) statement files, using 'account_statement_base_import' generic inheritance mechanism to import statements.

[ADD] account_statement_ofx_import: Allows to import OFX (Open Financial Exchange) statement files, using 'account_statement_base_import' generic inheritance mechanism to import statements.

[Joël Grand-Guillaume @ camptocamp (jgrandguillaume-c2c)]

Hi Perdo,

Thanks for the contribs !

LGTM,

review: Approve (code review, no tests)

[Omar (Pexego) (omar7r)]

LGTM

review: Approve (code review, no test)

[Leonardo Pistone (lepistone)]

Hi,

sorry for not having checked before, but the __openerp__ has a syntax error at line 66.

Thanks!

review: Needs Fixing (test)

=== added directory 'account_statement_ofx_import'
=== added file 'account_statement_ofx_import/__init__.py'
--- account_statement_ofx_import/__init__.py	1970-01-01 00:00:00 +0000
+++ account_statement_ofx_import/__init__.py	2013-11-04 12:25:22 +0000
@@ -0,0 +1,22 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Pedro Manuel Baeza Romero
+#    Copyright 2013 Servicios Tecnológicos Avanzados
+#
+#    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 statement
+import parser
 
=== added file 'account_statement_ofx_import/__openerp__.py'
--- account_statement_ofx_import/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_statement_ofx_import/__openerp__.py	2013-11-04 12:25:22 +0000
@@ -0,0 +1,49 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Pedro Manuel Baeza Romero
+#    Copyright 2013 Servicios Tecnológicos Avanzados
+#    Financed by AB Internet (http://www.abinternet.co.uk/)
+#
+#    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': "Bank statement OFX import",
+    'version': '1.0',
+    'author': 'Servicios Tecnológicos Avanzados - Pedro M. Baeza',
+    'maintainer': 'Pedro M. Baeza',
+    'category': 'Finance',
+    'complexity': 'normal',
+    'depends': [
+        'account_statement_base_import',
+    ],
+    'external_dependencies': {
+        'python': ['ofxparse'],
+    }
+    'description': """
+    Allows to import OFX (Open Financial Exchange) statement files, using
+    *account_statement_base_import* generic inheritance mechanism to import 
+    statements.
+    
+    It requires ofxparse library to work.
+    """,
+    'website': 'http://www.serviciosbaeza.com',
+    'data': [],
+    'test': [],
+    'installable': True,
+    'images': [],
+    'auto_install': False,
+    'license': 'AGPL-3',
+}
 
=== added directory 'account_statement_ofx_import/parser'
=== added file 'account_statement_ofx_import/parser/__init__.py'
--- account_statement_ofx_import/parser/__init__.py	1970-01-01 00:00:00 +0000
+++ account_statement_ofx_import/parser/__init__.py	2013-11-04 12:25:22 +0000
@@ -0,0 +1,22 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Pedro Manuel Baeza Romero
+#    Copyright 2013 Servicios Tecnológicos Avanzados
+#
+#    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 . import ofx_parser
+
 
=== added file 'account_statement_ofx_import/parser/ofx_parser.py'
--- account_statement_ofx_import/parser/ofx_parser.py	1970-01-01 00:00:00 +0000
+++ account_statement_ofx_import/parser/ofx_parser.py	2013-11-04 12:25:22 +0000
@@ -0,0 +1,118 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Pedro Manuel Baeza Romero
+#    Copyright 2013 Servicios Tecnológicos Avanzados
+#
+#    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 openerp.tools.translate import _
+from account_statement_base_import.parser import BankStatementImportParser
+import tempfile
+import datetime
+
+try:
+    import ofxparse
+except:
+    raise Exception(_('Please install python lib ofxparse'))
+
+class OfxParser(BankStatementImportParser):
+    """
+    Class for defining parser for OFX file format.
+    """
+    
+    def __init__(self, parser_name, *args, **kwargs):
+        """
+        """
+        super(OfxParser, self).__init__(parser_name, *args, **kwargs)
+
+    @classmethod
+    def parser_for(cls, parser_name):
+        """
+        Used by the new_bank_statement_parser class factory. Return true if
+        the providen name is 'ofx_so'.
+        """
+        return parser_name == 'ofx_so'
+
+    def _custom_format(self, *args, **kwargs):
+        """
+        No other work on data are needed in this parser.
+        """
+        return True
+
+    def _pre(self, *args, **kwargs):
+        """
+        No pre-treatment needed for this parser.
+        """
+        return True
+
+    def _parse(self, *args, **kwargs):
+        """
+        Launch the parsing itself.
+        """
+        ofx_file = tempfile.NamedTemporaryFile()
+        ofx_file.seek(0)
+        ofx_file.write(self.filebuffer)
+        ofx_file.flush()
+        ofx = ofxparse.OfxParser.parse(file(ofx_file.name))
+        ofx_file.close()
+        res = []
+        for transaction in ofx.account.statement.transactions:
+            res.append({
+                'date': transaction.date,
+                'amount': transaction.amount,
+                'ref': transaction.type,
+                'label': transaction.payee,
+            })
+        self.result_row_list = res
+        return True
+
+    def _validate(self, *args, **kwargs):
+        """
+        Nothing to do here. ofxparse trigger possible format errors.
+        """
+        return True
+
+    def _post(self, *args, **kwargs):
+        """
+        Nothing is needed to do after parsing.
+        """
+        return True
+
+    def _post(self, *args, **kwargs):
+        """
+        Nothing to do.
+        """
+        return True
+
+    def get_st_line_vals(self, line, *args, **kwargs):
+        """
+        This method must return a dict of vals that can be passed to create
+        method of statement line in order to record it. It is the
+        responsibility of every parser to give this dict of vals, so each one
+        can implement his own way of recording the lines.
+            :param: line: a dict of vals that represent a line of
+                result_row_list
+            :return: dict of values to give to the create method of statement
+                line
+        """
+        return {
+            'name': line.get('label', line.get('ref', '/')),
+            'date': line.get('date', datetime.datetime.now().date()),
+            'amount': line.get('amount', 0.0),
+            'ref': line.get('ref', '/'),
+            'label': line.get('label', ''),
+        }
+
 
=== added file 'account_statement_ofx_import/statement.py'
--- account_statement_ofx_import/statement.py	1970-01-01 00:00:00 +0000
+++ account_statement_ofx_import/statement.py	2013-11-04 12:25:22 +0000
@@ -0,0 +1,46 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    Author: Pedro Manuel Baeza Romero
+#    Copyright 2013 Servicios Tecnológicos Avanzados
+#
+#    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 openerp.tools.translate import _
+from openerp.osv import fields, orm
+
+class AccountStatementProfil(orm.Model):
+    _inherit = "account.statement.profile"
+
+    def get_import_type_selection(self, cr, uid, context=None):
+        """
+        Inherited from parent to add parser.
+        """
+        selection = super(AccountStatementProfil, self
+                          ).get_import_type_selection(cr, uid,
+                                                      context=context)
+        selection.append(('ofx_so', _('OFX - Open Financial Exchange')))
+        return selection
+
+    _columns = {
+        'import_type': fields.selection(
+            get_import_type_selection,
+            'Type of import',
+            required=True,
+            help="Choose here the method by which you want to import bank"
+                 "statement for this profile."),
+
+    }
+