Resolved Exporting VM3 sitemap

Hey Chris,

I'm sure you're working hard to make the long-waited release happen

Almost, I have been attending the J and Beyond conference, working hard to make Joomla better

Issue No.1: Cannot save the "Custom" (or any other) selection in Website. Always defaults to Beslist (see attached img)

That I will look into when I get home.

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 130968 bytes) in /home/qttest/public_html/administrator/components/com_virtuemart/helpers/vmtable.php on line 70

Oh gosh, who knows what vmtable is doing :-O Increasing the memory limit, if it doesn't work via CSVI, will need to be done on the server itself.

As for the tutorial it is pretty old, however I see no reason why it wouldn't work. I will get back to you in a day or two.

So I have checked on the XML website defaulting to Beslist and I can reproduce it. However the fix is not so easy, this will require a bit of rewrite meaning I need a little more time. If you select Custom and save the template, the option of Custom will be stored in the template, only whenever you make a change to the template and save it, you must also re-select the Website option, otherwise it will go back to Beslist.

Have you tried increasing the memory limit on the server?

So I had a moment of clarity and fixed the issue with remembering the selected export site. Apply the attached patch file and the correct site will show up.

Hi Roland,

Thanks for the feedback:

So I had a moment of clarity and fixed the issue with remembering the selected export site. Apply the attached patch file and the correct site will show up.

Hmm, uploaded the patch succesfully, but still Beslist is saved as the selected option. :huh:

Have you tried increasing the memory limit on the server?

I managed to get the export to complete with max_execution_time 60 and memory_limit 256M

Would it be possible for CSVI to make the export partially just like the import (with intervals i mean), so that resources required are not so intensive?

Furthermore, i'd like to address an important problem for us when exporting urls (e.g. for the sitemap):

- We have multiple domains, each one linked with a Joomla language, e.g. en-US->http://www.quality-tuning.com, el-GR->http://www.quality-tuning.gr (we achieve this with a Yireo's plugin https://www.yireo.com/software/joomla-extensions/language-domains)

At the moment CSVI supports only 1 domain to be set in its settings, we'd like to be able to set a domain per joomla language, otherwise we cannot create for example our sitemaps automatically. (we need to export one xml per domain)

Thanks and Regards!
Chris

Hello Chris,

Hmm, uploaded the patch succesfully, but still Beslist is saved as the selected option.

Perhaps it is the cache? Otherwise, just save the template with the correct site and it will be stored in the database but not shown. Today or tomorrow CSVI 6 Release Candidate comes out and it will have the changes in it.

Would it be possible for CSVI to make the export partially just like the import (with intervals i mean), so that resources required are not so intensive?

With or without intervals, the export is intensive for the server This is something I want to look into for a later release. It is going to need some serious coding.

At the moment CSVI supports only 1 domain to be set in its settings, we'd like to be able to set a domain per joomla language,

This is not a feature that I will not implement. Sites setup like that, are not many and I don't think this adds much value to CSVI. Having said that, you can of course create your own override of the export routine and add the needed code in that.

Hello Roland,

Perhaps it is the cache?

I thought so, i cleaned everything but nothing changed yet, let's see.

With or without intervals, the export is intensive for the server This is something I want to look into for a later release. It is going to need some serious coding.

Good luck on that

Having said that, you can of course create your own override of the export routine and add the needed code in that.

Hopefully i just solved this with a Replace Rule, so we are ok.

The only issue i just noticed is that Header,Body and Footer are not appearing in the xml file.

See attached the setup of the XML layout, the XML output and logfile. Maybe i'm missing smth? :huh:

Rgrds,
Chris

Hello Chris,

I just created a new template according to the Sitemap tutorial but everything exports as expected. Today I will release the CSVI 6 Pro Release Candidate, give that a try, it has also the patch I posted earlier.

Hello Roland,

Thanks for the feedback; i unistalled the beta and installed RC1. Noted that the selected export site is now saved properly

However the export is not working now, i get the following msg:

Error
Unknown column 'skip' in 'field list' SQL=SELECT `y9zak_virtuemart_categories`.`virtuemart_category_id`, `skip` FROM `y9zak_virtuemart_categories` LEFT JOIN `y9zak_virtuemart_categories_en_gb` ON `y9zak_virtuemart_categories_en_gb`.`virtuemart_category_id` = `y9zak_virtuemart_categories`.`virtuemart_category_id` LEFT JOIN `y9zak_virtuemart_category_medias` ON `y9zak_virtuemart_category_medias`.`virtuemart_category_id` = `y9zak_virtuemart_categories`.`virtuemart_category_id`

I tried another export (category type), and still i get a silimar error regarding this 'skip' column:

Error
Unknown column 'skip' in 'field list' SQL=SELECT `y9zak_virtuemart_categories`.`virtuemart_category_id`, `skip` FROM `y9zak_virtuemart_categories` LEFT JOIN `y9zak_virtuemart_categories_en_gb` ON `y9zak_virtuemart_categories_en_gb`.`virtuemart_category_id` = `y9zak_virtuemart_categories`.`virtuemart_category_id` LEFT JOIN `y9zak_virtuemart_category_medias` ON `y9zak_virtuemart_category_medias`.`virtuemart_category_id` = `y9zak_virtuemart_categories`.`virtuemart_category_id`

Would appreciate your advice.

Rgrds,
Chris

Hello Chris,

You cannot use the skip field for export as it has no function. Perhaps the actual skip field is not in your field list but it may be another unsupported field. Check that the export fields are correct. It may be useful to update the available fields and then remove the fields linked to the template and re-add them if you can't spot the offending field.

Thanks Roland, re-updating the available fields solved the issue, so this is also a good advice for your customers when updating to RC1 or final later.

XML export for the sitemap works nicely also, thanks! Looking forward for the final release. B)

Rgrds,
Chris

Hi Roland,

Getting the following error in RC1 when exporting the sitemap xml with all categories:

Error
Unknown column 'c.category_publish' in 'where clause' SQL=SELECT p.virtuemart_product_id FROM y9zak_virtuemart_products p LEFT JOIN y9zak_virtuemart_product_categories x ON p.virtuemart_product_id = x.virtuemart_product_id LEFT JOIN y9zak_virtuemart_categories c ON x.virtuemart_category_id = c.virtuemart_category_id WHERE c.category_publish = '1'

The sitemap exports ok if you select some categories manually.

The log file is empty, would you have a clue abt this error?

rgrds,
chris

Hello Chris,

I have identified the issue, it was a missed replacement. Attached is the patch file that fixes this issue.

Thanks Roland, it works

Noted also the following and would appreciate your advice:

When exporting multiple images, the CSVI format is as follows:

<image:loc>
<![CDATA[image1.jpg,image2.jpg,image3.jpg]]>
</image:loc>

While the proper format (as per https://support.google.com/webmasters/answer/178636) is:

<image:image>
<image:loc>http://example.com/image.jpg</image:loc>
</image:image>
<image:image>
<image:loc>http://example.com/photo.jpg</image:loc>
</image:image>

Can we achieve this?

Rgrds,
Chris

Chris,

This cannot be done, the XML body has only one place for the picture_url field, so you can only export 1 image per URL. The only way to achieve it is to write your own code to get this done.