Support is online

Not available product-name #8499

Open diegob opened this topic Monday, 12 September 2016 · 7 replies
Author

Good,
You can not make this available product name in the fields available, I have completely erased the csvi and reinstalled and does not appear as available so templates that have that field do not work.
Regards,

Support

Hello,
Please have a look at the missing fields in CSVI document to know how to see the missing available fields.

Kind regards,

Tharuna

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

Author

Hello,
I've done what you recommend, I uninstalled and physically deleted from cpanel tables ... and still the same.
I indicated that it has been running for years without problems and elsewhere works, but not add me to the fields product_name available.
I do not know what to do.
Thank you.

Support

Hello,
Can you tell me which import you are trying to do? Just confirming before we check into the cause why you don't see product_name field.

Kind regards,

Tharuna

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

Author

I am exporting products virtuemart two sku data fields and name.

Support

Hello,
Can you try to run the SQL file manually from /administrator/components/com_csvi/addon/com_virtuemart/install/availablefields.sql from phpmyadmin and see if it helps? To run the file go to phpMyAdmin >> select your database >> Click on import tab >> Select the above sql file and click go. See if product_name is available after that.

Kind regards,

Tharuna

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

Author

Hello,
It solves running on SQL, but if I run the option is cleared fields available prodoct_name.
Regards,

Support

Hello,
Can you go to PhpMyAdmin and delete the table #__csvi_availablefields?

Then in the SQL tab, can you run the below query and click on Go, so a new new available fields table is created? Don't forget to replace #_ with your table prefix. Then try to run the available fields and see if it solves the issue.

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

Log in to reply to this topic.