Support is online

update extra fields in K2 #8344

Open sniecinski opened this topic Friday, 17 June 2016 · 1 reply
Author

Hello,
I would like to update one of several available extra fields for some items in K2 (field values). Is it possible?
(CSVI Pro 6.5.7, Joomla 3.5.1, K2 2.7).
I created a file:
"id","Cechy_Gmina" (extra field name)
3,"aaa"
4,"bbb"
5,"ccc"
but after processing field is not updated. What am I doing wrong?

Kind Regards,
Lukas

2016-06-17	12:11:04	0	[DEBUG]	Clean up old logs. Found 26 logs and threshold is 25 logs
2016-06-17	12:11:04	0	[QUERY]	SELECT csvi_log_id FROM csf3e_csvi_logs ORDER BY csvi_log_id
2016-06-17	12:11:57	0	[DEBUG]	Clean up old logs. Found 25 logs and threshold is 25 logs
2016-06-17	12:11:57	0	[QUERY]	SELECT csvi_log_id FROM csf3e_csvi_logs ORDER BY csvi_log_id
2016-06-17	12:11:57	0	[DEBUG]	Loading the supported fields for com_k2, operation item and action import
2016-06-17	12:11:57	0	[QUERY]	SELECT `a`.`csvi_name` FROM `csf3e_csvi_availablefields` AS `a` LEFT JOIN `csf3e_csvi_availabletables` AS `t` ON `t`.`template_table` = `a`.`component_table` WHERE `a`.`component` = 'com_k2' AND `t`.`component` = 'com_k2' AND `t`.`task_name` = 'item' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2016-06-17	12:11:57	0	[DEBUG]	Load the fields to process
2016-06-17	12:11:57	0	[DEBUG]	Field name: id
2016-06-17	12:11:57	0	[DEBUG]	Field name: Cechy_Gmina
2016-06-17	12:11:57	0	[DEBUG]	==========
2016-06-17	12:11:57	0	[DEBUG]	CSVI Pro Version: 6.5.7
2016-06-17	12:11:57	0	[DEBUG]	PHP version: 5.6.17
2016-06-17	12:11:57	0	[DEBUG]	Action: import
2016-06-17	12:11:57	0	[DEBUG]	Component: com_k2
2016-06-17	12:11:57	0	[DEBUG]	Operation: item
2016-06-17	12:11:57	0	[DEBUG]	Source: fromupload
2016-06-17	12:11:57	0	[DEBUG]	Load from your computer: /schr/tmp/com_csvi/1466165472/gmina.csv
2016-06-17	12:11:57	0	[DEBUG]	Load from server:
2016-06-17	12:11:57	0	[DEBUG]	Delete after import: No
2016-06-17	12:11:57	0	[DEBUG]	Load from URL: http://
2016-06-17	12:11:57	0	[DEBUG]	FTP Host:
2016-06-17	12:11:57	0	[DEBUG]	FTP Port:
2016-06-17	12:11:57	0	[DEBUG]	FTP Root Folder:
2016-06-17	12:11:57	0	[DEBUG]	FTP Filename:
2016-06-17	12:11:57	0	[DEBUG]	Autodetect delimiters: No
2016-06-17	12:11:57	0	[DEBUG]	Field Delimiter: comma
2016-06-17	12:11:57	0	[DEBUG]	Text Enclosure: "
2016-06-17	12:11:57	0	[DEBUG]	Use file extension:
2016-06-17	12:11:57	0	[DEBUG]	I'm Mac: No
2016-06-17	12:11:57	0	[DEBUG]	Use file for configuration: No
2016-06-17	12:11:57	0	[DEBUG]	Add extra fields: No
2016-06-17	12:11:57	0	[DEBUG]	Skip first line: Yes
2016-06-17	12:11:57	0	[DEBUG]	Overwrite existing data: Yes
2016-06-17	12:11:57	0	[DEBUG]	Record name:
2016-06-17	12:11:57	0	[DEBUG]	Process images: Yes
2016-06-17	12:11:57	0	[DEBUG]	COM_CSVI_JFORM_overwrite_image_LABEL: No
2016-06-17	12:11:57	0	[DEBUG]	Maximum width resize: 1024
2016-06-17	12:11:57	0	[DEBUG]	Maximum height resize: 768
2016-06-17	12:11:57	0	[DEBUG]	Lines per import: 1000
2016-06-17	12:11:57	0	[DEBUG]	Time between imports: 5
2016-06-17	12:11:57	0	[DEBUG]	Override system limits?: No
2016-06-17	12:11:57	0	[DEBUG]	Maximum execution time:
2016-06-17	12:11:57	0	[DEBUG]	Maximum amount of memory:
2016-06-17	12:11:57	0	[DEBUG]	Maximum size of POST data in megabytes:
2016-06-17	12:11:57	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2016-06-17	12:11:57	0	[DEBUG]	==========
2016-06-17	12:11:57	0	[DEBUG]	Load custom fields
2016-06-17	12:11:57	0	[QUERY]	SELECT `x`.`id`,`x`.`type`,TRIM( CONCAT(`g`.`name`, '_', `x`.`name`) ) AS `title` FROM `csf3e_k2_extra_fields` AS `x` LEFT JOIN `csf3e_k2_extra_fields_groups` AS `g` ON `g`.`id` = `x`.`group`
2016-06-17	12:11:57	1	[DEBUG]	Use field value for field id
2016-06-17	12:11:57	1	[DEBUG]	Use field value for field Cechy_Gmina
2016-06-17	12:11:57	1	[DEBUG]	Process line 1
2016-06-17	12:11:57	2	[DEBUG]	Use field value for field id
2016-06-17	12:11:57	2	[DEBUG]	Use field value for field Cechy_Gmina
2016-06-17	12:11:57	2	[DEBUG]	Process line 2
2016-06-17	12:11:57	3	[DEBUG]	Use field value for field id
2016-06-17	12:11:57	3	[DEBUG]	Use field value for field Cechy_Gmina
2016-06-17	12:11:57	3	[DEBUG]	Process line 3
Support

Hello,

You are missing the required fields. Have a look at the Import K2 items documentation. It will tell you which fields you are missing and how to run the import.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.