email address exporter

Has anyone done this or does anyone know how to get emails from the database by sign-up date or by customer number?

For instance: I used the Email Address Exporter module to download everyone who subscribes to the newsletter. The following month, I did it again to add the new subscribers but because the list comes out alphbetically I can't tell who I already have on my newsletter list - which I since edited to exclude those who changed their mind and unsubscribed when I sent out my last newsletter.

Please don't tell me to use a service...I"ve been that expensive route and am trying to do this all inhouse.

Can email exporter be tweaked to collect by date or customer number?

You have a few options:

1. When a customer tells you they want off the list, either you or they can go into their account and unsubscribe them from the list.
2. If you want to alter the order in which records are exported, you can edit the SQL query in the appropriate record of the query_builder table, and change the ORDER BY clause to some other value.
3. You could keep a list of "exclusions" and then just be sure to remove them from the exported list after you export, before using the list for mailing.

Thanks for answering so fast...

1 & 3 I've been doing manually but still the list over flows from the previous month and it gets tedious. For instance the latest download of active newsletter subscribers for the last 3 months is 247 but we've only had 200 new customers since last newsletter so I know I must have some of these emails already. I do set GroupMail to not repeat email address but the free version I'm using will not let me export the edited list for safe-keeping and so I need to keep a seperate accurate list of subscribers as we also get subcribers from outside of zen.

So that leaves me with option #2 I believe. I don't know how to do the following (2):

2. If you want to alter the order in which records are exported, you can edit the SQL query in the appropriate record of the query_builder table, and change the ORDER BY clause to some other value.

would I actually be editing admin/email_export.php ? I can't find ORDER BY there...or is this a sql statment I would run in the admin/tools/Install SQL Patches window? Not real comfortable running squl queries but have done it a few times.

You would have to edit raw SQL data in the database, inside the query_builder table itself.

found this from another thread and will work on it:

INSERT INTO query_builder (query_id, query_category, query_name, query_description, query_string, query_keys_list) VALUES ('', 'email,newsletters', 'All customers who have purchased product #103', 'All customers who have ever purchased product #103, ignoring newsletter-subscription status.', 'select c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c, TABLE_ORDERS o, TABLE_ORDERS_PRODUCTS op WHERE c.customers_id = o.customers_id AND o.customers_id = c.customers_id AND o.orders_id = op.orders_id AND op.products_id = 103 GROUP BY c.customers_email_address ORDER by c.customers_lastname, c.customers_firstname ASC', '');

You will find SEVERAL queries listed in that table.
ONLY edit the ONE that you are selecting from the pulldown list when you're doing your email address exports.
And you do NOT need to "INSERT" any new records.

I'm not getting it I guess.

Where do I find ORDER BY? I guess what I need is a sql statment I would run in the admin/tools "run sql patches" window.

Can it start with "select"?

would i be creating a new audience list?

sorry drbyte...did not see that post above...

ok,

I changed in my MEMO > text field in my database...at least i think i changed it...still producing same order with no id:

select c.customers_id, c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c, TABLE_ORDERS o where c.customers_newsletter = '1' AND c.customers_id = o.customers_id and o.date_purchased > subdate(now(),INTERVAL 3 MONTH) GROUP BY c.customers_email_address order by c.customers_id ASC

Changing the query will not change the columns included in the export. That would require changing the whole layout of the export file etc, which would be done in the email_export.php file.

However, changing the ORDER BY value will affect the sort order of items being exported, so you could compare today's export vs next month's export, and know which ones are new just by the items that come after the last item on the today's list vs next month's list.

You are right! Thanks. This will save me oh so much time.

Hi,

I just downloaded and installed the email address exporter. I followed instructions exactly in the readme files. Logged out and back into Admin. The Addon does not show up under tools. I placed it in the /images/uploads folder. Is this correct and if it is, what could be wrong?

Any help would be appreciated. I need to export the email list.

Thanks

mizliz:

I followed instructions exactly in the readme files.
Um, apparently not.
mizliz:

I placed it in the /images/uploads folder. Is this correct and if it is, what could be wrong?
You clearly didn't upload the files and folders which belong in the /admin/ folder to the folders in your /admin/ folder, which is clearly stated as the installation instructions in the readme.

The readme file clearly says images/uploads. I opened and re-read it. I just added it to the admin folder as well. It is there but still does not show up in the admin screen. I'm using Filezilla to upload. Appears to be working fine. Just won't show up.

mizliz:

The readme file clearly says images/uploads. I opened and re-read it.
Okay, yes it does, but NOT in the INSTALLATION instructions :blush:

I'll paste the instructions here again for your convenience, and a little emphasis in case you missed the section entitled "INSTALLATION" ...

===========================================================

NOTES:
This add-on was created to allow quick and easy exporting of
email addresses from your Zen Cart shop.

This is especially useful if you are needing to manage mailing lists and/or send
newsletters or mass-emailings from your personal computer.
One great tool to use this with is GroupMail, which you can get a free copy of here:
http://www.shareasale.com/r.cfm?B=3937&U=151719&M=1465

As to export formats, you can choose from CSV, TXT (tab-delimited), XML, or HTML formats.

You can select any of the audiences available in your cart.
The most common audience would be Newsletter recipients.

If you choose the "Save To File On Server" option, you can set the "Destination Folder"
by editing the /admin/includes/extra_datafiles/email_export.php
and set the DIR_FS_EMAIL_EXPORT to the desired destination.
The default setting (for simplicity) is the /images/uploads folder.
Whatever folder you point this to must be CHMOD 777 or equivalent so that
the webserver userid can write to files in this folder.
When saving to file, if a file of the same name already exists, it will be overwritten. No backups.

===========================================================

INSTALLATION:
Edit the /admin/includes/extra_datafiles/email_export.php and set the DIR_FS_EMAIL_EXPORT to
the desired destination. Be sure the destination folder is CHMOD 777 (read/write).

Upload all the "admin" folder files to the "admin" folder on your server, retaining folder structures.

===========================================================

USE:
To use, just log into the admin area, click on "Tools",
and click on "Export Email Addresses".

===========================================================

Wow my instructons are diffeent than that. The following is he installation section from my read me file.

===========================================================

INSTALLATION:
Upload all files as-is to your server, retaining folder structures.

===========================================================

Thank you for the more detailed instructions. I will give a try.

Anyone know how to change this for it will export all the customers and not just the newsletters?

Thanks for your help.
Rich:smile: