Example #1
0
    def run(self):
        # Recupera il record dal database
        self.filedata_obj = self.pool['pricelist.import']
        self.pricelistImportRecord = self.filedata_obj.browse(
            self.cr, self.uid, self.pricelistImportID, context=self.context)
        self.file_name = self.pricelistImportRecord.file_name.split('\\')[-1]
        self.pricelist_id = self.pricelistImportRecord.pricelist_id

        Config = getattr(settings, self.pricelistImportRecord.format)
        self.HEADER = Config.HEADER_PRICELIST_ITEM
        self.REQUIRED = Config.REQUIRED_PRICELIST_ITEM

        self.RecordPriceListItem = namedtuple('RecordPriceListItem',
                                              Config.COLUMNS_PRICELIST_ITEM)

        table, self.numberOfLines = import_sheet(
            self.file_name, self.pricelistImportRecord.content_text)

        if DEBUG:
            # Importa il file
            self.process(self.cr, self.uid, table)

            # Genera il report sull'importazione
            self.notify_import_result(self.cr,
                                      self.uid,
                                      self.message_title,
                                      'Importazione completata',
                                      record=self.pricelistImportRecord)
        else:
            # Elaborazione del file
            try:
                # Importa il listino
                self.process(self.cr, self.uid, table)

                # Genera il report sull'importazione
                self.notify_import_result(self.cr,
                                          self.uid,
                                          self.message_title,
                                          'Importazione completata',
                                          record=self.pricelistImportRecord)
            except Exception as e:
                # Annulla le modifiche fatte
                self.cr.rollback()
                self.cr.commit()
                title = "Import failed"
                message = "Errore alla linea %s" % (
                    str(self.processed_lines) + "\nDettaglio:\n\n" + str(e))

                if DEBUG:
                    # Debug
                    _logger.debug(message)
                    pdb.set_trace()

                self.notify_import_result(self.cr,
                                          self.uid,
                                          title,
                                          message,
                                          error=True,
                                          record=self.pricelistImportRecord)
Example #2
0
    def run(self):
        # Recupera il record dal database
        self.filedata_obj = self.pool['invoice.import']
        self.invoiceImportRecord = self.filedata_obj.browse(self.cr, self.uid, self.invoiceImportID, context=self.context)
        self.file_name = self.invoiceImportRecord.file_name.split('\\')[-1]
        self.partner_id = self.invoiceImportRecord.partner_id
        self.date_invoice = self.invoiceImportRecord.date_invoice
        self.origin = self.invoiceImportRecord.origin or ''
        self.journal_id = self.invoiceImportRecord.journal_id
        self.location_id = self.invoiceImportRecord.location_id
        self.update_price = self.invoiceImportRecord.update_price
        self.account_id = self.invoiceImportRecord.account_id
        self.type = self.invoiceImportRecord.type
        self.format = self.invoiceImportRecord.format

        # ===================================================
        Config = getattr(settings, self.invoiceImportRecord.format)

        self.HEADER = Config.HEADER_INVOICE_ITEM
        self.REQUIRED = Config.REQUIRED_INVOICE_ITEM

        if not len(self.HEADER) == len(Config.COLUMNS_INVOICE_ITEM.split(',')):
            pprint(zip(self.HEADER, Config.COLUMNS_INVOICE_ITEM.split(',')))
            raise orm.except_orm('Error: wrong configuration!', 'The length of columns and headers must be the same')
        
        self.RecordSales = namedtuple('RecordSales', Config.COLUMNS_INVOICE_ITEM)

        # ===================================================

        table, self.numberOfLines = import_sheet(self.file_name, self.invoiceImportRecord.content_text)

        if DEBUG:
            # Importa il file
            self.process(self.cr, self.uid, table)
            
            # Genera il report sull'importazione
            self.notify_import_result(self.cr, self.uid, self.message_title, 'Importazione completata', record=self.invoiceImportRecord)
        else:
            # Elaborazione del file
            try:
                # Importa il sale order
                self.process(self.cr, self.uid, table)
                
                # Genera il report sull'importazione
                self.notify_import_result(self.cr, self.uid, self.message_title, 'Importazione completata', record=self.invoiceImportRecord)
            except Exception as e:
                # Annulla le modifiche fatte
                self.cr.rollback()
                self.cr.commit()
                
                title = "Import failed"
                message = "Errore alla linea %s" % self.processed_lines + "\nDettaglio:\n\n" + str(e)
                
                if DEBUG:
                    ### Debug
                    _logger.debug(message)
                    pdb.set_trace()
                
                self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.invoiceImportRecord)
