#
#
#Date: 2023-02-22 09:39:41 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
#Fields: date time line_nr action comment
2023-02-22 09:39:41 0 [DEBUG] Clean up old logs. Found 51 logs and threshold is 50 logs
2023-02-22 09:39:45 0 [DEBUG] Loading the supported fields for com_virtuemart, operation manufacturer and action import
2023-02-22 09:39:45 0 [QUERY] SELECT `a`.`csvi_name` FROM `qldvm_csvi_availablefields` AS `a` LEFT JOIN `qldvm_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` = 'manufacturer' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2023-02-22 09:39:45 0 [DEBUG] Load the fields to process
2023-02-22 09:39:45 0 [DEBUG] Field name: virtuemart_manufacturer_id
2023-02-22 09:39:45 0 [DEBUG] Field name: mf_name
2023-02-22 09:39:45 0 [DEBUG] Field name: mf_desc
2023-02-22 09:39:45 0 [DEBUG] Field name: mf_email
2023-02-22 09:39:45 0 [DEBUG] Field name: file_title
2023-02-22 09:39:45 0 [DEBUG] Field name: skip
2023-02-22 09:39:45 0 [DEBUG] Field name: file_meta
2023-02-22 09:39:45 0 [DEBUG] Field name: customtitle
2023-02-22 09:39:45 0 [DEBUG] Field name: metakey
2023-02-22 09:39:45 0 [DEBUG] Field name: metadesc
2023-02-22 09:39:45 0 [DEBUG] Field name: metarobot
2023-02-22 09:39:45 0 [DEBUG] Field name: metaauthor
2023-02-22 09:39:45 0 [DEBUG] Field name: published
2023-02-22 09:39:45 0 [DEBUG] Use field value for field virtuemart_manufacturer_id
2023-02-22 09:39:45 0 [DEBUG] Use field value for field mf_name
2023-02-22 09:39:45 0 [DEBUG] Use field value for field mf_desc
2023-02-22 09:39:45 0 [DEBUG] Use default value for field mf_email
2023-02-22 09:39:45 0 [DEBUG] Use field value for field file_title
2023-02-22 09:39:45 0 [DEBUG] Use default value for field file_url
2023-02-22 09:39:45 0 [DEBUG] Use field value for field file_meta
2023-02-22 09:39:45 0 [DEBUG] Use field value for field customtitle
2023-02-22 09:39:45 0 [DEBUG] Use field value for field metakey
2023-02-22 09:39:45 0 [DEBUG] Use field value for field metadesc
2023-02-22 09:39:45 0 [DEBUG] Use field value for field metarobot
2023-02-22 09:39:45 0 [DEBUG] Use field value for field metaauthor
2023-02-22 09:39:45 0 [DEBUG] Use field value for field published
2023-02-22 09:39:58 0 [DEBUG] Loading the supported fields for com_virtuemart, operation manufacturer and action import
2023-02-22 09:39:58 0 [QUERY] SELECT `a`.`csvi_name` FROM `qldvm_csvi_availablefields` AS `a` LEFT JOIN `qldvm_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` = 'manufacturer' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2023-02-22 09:39:58 0 [DEBUG] Load the fields to process
2023-02-22 09:39:58 0 [DEBUG] Field name: virtuemart_manufacturer_id
2023-02-22 09:39:58 0 [DEBUG] Field name: mf_name
2023-02-22 09:39:58 0 [DEBUG] Field name: mf_desc
2023-02-22 09:39:58 0 [DEBUG] Field name: mf_email
2023-02-22 09:39:58 0 [DEBUG] Field name: file_title
2023-02-22 09:39:58 0 [DEBUG] Field name: skip
2023-02-22 09:39:58 0 [DEBUG] Field name: file_meta
2023-02-22 09:39:58 0 [DEBUG] Field name: customtitle
2023-02-22 09:39:58 0 [DEBUG] Field name: metakey
2023-02-22 09:39:58 0 [DEBUG] Field name: metadesc
2023-02-22 09:39:58 0 [DEBUG] Field name: metarobot
2023-02-22 09:39:58 0 [DEBUG] Field name: metaauthor
2023-02-22 09:39:58 0 [DEBUG] Field name: published
2023-02-22 09:39:58 0 [DEBUG] Clean up old logs. Found 50 logs and threshold is 50 logs
2023-02-22 09:39:58 0 [DEBUG] Loading the supported fields for com_virtuemart, operation manufacturer and action import
2023-02-22 09:39:58 0 [QUERY] SELECT `a`.`csvi_name` FROM `qldvm_csvi_availablefields` AS `a` LEFT JOIN `qldvm_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` = 'manufacturer' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2023-02-22 09:39:58 0 [DEBUG] Load the fields to process
2023-02-22 09:39:58 0 [DEBUG] Field name: virtuemart_manufacturer_id
2023-02-22 09:39:58 0 [DEBUG] Field name: mf_name
2023-02-22 09:39:58 0 [DEBUG] Field name: mf_desc
2023-02-22 09:39:58 0 [DEBUG] Field name: mf_email
2023-02-22 09:39:58 0 [DEBUG] Field name: file_title
2023-02-22 09:39:58 0 [DEBUG] Field name: skip
2023-02-22 09:39:58 0 [DEBUG] Field name: file_meta
2023-02-22 09:39:58 0 [DEBUG] Field name: customtitle
2023-02-22 09:39:58 0 [DEBUG] Field name: metakey
2023-02-22 09:39:58 0 [DEBUG] Field name: metadesc
2023-02-22 09:39:58 0 [DEBUG] Field name: metarobot
2023-02-22 09:39:58 0 [DEBUG] Field name: metaauthor
2023-02-22 09:39:58 0 [DEBUG] Field name: published
2023-02-22 09:39:58 0 [DEBUG] ==========
2023-02-22 09:39:58 0 [DEBUG] RO CSVI Version: 8.6.1
2023-02-22 09:39:58 0 [DEBUG] PHP version: 7.4.33
2023-02-22 09:39:58 0 [DEBUG] Action: import
2023-02-22 09:39:58 0 [DEBUG] Component: com_virtuemart
2023-02-22 09:39:58 0 [DEBUG] Operation: manufacturer
2023-02-22 09:39:58 0 [DEBUG] Override:
2023-02-22 09:39:58 0 [DEBUG] Source: fromupload
2023-02-22 09:39:58 0 [DEBUG] Load from your computer: /var/www/vhosts/domain.com/tmp/com_csvi/1924946061/Manufacturers (5).csv
2023-02-22 09:39:58 0 [DEBUG] Load from server:
2023-02-22 09:39:58 0 [DEBUG] Delete after import: No
2023-02-22 09:39:58 0 [DEBUG] URL: https://domain.it/exp/Manufacturers.csv
2023-02-22 09:39:58 0 [DEBUG] URL Username:
2023-02-22 09:39:58 0 [DEBUG] Name of username field: user
2023-02-22 09:39:58 0 [DEBUG] URL Password:
2023-02-22 09:39:58 0 [DEBUG] Name of the password field: password
2023-02-22 09:39:58 0 [DEBUG] Retrieve method: get
2023-02-22 09:39:58 0 [DEBUG] Authorization Type: plain
2023-02-22 09:39:58 0 [DEBUG] Encode URL: Yes
2023-02-22 09:39:58 0 [DEBUG] (S)FTP Host:
2023-02-22 09:39:58 0 [DEBUG] (S)FTP Port:
2023-02-22 09:39:58 0 [DEBUG] SFTP: No
2023-02-22 09:39:58 0 [DEBUG] (S)FTP Root Folder:
2023-02-22 09:39:58 0 [DEBUG] (S)FTP Filename:
2023-02-22 09:39:58 0 [DEBUG] Connection Type:
2023-02-22 09:39:58 0 [DEBUG] Table List:
2023-02-22 09:39:58 0 [DEBUG] Username:
2023-02-22 09:39:58 0 [DEBUG] Host:
2023-02-22 09:39:58 0 [DEBUG] Port:
2023-02-22 09:39:58 0 [DEBUG] Database Name:
2023-02-22 09:39:58 0 [DEBUG] Database Table:
2023-02-22 09:39:58 0 [DEBUG] Client ID:
2023-02-22 09:39:58 0 [DEBUG] Client Secret:
2023-02-22 09:39:58 0 [DEBUG] Spreadsheet Id:
2023-02-22 09:39:58 0 [DEBUG] Sheet name:
2023-02-22 09:39:58 0 [DEBUG] From Cell/Column:
2023-02-22 09:39:58 0 [DEBUG] To Cell/Column:
2023-02-22 09:39:58 0 [DEBUG] Autodetect delimiters: No
2023-02-22 09:39:58 0 [DEBUG] Field Delimiter: ;
2023-02-22 09:39:58 0 [DEBUG] Text Enclosure: "
2023-02-22 09:39:58 0 [DEBUG] Escape Character:
2023-02-22 09:39:58 0 [DEBUG] Use file extension:
2023-02-22 09:39:58 0 [DEBUG] I'm Mac: No
2023-02-22 09:39:58 0 [DEBUG] Use file for configuration: No
2023-02-22 09:39:58 0 [DEBUG] Add extra fields: No
2023-02-22 09:39:58 0 [DEBUG] Skip first line: No
2023-02-22 09:39:58 0 [DEBUG] Skip lines: Yes
2023-02-22 09:39:58 0 [DEBUG] Overwrite existing data: Yes
2023-02-22 09:39:58 0 [DEBUG] Skip new items: No
2023-02-22 09:39:58 0 [DEBUG] Skip empty custom fields: No
2023-02-22 09:39:58 0 [DEBUG] Record container:
2023-02-22 09:39:58 0 [DEBUG] Record name:
2023-02-22 09:39:58 0 [DEBUG] Language: en-GB
2023-02-22 09:39:58 0 [DEBUG] Translation language: en-GB
2023-02-22 09:39:58 0 [DEBUG] Category separator: /
2023-02-22 09:39:58 0 [DEBUG] Global Rules:
2023-02-22 09:39:58 0 [DEBUG] Lines per import: 1000
2023-02-22 09:39:58 0 [DEBUG] Time between imports: 5
2023-02-22 09:39:58 0 [DEBUG] Override system limits?: No
2023-02-22 09:39:58 0 [DEBUG] Maximum execution time:
2023-02-22 09:39:58 0 [DEBUG] Maximum amount of memory:
2023-02-22 09:39:58 0 [DEBUG] Maximum size of POST data in megabytes:
2023-02-22 09:39:58 0 [DEBUG] Maximum allowed size for uploaded files in megabytes:
2023-02-22 09:39:58 0 [DEBUG] Template ID: 25
2023-02-22 09:39:58 0 [DEBUG] Tags:
2023-02-22 09:39:58 0 [DEBUG] Access token details:
2023-02-22 09:39:58 0 [DEBUG] ==========
2023-02-22 09:39:58 0 [DEBUG] Updating start date and time of import
2023-02-22 09:39:58 0 [QUERY] UPDATE `qldvm_csvi_logs` SET `start` = '2023-02-22 09:39:58' WHERE `csvi_log_id` = 113028
2023-02-22 09:39:58 1 [DEBUG] Use field value for field virtuemart_manufacturer_id
2023-02-22 09:39:58 1 [DEBUG] Use field value for field mf_name
2023-02-22 09:39:58 1 [DEBUG] Use field value for field mf_desc
2023-02-22 09:39:58 1 [DEBUG] Use default value for field mf_email
2023-02-22 09:39:58 1 [DEBUG] Use field value for field file_title
2023-02-22 09:39:58 1 [DEBUG] Use default value for field file_url
2023-02-22 09:39:58 1 [DEBUG] Use field value for field file_meta
2023-02-22 09:39:58 1 [DEBUG] Use field value for field customtitle
2023-02-22 09:39:58 1 [DEBUG] Use field value for field metakey
2023-02-22 09:39:58 1 [DEBUG] Use field value for field metadesc
2023-02-22 09:39:58 1 [DEBUG] Use field value for field metarobot
2023-02-22 09:39:58 1 [DEBUG] Use field value for field metaauthor
2023-02-22 09:39:58 1 [DEBUG] Use field value for field published
2023-02-22 09:39:58 1 [DEBUG] Process line 1
2023-02-22 09:39:58 1 [DEBUG] Manufacturer exists
2023-02-22 09:39:58 1 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `qldvm_virtuemart_manufacturers` WHERE `virtuemart_manufacturer_id` = 292
2023-02-22 09:39:58 1 [DEBUG] Load a row
2023-02-22 09:39:58 1 [DEBUG] Manufacturer category does not exist
2023-02-22 09:39:58 1 [QUERY] SELECT `virtuemart_manufacturercategories_id` FROM `qldvm_virtuemart_manufacturercategories_en_gb` WHERE `mf_category_name` = ''
2023-02-22 09:39:58 1 [DEBUG] Query for Manufacturer
2023-02-22 09:39:58 1 [DEBUG] Executed store
2023-02-22 09:39:58 1 [QUERY] UPDATE `qldvm_virtuemart_manufacturers` SET `virtuemart_manufacturercategories_id`='1',`metarobot`='',`metaauthor`='',`hits`='0',`published`='1',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='2023-02-22 09:39:58',`modified_by`='778',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_manufacturer_id` = '292'
2023-02-22 09:39:58 1 [DEBUG] Load a row
2023-02-22 09:39:58 1 [DEBUG] Manufacturer already exists
2023-02-22 09:39:58 1 [QUERY] SELECT * FROM qldvm_virtuemart_manufacturers_en_gb WHERE `virtuemart_manufacturer_id` = '292'
2023-02-22 09:39:58 1 [DEBUG] Query for ManufacturerLang
2023-02-22 09:39:58 1 [DEBUG] Executed store
2023-02-22 09:39:58 1 [QUERY] UPDATE `qldvm_virtuemart_manufacturers_en_gb` SET `mf_name`='AGLUTEN',`mf_email`='',`mf_desc`='\r\nSenza lattosio, senza coloranti, senza glutine, senza aromi artificiali e conservanti.
',`mf_url`='',`metadesc`='Agluten prodotti pieni di gusto privi di glutine, senza lattosio, senza coloranti, senza glutine, senza aromi artificiali e conservanti. Fonte di fibre',`metakey`='forno agluten, farina senza glutine,',`customtitle`='Agluten pane e farine, pasta, colazione, merende e dolci e tanto altro...',`slug`='agluten' WHERE `virtuemart_manufacturer_id` = '292'