Categories
View Replies (5)

Resolved Adding available fields

  1. chrobaks
    chrobaks
  2. RO CSVI
  3. Thursday, 20 October 2016
  4.  Subscribe via email
Hallo all,

I have problem with adding own available fields. I using instructions on this path: https://csvimproved.com/frequently-asked-questions/902-adding-your-own-custom-fields, but after update there are not my changes.

Joomla version: Joomla! 3.6.2 Stable.
CSVI: CSVI Pro 6.6.4

Path to override.sql:
C:\wamp64\www\eshop\administrator\components\com_csvi\install\availablefields\override.sql

Content this file:

INSERT IGNORE INTO `#__csvi_available_fields` (`csvi_name`, `component_name`, `component_table`, `component`) VALUES
('Nazov tovaru', 'product_name', 'product', 'VirtueMart');
('Product_ID', 'product_sku ', 'virtuemart_products', 'VirtueMart');

And my target CSV file is in attachments.


You know what I'm doing wrong?
0
Responses (5)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Using your custom available fields functionality is not working in current CSVI version but this functionality has been modified and is coming in our next CSVI release in a new form. The patch file of this functionality is available in this post. The instruction on how to use the new functionality is also posted in there.
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
chrobaks
chrobaks
Accepted Answer Pending Moderation
Thank you, it helped me.

But now I have error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name' at line 1 SQL=INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name`, `component_table`, `component`,`action`) VALUES
('Product_ID', 'product_sku', 'virtuemart_products', 'VirtueMart', 'import');

VirtueMart is name of component in Template detail, is it correct?

edit: my MYSQL version is 5.7.14
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
But now I have error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name' at line 1 SQL=INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name`, `component_table`, `component`,`action`) VALUES
('Product_ID', 'product_sku', 'virtuemart_products', 'VirtueMart', 'import');

The reason could be the use of wrong character (`) in your override.sql file. But can i ask you why you trying to create product_name and product_ID fields in override.sql file when it is already an available field in 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. # 3
chrobaks
chrobaks
Accepted Answer Pending Moderation
Because I have CSV file from my distributor with fields name which some names are in slovak language.
product_name = Nazov tovaru

I have Product_ID but I do not know is it case sensitive or no.
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
In that case you don't need to add your available fields, you can use CSVI field mapper functionality. Map the fields from your import file to CSVI available fields and do the import.
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. # 5
  • Page :
  • 1


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