Details
Date	2015-08-25 11:19:29 UTC
Software	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date	Time	Line	Action	Comment
Processed 93 lines
2015-08-25	11:19:29	0	[DEBUG]	Clean up old logs. Found 11 logs and threshold is 25 logs
2015-08-25	11:19:29	0	[QUERY]	SELECT csvi_log_id FROM jos_csvi_logs ORDER BY csvi_log_id
2015-08-25	11:19:39	0	[DEBUG]	Clean up old logs. Found 11 logs and threshold is 25 logs
2015-08-25	11:19:39	0	[QUERY]	SELECT csvi_log_id FROM jos_csvi_logs ORDER BY csvi_log_id
2015-08-25	11:19:39	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation price and action import
2015-08-25	11:19:39	0	[QUERY]	SELECT `a`.`csvi_name` FROM `jos_csvi_availablefields` AS `a` LEFT JOIN `jos_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-08-25	11:19:39	0	[DEBUG]	Load the fields to process
2015-08-25	11:19:39	0	[DEBUG]	Field name: product_sku
2015-08-25	11:19:39	0	[DEBUG]	Field name: shopper_group_name
2015-08-25	11:19:39	0	[DEBUG]	Field name: product_price
2015-08-25	11:19:39	0	[DEBUG]	Field name: product_currency
2015-08-25	11:19:39	0	[DEBUG]	Field name: price_quantity_start
2015-08-25	11:19:39	0	[DEBUG]	Field name: price_quantity_end
2015-08-25	11:19:39	0	[DEBUG]	Field name: product_price_publish_up
2015-08-25	11:19:39	0	[DEBUG]	Field name: product_price_publish_down
2015-08-25	11:19:39	0	[DEBUG]	==========
2015-08-25	11:19:39	0	[DEBUG]	CSVI Pro Version: 6.1.0
2015-08-25	11:19:39	0	[DEBUG]	PHP version: 5.5.26
2015-08-25	11:19:39	0	[DEBUG]	Action: import
2015-08-25	11:19:39	0	[DEBUG]	Component: com_virtuemart
2015-08-25	11:19:39	0	[DEBUG]	Operation: price
2015-08-25	11:19:39	0	[DEBUG]	Source: fromupload
2015-08-25	11:19:39	0	[DEBUG]	Load from computer: /homepages/38/d566226193/htdocs/pharmacie31/tmp/com_csvi/1440501574/WS_PREISE_20082015.txt
2015-08-25	11:19:39	0	[DEBUG]	Load from server:
2015-08-25	11:19:39	0	[DEBUG]	Delete after import: No
2015-08-25	11:19:39	0	[DEBUG]	Load from URL:
2015-08-25	11:19:39	0	[DEBUG]	FTP Host:
2015-08-25	11:19:39	0	[DEBUG]	FTP Port:
2015-08-25	11:19:39	0	[DEBUG]	FTP Root Folder:
2015-08-25	11:19:39	0	[DEBUG]	FTP Filename:
2015-08-25	11:19:39	0	[DEBUG]	Auto detect delimiters: No
2015-08-25	11:19:39	0	[DEBUG]	Field Delimiter: ;
2015-08-25	11:19:39	0	[DEBUG]	Text Enclosure:
2015-08-25	11:19:39	0	[DEBUG]	Use file extension:
2015-08-25	11:19:39	0	[DEBUG]	I'm Mac: No
2015-08-25	11:19:39	0	[DEBUG]	Use file for configuration: No
2015-08-25	11:19:39	0	[DEBUG]	Add extra fields: No
2015-08-25	11:19:39	0	[DEBUG]	Skip first line: Yes
2015-08-25	11:19:39	0	[DEBUG]	Overwrite existing data: Yes
2015-08-25	11:19:39	0	[DEBUG]	Skip new items: No
2015-08-25	11:19:39	0	[DEBUG]	Record name:
2015-08-25	11:19:39	0	[DEBUG]	Lines per import: 1000
2015-08-25	11:19:39	0	[DEBUG]	Time between imports: 5
2015-08-25	11:19:39	0	[DEBUG]	Override system limits?: No
2015-08-25	11:19:39	0	[DEBUG]	Maximum execution time:
2015-08-25	11:19:39	0	[DEBUG]	Maximum amount of memory:
2015-08-25	11:19:39	0	[DEBUG]	Maximum size of POST data in megabytes:
2015-08-25	11:19:39	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2015-08-25	11:19:39	0	[DEBUG]	==========
2015-08-25	11:19:39	1	[DEBUG]	Use field value for field Article ID
2015-08-25	11:19:39	1	[DEBUG]	Use field value for field shopper_group_name
2015-08-25	11:19:39	1	[DEBUG]	Use field value for field product_price_new
2015-08-25	11:19:39	1	[DEBUG]	Use field value for field product_currency
2015-08-25	11:19:39	1	[DEBUG]	Use field value for field price_quantity_start
2015-08-25	11:19:39	1	[DEBUG]	Use field value for field price_quantity_end
2015-08-25	11:19:39	1	[DEBUG]	Use default value for field Action du
2015-08-25	11:19:39	1	[DEBUG]	Use default value for field Action au
2015-08-25	11:19:39	1	[DEBUG]	Process line 1
2015-08-25	11:19:39	1	[DEBUG]	Find product ID based on product SKU
2015-08-25	11:19:39	1	[QUERY]	SELECT `virtuemart_product_id` FROM `jos_virtuemart_products` WHERE `product_sku` = '10192605'
2015-08-25	11:19:39	1	[DEBUG]	Check if the vendor exists
2015-08-25	11:19:39	1	[QUERY]	SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `jos_virtuemart_products` WHERE `product_sku` = '10192605'
2015-08-25	11:19:39	1	[DEBUG]	COM_CSVI_DEBUG_GET_CURRENCY_ID
2015-08-25	11:19:39	1	[QUERY]	SELECT `virtuemart_currency_id` FROM `jos_virtuemart_currencies` WHERE `currency_code_3` = '27' AND `virtuemart_vendor_id` = 1
2015-08-25	11:19:39	1	[DEBUG]	Get the shopper group ID
2015-08-25	11:19:39	1	[QUERY]	SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_shoppergroups` WHERE `shopper_group_name` = '2'
2015-08-25	11:19:39	1	[DEBUG]	Finding a product_price_id
2015-08-25	11:19:39	1	[QUERY]	SELECT `virtuemart_product_price_id` FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = 362 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 27 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL)
2015-08-25	11:19:39	1	[DEBUG]	Load a row
2015-08-25	11:19:39	1	[DEBUG]	Load a row
2015-08-25	11:19:39	1	[DEBUG]	Query for ProductPrice
2015-08-25	11:19:39	1	[QUERY]	UPDATE `jos_virtuemart_product_prices` SET `virtuemart_product_id`='362',`virtuemart_shoppergroup_id`='0',`product_price`='16.266250',`override`='0',`product_override_price`='0.00000',`product_tax_id`='1',`product_discount_id`='0',`product_currency`='27',`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-25 11:11:28',`created_by`='0',`modified_on`='2015-08-25 11:19:39',`modified_by`='516',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='438'
2015-08-25	11:19:39	2	[DEBUG]	Use field value for field Article ID
2015-08-25	11:19:39	2	[DEBUG]	Use field value for field shopper_group_name
2015-08-25	11:19:39	2	[DEBUG]	Use field value for field product_price_new
2015-08-25	11:19:39	2	[DEBUG]	Use field value for field product_currency
2015-08-25	11:19:39	2	[DEBUG]	Use field value for field price_quantity_start
2015-08-25	11:19:39	2	[DEBUG]	Use field value for field price_quantity_end
2015-08-25	11:19:39	2	[DEBUG]	Use field value for field Action du
2015-08-25	11:19:39	2	[DEBUG]	Use field value for field Action au
2015-08-25	11:19:39	2	[DEBUG]	Process line 2
2015-08-25	11:19:39	2	[DEBUG]	Find product ID based on product SKU
2015-08-25	11:19:39	2	[QUERY]	SELECT `virtuemart_product_id` FROM `jos_virtuemart_products` WHERE `product_sku` = '10192605'
2015-08-25	11:19:39	2	[DEBUG]	COM_CSVI_DEBUG_GET_CURRENCY_ID
2015-08-25	11:19:39	2	[QUERY]	SELECT `virtuemart_currency_id` FROM `jos_virtuemart_currencies` WHERE `currency_code_3` = '27' AND `virtuemart_vendor_id` = 1
2015-08-25	11:19:39	2	[DEBUG]	Get the shopper group ID
2015-08-25	11:19:39	2	[QUERY]	SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_shoppergroups` WHERE `shopper_group_name` = '2'
2015-08-25	11:19:39	2	[DEBUG]	Finding a product_price_id
2015-08-25	11:19:39	2	[QUERY]	SELECT `virtuemart_product_price_id` FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = 362 AND (`virtuemart_shoppergroup_id` = 0 OR `virtuemart_shoppergroup_id` IS NULL) AND (`product_currency` = 27 OR `product_currency` IS NULL) AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND (`product_price_publish_up` = '2015-09-06 22:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '2015-09-12 22:00:00' OR `product_price_publish_down` IS NULL)
2015-08-25	11:19:39	2	[DEBUG]	Load a row
2015-08-25	11:19:39	2	[DEBUG]	Load a row
2015-08-25	11:19:39	2	[DEBUG]	Query for ProductPrice
2015-08-25	11:19:39	2	[QUERY]	UPDATE `jos_virtuemart_product_prices` SET `virtuemart_product_id`='362',`virtuemart_shoppergroup_id`='0',`product_price`='16.266250',`override`='0',`product_override_price`='0.00000',`product_tax_id`='1',`product_discount_id`='0',`product_currency`='27',`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-25 11:11:28',`created_by`='0',`modified_on`='2015-08-25 11:19:39',`modified_by`='516',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='438'