1. soura123
  2. RO CSVI
  3. Tuesday, 22 December 2020
  4.  Subscribe via email
hello
my vendor sends an xml that the image field is like this
<imageURL>http://www.marhome.gr/images/uploads/<![CDATA[15-00-8375.jpg]]></imageURL>
when i import it get only
http://www.marhome.gr/images/uploads/
how can i import this?
thanks
Accepted Answer Pending Moderation
Hello,
This does not look like a valid XML. You cannot have CDATA and text in same value in XML node. A XML node value is read either as text or as CDATA. In your XML imageURL has both of these values, http://www.marhome.gr/images/uploads/ as text and 15-00-8375.jpg as CDATA. In this the first value http://www.marhome.gr/images/uploads/ is used as XML node value and you see that in import.
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
they probably has some weird program to export files
i use the replace to erase it but nothing
the weird is that on the browser i see it normally

http://www.marhome.gr/skroutz_xml/products_lianiki.xml

but on the view page sourse
i see the cdata on the image url
this is sth the send on a lot of shop
can you suggest some idea to manage to import this
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
i use the replace to erase it but nothing

It does nothing because it does not find CDATA in the value.

can you suggest some idea to manage to import this

As i said earlier there are two values coming from imageURL field. You need to process these two values in case you want to import this XML. See attached screenshot. I have set a Skip field for first imageURL and second imageURL to file_url field. By doing this skip field gets value http://www.marhome.gr/images/uploads/ and the file_url field will get the value 15-00-8375.jpg. You cannot process both values together here. It is also not possible to make a combine rule so the URL http://www.marhome.gr/images/uploads/ can be combined with file_url value 15-00-8375.jpg and that is because when you create combine rule you use imageURL in the rule. The rule reads the first imageURL field which is the skip field and does not process the file_url field.

You should tell your vendor to generate a valid XML file.
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
every time a problem
how on earth every single other eshop manages to import this file
and not csvi?
this is s static xml that send on every eshop
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
on the url send by vendor

http://www.marhome.gr/skroutz_xml/products_lianiki.xml

if you check there is no cdata on the fields
only on the view page sourse
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
We are looking into this XML issue and will get back to you with an update.

if you check there is no cdata on the fields
only on the view page sourse

Browser parses the CDATA field and so you are not seeing it. But with chrome i was able to see the CDATA in XML link you posted. See attached screenshot.
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. # 6
Accepted Answer Pending Moderation
same issue with the productURL field
it is like this

<productURL>http://www.marhome.gr/index.php?act=viewProd<;![CDATA[&]]>productId<![CDATA[=]]>420</productURL>
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello John,

We saw that as well. To answer your question why every eshop can import this file and CSVI cannot, I have never seen such an XML file in my life and I have been doing this for a long time :D

What is more usual is that the whole text is enclosed in CDATA tags and not just some values here and there.

As Tharuna said, we are looking into this and will get back to you.
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. # 8
Accepted Answer Pending Moderation
hello roland
my name is John by the way,
yes i m in the business 15 years
thsi is my first too
but from what i see that xml is a generic file send to a lot of eshops and to site with compare prices...
so if they manage to import some how so we can also...
by the way i have made a php script and recreate xml to a format correct so i dont excpect from csvi to fix it...
but i have the knowledge to do that maybe some one else cant do that...
take care
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello John,

Apologies on the name, no idea where I got that from :)

Glad to hear you found a workaround, we will fix this as well as I agree that RO CSVI should be able to handle such files as well as it is valid XML.

Happy holidays.
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. # 10
Accepted Answer Pending Moderation
thank you
happy holidays to you too
  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!