Categories
View Replies (23)

Resolved No supported fields have been found in the import.

  1. Labomba
    Labomba
  2. RO CSVI
  3. Wednesday, 16 September 2015
  4.  Subscribe via email
Hello,
I created a template and changed: use file for configuration: yes - set the delimiter manually to ;
When loading a csv file which contains 2 test articles I get the error:No supported fields have been found in the import.
But when I load the file in Maitenance - analyzer everything looks OK.
The csv file contains:
product_sku;product_desc;product_s_desc;manufacturer_name;product_price;product_in_stock;category_path
BX80662I56600K;Intel Core i5 6600K - 3.5 GHz - 4 cores - 4 threads - 6 MB cache - LGA1151 Socket - Box;Intel Core i5 6600K - 3.5 GHz - 4 cores - 4 threads - 6 MB cache - LGA1151 Socket - Box;Intel;252,132;0;CPU
BX80662I76700K;Intel Core i7 6700K - 4 GHz - 4 cores - 8 threads - 8 MB cache - LGA1151 Socket - Box;Intel Core i7 6700K - 4 GHz - 4 cores - 8 threads - 8 MB cache - LGA1151 Socket - Box;Intel;363,216;0;CPU

Going nuts over this, can somebody help?
0
Responses (23)
rolandd
rolandd
Accepted Answer Pending Moderation
Oh, I know what is wrong, your database is also out-of-date. The index on the available fields table is incomplete. If you know, go to PhpMyAdmin and delete the table csvi_availablefields and make sure it is removed.

After that on the SQL tab you can paste this command 
CREATE TABLE `jos_csvi_availablefields` (

	`csvi_availablefield_id` INT(11) NOT NULL AUTO_INCREMENT,

	`csvi_name` VARCHAR(255) NOT NULL,

	`component_name` VARCHAR(55) NOT NULL,

	`component_table` VARCHAR(55) NOT NULL,

	`component` VARCHAR(55) NOT NULL,

	`action` VARCHAR(6) NOT NULL,

	`isprimary` TINYINT(1) NOT NULL DEFAULT '0',

	PRIMARY KEY (`csvi_availablefield_id`),

	UNIQUE INDEX `component_name_table` (`component_name`, `component_table`, `component`, `action`)

)

COMMENT='Available fields for CSVI'

COLLATE='utf8_general_ci'

ENGINE=InnoDB

;
and click on Go. This will create the available fields table again. Update the available fields and now all should be there.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 21
kovacshazi
kovacshazi
Accepted Answer Pending Moderation
That's better, but still not completely.
New product ready - OK
Customfieldsforall added to products - OK
Only one custom field (Customfieldsforall) has been added to the product, it is also mixed data - Bad
Attachments (2)
no_more_custom_value.png no_more_custom_value.png
com_csvi.log.62.zip
  1. more than a month ago
  2. RO CSVI
  3. # 22
kovacshazi
kovacshazi
Accepted Answer Pending Moderation
It works!
Thank you for your patience help
  1. more than a month ago
  2. RO CSVI
  3. # 23
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!