Example #3
0
    def run(self):
        # Recupera il record dal database
        self.filedata_obj = self.pool['product.import']
        self.productImportRecord = self.filedata_obj.browse(self.cr, self.uid, self.productImportID, context=self.context)
        self.file_name = self.productImportRecord.file_name.split('\\')[-1]

        self.update_product_name = self.productImportRecord.update_product_name
        
        # ===================================================
        Config = getattr(settings, self.productImportRecord.format)

        self.HEADER = Config.HEADER_PRODUCT
        self.REQUIRED = Config.REQUIRED_PRODUCT
        self.PRODUCT_SEARCH = Config.PRODUCT_SEARCH
        self.PRODUCT_WARNINGS = Config.PRODUCT_WARNINGS
        self.PRODUCT_ERRORS = Config.PRODUCT_ERRORS
        
        # Default values
        self.PRODUCT_DEFAULTS = Config.PRODUCT_DEFAULTS
        
        if not len(self.HEADER) == len(Config.COLUMNS_PRODUCT.split(',')):
            pprint(zip(self.HEADER, Config.COLUMNS_PRODUCT.split(',')))
            raise orm.except_orm('Error: wrong configuration!', 'The length of columns and headers must be the same')
        
        self.RecordProduct = namedtuple('RecordProduct', Config.COLUMNS_PRODUCT)

        # ===================================================

        table, self.numberOfLines = import_sheet(self.file_name, self.productImportRecord.content_text)

        if DEBUG:
            # Importa il listino
            self.process(self.cr, self.uid, table)
            
            # Genera il report sull'importazione
            self.notify_import_result(self.cr, self.uid, self.message_title, 'Importazione completata', record=self.productImportRecord)
        else:
            # Elaborazione del listino prezzi
            try:
                # Importa il listino
                self.process(self.cr, self.uid, table)
                
                # Genera il report sull'importazione
                self.notify_import_result(self.cr, self.uid, self.message_title, 'Importazione completata', record=self.productImportRecord)
            except Exception as e:
                # Annulla le modifiche fatte
                self.cr.rollback()
                self.cr.commit()
                
                title = "Import failed"
                message = "Errore alla linea %s" % self.processed_lines + "\nDettaglio:\n\n" + str(e)
                
                if DEBUG:
                    ### Debug
                    _logger.debug(message)
                    pdb.set_trace()
                
                self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.productImportRecord)
Example #4
0
    def run(self):
        # Recupera il record dal database
        self.filedata_obj = self.pool['sales.import']
        self.salesImportRecord = self.filedata_obj.browse(self.cr, self.uid, self.salesImportID, context=self.context)
        self.file_name = self.salesImportRecord.file_name.split('\\')[-1]
        self.partner_id = self.salesImportRecord.partner_id
        self.date_order = self.salesImportRecord.date_order
        self.origin = self.salesImportRecord.origin or ''
        self.shop_id = self.salesImportRecord.shop_id
        self.location_id = self.salesImportRecord.location_id
        self.auto_approve = self.salesImportRecord.auto_approve
        self.update_price = self.salesImportRecord.update_price

        # ===================================================
        Config = getattr(settings, self.salesImportRecord.format)

        self.HEADER = Config.HEADER_SALES_ITEM
        self.REQUIRED = Config.REQUIRED_SALES_ITEM

        if not len(self.HEADER) == len(Config.COLUMNS_SALES_ITEM.split(',')):
            pprint(zip(self.HEADER, Config.COLUMNS_SALES_ITEM.split(',')))
            raise orm.except_orm('Error: wrong configuration!', 'The length of columns and headers must be the same')
        
        self.RecordSales = namedtuple('RecordSales', Config.COLUMNS_SALES_ITEM)

        # ===================================================

        table, self.numberOfLines = import_sheet(self.file_name, self.salesImportRecord.content_text)

        if DEBUG:
            # Importa il file
            self.process(self.cr, self.uid, table)
            
            # Genera il report sull'importazione
            self.notify_import_result(self.cr, self.uid, self.message_title, 'Importazione completata', record=self.salesImportRecord)
        else:
            # Elaborazione del file
            try:
                # Importa il sale order
                self.process(self.cr, self.uid, table)
                
                # Genera il report sull'importazione
                self.notify_import_result(self.cr, self.uid, self.message_title, 'Importazione completata', record=self.salesImportRecord)
            except Exception as e:
                # Annulla le modifiche fatte
                self.cr.rollback()
                self.cr.commit()
                
                title = "Import failed"
                message = "Errore alla linea %s" % str(self.processed_lines) + "\nDettaglio:\n\n" + str(e)
                
                if DEBUG:
                    ### Debug
                    _logger.debug(message)
                    pdb.set_trace()
                
                self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.salesImportRecord)
