Resolved Combine title in VM product import

andrejk
RO CSVI
Tuesday, 22 April 2025
Subscribe via email

Hello,
Joomla 4.4.3, VM 4.2.4

please, I import product from XML. I have in VM a parameter name : Parameter and I need to combine all values from a structure into this parameter:



<options>

<option>

<id>2948</id>

<code>2114F407</code>

<name>

<![CDATA[ biele, 220 Lumenov, USB ]]>

</name>

<ean>4712806001919</ean>

<price_msrp>25.95</price_msrp>

<price_msrp_czk>656.54</price_msrp_czk>

</option>

<option>

<id>2950</id>

<code>2114F411</code>

<name>

<![CDATA[ červené, 220 Lumenov, USB ]]>

</name>

<ean>4712806001902</ean>

<price_msrp>25.95</price_msrp>

<price_msrp_czk>656.54</price_msrp_czk>

</option>

<option>

<id>2947</id>

<code>2114F404</code>

<name>

<![CDATA[ čierne, 220 Lumenov, USB ]]>

</name>

<ean>4712806001896</ean>

<price_msrp>25.95</price_msrp>

<price_msrp_czk>656.54</price_msrp_czk>

</option>

<option>

<id>2949</id>

<code>2114F410</code>

<name>

<![CDATA[ modré, 220 Lumenov, USB ]]>

</name>

<ean>4712806001926</ean>

<price_msrp>25.95</price_msrp>

<price_msrp_czk>656.54</price_msrp_czk>

</option>

</options>

right now it's like this and it's wrong (more image in attachment):

Parameter
biele, 220 Lumenov, USB~červené, 220 Lumenov, USB~čierne, 220 Lumenov, USB~modré, 220 Lumenov, USB

Preview before import should be :

Parameter~Parameter~Parameter~Parameter
biele, 220 Lumenov, USB~červené, 220 Lumenov, USB~čierne, 220 Lumenov, USB~modré, 220 Lumenov, USB

Please how to set combine to always give custom_title value Parameter?

Best regards
Andrej

Responses (13)

tharuna

Accepted Answer Pending Moderation

Hello Andrej,
Not sure what is wrong with your rule. I created a new rule called Replace custom title and applied this on Nový SLOGER XML Import - Tharuna template and now custom_title loads fine. Can you check?

Kind regards,

Tharuna

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

2 weeks ago
RO CSVI
# 1

andrejk

Accepted Answer Pending Moderation

Hello,

I update RO CSVI but still the same result, please see attachments.

Best regards
Andrej

2 weeks ago
RO CSVI
# 2

tharuna

Accepted Answer Pending Moderation

Hello Andrej,
Thank you for the details. I see you are using RO CSVI 8.11.1 version. Any reason for using that version? Can you update to latest RO CSVI 8.17.0 version and check the import?

Let me know If that does not help. I will take a look into your site again.

Kind regards,

Tharuna

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

2 weeks ago
RO CSVI
# 3

andrejk

Accepted Answer Pending Moderation

Hello,

I sent my login details.

Best regards
Andrej

2 weeks ago
RO CSVI
# 4

tharuna

Accepted Answer Pending Moderation

Hello Andrej,
Can you try with modified attached template? You can restore this template and check the import. It works for me. See attached screenshot. But if you still have problem send me Joomla administrator login details and I will take a look. You can post the details on Site Details tab under your reply.

Kind regards,

Tharuna

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

2 weeks ago
RO CSVI
# 5

andrejk

Accepted Answer Pending Moderation

Hello,

hm, the same as before, please see the attachment.
Copying from custom_value to custom_title is OK. But replacing in custom_title does not work. I have also tried another regular expression /([^~]+~)/ but nothing.

Best regards
Andrej

2 weeks ago
RO CSVI
# 6

tharuna

Accepted Answer Pending Moderation

Hello,
In the template fields change the order of custom_title and custom_value fields. Like custom_value field comes first and then custom_title after. That is because we are copying value from custom_value field so we need that coming first. Do this change and try the import.

Kind regards,

Tharuna

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

2 weeks ago
RO CSVI
# 7

andrejk

Accepted Answer Pending Moderation

Hello,

I'm making a mistake somewhere, please see attachment.

Best regards
Andrej

2 weeks ago
RO CSVI
# 8

tharuna

Accepted Answer Pending Moderation

Hello Andrej,
You sent only a part of XML file in your first post. I would need atleast on full product node to test import with your template. Also I see you just have a field copy plugin for copying custom_value field to custom_title in your template. You are missing combine rule for combining all options/option/name node to custom_value field. You are also missing RO CSVI Multireplace rule which is explained in my previous reply. Can you try adding these rules and check?

Kind regards,

Tharuna

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

2 weeks ago
RO CSVI
# 9

andrejk

Accepted Answer Pending Moderation

Hello,

I send XML and sample before import.

Best regards
Andre

2 weeks ago
RO CSVI
# 10

tharuna

Accepted Answer Pending Moderation

Hello Andrej,

Is there any other way to import products? Since I have one custom_title and different numbers of custom_value?

Count of custom_title and custom_value values should be the same to run the import. Since you have only one custom_title we need to make it match with custom_value field. That can be done using RO CSVI Field copy rule and RO CSVI Multi replace rule.

To do that

1. Create Field copy rule to copy the value of custom_value to custom_title. Apply this rule on custom_value field.
2. Create RO CSVI Multi replace rule to match strings between ~ in custom_title. You need to create two Find and replace operations in Multi replace rule. Apply this rule on custom_title field.

See attached screenshots on the rules.

Run import and check if it works. If not send me your template XML file and sample of import file and I will look into it. To get the template XML file from RO CSVI templates list page select the import template and click on Backup templates button. Post the downloaded XML file.

Kind regards,

Tharuna

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

2 weeks ago
RO CSVI
# 11

andrejk

Accepted Answer Pending Moderation

Hello,

yes, I'm trying to add a parameter based on the custom_value count. Is there any other way to import products? Since I have one custom_title and different numbers of custom_value?

Best regards
Andrej

2 weeks ago
RO CSVI
# 12

tharuna

Accepted Answer Pending Moderation

Hello Andrej,
You can set the custom_title value in Default value field like Parameter~Parameter~Parameter~Parameter. See attached screenshot. But if you are trying to add Parameter based on number of custom_value then that is not possible. The maximum possible Parameter value should be set in custom_title field itself.

Kind regards,

Tharuna

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

2 weeks ago
RO CSVI
# 13

Page :
1

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

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

Resolved Combine title in VM product import

RO CSVI

RO Payments

RO Users

RO Single Sign On