Re: Export Shipping & Order Information v1.5.0
Quote:
Originally Posted by
OldNGrey
Aaargh.
Code:
AND ot.orders_id = 1GROUP BY o.orders_id ORDER BY orders_id ASC ==> (as call
There is a space missing from the front of the GROUP statement.
I have updated the GitHub file
https://github.com/OldNGreyBMR/expor....7/files/admin
Please let me know if you have any other problems with this. I couldn't operate without it for monthly reconciliations.
Great it works now for the blank options too! Yes this program helps a lot with accounting :)
However I looked at the exported data more closely just now for '1 Order per row', i think there is some errors in the exported data.
Some orders are duplicated. I couldn't possibly run the whole years check now but I did quick random 2024 checks.
Once the duplicated orders are removed, the sums & orders tallied.
Any idea where is the bug?
Thanks again for your quick resolution.
Noi
Re: Export Shipping & Order Information v1.5.0
Quote:
Originally Posted by
noi.ng
However I looked at the exported data more closely just now for '1 Order per row', i think there is some errors in the exported data.
Some orders are duplicated.
A problem arises with the differences between MariaDB and MySQL and the many optional SQL Modes set by the user/administrator.
MySQL allows the ANY_VALUE setting to get around the GROUP BY clause when ONLY_FULL_GROUP_BY setting is used but the ANY_VALUE setting does not exist in MariaDB. [ I've learned a lot in the past few weeks.]
In the past I removed the ANY_VALUE on comments to allow the export to run on MariaDB. This caused duplicate records for "1 Order per row" when multiple comments existed against an order.
In test I can now get "1 Order per row" without duplicates even if comments are included.
I'm also parsing more so quotation marks in fields do not break the csv export.
Re: Export Shipping & Order Information v1.5.0
Quote:
Originally Posted by
OldNGrey
A problem arises with the differences between MariaDB and MySQL and the many optional SQL Modes set by the user/administrator.
MySQL allows the ANY_VALUE setting to get around the GROUP BY clause when ONLY_FULL_GROUP_BY setting is used but the ANY_VALUE setting does not exist in MariaDB. [ I've learned a lot in the past few weeks.]
In the past I removed the ANY_VALUE on comments to allow the export to run on MariaDB. This caused duplicate records for "1 Order per row" when multiple comments existed against an order.
In test I can now get "1 Order per row" without duplicates even if comments are included.
I'm also parsing more so quotation marks in fields do not break the csv export.
That's interesting to note. Thanks for the information!
Best Regards, Noi
Re: Export Shipping & Order Information v1.5.1
I have an updated version (v1.5.1.c) in my GitHub https://github.com/OldNGreyBMR/expor...ing_export.php
This corrects issues:
#8 unicode names are not being parsed correctly, and
#9 additional blank columns are created on some records when one product per row is selected
Could you download this latest version and run it in your test system? If you detect any issue please post them here or as an issue in my Github.
Re: Export Shipping & Order Information v1.5.1
Quote:
Originally Posted by
OldNGrey
I have an updated version (v1.5.1.c) in my GitHub
https://github.com/OldNGreyBMR/expor...ing_export.php
This corrects issues:
#8 unicode names are not being parsed correctly, and
#9 additional blank columns are created on some records when one product per row is selected
Could you download this latest version and run it in your test system? If you detect any issue please post them here or as an issue in my Github.
Sorry I missed this thread. I have just downloaded. I will try in a few days when I can avail the time. Many thanks for the updated version.
Re: Export Shipping & Order Information v1.5.1
Quote:
Originally Posted by
noi.ng
Sorry I missed this thread. I have just downloaded. I will try in a few days when I can avail the time. Many thanks for the updated version.
An Update as at 24 Feb 24:
@OldNGrey
"I have an updated version (v1.5.1.c) in my GitHub https://github.com/OldNGreyBMR/expor...ing_export.php"
Hi, I assumed only this file "shipping_export.php"is changed.
I have replaced this file from the last version & it looks good now.
No more duplicates also for OneRowPerOrder too.
Just wondering, when I tried to get the complete version v1.5.1.c once more from this link below:
https://github.com/OldNGreyBMR/expor.../ESIv1.5.1.zip
I actually noted that the "shipping_export.php" is still the older version (so I took the single file from the link you gave & replace).
Am I taking from the wrong link? Other than that all is good now.
Many thanks! This plugin is really useful
Noi
Re: Export Shipping & Order Information v1.5.1
Quote:
Hi, I assumed only this file "shipping_export.php"is changed.
That is correct. That is the only file that changed for the zc157 version.
Thanks for testing it. Now that we have no errors I'll create a new release as a zip file and submit it to the admins.