Categories
View Replies (3)

Resolved URL Export Issue

  1. atrus
    atrus
  2. RO CSVI
  3. Monday, 14 September 2015
  4.  Subscribe via email
Hi Roland,

I'm getting a weird error when trying to export all products urls (abt 7500 records). See attached file. After some point the urls of all exported products are just:

https://www.quality-tuning.eu/ru/.html

The weird here is that all products have proper slugs/urls and if you export them separately one by one the url is exported by CSVI without problems. For example, if i do the export again using the Product SKU Filter for sku RDSL329, the export file (see attached also) has its url ok, however in the first export with all products the url is wrong! Seems as if the export process takes the wrong way at some point.

Attaching the log also, but it doesn't say much.

Any clue is appreciated!

Rgrds,
Chris
0
Responses (3)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Chris,

I believe your server has given up serving the URLs due to reaching a limit. CSVI calls your website with the non-sef URL and then retrieves the SEF url from it. That is how it can get the proper SEF URL. With about 7500 products, there will be about 7500 page requests send to the server, this is prone to triggering an attack filter.

Doing a single product only sends one request to the server, that isn't a problem.

Check with your host if you have reached any kind of limit that will stop serving requests and if you can add an exception for your site IP.
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
atrus
atrus
Accepted Answer Pending Moderation
Hello Roland,

CSVI calls your website with the non-sef URL and then retrieves the SEF url from it.


Wow, hadn't thought of that. Sounds like it takes up some resources indeed and we have a lot of these exports.

That gave me another idea: no need to produce the URLs this way, but instead setup the export template to create them by itself. It uses minimum resources, just a couple of combine rules and the product slug:

{domain/langsubdirectory/}{slug}{.suffix}

So you can have a URL like this: https://www.quality-tuning.eu/ru/rdx-bokovye-yubki-audi-a3-8p-turbo.html

Seems to be working great, will do some more tests.

Note: You must use VM3 hidden config seo_full=0

Rgrds,
Chris
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Chris,

Thanks for the feedback, that is indeed a useful workaround. The retrieval of SEF URLs is a nightmare in Joomla, especially with all the different SEF extensions out there. We should just have one routing system ;)
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. # 3
  • Page :
  • 1


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