Example #5
0
    def run(self):
        self.setup()

        try:
            table, self.numberOfLines = import_sheet(
                self.file_name, self.statementLineImportRecord.content_text)
        except Exception as e:
            # Annulla le modifiche fatte
            self.cr.rollback()
            self.cr.commit()

            title = 'Import failed'
            message = "Errore nell'importazione del file %s" % self.file_name + "\nDettaglio:\n\n" + str(
                e)

            if DEBUG:
                # Debug
                _logger.debug(message)
                pdb.set_trace()
            self.notify_import_result(self.cr,
                                      self.uid,
                                      title,
                                      message,
                                      error=True,
                                      record=self.statementLineImportRecord)

        try:
            # Import account_bank_statement
            self.process(self.cr, self.uid, table)

            # Genera il report sull'importazione
            self.notify_import_result(self.cr,
                                      self.uid,
                                      'Importazione Bank Statement',
                                      record=self.statementLineImportRecord)
        except Exception as e:
            # Annulla le modifiche fatte
            self.cr.rollback()
            self.cr.commit()

            title = "Import failed"
            message = u"Errore alla linea %s" % str(
                self.processed_lines) + "\nDettaglio:\n\n" + str(e)

            if DEBUG:
                raise e

            self.notify_import_result(self.cr,
                                      self.uid,
                                      title,
                                      message,
                                      error=True,
                                      record=self.statementLineImportRecord)
Example #6
0
    def run(self):
        self.setup()

        try:
            table, self.numberOfLines = import_sheet(self.file_name, self.partnerImportRecord.content_text)
        except Exception as e:
            # Annulla le modifiche fatte
            self.cr.rollback()
            self.cr.commit()

            title = "Import failed"
            message = "Errore nell'importazione del file %s" % self.file_name + "\nDettaglio:\n\n" + str(e)

            if DEBUG:
                ### Debug
                _logger.debug(message)
                pdb.set_trace()
            self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.productImportRecord)

        if DEBUG:
            # Importa i partner
            # self.process(self.cr, self.uid, sheet, book.datemode)
            self.process(self.cr, self.uid, table)

            # Genera il report sull'importazione
            self.notify_import_result(self.cr, self.uid, 'Importazione partner', record=self.partnerImportRecord)
        else:
            # Elaborazione del Partner
            try:
                # Import partner
                # self.process(self.cr, self.uid, sheet, book.datemode)
                self.process(self.cr, self.uid, table)

                # Genera il report sull'importazione
                self.notify_import_result(self.cr, self.uid, 'Importazione partner', record=self.partnerImportRecord)
            except Exception as e:
                # Annulla le modifiche fatte
                self.cr.rollback()
                self.cr.commit()

                title = "Import failed"
                message = u"Errore alla linea %s" % str(self.processed_lines) + "\nDettaglio:\n\n" + str(e)

                if DEBUG:
                    ### Debug
                    print message
                    pdb.set_trace()
                self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.partnerImportRecord)
