# # #Date: 2015-10-29 11:07:41 UTC #Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT #Fields: date time line_nr action comment 2015-10-29 11:07:41 0 [DEBUG] Clean up old logs. Found 17 logs and threshold is 25 logs 2015-10-29 11:07:41 0 [QUERY] SELECT csvi_log_id FROM zlto4_csvi_logs ORDER BY csvi_log_id 2015-10-29 11:07:53 0 [DEBUG] Clean up old logs. Found 17 logs and threshold is 25 logs 2015-10-29 11:07:53 0 [QUERY] SELECT csvi_log_id FROM zlto4_csvi_logs ORDER BY csvi_log_id 2015-10-29 11:07:54 0 [DEBUG] Found field delimiter: ^ 2015-10-29 11:07:54 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2015-10-29 11:07:54 0 [QUERY] SELECT `a`.`csvi_name` FROM `xxxx_csvi_availablefields` AS `a` LEFT JOIN `xxxx_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' 2015-10-29 11:07:54 0 [DEBUG] Load the fields to process 2015-10-29 11:07:54 0 [DEBUG] Setup field: product_sku 2015-10-29 11:07:54 0 [DEBUG] Setup field: product_name 2015-10-29 11:07:54 0 [DEBUG] Setup field: slug 2015-10-29 11:07:54 0 [DEBUG] Use the file for configuration 2015-10-29 11:07:54 0 [DEBUG] ========== 2015-10-29 11:07:54 0 [DEBUG] CSVI Pro Version: 6.3.0 2015-10-29 11:07:54 0 [DEBUG] PHP version: 5.5.29 2015-10-29 11:07:54 0 [DEBUG] Action: import 2015-10-29 11:07:54 0 [DEBUG] Component: com_virtuemart 2015-10-29 11:07:54 0 [DEBUG] Operation: product 2015-10-29 11:07:54 0 [DEBUG] Source: fromupload 2015-10-29 11:07:54 0 [DEBUG] Load from computer: /home/domains/test.com/public_html/tmp/com_csvi/1446116870/Producttitels NL bewerkt.csv 2015-10-29 11:07:54 0 [DEBUG] Load from server: 2015-10-29 11:07:54 0 [DEBUG] Delete after import: No 2015-10-29 11:07:54 0 [DEBUG] Load from URL: 2015-10-29 11:07:54 0 [DEBUG] FTP Host: 2015-10-29 11:07:54 0 [DEBUG] FTP Port: 2015-10-29 11:07:54 0 [DEBUG] FTP Root Folder: 2015-10-29 11:07:54 0 [DEBUG] FTP Filename: 2015-10-29 11:07:54 0 [DEBUG] Autodetect delimiters: Yes 2015-10-29 11:07:54 0 [DEBUG] Field Delimiter: comma 2015-10-29 11:07:54 0 [DEBUG] Text Enclosure: 2015-10-29 11:07:54 0 [DEBUG] Use file extension: 2015-10-29 11:07:54 0 [DEBUG] I'm Mac: No 2015-10-29 11:07:54 0 [DEBUG] Use file for configuration: Yes 2015-10-29 11:07:54 0 [DEBUG] Add extra fields: No 2015-10-29 11:07:54 0 [DEBUG] Skip first line: No 2015-10-29 11:07:54 0 [DEBUG] Overwrite existing data: Yes 2015-10-29 11:07:54 0 [DEBUG] Skip new items: No 2015-10-29 11:07:54 0 [DEBUG] Record name: 2015-10-29 11:07:54 0 [DEBUG] Language: nl-NL 2015-10-29 11:07:54 0 [DEBUG] Category separator: / 2015-10-29 11:07:54 0 [DEBUG] Append categories: No 2015-10-29 11:07:54 0 [DEBUG] Import based on: product_sku 2015-10-29 11:07:54 0 [DEBUG] Unpublish before import: No 2015-10-29 11:07:54 0 [DEBUG] Recreate alias: Yes 2015-10-29 11:07:54 0 [DEBUG] Force stockable parent update: No 2015-10-29 11:07:54 0 [DEBUG] Use ICEcat data: No 2015-10-29 11:07:54 0 [DEBUG] Similar SKU search: No 2015-10-29 11:07:54 0 [DEBUG] Process images: No 2015-10-29 11:07:54 0 [DEBUG] Location product files: 2015-10-29 11:07:54 0 [DEBUG] Delete image relations: No 2015-10-29 11:07:54 0 [DEBUG] Create image name: No 2015-10-29 11:07:54 0 [DEBUG] Image name based on: product_sku 2015-10-29 11:07:54 0 [DEBUG] Image name format: jpg 2015-10-29 11:07:54 0 [DEBUG] Change case: none 2015-10-29 11:07:54 0 [DEBUG] Fill media fields: No 2015-10-29 11:07:54 0 [DEBUG] Keep original file: No 2015-10-29 11:07:54 0 [DEBUG] Convert image type: none 2015-10-29 11:07:54 0 [DEBUG] Save images on server: No 2015-10-29 11:07:54 0 [DEBUG] Re-download image: Yes 2015-10-29 11:07:54 0 [DEBUG] Resize large image: No 2015-10-29 11:07:54 0 [DEBUG] Full image width: 2015-10-29 11:07:54 0 [DEBUG] Full image height: 2015-10-29 11:07:54 0 [DEBUG] Check filetype: No 2015-10-29 11:07:54 0 [DEBUG] Automatic thumbnail creation: No 2015-10-29 11:07:54 0 [DEBUG] Thumbnail type: none 2015-10-29 11:07:54 0 [DEBUG] Thumbnail width: 90 2015-10-29 11:07:54 0 [DEBUG] Thumbnail height: 90 2015-10-29 11:07:54 0 [DEBUG] Maximum width resize: 1024 2015-10-29 11:07:54 0 [DEBUG] Maximum height resize: 768 2015-10-29 11:07:54 0 [DEBUG] Watermark: No 2015-10-29 11:07:54 0 [DEBUG] Right margin: 2015-10-29 11:07:54 0 [DEBUG] Bottom margin: 2015-10-29 11:07:54 0 [DEBUG] Image: 2015-10-29 11:07:54 0 [DEBUG] Lines per import: 1000 2015-10-29 11:07:54 0 [DEBUG] Time between imports: 5 2015-10-29 11:07:54 0 [DEBUG] Override system limits?: No 2015-10-29 11:07:54 0 [DEBUG] Maximum execution time: 2015-10-29 11:07:54 0 [DEBUG] Maximum amount of memory: 2015-10-29 11:07:54 0 [DEBUG] Maximum size of POST data in megabytes: 2015-10-29 11:07:54 0 [DEBUG] Maximum allowed size for uploaded files in megabytes: 2015-10-29 11:07:54 0 [DEBUG] ========== 2015-10-29 11:07:54 0 [DEBUG] Load the custom fields 2015-10-29 11:07:54 0 [QUERY] SELECT `virtuemart_custom_id` AS `id`, `field_type`, TRIM(`custom_title`) AS title FROM `xxxx_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','Y','X') ORDER BY `ordering` 2015-10-29 11:07:54 1 [DEBUG] Use field value for field product_sku 2015-10-29 11:07:54 1 [DEBUG] Use field value for field product_name 2015-10-29 11:07:54 1 [DEBUG] Use field value for field slug 2015-10-29 11:07:54 1 [DEBUG] Process line 1 2015-10-29 11:07:54 1 [DEBUG] Check if the vendor exists 2015-10-29 11:07:54 1 [QUERY] SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `xxxx_virtuemart_products` WHERE `product_sku` = 'ALF146BP' 2015-10-29 11:07:54 1 [DEBUG] Load a row 2015-10-29 11:07:54 1 [DEBUG] Product tax: 2015-10-29 11:07:54 1 [DEBUG] Query for Product 2015-10-29 11:07:54 1 [QUERY] UPDATE `xxxx_virtuemart_products` SET `virtuemart_product_id`='796',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`='',`product_mpn`='',`product_weight`='1.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='5.0000',`product_height`='0.0000',`product_lwh_uom`='IN',`product_url`='',`product_in_stock`='999',`product_ordered`='1',`low_stock_notification`='0',`product_available_date`='2014-10-29 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='10',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2014-10-07 19:29:08',`created_by`='0',`modified_on`='2015-10-29 11:07:54',`modified_by`='62',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='ALF146BP' 2015-10-29 11:07:54 1 [DEBUG] Check product language entry 2015-10-29 11:07:54 1 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `xxxx_virtuemart_products_nl_nl` WHERE `virtuemart_product_id` = 796 2015-10-29 11:07:54 1 [DEBUG] Load a row 2015-10-29 11:07:54 1 [DEBUG] Check if the product slug exists 2015-10-29 11:07:54 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM xxxx_virtuemart_products_nl_nl WHERE `slug` = 'alfa-romeo-146-1994-2001-5d-stootlijst-set-zijportieren' AND `virtuemart_product_id` != 796 2015-10-29 11:07:54 1 [DEBUG] Check if the product slug exists 2015-10-29 11:07:54 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM xxxx_virtuemart_products_nl_nl WHERE `slug` = 'alfa-romeo-146-1994-2001-5d-stootlijst-set-zijportieren' AND `virtuemart_product_id` != 796 2015-10-29 11:07:54 1 [DEBUG] Query for ProductLang 2015-10-29 11:07:54 1 [QUERY] UPDATE `xxxx_virtuemart_products_nl_nl` SET `product_s_desc`='',`product_desc`='

