1. garikello
  2. RO CSVI
  3. Tuesday, 17 May 2016
  4.  Subscribe via email
Hi,

I was happily exporting products to xml file until recently, after I reached 1700 products in the store, CSVI doesn't make XML file anymore.
The time for server response goes 60 s and then it says that:
"The last server response has not been received in a timely fashion. The server may still be busy or stopped the process. You can wait a little longer to see if the server will sent a response or cancel the process."

I do wait, but without success....

So, what setting should be changed, so the CSVI manages to make xml file?

Any suggestions?
Accepted Answer Pending Moderation
Hello,
The processing is taking more time than it gets from the server. You can try Increasing the maximum execution time by clicking on Advance button, find tab called Limits, set Override system limits to Yes and set a maximum execution time in there. This may not work if your server is not a VPS or dedicated server, in that case you can ask your hosting provider to increase the maximum execution time on the server. See if your export goes good after that.
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
Accepted Answer Pending Moderation
What time should I place there?
There is no hint in what units time is set by the value I enter....
I tried to enter 100, but I am not sure if it is in seconds or miliseconds :)

UPS, just noticed how to see hints. My bad....

What value should I try?

Hmm, in logs I see that it is creating a list, and that creation is cancelled...
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
What value should I try?

Try putting the value to 120 seconds(2 minutes) and increase it if you still have issue.
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
Accepted Answer Pending Moderation
Hosting provider changed php script execution time.
Also I changed the limit to 200, after 120 didn 't work.

It doesn't manage t make a list anyway... the time goes over 300 and nothing happens.
On Sunday it took less than 60 seconds to make a file.
Nothing changed in setup. The only thing changed I can think of is the amount of products. But it shoudn't be a problem, right?
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
The only thing changed I can think of is the amount of products. But it shoudn't be a problem, right?

That should not be a problem. Can you try exporting only a few products by setting From record and to record on files tab in template settings?
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
Accepted Answer Pending Moderation
I tried that.
I set to make file with 10 records. No problem there. It did generate the file.

When I set the setting back, same thing, no xml in result. I waited over 1500 s.

I included log file.

com_csvi.log.204.zip
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
Can you Analyse the export with firebug and send the screenshot of what you see? The document explains about import but it is the same for export too.
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
Accepted Answer Pending Moderation
I tried to experiment with file option amount of records. Until 1700 file is generated. If I set amount over 1700 or leave the setting empty, there is no result.

I am looking at the moment what firebug can tell me....

Firebug gives out nothing at all:
http://screencast.com/t/WZk0g1Tm6w

Is there a way I can give you template settings to check?

Edit:
OK, I noticed that in section About I have Error message:

Error
Table 'datevlv_new.#__utf8_conversion' doesn't exist SQL=SELECT `converted` FROM `#__utf8_conversion` WHERE `converted` = 2

and:

Warning: Database is not up to date!

Table 'lg_csvi_icecat_index' does not have column 'm_prod_id' with type VARCHAR(50). (From file 6.4.2.sql.)
COM_CSVI_MSG_DATABASE_UTF8_CONVERSION_UTF8MB4

Is this connected somehow?

AND xml file I have with 1700 records is 1,53 MB big, is this OK?
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,

Firebug gives out nothing at all:
It looks like you started it after you started the export. Did you open the Firebug tab before starting the export?

Is this connected somehow?
That is irrelevant if you ask me. However it is something you want fixed. Rather than going to About to fix them it is better if you go to Extensions -> Manage -> Database and check there what the status is and fix it from there.

AND xml file I have with 1700 records is 1,53 MB big, is this OK?
That is OK, I have downloaded much larger XMLs. It seems you are hitting some kind of server limit. Can your hosting provider shed some light on this?
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. # 9
Accepted Answer Pending Moderation
Yeah, now firebug gives this: http://screencast.com/t/uGw9MvDQZ8

Hosting provider is looking into that as well.
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,
In your screenshot firebug looks good but it will show the error when you get "The last server response has not been received in a timely fashion....." , You need wait till then. Lets wait and see what your hosting provider comes with.
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
Accepted Answer Pending Moderation
OK, hosting provider changed settings for script handling.
Now everything works.

Thanks.
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,
Glad to know everything is fixed and Thank you for posting your solution.
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
Accepted Answer Pending Moderation
I am having the same issue will only export 5 records - after that nothing can i ask what was the solujtion re server script handling that occured ??
  1. more than a month ago
  2. RO CSVI
  3. # 14
  • Page :
  • 1


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