Resolved No supported fields have been found in the import.

When editing the template I can only set one Operation option and that is: Custom tables.
Is this normal?

Hello,

I can only set one Operation option and that is: Custom tables.
Is this normal?

That is normal if you choose CSVI as component. Looking at the CSV file you posted above you need to select VirtueMart as component. If you don't have that option, you probably didn't install the VirtueMart add-on. You would need to do that first so you have the product import (amongst others) available.

Thnx for the reply Ronaldd, I now installed the virtuemart extension.
Now I can select the Component Virtuemart, but the import product isn't to be found in the list?

I tried to install the template examples, but the I get a 404 error screen, check printscreen....

That 404 screen I have never seen before. Let's start from the beginning. Go to CSVI Pro -> Maintenance -> Tasks and click Reset and confirm. After that go to CSVI Pro -> Maintenance -> Available Fields and click Update. Once that is finished, see if you do get the product import option.

done the reset part, after that I clicked on maintenance -> Available Fields and clicked update.
Same 404 error, and processing runs eternaly?

The process doesn't run anymore as soon as you see the popup. Now the error message talks about a view that is not part of CSVI. Most likely, there is a plugin interfering with the update process. You may want to check any 3rd party plugins installed that deal with content. Just unpublish any possible plugins that might be the culprit and run the update again.

Hi Ronaldd,
For shore that is the reason.
But could you be more precise please, I mean i'm not a PHP developer.
If I was then i wouldn't have bought the plugin?
It must be possible to tell me what page CSVI wants to display or what page it is calling when doing the update.
My site is pretty recent, I have plugins installed but nothing extremely special....and as far as I now nothing special for content matters.
Could this be the Joomla template causing this?

Hello,

But could you be more precise please, I mean i'm not a PHP developer.
If I was then i wouldn't have bought the plugin?

If you were a PHP developer, you would have tracked down the issue already That is why I suggested you can just go to Plugins in Joomla and turn them off, that doesn't require PHP developer knowledge.

You can't blame CSVI if other extensions are interfering with it, if I had the option to stop them from interfering with CSVI I would. It really is a trial and error process as I also don't know which plugin is doing this. You could turn off all 3rd party plugins and turn them on one by one until the error shows up.

I have plugins installed but nothing extremely special

All you need is 1 plugin that behaves bad, doesn't have to be anything special. There was another user which had a plugin that inserted a tab character in the export file. It can happen. Most plugins do not check if they are working on the frontend or backend even if they are only meant to run in the frontend.

and as far as I now nothing special for content matters.

I was suggesting content because of the error you get.

Could this be the Joomla template causing this?

That I don't think so because the error is looking for a page (view). It is a plugin that seems to alter the page layout.

Hi Roland,
After updating the webserver to the latest version of php, everything seems to work fine.
Thank you very much for the info and efforts!
Best regards,

Hello,

Good to hear that, a lesson for everybody else, make sure your system is up-to-date

I have the same error message

VERSIONS:
J3.4.3
VM3.0.10
CSVI6.3.0
PHP5.6.8

What is wrong or what could be the solution?

What is wrong or what could be the solution?

The problem I would say are your delimiters. In your template set the Auto-detect delimiters to No and specify your own. Do know that the |-symbol is also used by CSVI for other options. Best is to use the normal CSV delimiters of comma and double quote.

Unfortunately, there are some other problems.

There are some problems with reading your CSV file, look at this:

WHERE `product_sku` = 'GC0001,\"Alvikorr Alapozó és zománc egyben 0,25 liter\",Rö

CSVI doesn't recognize the SKU and reads the complete line.

Your CSV file looks all good to me and I can import it without a problem here. There is one unsupported field but not relevant to the issue here.

What do you see on the About page? Are all folders writable?

Instead of uploading the file, if you put the file on the server and let CSVI read it from the folder, does it work OK then?

0 Unsupported Failure These fields have been found but are not supported by CSVI:

product_sku
product_name
product_s_desc
product_desc
manufacturer_name
price_with_tax
product_tax
category_path
product_parent_sku
published
product_in_stock
custom_value
custom_title
custom_param
custom_price
custom_ordering
file_url

. Either these fields do not exist in your system, or the list of available fields need to be updated. To update the list of available fields go to Available Fields and click on Update.
0 Information Megjegyzés There are unsupported fields. Either these fields do not exist in your system, or the list of available fields need to be updated. To update the list of available fields go to Available Fields and click on Update.
1 Skipped Megjegyzés Missing required fields

The page is available fields will be displayed incorrectly.

http://greencoating.s50.mediacenter.hu/administrator/index.php?option=com_csvi&view=availablefields
Error message data:
1 Call to undefined method CsviControllerAvailableFields::hasRedirect() in file: /web/greencoatin/http://greencoating.eu/libraries/fof/dispatcher/dispatcher.php line: 342 timestamp: 2015-11-02T08:50:45+00:00

Hello,

Call to undefined method CsviControllerAvailableFields::hasRedirect()

This means you have a mix of old and new CSVI files in your installation. Uninstall CSVI, Install CSVI and then install the VirtueMart addon, update the available fields and try your import again.

0 Information Megjegyzés There are unsupported fields. Either these fields do not exist in your system, or the list of available fields need to be updated. To update the list of available fields go to Available Fields and click on Update.
0 Unsupported Failure These fields have been found but are not supported by CSVI:

product_sku
published
product_in_stock

. Either these fields do not exist in your system, or the list of available fields need to be updated. To update the list of available fields go to Available Fields and click on Update.
1 Skipped Megjegyzés Missing required fields


Uninstall -> install -> Avialable fields Update: It really is not in the three fields in the list

Please follow the steps in the document Missing fields in CSVI. You should have all the fields after that.

I made as in the description, but the field is not in the list

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.