Alfa Romeo 146 \'94-\'01 stootlijst set

\r\n

 

\r\n

Een stootlijst set van Car Parts Expert beschermt uw Alfa Romeo 146 effectief tegen deukjes en krasjes. Bovendien geven ze uw Alfa Romeo 146 een stoer uiterlijk. Al onze stootlijsten zijn kwalitatief hoogwaardige producten, vervaardigd uit PU of PP tenzij anders aangegeven. Klik hier om te zien hoe u gemakkelijk en snel zelf een stootlijst set monteert.

\r\n

 

\r\n

Elke stootlijst set wordt geleverd met complete montageset en duidelijke montagehandleiding. Montage is uiterst eenvoudig, doordat het product standaard is voorzien van stevig hechtende dubbelzijdige tape. Standaard worden onze stootlijst sets geleverd in matzwart, maar voor een extra luxe uitstraling kunnen we ze ook in elke gewenste carrosseriekleur leveren. Car Parts Expert biedt daarvoor een eigen spuitservice met unieke klanttevredenheidsgarantie.

',`product_name`='Alfa Romeo 146 1994-2001 5d stootlijst set zijportieren',`metadesc`='',`metakey`='',`customtitle`='',`slug`='alfa-romeo-146-1994-2001-5d-stootlijst-set-zijportieren' WHERE `virtuemart_product_id`='796' 2015-10-29 11:07:54 1 [DEBUG] Checking manufacturer 2015-10-29 11:07:54 1 [DEBUG] Processing custom available field: COM_VIRTUEMART_PAINTEDINCOLOUR_TITLE 2015-10-29 11:07:54 1 [DEBUG] Processing custom available field: COM_VIRTUEMART_PAINTEDINCOLOUR_SELECT_COLOUR 2015-10-29 11:07:54 1 [DEBUG] Processing custom available field: In kleur gespoten 2015-10-29 11:07:54 1 [DEBUG] Processing custom available field: Select colour code 2015-10-29 11:07:54 1 [DEBUG] Processing custom available field: Beschikbare kleuren 2015-10-29 11:07:54 1 [DEBUG] Processing custom available field: COM_VIRTUEMART_PRODUCTDETAIL_BODY 2015-10-29 11:07:54 1 [DEBUG] Processing custom available field: COM_VIRTUEMART_PRODUCTDETAIL_DATE 2015-10-29 11:07:54 1 [DEBUG] Processing custom available field: COM_VIRTUEMART_PRODUCTDETAIL_COLOUR 2015-10-29 11:07:54 1 [DEBUG] Processing custom available field: Spuitoptie 2015-10-29 11:07:54 2 [DEBUG] Use field value for field product_sku 2015-10-29 11:07:54 2 [DEBUG] Use field value for field product_name 2015-10-29 11:07:54 2 [DEBUG] Use field value for field slug 2015-10-29 11:07:54 2 [DEBUG] Process line 2 2015-10-29 11:07:54 2 [DEBUG] Load a row 2015-10-29 11:07:54 2 [DEBUG] Product tax: 2015-10-29 11:07:54 2 [DEBUG] Query for Product 2015-10-29 11:07:54 2 [QUERY] UPDATE `xxxx_virtuemart_products` SET `virtuemart_product_id`='255',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_weight`='6.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='3.0000',`product_height`='0.0000',`product_lwh_uom`='IN',`product_url`='',`product_in_stock`='5',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='2012-02-15 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='5',`product_unit`='',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2012-02-16 10:26:33',`created_by`='0',`modified_on`='2015-10-29 11:07:54',`modified_by`='62',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='ALF247SU' 2015-10-29 11:07:54 2 [DEBUG] Check product language entry 2015-10-29 11:07:54 2 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `xxxx_virtuemart_products_nl_nl` WHERE `virtuemart_product_id` = 255 2015-10-29 11:07:54 2 [DEBUG] Load a row 2015-10-29 11:07:54 2 [DEBUG] Check if the product slug exists 2015-10-29 11:07:54 2 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM xxxx_virtuemart_products_nl_nl WHERE `slug` = 'alfa-romeo-147-2000-2010-3d-5d-dakspoiler' AND `virtuemart_product_id` != 255 2015-10-29 11:07:54 2 [DEBUG] Check if the product slug exists 2015-10-29 11:07:54 2 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM xxxx_virtuemart_products_nl_nl WHERE `slug` = 'alfa-romeo-147-2000-2010-3d-5d-dakspoiler' AND `virtuemart_product_id` != 255 2015-10-29 11:07:54 2 [DEBUG] Query for ProductLang 2015-10-29 11:07:54 2 [QUERY] UPDATE `xxxx_virtuemart_products_nl_nl` SET `product_s_desc`='',`product_desc`='

