Email Address Exporter [Support Thread]

Email Address Exporter — support thread (v3.0.0)

The Email Address Exporter has been around in one form or another since 2005, and has been quietly kept working through a great many Zen Cart releases. What it has never had is a support thread of its own. This is it — if you use the plugin, ask here.

It has also just been rebuilt. v3.0.0 runs on Zen Cart v1.5.8 through v3.0.0 from a single codebase, on PHP 7.4 through 8.x, with no version-specific downloads to choose between. Compatibility was checked against v1.5.8, v2.0.0, v2.2.2 and the v3.0.0 development branch rather than assumed.


New in v3.0.0

• 
  
• Filters, as an alternative to picking a saved Query Builder audience: country, state/zone and city; registration date range; purchase date range, order status, category (optionally including its subcategories), and product ID. They combine, so you can ask for "Florida customers who bought from Widgets in the first half of the year".
  
• You choose the columns — sixteen of them, covering name, contact details, the full default address, newsletter flag, email format and account dates.
  
• JSON export, alongside CSV, TXT, XML and HTML.
  
• Consent filters, on by default — subscribers only, and excluding anyone whose email format is set to NONE. They are what keeps an export limited to people who agreed to be emailed.
  
• Excluded customers are counted, not dropped in silence. A date or location filter cannot match a customer whose registration date or address was never recorded, so the page now tells you how many that affects before you export.
  
• Telephone numbers can be normalised to digits only, since customer-entered numbers are rarely consistent.
  
• UTF-8 BOM option for CSV, so Excel stops mangling accented names.
  
• A two-column layout, nothing smaller than 14px, and all sizes in relative units.
  
  
  
  
  Fixed
  
  Several of these had been quietly wrong for a long time:
  
  
• 
  
• Choosing CSV silently produced a TXT file.
  
• The company and telephone columns were always empty.
  
• The "All Customers" audience never appeared in the list.
  
• XML output was not well-formed and would not parse.
  
• CSV values were not quoted, so a comma or apostrophe in a name corrupted the row. Now RFC 4180, with protection against spreadsheet formula injection.
  
• A filter containing & (a town like "Stoke & Trent") silently matched nothing.
  
• The page opened with a spurious error message every time.
  
  
  
  
  Credit where it is due
  
  Created by DrByte, who also maintained it across many Zen Cart releases and converted it to the encapsulated plugin format. Later revisions by That Software Guy (swguy), Swifty8078 and Ooba_Scott. It builds directly on the audience and Query Builder functions in Zen Cart core, so thanks are owed to the development team as well.
  
  v3.0.0 by My Zen Cart Host (dbltoe).
  
  
  Availability
  
  The release is being packaged and submitted to the Plugins Library now. I will post the download details in this thread as soon as they exist.
  
  Bug reports and feature requests are welcome here in the meantime.

v3.0.0 is released and has been submitted to the Zen Cart Plugins Library.

Until the library listing is approved, download it from GitHub:
https://github.com/dbltoe/email-address-exporter/releases

Once approved it will also be available in the Plugins Library:
https://www.zen-cart.com/downloads.php?do=file&id=6

Source, issue tracker and full changelog:
https://github.com/dbltoe/email-address-exporter

Installing

It installs into your store's root — the folder that also holds YOUR_ADMIN, includes/, email/ and logs/. Unzip the download, open the email-address-exporter-3.0.0 folder inside it, and upload the zc_plugins/ folder from there to your store root, merging it into the zc_plugins/ folder already present, so you end up with:

<your store root>/zc_plugins/EmailAddressExporter/v3.0.0/manifest.php

Then install it from Modules → Plugin Manager. The page appears under Tools → Export Email Addresses.

If you end up with zc_plugins/zc_plugins/, the folder went one level too deep — move EmailAddressExporter up one level and delete the empty inner folder. Plugin Manager will not list the plugin until that is right.

Upgrading from an earlier version: uninstall the old one in Plugin Manager first. No data is affected — the plugin creates no tables and modifies no records.

Full documentation ships with it as readme.html, and is linked from the Plugin Manager panel alongside the Install button.