Details
Date	2015-10-09 09:38:04 UTC
Software	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date	Time	Line	Action	Comment
Processed 86 lines
2015-10-09	09:38:04	0	[DEBUG]	Clean up old logs. Found 26 logs and threshold is 25 logs
2015-10-09	09:38:04	0	[QUERY]	SELECT csvi_log_id FROM dinbok2_csvi_logs ORDER BY csvi_log_id
2015-10-09	09:38:29	0	[DEBUG]	Clean up old logs. Found 25 logs and threshold is 25 logs
2015-10-09	09:38:29	0	[QUERY]	SELECT csvi_log_id FROM dinbok2_csvi_logs ORDER BY csvi_log_id
2015-10-09	09:38:31	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation price and action import
2015-10-09	09:38:31	0	[QUERY]	SELECT `a`.`csvi_name` FROM `dinbok2_csvi_availablefields` AS `a` LEFT JOIN `dinbok2_csvi_availabletables` AS `t` ON `t`.`template_table` = `a`.`component_table` WHERE `a`.`component` = 'com_virtuemart' AND `t`.`component` = 'com_virtuemart' AND `t`.`task_name` = 'price' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2015-10-09	09:38:31	0	[DEBUG]	Load the fields to process
2015-10-09	09:38:31	0	[DEBUG]	Field name: product_sku
2015-10-09	09:38:31	0	[DEBUG]	Field name: virtuemart_shoppergroup_id
2015-10-09	09:38:31	0	[DEBUG]	Field name: product_currency
2015-10-09	09:38:31	0	[DEBUG]	Field name: price_quantity_start
2015-10-09	09:38:31	0	[DEBUG]	Field name: price_quantity_end
2015-10-09	09:38:31	0	[DEBUG]	Field name: product_price
2015-10-09	09:38:31	0	[DEBUG]	Field name: product_price_new
2015-10-09	09:38:31	0	[DEBUG]	==========
2015-10-09	09:38:31	0	[DEBUG]	CSVI Pro Version: 6.2.0
2015-10-09	09:38:31	0	[DEBUG]	PHP version: 5.4.27
2015-10-09	09:38:31	0	[DEBUG]	Action: import
2015-10-09	09:38:31	0	[DEBUG]	Component: com_virtuemart
2015-10-09	09:38:31	0	[DEBUG]	Operation: price
2015-10-09	09:38:31	0	[DEBUG]	Source: fromupload
2015-10-09	09:38:31	0	[DEBUG]	Load from computer: C:/xampp/htdocs/dinbok/tmp/com_csvi/1444383496/Prisuppdateringar.csv
2015-10-09	09:38:31	0	[DEBUG]	Load from server:
2015-10-09	09:38:31	0	[DEBUG]	Delete after import: No
2015-10-09	09:38:31	0	[DEBUG]	Load from URL:
2015-10-09	09:38:31	0	[DEBUG]	FTP Host:
2015-10-09	09:38:31	0	[DEBUG]	FTP Port:
2015-10-09	09:38:31	0	[DEBUG]	FTP Root Folder:
2015-10-09	09:38:31	0	[DEBUG]	FTP Filename:
2015-10-09	09:38:31	0	[DEBUG]	Autodetect delimiters: No
2015-10-09	09:38:31	0	[DEBUG]	Field Delimiter: comma
2015-10-09	09:38:31	0	[DEBUG]	Text Enclosure: ~
2015-10-09	09:38:31	0	[DEBUG]	Use file extension: csv
2015-10-09	09:38:31	0	[DEBUG]	I'm Mac: No
2015-10-09	09:38:31	0	[DEBUG]	Use file for configuration: No
2015-10-09	09:38:31	0	[DEBUG]	Add extra fields: No
2015-10-09	09:38:31	0	[DEBUG]	Skip first line: No
2015-10-09	09:38:31	0	[DEBUG]	Overwrite existing data: Yes
2015-10-09	09:38:31	0	[DEBUG]	Skip new items: No
2015-10-09	09:38:31	0	[DEBUG]	Record name:
2015-10-09	09:38:31	0	[DEBUG]	Lines per import: 1000
2015-10-09	09:38:31	0	[DEBUG]	Time between imports: 5
2015-10-09	09:38:31	0	[DEBUG]	Override system limits?: No
2015-10-09	09:38:31	0	[DEBUG]	Maximum execution time:
2015-10-09	09:38:31	0	[DEBUG]	Maximum amount of memory:
2015-10-09	09:38:31	0	[DEBUG]	Maximum size of POST data in megabytes:
2015-10-09	09:38:31	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2015-10-09	09:38:31	0	[DEBUG]	==========
2015-10-09	09:38:31	1	[DEBUG]	Use field value for field product_sku
2015-10-09	09:38:31	1	[DEBUG]	Use field value for field virtuemart_shoppergroup_id
2015-10-09	09:38:31	1	[DEBUG]	Use field value for field product_currency
2015-10-09	09:38:31	1	[DEBUG]	Use field value for field price_quantity_start
2015-10-09	09:38:31	1	[DEBUG]	Use field value for field price_quantity_end
2015-10-09	09:38:31	1	[DEBUG]	Use field value for field product_price
2015-10-09	09:38:31	1	[DEBUG]	Use field value for field product_price_new
2015-10-09	09:38:31	1	[DEBUG]	Process line 1
2015-10-09	09:38:31	1	[DEBUG]	Find product ID based on product SKU
2015-10-09	09:38:31	1	[QUERY]	SELECT `virtuemart_product_id` FROM `dinbok2_virtuemart_products` WHERE `product_sku` = '9789173874458'
2015-10-09	09:38:31	1	[DEBUG]	Check if the vendor exists
2015-10-09	09:38:31	1	[QUERY]	SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `dinbok2_virtuemart_products` WHERE `product_sku` = '9789173874458'
2015-10-09	09:38:31	1	[DEBUG]	COM_CSVI_DEBUG_GET_CURRENCY_ID
2015-10-09	09:38:31	1	[QUERY]	SELECT `virtuemart_currency_id` FROM `dinbok2_virtuemart_currencies` WHERE `currency_code_3` = 'SWEDISH KRONA' AND `virtuemart_vendor_id` = 1
2015-10-09	09:38:31	1	[DEBUG]	Finding a product_price_id
2015-10-09	09:38:31	1	[QUERY]	SELECT `virtuemart_product_price_id` FROM `dinbok2_virtuemart_product_prices` WHERE `virtuemart_product_id` = 8198 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 124 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
2015-10-09	09:38:31	1	[DEBUG]	Load a row
2015-10-09	09:38:31	1	[DEBUG]	Load a row
2015-10-09	09:38:31	1	[DEBUG]	Query for ProductPrice
2015-10-09	09:38:31	1	[QUERY]	UPDATE `dinbok2_virtuemart_product_prices` SET `virtuemart_product_id`='8198',`virtuemart_shoppergroup_id`='0',`product_price`='131.1326',`override`='0',`product_override_price`='0.00000',`product_tax_id`='3',`product_discount_id`='0',`product_currency`='124',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='2015-08-14 12:53:27',`created_by`='0',`modified_on`='2015-10-09 09:38:31',`modified_by`='516',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='5286'
2015-10-09	09:38:31	2	[DEBUG]	Use field value for field product_sku
2015-10-09	09:38:31	2	[DEBUG]	Use field value for field virtuemart_shoppergroup_id
2015-10-09	09:38:31	2	[DEBUG]	Use field value for field product_currency
2015-10-09	09:38:31	2	[DEBUG]	Use field value for field price_quantity_start
2015-10-09	09:38:31	2	[DEBUG]	Use field value for field price_quantity_end
2015-10-09	09:38:31	2	[DEBUG]	Use field value for field product_price
2015-10-09	09:38:31	2	[DEBUG]	Use field value for field product_price_new
2015-10-09	09:38:31	2	[DEBUG]	Process line 2
2015-10-09	09:38:31	2	[DEBUG]	Find product ID based on product SKU
2015-10-09	09:38:31	2	[QUERY]	SELECT `virtuemart_product_id` FROM `dinbok2_virtuemart_products` WHERE `product_sku` = '9789174752229'
2015-10-09	09:38:31	2	[DEBUG]	COM_CSVI_DEBUG_GET_CURRENCY_ID
2015-10-09	09:38:31	2	[QUERY]	SELECT `virtuemart_currency_id` FROM `dinbok2_virtuemart_currencies` WHERE `currency_code_3` = 'SWEDISH KRONA' AND `virtuemart_vendor_id` = 1
2015-10-09	09:38:31	2	[DEBUG]	Finding a product_price_id
2015-10-09	09:38:31	2	[QUERY]	SELECT `virtuemart_product_price_id` FROM `dinbok2_virtuemart_product_prices` WHERE `virtuemart_product_id` = 8389 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 124 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
2015-10-09	09:38:31	2	[DEBUG]	Load a row
2015-10-09	09:38:31	2	[DEBUG]	Load a row
2015-10-09	09:38:31	2	[DEBUG]	Query for ProductPrice
2015-10-09	09:38:31	2	[QUERY]	UPDATE `dinbok2_virtuemart_product_prices` SET `virtuemart_product_id`='8389',`virtuemart_shoppergroup_id`='0',`product_price`='74.5286',`override`='0',`product_override_price`='0.00000',`product_tax_id`='3',`product_currency`='124',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='2015-09-07 10:03:21',`created_by`='0',`modified_on`='2015-10-09 09:38:31',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='5449'