Details
Date	2016-01-26 08:57:59 UTC
Software	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date	Time	Line	Action	Comment
Processed 112 lines
2016-01-26	08:57:59	0	[DEBUG]	Clean up old logs. Found 26 logs and threshold is 25 logs
2016-01-26	08:57:59	0	[QUERY]	SELECT csvi_log_id FROM fng69_csvi_logs ORDER BY csvi_log_id
2016-01-26	08:58:10	0	[DEBUG]	Clean up old logs. Found 25 logs and threshold is 25 logs
2016-01-26	08:58:10	0	[QUERY]	SELECT csvi_log_id FROM fng69_csvi_logs ORDER BY csvi_log_id
2016-01-26	08:58:10	0	[DEBUG]	Found field delimiter: ,
2016-01-26	08:58:10	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation product and action import
2016-01-26	08:58:10	0	[QUERY]	SELECT `a`.`csvi_name` FROM `fng69_csvi_availablefields` AS `a` LEFT JOIN `fng69_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` = 'product' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2016-01-26	08:58:10	0	[DEBUG]	Load the fields to process
2016-01-26	08:58:10	0	[DEBUG]	Field name: product_sku
2016-01-26	08:58:10	0	[DEBUG]	Field name: product_mpn
2016-01-26	08:58:10	0	[DEBUG]	Field name: product_name
2016-01-26	08:58:10	0	[DEBUG]	Field name: product_desc
2016-01-26	08:58:10	0	[DEBUG]	==========
2016-01-26	08:58:10	0	[DEBUG]	CSVI Pro Version: 6.4.3
2016-01-26	08:58:10	0	[DEBUG]	PHP version: 5.5.31
2016-01-26	08:58:10	0	[DEBUG]	Action: import
2016-01-26	08:58:10	0	[DEBUG]	Component: com_virtuemart
2016-01-26	08:58:10	0	[DEBUG]	Operation: product
2016-01-26	08:58:10	0	[DEBUG]	Source: fromupload
2016-01-26	08:58:10	0	[DEBUG]	Load from computer: /home/sotecmex/public_html/neww/tmp/com_csvi/1453798686/IMPORTAR.csv
2016-01-26	08:58:10	0	[DEBUG]	Load from server:
2016-01-26	08:58:10	0	[DEBUG]	Delete after import: No
2016-01-26	08:58:10	0	[DEBUG]	Load from URL:
2016-01-26	08:58:10	0	[DEBUG]	FTP Host:
2016-01-26	08:58:10	0	[DEBUG]	FTP Port:
2016-01-26	08:58:10	0	[DEBUG]	FTP Root Folder:
2016-01-26	08:58:10	0	[DEBUG]	FTP Filename:
2016-01-26	08:58:10	0	[DEBUG]	Autodetect delimiters: Yes
2016-01-26	08:58:10	0	[DEBUG]	Field Delimiter: comma
2016-01-26	08:58:10	0	[DEBUG]	Text Enclosure:
2016-01-26	08:58:10	0	[DEBUG]	Use file extension:
2016-01-26	08:58:10	0	[DEBUG]	I'm Mac: No
2016-01-26	08:58:10	0	[DEBUG]	Use file for configuration: No
2016-01-26	08:58:10	0	[DEBUG]	Add extra fields: No
2016-01-26	08:58:10	0	[DEBUG]	Skip first line: Yes
2016-01-26	08:58:10	0	[DEBUG]	Overwrite existing data: Yes
2016-01-26	08:58:10	0	[DEBUG]	Skip new items: No
2016-01-26	08:58:10	0	[DEBUG]	Record name:
2016-01-26	08:58:10	0	[DEBUG]	Language: es-ES
2016-01-26	08:58:10	0	[DEBUG]	Category separator: /
2016-01-26	08:58:10	0	[DEBUG]	Append categories: No
2016-01-26	08:58:10	0	[DEBUG]	Import based on: product_sku
2016-01-26	08:58:10	0	[DEBUG]	Unpublish before import: No
2016-01-26	08:58:10	0	[DEBUG]	Recreate alias: No
2016-01-26	08:58:10	0	[DEBUG]	Force stockable parent update: No
2016-01-26	08:58:10	0	[DEBUG]	Use ICEcat data: Yes
2016-01-26	08:58:10	0	[DEBUG]	Similar SKU search: No
2016-01-26	08:58:10	0	[DEBUG]	COM_CSVI_JFORM_1_LABEL: product_available_date
2016-01-26	08:58:10	0	[DEBUG]	Process images: Yes
2016-01-26	08:58:10	0	[DEBUG]	Location product files:
2016-01-26	08:58:10	0	[DEBUG]	Delete image relations: No
2016-01-26	08:58:10	0	[DEBUG]	Create image name: No
2016-01-26	08:58:10	0	[DEBUG]	Image name based on: product_sku
2016-01-26	08:58:10	0	[DEBUG]	Image name format: jpg
2016-01-26	08:58:10	0	[DEBUG]	Change case: none
2016-01-26	08:58:10	0	[DEBUG]	Fill media fields: No
2016-01-26	08:58:10	0	[DEBUG]	Keep original file: No
2016-01-26	08:58:10	0	[DEBUG]	Convert image type: none
2016-01-26	08:58:10	0	[DEBUG]	Save images on server: Yes
2016-01-26	08:58:10	0	[DEBUG]	Re-download image: Yes
2016-01-26	08:58:10	0	[DEBUG]	Resize large image: No
2016-01-26	08:58:10	0	[DEBUG]	Full image width:
2016-01-26	08:58:10	0	[DEBUG]	Full image height:
2016-01-26	08:58:10	0	[DEBUG]	Check filetype: No
2016-01-26	08:58:10	0	[DEBUG]	Automatic thumbnail creation: Yes
2016-01-26	08:58:10	0	[DEBUG]	Thumbnail type: none
2016-01-26	08:58:10	0	[DEBUG]	Thumbnail width: 90
2016-01-26	08:58:10	0	[DEBUG]	Thumbnail height: 90
2016-01-26	08:58:10	0	[DEBUG]	Maximum width resize: 1024
2016-01-26	08:58:10	0	[DEBUG]	Maximum height resize: 768
2016-01-26	08:58:10	0	[DEBUG]	Watermark: No
2016-01-26	08:58:10	0	[DEBUG]	Right margin:
2016-01-26	08:58:10	0	[DEBUG]	Bottom margin:
2016-01-26	08:58:10	0	[DEBUG]	Image:
2016-01-26	08:58:10	0	[DEBUG]	Lines per import: 1000
2016-01-26	08:58:10	0	[DEBUG]	Time between imports: 5
2016-01-26	08:58:10	0	[DEBUG]	Override system limits?: No
2016-01-26	08:58:10	0	[DEBUG]	Maximum execution time:
2016-01-26	08:58:10	0	[DEBUG]	Maximum amount of memory:
2016-01-26	08:58:10	0	[DEBUG]	Maximum size of POST data in megabytes:
2016-01-26	08:58:10	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2016-01-26	08:58:10	0	[DEBUG]	==========
2016-01-26	08:58:10	0	[DEBUG]	Load the custom fields
2016-01-26	08:58:10	0	[QUERY]	SELECT `virtuemart_custom_id` AS `id`, `field_type`, TRIM(`custom_title`) AS title FROM `fng69_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','Y','X') ORDER BY `ordering`
2016-01-26	08:58:10	1	[DEBUG]	Found ICEcat mpn reference: RC-922M-KWN1-GP
2016-01-26	08:58:10	1	[DEBUG]	Found ICEcat manufacturer name:
2016-01-26	08:58:10	1	[DEBUG]	ICEcat manufacturer not found
2016-01-26	08:58:10	1	[DEBUG]	Use field value for field product_sku
2016-01-26	08:58:10	1	[DEBUG]	Use field value for field product_mpn
2016-01-26	08:58:10	1	[DEBUG]	Use default value for field product_name
2016-01-26	08:58:10	1	[DEBUG]	Use default value for field product_desc
2016-01-26	08:58:10	1	[DEBUG]	Process line 1
2016-01-26	08:58:10	1	[DEBUG]	Check if the vendor exists
2016-01-26	08:58:10	1	[QUERY]	SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `fng69_virtuemart_products` WHERE `product_sku` = 'RC-922M-KWN1-GP'
2016-01-26	08:58:10	1	[DEBUG]	Load a row
2016-01-26	08:58:10	1	[DEBUG]	Processing item: RC-922M-KWN1-GP
2016-01-26	08:58:10	1	[DEBUG]	Product tax:
2016-01-26	08:58:10	1	[DEBUG]	Query for Product
2016-01-26	08:58:10	1	[QUERY]	INSERT INTO `fng69_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_mpn`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','0','RC-922M-KWN1-GP','RC-922M-KWN1-GP','0','KG','0','0','0','M','','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','0','0','2016-01-26 08:58:10','557','2016-01-26 08:58:10','557','0000-00-00 00:00:00','0')
2016-01-26	08:58:10	1	[DEBUG]	Check product language entry
2016-01-26	08:58:10	1	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `fng69_virtuemart_products_es_es` WHERE `virtuemart_product_id` = 10
2016-01-26	08:58:10	1	[DEBUG]	Check if the product slug exists
2016-01-26	08:58:10	1	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM fng69_virtuemart_products_es_es WHERE `slug` = '2016-01-26-08-58-102011501951' AND `virtuemart_product_id` != 10
2016-01-26	08:58:10	1	[DEBUG]	Insert the dummy entry for the product language
2016-01-26	08:58:10	1	[QUERY]	INSERT INTO `fng69_virtuemart_products_es_es` (`virtuemart_product_id`,`slug`) VALUES (10, '2016-01-26-08-58-102011501951')
2016-01-26	08:58:10	1	[DEBUG]	Query for ProductLang
2016-01-26	08:58:10	1	[QUERY]	UPDATE `fng69_virtuemart_products_es_es` SET `product_s_desc`='',`product_desc`='',`product_name`='',`metadesc`='',`metakey`='',`customtitle`='',`slug`='2016-01-26-08-58-102011501951' WHERE `virtuemart_product_id`='10'
2016-01-26	08:58:10	1	[DEBUG]	Checking manufacturer
2016-01-26	08:58:10	1	[DEBUG]	Processing custom available field: Top Right Position
2016-01-26	08:58:10	1	[DEBUG]	Processing custom available field: Specification
2016-01-26	08:58:10	1	[DEBUG]	Processing custom available field: Size
2016-01-26	08:58:10	1	[DEBUG]	Processing custom available field: Color