Categories
View Replies (6)

Resolved google export unstable and contains chars UTF-8-Coding

  1. mac4life
    mac4life
  2. RO CSVI
  3. Tuesday, 06 March 2018
  4.  Subscribe via email
Hi

I'm using CSV Improved for a long time.
Without changing anything, it runs now unstable.

Errors like this appearing

Error
No template has been selected for export. Make sure you have selected a template from the dropdown list which you want to export.


or non (attached log)

The result is always the same,
the xml file does not contain the numbers of products as stated and seems to be corrupted

Google error
1 ERROR: XML-Formatting error .
your feed contains a char, that is not allowed in UTF-8 encoding.

No idea why this happens, because I have no new products, which could be the problem.

Log files, template and xml files are attached

csvi.zip

PHP version 7.0.27
Joomla! version 3.8.5
VirtueMart 3.2.12
CSVI Pro 7.4.1
0
Responses (6)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I'm using CSV Improved for a long time.
Without changing anything, it runs now unstable.

Errors like this appearing
Error
No template has been selected for export. Make sure you have selected a template from the dropdown list which you want to export.


or non (attached log)

This error would appear if there is no valid template selected for export. Are you running this export using cron? If yes, have a look at Setting up cron job document to know if you have right cron URL.

the xml file does not contain the numbers of products as stated and seems to be corrupted

Google error
1 ERROR: XML-Formatting error .
your feed contains a char, that is not allowed in UTF-8 encoding.

No idea why this happens, because I have no new products, which could be the problem.

There is a problem in the google.xml file you have attached in the post. If you check at line 6108 in the file there is a bunch of NULL entries in it and that is XML formatting error. What if you export only 10 products? do you still see those Null entries?
Kind regards,

Tharuna

=========================
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
mac4life
mac4life
Accepted Answer Pending Moderation
Hi

I do run it manually, no cron job.
This error would appear if there is no valid template selected for export. Are you running this export using cron? If yes, have a look at Setting up cron job document to know if you have right cron URL.


When I export 10 products, the xml file seems to be ok 
There is a problem in the google.xml file you have attached in the post. If you check at line 6108 in the file there is a bunch of NULL entries in it and that is XML formatting error. What if you export only 10 products? do you still see those Null entries?


csvi1.zip .
Attachments (1)
csvi1.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you check the entries you have in your #__virtuemart_products table after virtuemart_product_id 1139? As per your google.xml file sent in your first post, after virtuemart_product_id 1139 the next record is with virtuemart_product_id 1385 and in between there are Null entries.
Kind regards,

Tharuna

=========================
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. # 3
mac4life
mac4life
Accepted Answer Pending Moderation
Hi

I did check the entries, but it seems to be a different issue.
Null entries appearing everytime in a differnt place, even when I don't change anything in the DB, just running the template twice.

Some times this error occurs , no cron job
Error
No template has been selected for export. Make sure you have selected a template from the dropdown list which you want to export.


It's really strange
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I did check the entries, but it seems to be a different issue.
Null entries appearing everytime in a differnt place, even when I don't change anything in the DB, just running the template twice.

Can you try to create a new Google export template with few fields and see how export goes?

Error
No template has been selected for export. Make sure you have selected a template from the dropdown list which you want to export.

You see this error only with Google export? Did you try other exports?
Kind regards,

Tharuna

=========================
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. # 5
mac4life
mac4life
Accepted Answer Pending Moderation
Hi

I did create a new template (a copy, did not work).
Et voilà, the export runs now smoothly as usual.

I don't know why, but the old export template seemed to be broken …

Thank you, Case solved
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


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