Hi, I don't understand how the XML export of CSVI Pro operates.
When I export XML using the Virtuemart Order Advanced Export, I get a perfect XML file with exactly the fields I want.
When I export XML using the Virtuemart Product Export, the XML is a mess, e.g. in the 'body' part of the layout I get:
*<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-gb" lang="en-gb" dir="ltr" > <head> <meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=utf-8" /> <title>1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM rhpg_virtuemart_products ... etc.*What's happening here?
My config:
CSVI pro 5.20
Joomla 3.4.1
VM 3.0.6.2
Hello,
using the Virtuemart Product Export, the XML is a mess
You get regular output because of an error. Since you didn't post the full error I can only guess. I would say update CSVI to version 5.21.1, it deals with some possible export issues. See if the error still remains, if so, post the whole error for me to see.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Ok I'll try that
Hi, I have installed version 5.21.1 and that seems to have fixed the problem.
Strangely, when I processed my template with the new version, I got the same error. But when I created a new template from scratch, the output was good.
So not sure about the cause of the problem, the new template has the same settings as the old one. But the most important thing is that it works.
Thanks for helping out!
Glad to hear it all worked out :)
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.