Page 6 of 6 FirstFirst ... 456
Results 51 to 59 of 59
  1. #51
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Email Address Exporter Question

    It's not a problem with query_factory, because it's just executing the query given to it.
    The email_export.php line 88 gives it a query, which it has just extracted from the database via lines 86-87, based on lines 72-73 which read whatever you chose from your dropdown menu.

    Maybe the problem is that your server is being ultra sensitive about the kinds of data it allows to be submitted, and so could be treating the ">" symbol in "Dormant Customers (>3months) (Subscribers)" as a scary character (because > is the end of an HTML tag, and used in SQL queries).

    To test that:
    - go into phpMyAdmin
    - to the query_builder table
    - to (what is normally) record #3
    - and look at the query_name field: Right now it should say: "
    Dormant Customers (>3months) (Subscribers)"
    - Change the
    >3 in there to >3 so that it displays a greater-than symbol via html encoded characters instead of the actual symbol.
    Save the change, and try the exporter again, after reloading the page.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  2. #52
    Join Date
    Jan 2006
    Location
    Downunder - QLD - Gold Coast
    Posts
    964
    Plugin Contributions
    0

    Default Re: Email Address Exporter Question

    Excellent!!!!!

    Thank you Dr. Byte. Great support !

    It worked
    Downunder QLD

  3. #53
    Join Date
    Aug 2014
    Location
    Lisbon
    Posts
    594
    Plugin Contributions
    0

    Default Re: Email Address Exporter Question

    Is there another way, without having to change the default zc installation ?
    I don't get it... in the send email, I have the option All, but in export I don't....
    “Though the problems of the world are increasingly complex, the solutions remain embarrassingly simple.” ― Bill Mollison

  4. #54
    Join Date
    Jul 2010
    Location
    L'Aquila
    Posts
    113
    Plugin Contributions
    1

    Default Re: Email Address Exporter Question

    Hi I installed this plug in, Email Address Exporter but no phone numbers are exported, I have also made a change to the function but nothing, they are only exported surname name and email address

    file function modify:
    <?php
    /**
    * Register module into admin menu system
    */
    if (!defined('IS_ADMIN_FLAG')) {
    die('Illegal Access');
    }

    if (function_exists('zen_register_admin_page')) {
    if (!zen_page_key_exists('emailExport')) {
    zen_register_admin_page('emailExport', 'BOX_TOOLS_EMAIL_EXPORT','FILENAME_EMAIL_EXPORT', '', 'tools', 'Y', 10);
    }
    }


    // other tweaking to add slightly more flexibility when exporting email addresses
    $result = $db->Execute("SELECT query_string from " . TABLE_QUERY_BUILDER . " where query_name = 'All Customers'");
    if ($result->fields['query_string'] == 'select customers_email_address, customers_firstname, customers_lastname, customers_telephone from TABLE_CUSTOMERS order by customers_lastname, customers_firstname, customers_email_address, customers_telephone') {
    $db->Execute("UPDATE " . TABLE_QUERY_BUILDER . " set query_string='select customers_firstname, customers_lastname, customers_email_address, customers_telephone, c.*, a.* from TABLE_CUSTOMERS c, TABLE_ADDRESS_BOOK a WHERE c.customers_id = a.customers_id AND c.customers_default_address_id = a.address_book_id ORDER BY customers_lastname, customers_firstname, customers_email_address, customers_telephone' where query_name = 'All Customers'");
    }
    $result = $db->Execute("SELECT query_string from " . TABLE_QUERY_BUILDER . " where query_name = 'All Newsletter Subscribers'");
    if ($result->fields['query_string'] == "select customers_firstname, customers_lastname, customers_email_address, customers_telephone from TABLE_CUSTOMERS where customers_newsletter = '1'") {
    $db->Execute("UPDATE " . TABLE_QUERY_BUILDER . " set query_string='select customers_firstname, customers_lastname, customers_email_address, customers_telephone, c.*, a.* from TABLE_CUSTOMERS c, TABLE_ADDRESS_BOOK a WHERE c.customers_id = a.customers_id AND c.customers_default_address_id = a.address_book_id AND customers_newsletter = 1' where query_name = 'All Newsletter Subscribers'");
    }
    Erboristeria La Spiga e Il Girasole Herbal Shop - https://www.erboristeriabio.com
    Golden Eagle Herbal - https://www.erboristeriabio.it
    Giraspiga - https://www.giraspiga.com

  5. #55
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Email Address Exporter Question

    Whatever code you quoted looks like it came from the reg_email_address_exporter.php file that comes with the plugin. I don't know why you would modify it.
    The /admin/email_export.php file automatically outputs the customer telephone number if it is available in the query, and the reg_email_address_exporter.php automatically puts it into the query.

    It seems like you may have an old version of it from before 2017? or maybe a very old Zen Cart that hasn't been upgraded?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  6. #56
    Join Date
    Jul 2010
    Location
    L'Aquila
    Posts
    113
    Plugin Contributions
    1

    Default Re: Email Address Exporter Question

    Hi, the version of the plug in is the last, and the zen cart version is the 155e, but the phone numbers do not export them. Thank you
    Erboristeria La Spiga e Il Girasole Herbal Shop - https://www.erboristeriabio.com
    Golden Eagle Herbal - https://www.erboristeriabio.it
    Giraspiga - https://www.giraspiga.com

  7. #57
    Join Date
    Jul 2010
    Location
    L'Aquila
    Posts
    113
    Plugin Contributions
    1

    Default Re: Email Address Exporter Question

    Perhaps some installed plug in may have affected the operation? I have installed Recover cart sales, Reward Point, Edit Order,
    Erboristeria La Spiga e Il Girasole Herbal Shop - https://www.erboristeriabio.com
    Golden Eagle Herbal - https://www.erboristeriabio.it
    Giraspiga - https://www.giraspiga.com

  8. #58
    Join Date
    Jul 2010
    Location
    L'Aquila
    Posts
    113
    Plugin Contributions
    1

    Default Re: Email Address Exporter Question

    Hello, for safety I made a new clean zen cart installation, and once the plug in is installed I confirm that the phone number is not exported, so the query that is proposed in the file does not work, we need a different query . Thank you
    Erboristeria La Spiga e Il Girasole Herbal Shop - https://www.erboristeriabio.com
    Golden Eagle Herbal - https://www.erboristeriabio.it
    Giraspiga - https://www.giraspiga.com

  9. #59
    Join Date
    Jul 2010
    Location
    L'Aquila
    Posts
    113
    Plugin Contributions
    1

    Default Re: Email Address Exporter Question

    Hello
    the query to do on the DB to get the result is:
    SELECT `customers_firstname`,` customers_lastname`, `customers_email_address`,` customers_telephone`, `customers_newsletter`
    FROM `zen_customers`
    WHERE customers_newsletter = 1

    How do I insert it into the Tool? Thank you
    Erboristeria La Spiga e Il Girasole Herbal Shop - https://www.erboristeriabio.com
    Golden Eagle Herbal - https://www.erboristeriabio.it
    Giraspiga - https://www.giraspiga.com

 

 
Page 6 of 6 FirstFirst ... 456

Similar Threads

  1. Email Address Exporter - Installation Question
    By rjeproductions in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 29 Nov 2011, 04:24 AM
  2. Email Address Exporter - How can I export the email addresses of every customer?
    By SpencerW in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 14 Oct 2011, 07:35 AM
  3. email address exporter
    By athena in forum All Other Contributions/Addons
    Replies: 17
    Last Post: 7 Jul 2009, 09:23 PM
  4. Email Address Exporter
    By buzzville in forum General Questions
    Replies: 3
    Last Post: 28 Jan 2007, 09:29 AM

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