﻿
Details
Date	2015-06-09 18:51:54 UTC
Software	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date	Time	Line	Action	Comment
Processed 108 lines
2015-06-09	18:51:54	0	[DEBUG]	Clean up old logs. Found 26 logs and threshold is 25 logs
2015-06-09	18:51:54	0	[QUERY]	SELECT csvi_log_id FROM y9zak_csvi_logs ORDER BY csvi_log_id
2015-06-09	18:52:12	0	[DEBUG]	Clean up old logs. Found 25 logs and threshold is 25 logs
2015-06-09	18:52:12	0	[QUERY]	SELECT csvi_log_id FROM y9zak_csvi_logs ORDER BY csvi_log_id
2015-06-09	18:52:13	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation userinfo and action import
2015-06-09	18:52:13	0	[QUERY]	SELECT `a`.`csvi_name` FROM `y9zak_csvi_availablefields` AS `a` LEFT JOIN `y9zak_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` = 'userinfo' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2015-06-09	18:52:13	0	[DEBUG]	Load the fields to process
2015-06-09	18:52:13	0	[DEBUG]	Setup field: email
2015-06-09	18:52:13	0	[DEBUG]	Setup field: address_type
2015-06-09	18:52:13	0	[DEBUG]	Setup field: address_type_name
2015-06-09	18:52:13	0	[DEBUG]	Setup field: first_name
2015-06-09	18:52:13	0	[DEBUG]	Setup field: middle_name
2015-06-09	18:52:13	0	[DEBUG]	Setup field: last_name
2015-06-09	18:52:13	0	[DEBUG]	Setup field: address_1
2015-06-09	18:52:13	0	[DEBUG]	Setup field: address_2
2015-06-09	18:52:13	0	[DEBUG]	Setup field: city
2015-06-09	18:52:13	0	[DEBUG]	Setup field: country
2015-06-09	18:52:13	0	[DEBUG]	Setup field: company
2015-06-09	18:52:13	0	[DEBUG]	Setup field: eu_vatid
2015-06-09	18:52:13	0	[DEBUG]	Setup field: perms
2015-06-09	18:52:13	0	[DEBUG]	Setup field: password_crypt
2015-06-09	18:52:13	0	[DEBUG]	Setup field: shopper_group_name
2015-06-09	18:52:13	0	[DEBUG]	Setup field: usergroup_name
2015-06-09	18:52:13	0	[DEBUG]	Setup field: phone_1
2015-06-09	18:52:13	0	[DEBUG]	Setup field: phone_2
2015-06-09	18:52:13	0	[DEBUG]	Setup field: username
2015-06-09	18:52:13	0	[DEBUG]	Setup field: registerDate
2015-06-09	18:52:13	0	[DEBUG]	Setup field: zip
2015-06-09	18:52:13	0	[DEBUG]	Use the file for configuration
2015-06-09	18:52:13	0	[DEBUG]	==========
2015-06-09	18:52:13	0	[DEBUG]	CSVI Pro Version: 6.0rc1
2015-06-09	18:52:13	0	[DEBUG]	PHP version: 5.5.6
2015-06-09	18:52:13	0	[DEBUG]	Action: import
2015-06-09	18:52:13	0	[DEBUG]	Component: com_virtuemart
2015-06-09	18:52:13	0	[DEBUG]	Operation: userinfo
2015-06-09	18:52:13	0	[DEBUG]	Source: fromupload
2015-06-09	18:52:13	0	[DEBUG]	Load from computer: /home/qttest/public_html/tmp/com_csvi/1433875919/users.csv
2015-06-09	18:52:13	0	[DEBUG]	Load from server:
2015-06-09	18:52:13	0	[DEBUG]	Delete after import: No
2015-06-09	18:52:13	0	[DEBUG]	Load from URL:
2015-06-09	18:52:13	0	[DEBUG]	FTP Host:
2015-06-09	18:52:13	0	[DEBUG]	FTP Port:
2015-06-09	18:52:13	0	[DEBUG]	FTP Root Folder:
2015-06-09	18:52:13	0	[DEBUG]	FTP Filename:
2015-06-09	18:52:13	0	[DEBUG]	Auto detect delimiters: No
2015-06-09	18:52:13	0	[DEBUG]	Field Delimiter: ;
2015-06-09	18:52:13	0	[DEBUG]	Text Enclosure:
2015-06-09	18:52:13	0	[DEBUG]	Use file extension:
2015-06-09	18:52:13	0	[DEBUG]	I'm Mac: No
2015-06-09	18:52:13	0	[DEBUG]	Use file for configuration: Yes
2015-06-09	18:52:13	0	[DEBUG]	Add extra fields: No
2015-06-09	18:52:13	0	[DEBUG]	Skip first line: No
2015-06-09	18:52:13	0	[DEBUG]	Overwrite existing data: Yes
2015-06-09	18:52:13	0	[DEBUG]	Skip new items: No
2015-06-09	18:52:13	0	[DEBUG]	Record name:
2015-06-09	18:52:13	0	[DEBUG]	Lines per import: 1000
2015-06-09	18:52:13	0	[DEBUG]	Time between imports: 5
2015-06-09	18:52:13	0	[DEBUG]	Override system limits?: No
2015-06-09	18:52:13	0	[DEBUG]	Maximum execution time:
2015-06-09	18:52:13	0	[DEBUG]	Maximum amount of memory:
2015-06-09	18:52:13	0	[DEBUG]	Maximum size of POST data in megabytes:
2015-06-09	18:52:13	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2015-06-09	18:52:13	0	[DEBUG]	==========
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field email
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field address_type
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field address_type_name
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field first_name
2015-06-09	18:52:13	1	[DEBUG]	Use default value for field middle_name
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field last_name
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field address_1
2015-06-09	18:52:13	1	[DEBUG]	Use default value for field address_2
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field city
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field country
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field company
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field eu_vatid
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field perms
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field password_crypt
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field shopper_group_name
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field usergroup_name
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field phone_1
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field phone_2
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field username
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field registerDate
2015-06-09	18:52:13	1	[DEBUG]	Use field value for field zip
2015-06-09	18:52:13	1	[DEBUG]	Process line 1
2015-06-09	18:52:13	1	[DEBUG]	Find the user ID from Joomla
2015-06-09	18:52:13	1	[QUERY]	SELECT `id` FROM `y9zak_users` WHERE `email` = 'info@hpt.pl'
2015-06-09	18:52:13	1	[DEBUG]	Find the user info ID
2015-06-09	18:52:13	1	[QUERY]	SELECT `virtuemart_userinfo_id` FROM `y9zak_virtuemart_userinfos` WHERE `virtuemart_user_id` = 944 AND `address_type` = 'BT' AND `address_type_name` = 'Billing address'
2015-06-09	18:52:13	1	[DEBUG]	Load a row
2015-06-09	18:52:13	1	[DEBUG]	Query for User
2015-06-09	18:52:13	1	[QUERY]	UPDATE `y9zak_users` SET `name`='KRZYSZTOF BORYLO',`username`='hptuning',`email`='info@hpt.pl',`password`='$P$DvA.zt6eUndMhW8WdAIcXcggzSjAQW0',`block`='0',`sendEmail`='0',`registerDate`='0000-00-00 00:00:00',`lastvisitDate`='0000-00-00 00:00:00',`activation`='',`params`=NULL,`lastResetTime`='0000-00-00 00:00:00',`resetCount`='0',`otpKey`='',`otep`='',`requireReset`='0' WHERE `id`='944'
2015-06-09	18:52:13	1	[DEBUG]	Joomla user stored
2015-06-09	18:52:13	1	[DEBUG]	Delete old user groups
2015-06-09	18:52:13	1	[QUERY]	DELETE FROM `y9zak_user_usergroup_map` WHERE `user_id` = 944
2015-06-09	18:52:13	1	[DEBUG]	Joomla user map stored
2015-06-09	18:52:13	1	[QUERY]	INSERT INTO `y9zak_user_usergroup_map` VALUES (944, 2)
2015-06-09	18:52:13	1	[DEBUG]	Query for Userinfo
2015-06-09	18:52:13	1	[QUERY]	UPDATE `y9zak_virtuemart_userinfos` SET `virtuemart_user_id`='944',`address_type`='BT',`address_type_name`='Billing address',`name`=NULL,`company`='HP TUNING',`title`=NULL,`last_name`='BORYLO',`first_name`='KRZYSZTOF',`middle_name`=NULL,`phone_1`='91 4-851-333',`phone_2`='+48 501-214-186',`fax`=NULL,`address_1`='UL.MONTE CASSINO 39/3',`address_2`=NULL,`city`='SZCZECIN',`virtuemart_state_id`='0',`virtuemart_country_id`='170',`zip`='70-464',`agreed`='0',`tos`='0',`customer_note`='',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='2015-06-09 18:52:13',`modified_by`='937',`locked_on`='0000-00-00 00:00:00',`locked_by`='0',`eu_vatid`='PL8512529067' WHERE `virtuemart_userinfo_id`='11'
2015-06-09	18:52:13	1	[DEBUG]	VirtueMart user id: 944
2015-06-09	18:52:13	1	[DEBUG]	VirtueMart user info id: 11
2015-06-09	18:52:13	1	[DEBUG]	Find existing VirtueMart user with shopper group link
2015-06-09	18:52:13	1	[QUERY]	SELECT `id` FROM `y9zak_virtuemart_vmuser_shoppergroups` WHERE `virtuemart_user_id` = 944 AND `virtuemart_shoppergroup_id` = 5
2015-06-09	18:52:13	1	[DEBUG]	Query for VmuserShoppergroup
2015-06-09	18:52:13	1	[QUERY]	UPDATE `y9zak_virtuemart_vmuser_shoppergroups` SET `virtuemart_user_id`='944',`virtuemart_shoppergroup_id`='5' WHERE `id`='6'
2015-06-09	18:52:13	1	[DEBUG]	Load a row
2015-06-09	18:52:13	1	[DEBUG]	Query for Vmuser
2015-06-09	18:52:13	1	[QUERY]	UPDATE `y9zak_virtuemart_vmusers` SET `virtuemart_vendor_id`='1',`user_is_vendor`='0',`customer_number`='8ac4f0e5a5ec589c1b12f27aff27777c',`perms`='shopper',`virtuemart_paymentmethod_id`='0',`virtuemart_shipmentmethod_id`='0',`agreed`='0',`created_on`='2015-06-09 18:15:05',`created_by`='937',`modified_on`='2015-06-09 18:52:13',`modified_by`='937',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_user_id`='944'