1. keep
  2. RO CSVI
  3. Tuesday, 11 January 2022
  4.  Subscribe via email
When you build an import template, you can assign rules to fields, which is great when you import from an Excel document and want to change new lines to line breaks. But it does work only if you add the fields manually, you can't use 'use file for configuraion' option.
The site I need to manage has several VirtueMart categories and the products have different custom fields per categories. There are standard fields, like product_sku, product_name, category_path, product_price, etc but the other fields are depenging on the product group, like you have different fields for car parts and washing machines and chocolate bars.
The site managers have different import files for different categories which can be improted with a single csvi template where the fields are based on the first line but in this case you can't use the rules. Do I need to build different import templates for different product groups (can be over 100 groups and need to be maintained after) or is there any other option?
The current task is the nl2br but could be other rules as well

RO CSVI 8.2.0
Accepted Answer Pending Moderation
Hello,
The site managers have different import files for different categories which can be improted with a single csvi template where the fields are based on the first line but in this case you can't use the rules.

Thats correct. When adding the rules to template fields, RO CSVI knows which field the rule belongs to and applies to it. There is no option to understand the rule if the column headers of file are used.

Do I need to build different import templates for different product groups (can be over 100 groups and need to be maintained after) or is there any other option?
The current task is the nl2br but could be other rules as well

If the fields and rules are different for each template then it is good to have different template for different imports. You can use the copy template option to create new import template and do the modifications as needed.
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. # 1
Accepted Answer Pending Moderation
Hi. Maybe if there would be an option to make the rules global it could help in some cases. Like a simple new line -> html line break is a good example.
If the full global solution (per rule) is too wide there could have a multi-dropdown for the template where you can select some rules which are applied to all of the fields.
Sure, it's not for every case but in my case I have only one rule (nl2br) but I shouldn't copy and manage ~100 templates
  1. one week ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
I was wondering if a custom plugin could do the job. Is it possible to trigger selected rules to selected templates via a plugin? I have PHP knowledge, I've already created csvi plugin as well but I was wondering what do you think about it?
  1. one week ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
Maybe if there would be an option to make the rules global it could help in some cases. Like a simple new line -> html line break is a good example.
If the full global solution (per rule) is too wide there could have a multi-dropdown for the template where you can select some rules which are applied to all of the fields.

We liked the idea of having global rules and are planning to develop this feature. Will send you the patch file once the feature is ready for testing.

Sure, it's not for every case but in my case I have only one rule (nl2br) but I shouldn't copy and manage ~100 templates

Yes, one rule and 100 templates is not a good idea. I hope the new global rules feature would solve this problem.
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. # 4
  • Page :
  • 1


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