Alfa Romeo 147 ‘00- spoiler\r\n

\r\n

Zonder TÜV certificaat (Teilegutachten)\r\n

\r\n

 

\r\n

Deze achterklepspoiler van Car Parts Expert geeft uw Alfa Romeo 147 een sportief uiterlijk. Een dakspoiler zorgt er bovendien vaak voor dat de turbulentie achter de auto vermindert, waardoor het brandstofverbruik afneemt en uw achterruit minder snel vervuilt. Klik hier om te zien hoe u gemakkelijk en snel zelf een dakspoiler monteert.

\r\n

 

\r\n

Al onze achterklepspoilers zijn kwalitatief hoogwaardige producten, vervaardigd uit PU of ABS tenzij anders aangegeven. Ze worden geleverd met complete montageset en duidelijke montagehandleiding. Uiteraard moet een achterklepspoiler voor montage eerst in de kleur van de auto worden gespoten. U hoeft dit echter niet zelf te regelen, want Car Parts Expert biedt een eigen spuitservice met unieke klanttevredenheidsgarantie.

',`product_name`='Alfa Romeo 147 2000-2010 3d & 5d dakspoiler',`metadesc`='',`metakey`='',`customtitle`='',`slug`='alfa-romeo-147-2000-2010-3d-5d-dakspoiler' WHERE `virtuemart_product_id`='255' 2015-10-29 11:07:54 2 [DEBUG] Checking manufacturer 2015-10-29 11:07:54 2 [DEBUG] Processing custom available field: COM_VIRTUEMART_PAINTEDINCOLOUR_TITLE 2015-10-29 11:07:54 2 [DEBUG] Processing custom available field: COM_VIRTUEMART_PAINTEDINCOLOUR_SELECT_COLOUR 2015-10-29 11:07:54 2 [DEBUG] Processing custom available field: In kleur gespoten 2015-10-29 11:07:54 2 [DEBUG] Processing custom available field: Select colour code 2015-10-29 11:07:54 2 [DEBUG] Processing custom available field: Beschikbare kleuren 2015-10-29 11:07:54 2 [DEBUG] Processing custom available field: COM_VIRTUEMART_PRODUCTDETAIL_BODY 2015-10-29 11:07:54 2 [DEBUG] Processing custom available field: COM_VIRTUEMART_PRODUCTDETAIL_DATE 2015-10-29 11:07:54 2 [DEBUG] Processing custom available field: COM_VIRTUEMART_PRODUCTDETAIL_COLOUR 2015-10-29 11:07:54 2 [DEBUG] Processing custom available field: Spuitoptie 2015-10-29 11:07:54 3 [DEBUG] Use field value for field product_sku 2015-10-29 11:07:54 3 [DEBUG] Use field value for field product_name 2015-10-29 11:07:54 3 [DEBUG] Use field value for field slug 2015-10-29 11:07:54 3 [DEBUG] Process line 3 2015-10-29 11:07:54 3 [DEBUG] Load a row 2015-10-29 11:07:54 3 [DEBUG] Product tax: 2015-10-29 11:07:54 3 [DEBUG] Query for Product 2015-10-29 11:07:54 3 [QUERY] UPDATE `xxxx_virtuemart_products` SET `virtuemart_product_id`='1272',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`='',`product_mpn`='',`product_weight`='10.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='3.0000',`product_height`='0.0000',`product_lwh_uom`='IN',`product_url`='',`product_in_stock`='999',`product_ordered`='4',`low_stock_notification`='0',`product_available_date`='2015-05-11 00:00:00',`product_availability`='14d.gif',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-04-23 09:44:24',`created_by`='0',`modified_on`='2015-10-29 11:07:54',`modified_by`='62',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='ALF117TM' 2015-10-29 11:07:54 3 [DEBUG] Check product language entry 2015-10-29 11:07:54 3 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `xxxx_virtuemart_products_nl_nl` WHERE `virtuemart_product_id` = 1272 2015-10-29 11:07:54 3 [DEBUG] Load a row 2015-10-29 11:07:54 3 [DEBUG] Check if the product slug exists 2015-10-29 11:07:54 3 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM xxxx_virtuemart_products_nl_nl WHERE `slug` = 'alfa-romeo-147-2000-2010-3d-5d-kofferbakmat-anti-slip-pe-tpe' AND `virtuemart_product_id` != 1272 2015-10-29 11:07:54 3 [DEBUG] Check if the product slug exists 2015-10-29 11:07:54 3 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM xxxx_virtuemart_products_nl_nl WHERE `slug` = 'alfa-romeo-147-2000-2010-3d-5d-kofferbakmat-anti-slip-pe-tpe' AND `virtuemart_product_id` != 1272 2015-10-29 11:07:54 3 [DEBUG] Query for ProductLang 2015-10-29 11:07:54 3 [QUERY] UPDATE `xxxx_virtuemart_products_nl_nl` SET `product_s_desc`='zonder audio systeem (soundsystem)',`product_desc`='

