Categories
View Replies (3)

Resolved Missing Available Fields for VM3

  1. paco49ers
    paco49ers
  2. RO CSVI
  3. Wednesday, 13 January 2016
  4.  Subscribe via email
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.
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
paco49ers
paco49ers
Accepted Answer Pending Moderation
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.
Attachments (1)
error-csvi-sql.png error-csvi-sql.png
  1. more than a month ago
  2. RO CSVI
  3. # 2
paco49ers
paco49ers
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


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