Page 50 of 50 FirstFirst ... 40484950
Results 491 to 497 of 497
  1. #491
    Join Date
    Dec 2012
    Location
    Singapore
    Posts
    27
    Plugin Contributions
    0

    Default Re: Export Shipping & Order Information v1.5.0

    Quote Originally Posted by OldNGrey View Post
    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

  2. #492
    Join Date
    Apr 2008
    Location
    Qld, Australia
    Posts
    250
    Plugin Contributions
    6

    Default Re: Export Shipping & Order Information v1.5.0

    Quote Originally Posted by noi.ng View Post
    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.
    OldNGrey
    ZC158a PHP 8.2.15
    MySQL 10.6.16-MariaDB

  3. #493
    Join Date
    Dec 2012
    Location
    Singapore
    Posts
    27
    Plugin Contributions
    0

    Default Re: Export Shipping & Order Information v1.5.0

    Quote Originally Posted by OldNGrey View Post
    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

  4. #494
    Join Date
    Apr 2008
    Location
    Qld, Australia
    Posts
    250
    Plugin Contributions
    6

    Default 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.
    OldNGrey
    ZC158a PHP 8.2.15
    MySQL 10.6.16-MariaDB

  5. #495
    Join Date
    Dec 2012
    Location
    Singapore
    Posts
    27
    Plugin Contributions
    0

    Default Re: Export Shipping & Order Information v1.5.1

    Quote Originally Posted by OldNGrey View Post
    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.

  6. #496
    Join Date
    Dec 2012
    Location
    Singapore
    Posts
    27
    Plugin Contributions
    0

    Default Re: Export Shipping & Order Information v1.5.1

    Quote Originally Posted by noi.ng View Post
    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

  7. #497
    Join Date
    Apr 2008
    Location
    Qld, Australia
    Posts
    250
    Plugin Contributions
    6

    Default Re: Export Shipping & Order Information v1.5.1

    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.
    OldNGrey
    ZC158a PHP 8.2.15
    MySQL 10.6.16-MariaDB

 

 
Page 50 of 50 FirstFirst ... 40484950

Similar Threads

  1. Export Shipping+Order Information plugin not exporting some orders
    By woemlavy in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 22 Mar 2013, 02:01 PM
  2. v138a Trouble Installing Export Shipping+Order Information
    By scripto in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 16 Jan 2013, 11:36 PM
  3. Export Shipping/Order Information - dump down to 2 sheets or XML
    By sbbemn in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 4 Oct 2012, 05:37 PM
  4. Export Shipping / Order Information
    By digruk in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 28 Oct 2011, 08:25 PM
  5. Export Shipping Order Information doesn't include downloadable products?
    By rcaroe in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 31 Jul 2010, 05:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR