Categories
View Replies (4)

Resolved XML Export basic

  1. peterva
    peterva
  2. RO CSVI
  3. Tuesday, 24 March 2015
  4.  Subscribe via email
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
0
Responses (4)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
peterva
peterva
Accepted Answer Pending Moderation
Ok I'll try that
  1. more than a month ago
  2. RO CSVI
  3. # 2
peterva
peterva
Accepted Answer Pending Moderation
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!
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


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