1. widevsrl
  2. RO CSVI
  3. Friday, 15 October 2021
  4.  Subscribe via email
Hi we use rules on import csv and we need to search if a word is inside string ex:

word "STREET" or "street" or "Street" and "Scooter" or "SCOOTER" or "scooter" are present inside the string like " The SCOOTER BLU and Green.." if the word si present (on this case "SCOOTER" we need to assigne a specific value to a custom fields created with "Custom fields for all" plugin.

With rule, that we have make, is possible find a single word in an identical single word but not inside a string, if the field that we check contain an identical single word the rule work properly otherwise if the field contain a string the role not match.
Accepted Answer Pending Moderation
Hello,
Yes, single word check would work with conditional rule but not with strings. To check if the word exists in a given string you need to use regular expressions. This regular expression search and replace option is available with RO CSVI Multi replace rule and not with conditional rule. See attached screenshot on how to use regex with Multi replace rule.


(?i)(scooter)


What you can do, using RO CSVI Field copy rule copy the text from the field which has value " The SCOOTER BLU and Green.." to custom field created with Custom fields for all plugin. Apply the multi replace rule on the custom field so the word is searched and replaced with value you need.
Attachments (1)
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
Hi thanks for your respons,
i have create the rule to concatenate 3 fields on one and the result is ok.

Schermata del 2021-10-15 17-18-43.png (Rule)
Schermata del 2021-10-15 17-47-37.png (Result)

i have created the second rule to find string "Street" and replace ALL the text with only the text "Street", but it not work properly, the text is found but not replaced

Schermata del 2021-10-15 17-55-50.png (Rule)
and assigned to the field
Schermata del 2021-10-15 17-58-52.png (Assigned rule to field)
and
Schermata del 2021-10-15 18-02-48.png (Result)

Thanks in advance for your help
Attachments (5)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Schermata del 2021-10-15 17-18-43.png (Rule)

I am seeing there are untranslated strings on the Field combine rules page. Which language you are using?

i have created the second rule to find string "Street" and replace ALL the text with only the text "Street", but it not work properly, the text is found but not replaced

The regex i sent is to find the text scooter in the string and replace only that word. I guess you are looking for text street and scooter in the string and it has to replace the whole phrase with Street. With the new regex here the phrase will look for one word in the string. So "This is a new street in the city" will be replaced to just "Street"(As an example). To also check for text scooter, create another rule operation for Find and replace for scooter string with the same regex.


/[A-Z][^\\.;]*(?i)(street)[^\\.;]*/



/[A-Z][^\\.;]*(?i)(scooter)[^\\.;]*/


Let me know on how that goes.
Attachments (1)
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
Thanks for your response we have soldev the problem, now we have another question.
We have generated 4 fields Dependent one each other (Schermata del 2021-10-18 18-43-08.png ), we have made the update of available fileds but on RO CSVI the fileds are not searcheable as available fields
(Schermata del 2021-10-18 18-47-21.png).
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Thanks for your response we have soldev the problem,

Glad to know that regex problem is solved.

We have generated 4 fields Dependent one each other (Schermata del 2021-10-18 18-43-08.png ), we have made the update of available fileds but on RO CSVI the fileds are not searcheable as available fields

As of now we support only core VirtueMart custom fields as template fields and so you do not see the plugin fields as template fields. Support for customfieldsforall as template field has been added and will be included with upcoming release which is expected by this week. You can wait to update and run the export. If not let me know and i can send you a patch file.
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. # 5
Accepted Answer Pending Moderation
Godd morning,
if is it possible is very nice for us to have the patch in advance, we reiterate our congratulations for your work and support.

Best regards
Widev Srl
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Widev Srl,
Attached is the patch file with fix for customfieldsforall as template fields. Load the attached patch file and then update available fields. You can then find customfieldsforall fields as available fields. Please remember the patch file is only for Customfieldsforall custom fields and does not support other plugin custom fields.

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. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Thank for response, we have apply the patch but not find the "dependent custum fields for all"

how shown on screenshot Schermata del 2021-10-19 14-56-13.png
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
Dependent custom fields for all fields don't show up because there is no support for it. As i mentioned in my previous post, the support is only added for custom fields for all. We have a task in our todo list for our next release to extend custom fields for all feature to support dependent custom fields for all.
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. # 9
Accepted Answer Pending Moderation
OK, sorry, when you think to release the update?
Best Regards
William
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello William,
As of now there is no ETA on the release of this feature. We have our RO CSVI 8.0.0 beta2 release coming up with custom fields for all support. Will keep you posted once we add support for dependent custom fields for all.
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. # 11
  • Page :
  • 1


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