Merge lp:~jsancho/sepa-tools/sepa-unpaid-6.0 into lp:sepa-tools/6.0

[Javier Sancho]

Module to import unpaid payment orders from SEPA XML file format (PAIN version 002.001.03)

[lp:~jsancho/sepa-tools/sepa-unpaid-6.0]

11. By Javier Sancho <[e-mail]> on 2014-06-05

Return codes and translations update

Unmerged revisions

11. By Javier Sancho <[e-mail]> on 2014-06-05

Return codes and translations update

10. By Javier Sancho <[e-mail]> on 2014-06-03

[ADD] account_bank_statement_sepa_unpaid: import unpaid payment orders from SEPA XML file format

=== added directory 'account_bank_statement_sepa_unpaid'
=== added file 'account_bank_statement_sepa_unpaid/__init__.py'
--- account_bank_statement_sepa_unpaid/__init__.py	1970-01-01 00:00:00 +0000
+++ account_bank_statement_sepa_unpaid/__init__.py	2014-06-05 08:09:02 +0000
@@ -0,0 +1,24 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2014 Nayar Systems (<http://www.72horas.net/>)
+#    @author: Javier Sancho <[e-mail]>
+#
+#    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 account_bank_statement
+import wizard

=== added file 'account_bank_statement_sepa_unpaid/__openerp__.py'
--- account_bank_statement_sepa_unpaid/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_bank_statement_sepa_unpaid/__openerp__.py	2014-06-05 08:09:02 +0000
@@ -0,0 +1,48 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2014 Nayar Systems (<http://www.72horas.net/>)
+#    @author: Javier Sancho <[e-mail]>
+#
+#    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': 'Account Bank Statement SEPA Unpaid',
+    'summary': 'Import SEPA files for unpaid payment orders',
+    'version': '1.0',
+    'license': 'AGPL-3',
+    'author': 'Nayar Systems',
+    'website': 'http://www.72horas.net',
+    'category': 'Banking addons',
+    'depends': [
+        'account',
+        'l10n_es',
+        'nan_account_bank_statement',
+        ],
+    'update_xml': [
+        'wizard/import_sepa_unpaid_view.xml'
+    ],
+    'description': '''
+Module to import unpaid payment orders from SEPA XML file format.
+
+SEPA PAIN (PAyment INitiation) is the new european standard for Customer-to-Bank payment instructions. This module implements SEPA Direct Debit (SDD), more specifically PAIN version 002.001.03. It is part of the ISO 20022 standard, available on http://www.iso20022.org.
+
+Please contact Javier Sancho from Nayar Systems <[e-mail]> for any help or question about this module.
+    ''',
+    'active': False,
+    'installable': True,
+    }

=== added file 'account_bank_statement_sepa_unpaid/account_bank_statement.py'
--- account_bank_statement_sepa_unpaid/account_bank_statement.py	1970-01-01 00:00:00 +0000
+++ account_bank_statement_sepa_unpaid/account_bank_statement.py	2014-06-05 08:09:02 +0000
@@ -0,0 +1,194 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2014 Nayar Systems (<http://www.72horas.net/>)
+#    @author: Javier Sancho <[e-mail]>
+#
+#    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 base64
+from lxml import etree
+from osv import osv, fields
+from tools.translate import _
+
+
+RETURN_CODES = (
+    ('AC01', _('Account identifier incorrect')),
+    ('AC04', _('Account closed')),
+    ('AC06', _('Account blocked for direct debit by the Debtor')),
+    ('AC13', _('Debtor Account is a consumer account')),
+    ('AG01', _('Direct debit forbidden on this account for regulatory reasons')),
+    ('AG02', _('Operation/transaction code incorrect, invalid file format')),
+    ('AM04', _('Insufficient funds')),
+    ('AM05', _('Duplicate collection')),
+    ('BE01', _('Debtor\'s name does not match with the account holder\'s nam')),
+    ('BE05', _('Identifier of the Creditor incorrect')),
+    ('FF01', _('Operation/transaction code incorrect, invalid file forma')),
+    ('FF05', _('Direct Debit type incorrect')),
+    ('MD01', _('No valid Mandate')),
+    ('MD02', _('Mandate data missing or incorrect')),
+    ('MD06', _('Disputed authorised transaction')),
+    ('MD07', _('Debtor deceased')),
+    ('MS02', _('Refusal by the Debtor')),
+    ('MS03', _('Reason not specified')),
+    ('RC01', _('Bank identifier incorrect')),
+    ('RR01', _('Missing Debtor Account Or Identification')),
+    ('RR02', _('Missing Debtors Name Or Address')),
+    ('RR03', _('Missing Creditors Name Or Address')),
+    ('RR04', _('Regulatory Reason')),
+    ('SL01', _('Specific Service offered by the Debtor Bank')),
+    ('FF01', _('No valid file format')),
+)
+
+RETURN_CODES = dict(RETURN_CODES)
+
+class account_bank_statement(osv.osv):
+    _inherit = 'account.bank.statement'
+
+    def import_sepa_unpaid_file(self, cr, uid, statement_id, file_contents, context=None):
+        """
+        Import SEPA PAIN.002.001.03 File
+        """
+
+        payment_line_obj = self.pool.get('payment.line')
+        partner_obj = self.pool.get('res.partner')
+        statement_line_obj = self.pool.get('account.bank.statement.line')
+        invoice_obj = self.pool.get('account.invoice')
+
+        st_data = self._load_sepa_unpaid_file(cr, uid, file_contents, context=context)
+        total_amount = 0
+        for payment in st_data['payments']:
+            for transaction in payment['transactions']:
+                invoice_number = transaction['remittance_info']
+                invoice_id = invoice_obj.search(cr, uid, [('number', '=', invoice_number)])
+                payment_line_id = payment_line_obj.search(cr, uid, [('name', '=', transaction['id'])], context=context)[0]
+                payment_line = payment_line_obj.browse(cr, uid, payment_line_id, context=context)
+                total_amount += transaction['amount']
+                values = {
+                    'statement_id': statement_id,
+                    'date': st_data['header']['date'].split('T')[0],
+                    'due_date': transaction['reqd_date'],
+                    'type': 'customer',
+                    'name': _("Unpaid Inv. %s") % invoice_number,
+                    'invoice_id': invoice_id and invoice_id[0] or False,
+                    'partner_id': payment_line.partner_id.id,
+                    'account_id': payment_line.partner_id.property_account_receivable.id,
+                    'amount': -1 * transaction['amount'],
+                    'ref': _(RETURN_CODES.get(transaction['code'], transaction['code'])),
+                    }
+                # Statement line
+                line_id = statement_line_obj.create(cr, uid, values, context=context)
+
+        # Update statement
+        statement = self.browse(cr, uid, statement_id)
+        data = {
+            'date': st_data['header']['date'].split('T')[0],
+            'balance_end_real': statement.balance_start - total_amount,
+            }
+        data.update(self.onchange_date(cr, uid, statement_id, data['date'])['value'])
+        self.write(cr, uid, [statement_id], data)
+
+        # Attach the SEPA file to the current statement
+        file_name = context.get('file_name', _('unpaid-bank-statement.xml'))
+        res = self._attach_file_to_statement(cr, uid, file_contents, statement_id, file_name, file_name)
+
+
+    def _load_sepa_unpaid_file(self, cr, uid, file_contents, context=None):
+        """
+        Load SEPA PAIN.002.001.03 File
+        """
+        decoded_file_contents = base64.decodestring(file_contents)
+        root = etree.fromstring(decoded_file_contents)
+        nsmap = root.nsmap[None]
+
+        st_data = {
+            'header': self._load_header(cr, uid, root, nsmap, context=context),
+            'orders': self._load_original_orders(cr, uid, root, nsmap, context=context),
+            'payments': self._load_original_payments(cr, uid, root, nsmap, context=context),
+            }
+        return st_data
+
+
+    def _load_header(self, cr, uid, root, nsmap, context=None):
+        header = root.find(".//{" + nsmap + "}GrpHdr")
+        header_data = {
+            'id': header.find("{" + nsmap + "}MsgId").text,
+            'date': header.find("{" + nsmap + "}CreDtTm").text,
+            'creditor_name': header.find("{" + nsmap + "}InitgPty/{" + nsmap + "}Nm").text,
+            'creditor_identifier': header.find("{" + nsmap + "}InitgPty/{" + nsmap + "}Id/{" + nsmap + "}OrgId/{" + nsmap + "}Othr/{" + nsmap + "}Id").text,
+            }
+        return header_data
+
+
+    def _load_original_orders(self, cr, uid, root, nsmap, context=None):
+        orders = root.findall(".//{" + nsmap + "}OrgnlGrpInfAndSts")
+        orders_data = []
+        for order in orders:
+            orders_data.append({
+                    'id': order.find("{" + nsmap + "}OrgnlMsgId").text,
+                    'scheme': order.find("{" + nsmap + "}OrgnlMsgNmId").text,
+                    'total_transactions': int(order.find("{" + nsmap + "}OrgnlNbOfTxs").text),
+                    'total_amount': float(order.find("{" + nsmap + "}OrgnlCtrlSum").text),
+                    })
+        return orders_data
+
+
+    def _load_original_payments(self, cr, uid, root, nsmap, context=None):
+        payments = root.findall(".//{" + nsmap + "}OrgnlPmtInfAndSts")
+        payments_data = []
+        for payment in payments:
+            payments_data.append({
+                    'id': payment.find("{" + nsmap + "}OrgnlPmtInfId").text,
+                    'total_transactions': int(payment.find("{" + nsmap + "}OrgnlNbOfTxs").text),
+                    'total_amount': float(payment.find("{" + nsmap + "}OrgnlCtrlSum").text),
+                    'transactions': self._load_payment_transactions(cr, uid, payment, nsmap, context=context),
+                    })
+        return payments_data
+
+
+    def _load_payment_transactions(self, cr, uid, payment, nsmap, context=None):
+        transactions = payment.findall("{" + nsmap + "}TxInfAndSts")
+        transactions_data = []
+        for transaction in transactions:
+            reference = transaction.find("{" + nsmap + "}OrgnlTxRef")
+            transactions_data.append({
+                    'id': transaction.find("{" + nsmap + "}OrgnlEndToEndId").text,
+                    'status': transaction.find("{" + nsmap + "}TxSts").text,
+                    'code': transaction.find("{" + nsmap + "}StsRsnInf/{" + nsmap + "}Rsn/{" + nsmap + "}Cd").text,
+                    'amount': float(reference.find("{" + nsmap + "}Amt/{" + nsmap + "}InstdAmt").text),
+                    'currency': reference.find("{" + nsmap + "}Amt/{" + nsmap + "}InstdAmt").attrib['Ccy'],
+                    'reqd_date': reference.find("{" + nsmap + "}ReqdColltnDt").text,
+                    'mandate_id': reference.find("{" + nsmap + "}MndtRltdInf/{" + nsmap + "}MndtId").text,
+                    'remittance_info': reference.find("{" + nsmap + "}RmtInf/{" + nsmap + "}Ustrd").text,
+                    'debtor_name': reference.find("{" + nsmap + "}Dbtr/{" + nsmap + "}Nm").text,
+                    'debtor_iban': reference.find("{" + nsmap + "}DbtrAcct/{" + nsmap + "}Id/{" + nsmap + "}IBAN").text,
+                    'debtor_bic': reference.find("{" + nsmap + "}DbtrAgt/{" + nsmap + "}FinInstnId/{" + nsmap + "}BIC").text,
+                    })
+        return transactions_data
+
+account_bank_statement()
+
+
+class account_bank_statement_line(osv.osv):
+    _inherit = 'account.bank.statement.line'
+
+    _columns = {
+        'invoice_id': fields.many2one('account.invoice', 'Invoice'),
+        'due_date': fields.date('Due Date'),
+        }
+
+account_bank_statement_line()

=== added directory 'account_bank_statement_sepa_unpaid/i18n'
=== added file 'account_bank_statement_sepa_unpaid/i18n/es.po'
--- account_bank_statement_sepa_unpaid/i18n/es.po	1970-01-01 00:00:00 +0000
+++ account_bank_statement_sepa_unpaid/i18n/es.po	2014-06-05 08:09:02 +0000
@@ -0,0 +1,225 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* nayar_bank_statement_sepa_unpaid
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 6.0.4\n"
+"Report-Msgid-Bugs-To: [e-mail]\n"
+"POT-Creation-Date: 2014-06-05 07:23+0000\n"
+"PO-Revision-Date: 2014-06-05 07:23+0000\n"
+"Last-Translator: <>\n"
+"Language-Team: \n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: \n"
+"Plural-Forms: \n"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:51
+#, python-format
+msgid "Missing Creditors Name Or Address"
+msgstr "Falta nombre o direción del acreedor"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:42
+#, python-format
+msgid "No valid Mandate"
+msgstr "Mandato no válido"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:45
+#, python-format
+msgid "Debtor deceased"
+msgstr "Fallecimiento del deudor"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:49
+#, python-format
+msgid "Missing Debtor Account Or Identification"
+msgstr "Falta cuenta o identificación del deudor"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:48
+#, python-format
+msgid "Bank identifier incorrect"
+msgstr "Identificador de la entidad incorrecto"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:106
+#, python-format
+msgid "unpaid-bank-statement.xml"
+msgstr "unpaid-bank-statement.xml"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:32
+#, python-format
+msgid "Account blocked for direct debit by the Debtor"
+msgstr "Cuenta bloqueada por el deudor"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:47
+#, python-format
+msgid "Reason not specified"
+msgstr "Motivo no especificado"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: view:account.bank.statement.sepa.unpaid.import.wizard:0
+msgid "Import"
+msgstr "Importar"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: model:ir.actions.act_window,name:nayar_bank_statement_sepa_unpaid.action_sepa_unpaid_import_wizard
+msgid "Import SEPA Unpaid File"
+msgstr "Importar impagados SEPA"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:86
+#, python-format
+msgid "Unpaid Inv. %s"
+msgstr "Fact. imp. %s"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:35
+#, python-format
+msgid "Operation/transaction code incorrect, invalid file format"
+msgstr "Código de operación incorrecto, formato inválido"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:52
+#, python-format
+msgid "Regulatory Reason"
+msgstr "Motivos regulatorios"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:50
+#, python-format
+msgid "Missing Debtors Name Or Address"
+msgstr "Falta nombre o dirección del deudor"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: field:account.bank.statement.sepa.unpaid.import.wizard,file:0
+#: field:account.bank.statement.sepa.unpaid.import.wizard,file_name:0
+msgid "Bank Unpaid Statements File"
+msgstr "Bank Unpaid Statements File"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:54
+#, python-format
+msgid "No valid file format"
+msgstr "Formato de fichero no válido"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:34
+#, python-format
+msgid "Direct debit forbidden on this account for regulatory reasons"
+msgstr "Adeudos prohibidos en cuenta por motivos regulatorios"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:31
+#, python-format
+msgid "Account closed"
+msgstr "Cuenta cerrada"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:39
+#, python-format
+msgid "Identifier of the Creditor incorrect"
+msgstr "Identificador de acreedor incorrecto"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: view:account.bank.statement.sepa.unpaid.import.wizard:0
+msgid "Bank Statements Import according to SEPA PAIN.002.001.03 XML File Structure"
+msgstr "Importe de extracto bancario según formato XML SEPA PAIN.002.001.03"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: model:ir.model,name:nayar_bank_statement_sepa_unpaid.model_account_bank_statement_sepa_unpaid_import_wizard
+msgid "account.bank.statement.sepa.unpaid.import.wizard"
+msgstr "account.bank.statement.sepa.unpaid.import.wizard"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:43
+#, python-format
+msgid "Mandate data missing or incorrect"
+msgstr "Faltan datos del mandato o son incorrectos"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:46
+#, python-format
+msgid "Refusal by the Debtor"
+msgstr "Rechazado por el deudor"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:30
+#, python-format
+msgid "Account identifier incorrect"
+msgstr "IBAN no válido"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: constraint:account.bank.statement.line:0
+msgid "The amount of the voucher must be the same amount as the one on the statement line"
+msgstr "El importe del recibo debe ser el mismo importe que el de la línea del extracto"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:38
+#, python-format
+msgid "Debtor's name does not match with the account holder's nam"
+msgstr "Nombre del deudor no coincide con propietario de la cuenta"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:53
+#, python-format
+msgid "Specific Service offered by the Debtor Bank"
+msgstr "Servicios específicos ofrecidos por la entidad del deudor"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:44
+#, python-format
+msgid "Disputed authorised transaction"
+msgstr "Operación autorizada disputada"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: model:ir.model,name:nayar_bank_statement_sepa_unpaid.model_account_bank_statement_line
+msgid "Bank Statement Line"
+msgstr "Línea de extracto bancario"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:36
+#, python-format
+msgid "Insufficient funds"
+msgstr "Falta de fondos"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: model:ir.model,name:nayar_bank_statement_sepa_unpaid.model_account_bank_statement
+msgid "Bank Statement"
+msgstr "Extracto bancario"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: view:account.bank.statement.sepa.unpaid.import.wizard:0
+msgid "Cancel"
+msgstr "Cancelar"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:41
+#, python-format
+msgid "Direct Debit type incorrect"
+msgstr "Tipo de adeudo incorrecto"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:37
+#, python-format
+msgid "Duplicate collection"
+msgstr "Duplicado"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:40
+#, python-format
+msgid "Operation/transaction code incorrect, invalid file forma"
+msgstr "Código de operación incorrecto, formato inválido"
+
+#. module: nayar_bank_statement_sepa_unpaid
+#: code:addons/nayar_bank_statement_sepa_unpaid/account_bank_statement.py:33
+#, python-format
+msgid "Debtor Account is a consumer account"
+msgstr "Cuenta del deudor es cuenta de un consumidor"
+

=== added directory 'account_bank_statement_sepa_unpaid/wizard'
=== added file 'account_bank_statement_sepa_unpaid/wizard/__init__.py'
--- account_bank_statement_sepa_unpaid/wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ account_bank_statement_sepa_unpaid/wizard/__init__.py	2014-06-05 08:09:02 +0000
@@ -0,0 +1,23 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2014 Nayar Systems (<http://www.72horas.net/>)
+#    @author: Javier Sancho <[e-mail]>
+#
+#    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 import_sepa_unpaid

=== added file 'account_bank_statement_sepa_unpaid/wizard/import_sepa_unpaid.py'
--- account_bank_statement_sepa_unpaid/wizard/import_sepa_unpaid.py	1970-01-01 00:00:00 +0000
+++ account_bank_statement_sepa_unpaid/wizard/import_sepa_unpaid.py	2014-06-05 08:09:02 +0000
@@ -0,0 +1,42 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2014 Nayar Systems (<http://www.72horas.net/>)
+#    @author: Javier Sancho <[e-mail]>
+#
+#    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 osv import osv, fields
+
+class sepa_unpaid_import_wizard(osv.osv_memory):
+    _name = 'account.bank.statement.sepa.unpaid.import.wizard'
+
+    _columns = {
+        'file': fields.binary('Bank Unpaid Statements File', required=True, filters="*.xml"),
+        'file_name': fields.char('Bank Unpaid Statements File', size=256, required=True),
+        }
+
+    def import_sepa_file(self, cr, uid, ids, context=None):
+        data = self.browse(cr, uid, ids[0], context=context)
+        context['file_name'] = data.file_name
+        file_contents = data.file
+
+        st_obj = self.pool.get('account.bank.statement')
+        st_obj.import_sepa_unpaid_file(cr, uid, context['active_id'], file_contents, context=context)
+        return {'type': 'ir.actions.act_window_close'}
+
+sepa_unpaid_import_wizard()

=== added file 'account_bank_statement_sepa_unpaid/wizard/import_sepa_unpaid_view.xml'
--- account_bank_statement_sepa_unpaid/wizard/import_sepa_unpaid_view.xml	1970-01-01 00:00:00 +0000
+++ account_bank_statement_sepa_unpaid/wizard/import_sepa_unpaid_view.xml	2014-06-05 08:09:02 +0000
@@ -0,0 +1,48 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+  Copyright (C) 2014 Nayar Systems (http://www.72horas.net/)
+  @author: Javier Sancho <[e-mail]>
+  The license is in the file __openerp__.py
+-->
+<openerp>
+  <data>
+    <record model="ir.ui.view" id="sepa_unpaid_import_wizard">
+      <field name="name">account.bank.statement.sepa.unpaid.import.wizard.form</field>
+      <field name="model">account.bank.statement.sepa.unpaid.import.wizard</field>
+      <field name="type">form</field>
+      <field name="arch" type="xml">
+	<form string="Bank Statements Import according to SEPA PAIN.002.001.03 XML File Structure">
+	  <group col="4" colspan="4">
+	    <field name="file_name"/>
+	    <field name="file" filename="file_name" nolabel="1" colspan="2"/>
+	  </group>
+	  <group col="2" colspan="4">
+	    <button icon="gtk-cancel" special="cancel" string="Cancel"/>
+	    <button icon="gtk-ok" name="import_sepa_file" string="Import" type="object"/>
+	  </group>
+	</form>
+      </field>
+    </record>
+
+    <record id="action_sepa_unpaid_import_wizard" model="ir.actions.act_window">
+      <field name="name">account.bank.statement.sepa.unpaid.import.wizard.action</field>
+      <field name="type">ir.actions.act_window</field>
+      <field name="res_model">account.bank.statement.sepa.unpaid.import.wizard</field>
+      <field name="view_type">form</field>
+      <field name="view_mode">form</field>
+      <field name="target">new</field>
+    </record>
+
+    <act_window
+	id="action_sepa_unpaid_import_wizard"
+	name="Import SEPA Unpaid File"
+	key2="client_action_multi"
+	res_model="account.bank.statement.sepa.unpaid.import.wizard"
+	src_model="account.bank.statement"
+	view_type="form"
+	view_mode="form"
+	target="new"
+	groups="account.group_account_manager"/>
+
+  </data>
+</openerp>