Example #7
0
    def run(self):
        self.setup()

        try:
            table, self.numberOfLines = import_sheet(self.file_name, self.productImportRecord.content_text)
        except Exception as e:
            # Annulla le modifiche fatte
            self.cr.rollback()
            self.cr.commit()

            title = "Import failed"
            message = "Errore nell'importazione del file %s" % self.file_name + "\nDettaglio:\n\n" + str(e)

            if DEBUG:
                ### Debug
                _logger.debug(message)
                pdb.set_trace()
            self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.productImportRecord)

        if DEBUG:
            # Importa il listino
            self.process(self.cr, self.uid, table)

            # Genera il report sull'importazione
            self.notify_import_result(self.cr, self.uid, self.message_title, 'Importazione completata', record=self.productImportRecord)
        else:
            # Elaborazione del listino prezzi
            try:
                # Importa il listino
                self.process(self.cr, self.uid, table)

                # Genera il report sull'importazione
                self.notify_import_result(self.cr, self.uid, self.message_title, 'Importazione completata', record=self.productImportRecord)
            except Exception as e:
                # Annulla le modifiche fatte
                self.cr.rollback()
                self.cr.commit()

                title = "Import failed"
                message = "Errore alla linea %s" % str(self.processed_lines) + "\nDettaglio:\n\n" + str(e)

                if DEBUG:
                    ### Debug
                    _logger.debug(message)
                    pdb.set_trace()

                self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.productImportRecord)
Example #8
0
    def run(self):
        self.setup()

        try:
            table, self.numberOfLines = import_sheet(self.file_name, self.statementLineImportRecord.content_text)
        except Exception as e:
            # Annulla le modifiche fatte
            self.cr.rollback()
            self.cr.commit()

            title = 'Import failed'
            message = "Errore nell'importazione del file %s" % self.file_name + "\nDettaglio:\n\n" + str(e)

            if DEBUG:
                # Debug
                _logger.debug(message)
                pdb.set_trace()
            self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.statementLineImportRecord)

        try:
            # Import account_bank_statement
            self.process(self.cr, self.uid, table)

            # Genera il report sull'importazione
            self.notify_import_result(self.cr, self.uid, 'Importazione Bank Statement', record=self.statementLineImportRecord)
        except Exception as e:
            # Annulla le modifiche fatte
            self.cr.rollback()
            self.cr.commit()

            title = "Import failed"
            message = u"Errore alla linea %s" % str(self.processed_lines) + "\nDettaglio:\n\n" + str(e)

            if DEBUG:
                raise e

            self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.statementLineImportRecord)
Example #9
0
    def run(self):
        # Recupera il record dal database
        self.filedata_obj = self.pool['inventory.import']
        self.productImportRecord = self.filedata_obj.browse(self.cr, self.uid, self.productImportID, context=self.context)
        self.file_name = self.productImportRecord.file_name.split('\\')[-1]

        self.date = self.productImportRecord.date
        self.location_id = self.productImportRecord.location_id
        
        # ===================================================
        Config = getattr(settings, self.productImportRecord.format)

        self.HEADER = Config.HEADER_INVENTORY_ITEM
        self.REQUIRED_INVENTORY_ITEM = Config.REQUIRED_INVENTORY_ITEM
        self.PRODUCT_SEARCH = Config.INVENTORY_PRODUCT_SEARCH

        # Default values
        
        if not len(self.HEADER) == len(Config.COLUMNS_INVENTORY_ITEM.split(',')):
            pprint(zip(self.HEADER, Config.COLUMNS_INVENTORY_ITEM.split(',')))
            raise orm.except_orm('Error: wrong configuration!', 'The length of columns and headers must be the same')
        
        self.RecordProduct = namedtuple('RecordProduct', Config.COLUMNS_INVENTORY_ITEM)

        # ===================================================
        try:
            table, self.numberOfLines = import_sheet(self.file_name, self.productImportRecord.content_text)
        except Exception as e:
            # Annulla le modifiche fatte
            self.cr.rollback()
            self.cr.commit()

            title = "Import failed"
            message = "Errore nell'importazione del file %s" % self.file_name + "\nDettaglio:\n\n" + str(e)

            if DEBUG:
                ### Debug
                _logger.debug(message)
                pdb.set_trace()
            self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.productImportRecord)

        if DEBUG:
            # Importa inventario
            self.process(self.cr, self.uid, table)
            
            # Genera il report sull'importazione
            self.notify_import_result(self.cr, self.uid, self.message_title, 'Importazione completata', record=self.productImportRecord)
        else:
            # Elaborazione dell'inventario
            try:
                # Importa il listino
                self.process(self.cr, self.uid, table)
                
                # Genera il report sull'importazione
                self.notify_import_result(self.cr, self.uid, self.message_title, 'Importazione completata', record=self.productImportRecord)
            except Exception as e:
                # Annulla le modifiche fatte
                self.cr.rollback()
                self.cr.commit()
                
                title = "Import failed"
                message = "Errore alla linea %s" % str(self.processed_lines) + "\nDettaglio:\n\n" + str(e)
                
                if DEBUG:
                    ### Debug
                    _logger.debug(message)
                    pdb.set_trace()

                self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.productImportRecord)
