1. keep
  2. RO CSVI
  3. Tuesday, 26 March 2019
  4.  Subscribe via email
There is a site where are several virtuemart custom fields. These are mostly meta params of the product, like: color, material etc.
I run the 'available fields' script of CSVI and added them to the export template as template field.
The export/import is fine except one thing.
There is a custom field which is called 'gifts' and sometimes multiple instances of this field is binded to the product, because some products contains 1 gift, some other containts 3 gifts etc. So in the #__virtuemart_product_customfield table there are multiple rows with the same virtuemart_product_id and virtuemart_custom_id
How can I export/import these fields?
The main goal would be building a product filter with breadesigns' custom filters extension and use a checkbox to filter the products where a specified gift is available.
Accepted Answer
Accepted Answer Pending Moderation
Hello,
Sorry for delayed response on this feature. With the attached patch file you can import and export multiple values for custom fields. The values are separated by ~ instead of | as (~) separator is the default character used in custom fields. If you are specific in using | character then you can use RO CSVI Multi replace rule to find | character and replace with ~ character. Load the attached patch file and run the export and import. The patch file was developed based on RO CSVI 8.2.0 version files so make sure to use the patch file in this version.


Let me know on how it goes.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # Permalink
Accepted Answer Pending Moderation
Hello,
For exporting and importing multiple values you need to use custom_title, custom_value and custom_param as available fields. Check Product import with custom fields document for import examples and Product export with custom fields for export examples.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello

Yes, I found it, it's ok for me, but it makes more hard to handle that for the data admin, who is not a programmer.
Could you please consider adding a spearator-based version, like file_url or category_path where I can set multiple values via a single field with a | separator character?
It would be much more easy to read/handle that
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Thank you for your feedback. We do have the plan of making custom fields handling in a more user friendly way and you can expect these changes with CSVI 8 version which we are planning to release later this year.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,

You are asking for a more friendly format, but what do you suggest? If we take the example CSV
product_sku;custom_title;custom_value;custom_price;custom_param;custom_disabler;custom_override
H01;Size~Size~Size;34~36~38;24~26~28;Y~N~Y;Y~N~Y


You have a Size field with different sizes and values. How would you propose to handle that? I am just looking for some feedback here :)
Kind regards,

RolandD

=========================
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. # 4
Accepted Answer Pending Moderation
maybe something like this:
product_sku;color;material;gifts
sku1;black;metal;case
sku2;white;metal;case|cable|spare buttons
sku3;white;plastic;

It's quite similar to multiple category_path or file_url values
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hi guys

Any update with this? I can't teach the classic way to the site admins :)
  1. one week ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
cool, great functionality, great support
  1. one week ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


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