def import_price_list(self,
job_file_id,
create_notification_on_server=True,
update_only=False,
user_for_revision=None):
"""
import products from the given price list
:param job_file_id: ID within the database that references the Excel file that should be imported
:param create_notification_on_server: create a new Notification Message on the Server
:param update_only: Don't create new products in the database, update only existing ones
:param user_for_revision: username that should be used for the revision tracking (only if started manually)
"""
def update_task_state(status_message):
"""Update the status message of the task, which is displayed in the watch view"""
self.update_state(state=TaskState.PROCESSING,
meta={"status_message": status_message})
update_task_state("Try to import uploaded file...")
try:
import_excel_file = JobFile.objects.get(id=job_file_id)
except:
msg = "Cannot find file that was uploaded."
logger.error(msg, exc_info=True)
result = {"error_message": msg}
return result
# verify that file exists
try:
import_products_excel = ProductsExcelImporter(
path_to_excel_file=import_excel_file.file,
user_for_revision=User.objects.get(username=user_for_revision))
import_products_excel.verify_file()
update_task_state("File valid, start updating the database...")
# if something goes wrong, rollback all changes
with transaction.atomic():
import_products_excel.import_to_database(
status_callback=update_task_state, update_only=update_only)
update_task_state("Database import finished, processing results...")
summary_msg = "User <strong>%s</strong> imported a Product list, %s Products " \
"changed." % (user_for_revision, import_products_excel.valid_imported_products)
detail_msg = "<div style=\"text-align:left;\">%s " \
"Products successful updated. " % import_products_excel.valid_imported_products
if import_products_excel.invalid_products != 0:
detail_msg += "%s entries are invalid. Please check the following messages for " \
"more details." % import_products_excel.invalid_products
if len(import_products_excel.import_result_messages) != 0:
detail_msg += "<ul>"
for e in import_products_excel.import_result_messages:
detail_msg += "<li>%s</li>" % e
detail_msg += "</ul></div>"
# if the task was executed eager, set state to SUCCESS (required for testing)
if self.request.is_eager:
self.update_state(state=TaskState.SUCCESS,
meta={"status_message": detail_msg})
if create_notification_on_server:
NotificationMessage.objects.create(
title="Import product list",
type=NotificationMessage.MESSAGE_INFO,
summary_message=summary_msg,
detailed_message=detail_msg)
# drop the file
import_excel_file.delete()
result = {"status_message": detail_msg}
except (InvalidImportFormatException, InvalidExcelFileFormat) as ex:
msg = "import failed, invalid file format (%s)" % ex
logger.error(msg, ex)
result = {"error_message": msg}
except Exception as ex: # catch any exception
msg = "Unexpected exception occurred while importing product list (%s)" % ex
logger.error(msg, ex)
result = {"error_message": msg}
# if the task was executed eager, set state to SUCCESS (required for testing)
if self.request.is_eager:
self.update_state(state=TaskState.SUCCESS, meta=result)
return result