Example #10
0
    def run(self):
        # Recupera il record dal database
        self.filedata_obj = self.pool['pricelist.import']
        self.pricelistImportRecord = self.filedata_obj.browse(
            self.cr, self.uid,
            self.pricelistImportID,
            context=self.context
        )
        self.format = self.pricelistImportRecord.format
        self.partner_id = self.pricelistImportRecord.partner_id
        self.file_name = self.pricelistImportRecord.file_name.split('\\')[-1]
        self.pricelist_id = self.pricelistImportRecord.pricelist_id

        Config = getattr(settings, self.pricelistImportRecord.format)
        self.HEADER = Config.HEADER_PRICELIST_ITEM
        self.REQUIRED = Config.REQUIRED_PRICELIST_ITEM

        self.RecordPriceListItem = namedtuple(
            'RecordPriceListItem',
            Config.COLUMNS_PRICELIST_ITEM
        )

        table, self.numberOfLines = import_sheet(
            self.file_name,
            self.pricelistImportRecord.content_text
        )

        if DEBUG:
            # Importa il file
            self.process(self.cr, self.uid, table)

            # Genera il report sull'importazione
            self.notify_import_result(
                self.cr, self.uid,
                self.message_title,
                'Importazione completata',
                record=self.pricelistImportRecord
            )
        else:
            # Elaborazione del file
            try:
                # Importa il listino
                self.process(self.cr, self.uid, table)

                # Genera il report sull'importazione
                self.notify_import_result(
                    self.cr, self.uid,
                    self.message_title,
                    'Importazione completata',
                    record=self.pricelistImportRecord
                )
            except Exception as e:
                # Annulla le modifiche fatte
                self.cr.rollback()
                self.cr.commit()
                title = "Import failed"
                message = "Errore nell'importazione del file %s" % self.file_name + "\nDettaglio:\n\n" + str(e)

                if DEBUG:
                    # Debug
                    _logger.debug(message)
                    pdb.set_trace()

                self.notify_import_result(
                    self.cr, self.uid,
                    title,
                    message,
                    error=True,
                    record=self.pricelistImportRecord
                )
    def run(self):
        # Recupera il record dal database
        self.filedata_obj = self.pool['partner.import']
        self.partnerImportRecord = self.filedata_obj.browse(self.cr, self.uid, self.partnerImportID, context=self.context)
        self.file_name = self.partnerImportRecord.file_name.split('\\')[-1]
        self.strict = self.partnerImportRecord.strict
        self.UPDATE_ON_CODE = self.partnerImportRecord.update_on_code
        self.partner_template_id = self.partnerImportRecord.partner_template_id
        #===================================================
        Config = getattr(settings, self.partnerImportRecord.format)
        self.FORMAT = self.partnerImportRecord.format
        self.HEADER = Config.HEADER_CUSTOMER
        self.REQUIRED = Config.REQUIRED
        self.PARTNER_SEARCH = Config.PARTNER_SEARCH
        self.ADDRESS_TYPE = Config.ADDRESS_TYPE
        self.PARTNER_UNIQUE_OFFICE_CODE = Config.PARTNER_UNIQUE_OFFICE_CODE

        if not len(self.HEADER) == len(Config.COLUMNS.split(',')):
            pprint(zip(self.HEADER, Config.COLUMNS.split(',')))
            raise orm.except_orm('Error: wrong configuration!', 'The length of columns and headers must be the same')

        self.Record = namedtuple('Record', Config.COLUMNS)
        #===================================================

        self.partner_type = self.partnerImportRecord.partner_type

        # for encoding in ('utf-8', 'latin-1', 'cp1252'):
        #     try:
        #         book = xlrd.open_workbook(file_contents=self.partnerImportRecord.content_text, encoding_override=encoding)
        #         break
        #     except:
        #         pass
        # else:
        #     raise orm.except_orm('Error', _('Unknown encoding'))


        # sheet = []
        # sh = book.sheet_by_index(0)
        #
        # for rx in range(sh.nrows):
        #     row = []
        #     for cx in range(sh.ncols):
        #         row.append(sh.cell_value(rowx=rx, colx=cx))
        #     sheet.append(row)
        #
        # self.numberOfLines = sh.nrows

        try:
            table, self.numberOfLines = import_sheet(self.file_name, self.partnerImportRecord.content_text)
        except Exception as e:
            # Annulla le modifiche fatte
            self.cr.rollback()
            self.cr.commit()

            title = "Import failed"
            message = "Errore nell'importazione del file %s" % self.file_name + "\nDettaglio:\n\n" + str(e)

            if DEBUG:
                ### Debug
                _logger.debug(message)
                pdb.set_trace()
            self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.productImportRecord)

        if DEBUG:
            # Importa i partner
            # self.process(self.cr, self.uid, sheet, book.datemode)
            self.process(self.cr, self.uid, table)

            # Genera il report sull'importazione
            self.notify_import_result(self.cr, self.uid, 'Importazione partner', record=self.partnerImportRecord)
        else:
            # Elaborazione del Partner
            try:
                # Import partner
                # self.process(self.cr, self.uid, sheet, book.datemode)
                self.process(self.cr, self.uid, table)

                # Genera il report sull'importazione
                self.notify_import_result(self.cr, self.uid, 'Importazione partner', record=self.partnerImportRecord)
            except Exception as e:
                # Annulla le modifiche fatte
                self.cr.rollback()
                self.cr.commit()

                title = "Import failed"
                message = u"Errore alla linea %s" % str(self.processed_lines) + "\nDettaglio:\n\n" + str(e)

                if DEBUG:
                    ### Debug
                    print message
                    pdb.set_trace()
                self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.partnerImportRecord)
