Hello,
I need to import a CSV file, it contains 11 fields, among them product_sku, product_in_stock and published, but this fields are missing from Available Fields - Virtuemart - Products
I had followed what you stated in this link but still not working.
https://www.csvimproved.com/support/questions-and-answers/1098-missing-fields-in-csvi
Please check the attached image and I only get 53 available fields for products, an they should be more than 70
My site runs Joomla 3, Virtuemart 3 and CSVI pro + VM plugin all of them the latest versions.
Please help with this.
Hello,
Can you try deleting the table csvi_availablefields from the database, Run the below query to create the table again and then run the Update available fields? You should have all the fields then.
CREATE TABLE IF NOT EXISTS #__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)
) CHARSET=utf8 COMMENT='Available fields for CSVI'";
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thanks a lot for your quick response, but is not working. First the SQL string generates an error, see image 1, I had to run the script without the last line.
Then I have the same problem I have only 49 fields available yesterday I had 49) and I believe should be 82.
It was working with version 5.x a few weeks ago. I had even tried uninstalling and installing again ad t is not working. I have a very similar site and Installed 6.4 and worked perfectly. Please help.
Hello, thanks I had found my error naming the new table. It is working now, thanks a lot!
The only issue here is the error I got on SQL for the last line, I had removed the comment and works perfectly.
Log in to reply to this topic.