Resolved Export order for a month

Hello,
Please post the debug log of your export to check. To get the debug log check How to collect debug information? document.

Thank you
This is the debug

Hello,
Can you attach the debug log instead of screenshots? It will be easy for us to check that way.

thank you

Hello,
Checking at your debug log the query is looking for orders of this month that is for last 4 days which is correct as per the filter you have set. Do you have orders created in these last 4 days?

yes I have orders created

Hello,
There is nothing wrong with your export as per your debug log. Running the VirtueMart order export in my local server with same template setting as yours gets me the orders. One thing i noticed is that you are running the older 7.2.4 version of CSVI. Can you try to update it to latest 7.5.1 version and check the export?

If you are still having issue with export, please send the mysql dump of your VirtueMart tables to my email at tharuna@csvimproved.com. I will check the export with your data.

hello I have installe the bew version and have this error :
Erreur
CSVI Addons you have installed are outdated. You need to update your addons to the same version as CSVI extension. In the extension manager you can see the current list of adddons and their versions. You can update the addons from the Update page in the Joomla Extension Manager.

I can't find the new version of csvi pro awocoupon (I have the 722 version) ?

and sorry for my english but what you mean by "the mysql dump of your VirtueMart tables" ?
thank you

Hello,

Erreur
CSVI Addons you have installed are outdated. You need to update your addons to the same version as CSVI extension. In the extension manager you can see the current list of adddons and their versions. You can update the addons from the Update page in the Joomla Extension Manager.

This is a message to tell you that some of the addons you have installed are not up to date. You can check which addons are not updated by clicking on the link in the error.

I can't find the new version of csvi pro awocoupon (I have the 722 version) ?

Do you use AwoCoupon for your import and exports? We removed support for AwoCoupon from 7.5.1 version. Is it because of this addon you are seeing the above error?

and sorry for my english but what you mean by "the mysql dump of your VirtueMart tables" ?

Did the update fix the VirtueMart order export or do you still have issue with export?

Do you use AwoCoupon for your import and exports? We removed support for AwoCoupon from 7.5.1 version. Is it because of this addon you are seeing the above error? => I don't use any more awocoupon for import and export yes it is because of this addon

Did the update fix the VirtueMart order export or do you still have issue with export? => no the update doesn't fix the VM order, tge other export product of VM for example works well.

Hello,

Do you use AwoCoupon for your import and exports? We removed support for AwoCoupon from 7.5.1 version. Is it because of this addon you are seeing the above error? => I don't use any more awocoupon for import and export yes it is because of this addon

Ok since you are not using this addon and also the support has been removed, you can uninstall this CSVI addon from Joomla extension manager and from Manage page. If you still see the error after uninstalling, go to System -> Clear cache and look for CSVI, delete the entry and the error should be gone.

Did the update fix the VirtueMart order export or do you still have issue with export? => no the update doesn't fix the VM order, tge other export product of VM for example works well.

In that case i need to check the records in your database. To get MySql dump go to your PhpMyAdmin >> Select your database >> Click on Export tab >> click on Custom - display all possible options. Select your virtuemart tables and click Go. Send me the downloaded file in a private message or to my email at tharuna@csvimproved.com.

Hello,
Thank you for sending the mysql dump. I ran export using your data and export gets me 44591 orders when setting filter for this month. Does your export complete? Do you get the export file to download?

Can you also post your template XML file to check? To get the template XML file go to CSVI maintenance menu, select CSVI Pro in first option and Backup templates in second option. Select your export template and click continue. Post the downloaded XML file.

Hello I still see the error after uninstalling and go to System -> Clear cache and look for CSVI, delete the entry

For the export Please fins the print screen I have something and I can save the file but the export is empty...

Then please find attachment the xml files

Hello,

I still see the error after uninstalling and go to System -> Clear cache and look for CSVI, delete the entry

Did you also clear the cache for Administrator by selecting it in the drop down list?

For the export Please fins the print screen I have something and I can save the file but the export is empty...

You have all template fields set to unpublished for your export template. Publish the template fields from CSVI Template fields page and you should be seeing records in your export.

Did you also clear the cache for Administrator by selecting it in the drop down list? yes but still have the error message

For this export it is solve but now I have another question : I have several times the sames lines what can be wrong ? thank you

Hello,

Have a look at the Use of group by and sort by fields. This will explain how to get rid of duplicates.