Example #12
0
    def run(self):
        try:
            # Recupera il record dal database
            self.filedata_obj = self.pool['picking.import']
            self.pickingImportRecord = self.filedata_obj.browse(
                self.cr, self.uid, self.pickingImportID, context=self.context)
            self.file_name = self.pickingImportRecord.file_name.split('\\')[-1]
            self.address_id = self.pickingImportRecord.address_id
            self.stock_journal_id = self.pickingImportRecord.stock_journal_id
            self.location_id = self.pickingImportRecord.location_id
            self.location_dest_id = self.pickingImportRecord.location_dest_id

            # ===================================================
            Config = getattr(settings, self.pickingImportRecord.format)

            self.HEADER = Config.HEADER_PICKING
            self.REQUIRED = Config.REQUIRED_PICKING

            if not len(self.HEADER) == len(Config.COLUMNS_PICKING.split(',')):
                pprint(zip(self.HEADER, Config.COLUMNS_PICKING.split(',')))
                raise orm.except_orm(
                    'Error: wrong configuration!',
                    'The length of columns and headers must be the same')

            self.RecordPicking = namedtuple('RecordPicking',
                                            Config.COLUMNS_PICKING)

            # ===================================================

            table, self.numberOfLines = import_sheet(
                self.file_name, self.pickingImportRecord.content_text)
        except Exception as e:
            # Annulla le modifiche fatte
            self.cr.rollback()
            self.cr.commit()

            title = "Import failed"
            message = "Errore nell'importazione del file %s" % self.file_name + "\nDettaglio:\n\n" + str(
                e)

            if DEBUG:
                ### Debug
                _logger.debug(message)
                pdb.set_trace()
            self.notify_import_result(self.cr,
                                      self.uid,
                                      title,
                                      message,
                                      error=True,
                                      record=self.pickingImportRecord)

        if DEBUG:
            # Importa il file
            self.process(self.cr, self.uid, table)

            # Genera il report sull'importazione
            self.notify_import_result(self.cr,
                                      self.uid,
                                      self.message_title,
                                      'Importazione completata',
                                      record=self.pickingImportRecord)
        else:
            # Elaborazione del file
            try:
                # Importa il listino
                self.process(self.cr, self.uid, table)

                # Genera il report sull'importazione
                self.notify_import_result(self.cr,
                                          self.uid,
                                          self.message_title,
                                          'Importazione completata',
                                          record=self.pickingImportRecord)
            except Exception as e:
                # Annulla le modifiche fatte
                self.cr.rollback()
                self.cr.commit()

                title = "Import failed"
                message = "Errore alla linea %s" % str(
                    self.processed_lines) + "\nDettaglio:\n\n" + str(e)

                if DEBUG:
                    ### Debug
                    _logger.debug(message)
                    pdb.set_trace()

                self.notify_import_result(self.cr,
                                          self.uid,
                                          title,
                                          message,
                                          error=True,
                                          record=self.pickingImportRecord)