Alfa Romeo 147 \'00-\'10 3/5d kofferbakmat anti-slip PE/TPE

zonder audio systeem (soundsystem)

Deze kofferbak mat van Car Parts Expert beschermt de bagageruimte van uw Alfa Romeo 147 tegen vuil, vloeistof en beschadiging. In tegenstelling tot veel goedkope kofferbakmatten, is deze mat een hoogwaardig product, met een volledig anti-slip oppervlak.

Producteigenschappen:

',`product_name`='Alfa Romeo 147 2000-2010 3d & 5d kofferbakmat anti-slip PE/TPE',`metadesc`='',`metakey`='',`customtitle`='',`slug`='alfa-romeo-147-2000-2010-3d-5d-kofferbakmat-anti-slip-pe-tpe' WHERE `virtuemart_product_id`='1272' 2015-10-29 11:07:54 3 [DEBUG] Checking manufacturer 2015-10-29 11:07:54 3 [DEBUG] Processing custom available field: COM_VIRTUEMART_PAINTEDINCOLOUR_TITLE 2015-10-29 11:07:54 3 [DEBUG] Processing custom available field: COM_VIRTUEMART_PAINTEDINCOLOUR_SELECT_COLOUR 2015-10-29 11:07:54 3 [DEBUG] Processing custom available field: In kleur gespoten 2015-10-29 11:07:54 3 [DEBUG] Processing custom available field: Select colour code 2015-10-29 11:07:54 3 [DEBUG] Processing custom available field: Beschikbare kleuren 2015-10-29 11:07:54 3 [DEBUG] Processing custom available field: COM_VIRTUEMART_PRODUCTDETAIL_BODY 2015-10-29 11:07:54 3 [DEBUG] Processing custom available field: COM_VIRTUEMART_PRODUCTDETAIL_DATE 2015-10-29 11:07:54 3 [DEBUG] Processing custom available field: COM_VIRTUEMART_PRODUCTDETAIL_COLOUR 2015-10-29 11:07:54 3 [DEBUG] Processing custom available field: Spuitoptie