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.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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
Accepted Answer
Pending Moderation
Hello,
It does nothing because it does not find CDATA in the value.
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.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
Accepted Answer
Pending Moderation
on the url send by vendor
if you check there is no cdata on the fields
only on the view page sourse
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
Accepted Answer
Pending Moderation
Hello,
We are looking into this XML issue and will get back to you with an update.
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.
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
same issue with the productURL field
it is like this
it is like this
<productURL>http://www.marhome.gr/index.php?act=viewProd<![CDATA[&]]>productId<![CDATA[=]]>420</productURL>
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
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.
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

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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
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 »