Example #13
0
    def run(self):
        # Recupera il record dal database
        self.filedata_obj = self.pool['crm.import']
        self.CrmImportRecord = self.filedata_obj.browse(self.cr, self.uid, self.crmImportID, context=self.context)
        self.file_name = self.CrmImportRecord.file_name.split('\\')[-1]
        self.shop_id = self.CrmImportRecord.shop_id

        # ===================================================
        Config = getattr(settings, self.CrmImportRecord.format)

        self.HEADER = Config.HEADER_CRM
        self.REQUIRED = Config.REQUIRED_CRM
        self.COLUMNS_CRM = Config.COLUMNS_CRM
        self.CRM_SEARCH = Config.CRM_SEARCH
        self.CRM_WARNINGS = Config.CRM_WARNINGS
        self.CRM_ERRORS = Config.CRM_ERRORS
        self.FORMAT = self.CrmImportRecord.format

        # Default values
        self.CRM_DEFAULTS = Config.CRM_DEFAULTS
        
        if not len(self.HEADER) == len(Config.COLUMNS_CRM):
            pprint(zip(self.HEADER, Config.COLUMNS_CRM))
            raise orm.except_orm('Error: wrong configuration!', 'The length of columns and headers must be the same')
        
        self.RecordCrm = namedtuple('RecordProduct', Config.COLUMNS_CRM)

        # ===================================================
        try:
            table, self.numberOfLines = import_sheet(self.file_name, self.CrmImportRecord.content_text)
        except Exception as e:
            # Annulla le modifiche fatte
            self.cr.rollback()
            self.cr.commit()

            title = "Import failed"
            message = "Errore nell'importazione del file %s" % self.file_name + "\nDettaglio:\n\n" + str(e)

            if DEBUG:
                ### Debug
                _logger.debug(message)
                # pdb.set_trace()
            self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.CrmImportRecord)

        if DEBUG:
            # Importa il listino
            try:
                self.process(self.cr, self.uid, table)
            
                # Genera il report sull'importazione

                self.notify_import_result(self.cr, self.uid, self.message_title, 'Importazione completata', record=self.CrmImportRecord)
            except Exception as e:
                title = "Import failed"
                message = "Errore alla linea %s" % self.processed_lines + "\nDettaglio:\n\n" + str(e)

        else:
            # Elaborazione del listino prezzi
            try:
                # Importa il listino
                self.process(self.cr, self.uid, table)
                
                # Genera il report sull'importazione
                self.notify_import_result(self.cr, self.uid, self.message_title, 'Importazione completata', record=self.CrmImportRecord)
            except Exception as e:
                # Annulla le modifiche fatte
                self.cr.rollback()
                self.cr.commit()
                
                title = "Import failed"
                message = "Errore alla linea %s" % self.processed_lines + "\nDettaglio:\n\n" + str(e)
                
                if DEBUG:
                    ### Debug
                    _logger.debug(message)
                    # pdb.set_trace()
                
                self.notify_import_result(self.cr, self.uid, title, message, error=True, record=self.CrmImportRecord)