Categories
View Replies (23)

Resolved Export to Yandex Market

  1. spro1
    spro1
  2. RO CSVI
  3. Thursday, 24 November 2016
  4.  Subscribe via email
Hello!
CSVI version 6.6.4
Joomla! 3.6.4
VirtueMart 3.0.18
I need export to Yandex Market.
There are several problems:
1. In the header, there is no information about the store, eg:


<name></name>

<company></company>

<url></url>

<currencies>

<currency id="" rate="" plus=""/>

2. tag <offer> does not contain the product id, available info and type (eg: <offer id="">, need: <offer type="vendor.model" id="1724" available="true">;)
3. In <picture> tag need to specify the full path to the image (eg: <picture>https://sitename.com/images/stories/virtuemart/product/7916073.jpg</picture>;)
4. In <description> tag need add clean text, without code and tags. Is that possible?

Can you tell me what variables are available in the export template Yandex, please?
0
Responses (23)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
1. In the header, there is no information about the store, eg:
<name></name>
<company></company>
<url></url>
<currencies>
<currency id="" rate="" plus=""/>
2. tag <offer> does not contain the product id, available info and type (eg: <offer id="">, need: <offer type="vendor.model" id="1724" available="true">;)

Load the attached patch file from CSVI maintenance menu and these two issues should be solved.

3. In <picture> tag need to specify the full path to the image (eg: <picture>http://sitename.com/images/stories/virtuemart/product/7916073.jpg</picture>;)
Go the dashboard and click Options in the right top corner. Setup your Domain name information in there, you should be seeing full urls after that.

4. In <description> tag need add clean text, without code and tags. Is that possible?

What you have in your database as description is what exported in your XML file. You need to clean up your description field value in your database so you have clean text in export file.

Can you tell me what variables are available in the export template Yandex, please?

Go to Available fields page, in search tools select export as action, component as VirtueMart and Operation to be Yandex. That will list you all available fields for Yandex export.


patch_yandex_2016_11_25.zip
Attachments (1)
patch_yandex_2016_11_25.zip
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
spro1
spro1
Accepted Answer Pending Moderation
Hello!
1,2 After applying the patch error occurs 500 when exporting
3. Ok.
4. The database contains the text formatting, because it needed.
attached script removes tags for export, is it possible to do the same in CSVI?
[code type=php]
if ($row->product_desc) {
$xml .= '<description>'.htmlspecialchars(strip_tags($row->product_desc)).'</description>'."\n";
}
[/code]

I mean the variables available in the file administrator/components/com_csvi/helper/file/export/xml/yandex.php
Attachments (3)
com_csvi.log.332.zip
market.zip
Снимок.JPG Снимок.JPG
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
1,2 After applying the patch error occurs 500 when exporting

Can you check your server error logs to see what is causing this 500 error? There should be an log entry for this error.

4. The database contains the text formatting, because it needed.
attached script removes tags for export, is it possible to do the same in CSVI?

You can create a custom override file for Yandex export routine and add your custom code needed. Have a look at Override import/export routine document for the same.

I mean the variables available in the file administrator/components/com_csvi/helper/file/export/xml/yandex.php

May i know why you want to know the variables of this file? If you are looking for doing any custom coding it can be done in an override file as explained above.
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
spro1
spro1
Accepted Answer Pending Moderation
server error_log
Attachments (1)
error_log.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you load the modified patch file attached here and see if it works?


patch_yandex_2016_11_25_modified.zip
Attachments (1)
patch_yandex_2016_11_25_modified.zip
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
spro1
spro1
Accepted Answer Pending Moderation
Export works!
But the tag <picture> does not contain the full path to the image
[code type=xml]<picture>images/stories/virtuemart/product/7691066_1.jpg</picture>[/code]
Attachments (2)
yandex_market.xml
Снимок-2.JPG Снимок-2.JPG
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you try the attached patch file for image url and see if it works?


patch_yandex_file_url_2016_11_16.zip
Attachments (1)
patch_yandex_file_url_2016_11_16.zip
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. # 7
spro1
spro1
Accepted Answer Pending Moderation
Now export works correctly. Thank you!
But if i export all products Error 500 appears(((
The store contains more than 3000 products
Attachments (1)
error_log-2.zip
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
If you are seeing error 500 then there is something which has gone wrong in your export. Please check the 500 internal server error document to know the causes. You may need to check your server error logs and see if there is any log entry for this error.
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. # 9
spro1
spro1
Accepted Answer Pending Moderation
server log is attached in the last message.
Can I export with pauses, and not immediately? just as it is done when importing
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The server error log shows that your server ran out of memory while doing the export. Try to increase the memory limit on your server and see if it helps.
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. # 11
spro1
spro1
Accepted Answer Pending Moderation
Hello!
the server has a limit of 128 MB of RAM to 1 process. Is it possible to somehow solve the problem, if i can not change the server settings?
  1. more than a month ago
  2. RO CSVI
  3. # 12
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
One solution you can try here is export records in batches, in your export template settings on file tab you can set From record and To record fields and do the export. Initially try to set to few records to see if export finishes. You can then gradually increase the record count to know the maximum records you can export in one batch.
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. # 13
spro1
spro1
Accepted Answer Pending Moderation
the file will be overwritten or supplemented?
  1. more than a month ago
  2. RO CSVI
  3. # 14
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Every time you do a export giving a record count, a new file will be created with new set of records.
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. # 15
spro1
spro1
Accepted Answer Pending Moderation
export works in parts, but I need to get a file with all products.
the import template have a available limits settings and they work fine. Why they are not available for export?
Attachments (1)
Снимок-2-3.JPG Снимок-2-3.JPG
  1. more than a month ago
  2. RO CSVI
  3. # 16
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Why they are not available for export?
The export should not need it because the records don't need to be read into memory. During export, one record at a time is processed.

You posted the server log before and you can see that the error comes from the VirtueMart file and not the CSVI file. You cannot increase the memory limit for the export? Nowadays 128MB is really not all that much.

Adding a batched export means a fundamental change in how exports are handled, this is not an easy thing to do.
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. # 17
spro1
spro1
Accepted Answer Pending Moderation
Hello!
Thank you for your answers!
Sorry, but there is another problem.
After applying the latest patch the contents of the last tag is duplicated
Attachments (2)
Снимок.PNG Снимок.PNG
patch_yandex_file_url_2016_11_16.zip
  1. more than a month ago
  2. RO CSVI
  3. # 18
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you post your template XML file to check? To get the backup go to CSVI maintenance menu, select CSVI Pro on first option and Backup templates on second option, Select your export template and click continue. An XML file will be downloaded. Please post the file here.
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. # 19
spro1
spro1
Accepted Answer Pending Moderation
Hello!
Attachments (1)
csvi_templates_20161201.xml
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


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