1. konstantinos29
  2. RO CSVI
  3. Friday, 17 July 2020
  4.  Subscribe via email
I am exporting a category of products (Virtuemart), with a large number on them.
Unfortunately, the server times out (with a high limit of 2000+ seconds).

1) What can I do now, to solve the problem?

2) Would it be possible to "ping" or "reset" the server response counter, in your code, for time consuming operations like this one?

Thanks
Accepted Answer
Accepted Answer Pending Moderation
Hello,
1) What can I do now, to solve the problem?

You can export records by setting limits to number of records so to handle these large numbers. To set the limits, in your export template on File tab set From and To record and run the export.

2) Would it be possible to "ping" or "reset" the server response counter, in your code, for time consuming operations like this one?

As of now we do not have the code to reset server in export. But running export in batches is something we have in our todo list. With this batch export server is reset after one batch of records is read and then continues to read the next batch. This way server does not hit its limits and won't land into timeout problems.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer Pending Moderation
Hello,

Could you do a test with the record limits (File tab, from, to) as you recommended... the limits don't seem to work for me. The full CSV is always generated.

(latest 7.17 version)

Thanks
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,
Yes i tested on my local test site with RO CSVI 7.17.0 version and the limits in export work. Can you post the export debug log to check? To get the debug log check How to get debug information? document.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Found the issue,

As a programmer myself, I put 0 in the "From" field.

This completely bypassed the end limit end exported the whole catalog.
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
This completely bypassed the end limit end exported the whole catalog.

RO CSVI code checks if the limit values are greater than 0 and then applies it to export. That is the reason limits did not work.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks 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!