using "Email address exporter" to export ALL customers regardless of status

[rosenblum68]

If you are using the "Email Address Exporter" module, and want to be able to select ALL of your registered customers for export (or design other criteria for download), you can do this by adding records to the database table 'query builder'. There should be 6 entries. Add a row as shown below. It will then show up as an option when you do 'TOOLS'-'EXPORT EMAIL ADDRESSES'


'query_string' = 'select c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c GROUP BY c.customers_email_address order by c.customers_lastname, c.customers_firstname ASC'

'query_id' = NULL

'query_category' = email,newsletters

'query_name' = All registered customers (Regardless of subscription status)

'query_description' = All registered customers.

hope this is useful for someone else!

jeff

[gapi78]

Where do can i find this code to change, i looked everywhere but didnt find anything to change.

[lloyd_borrett]

I think you have to add those values into the database table 'query builder'. I suspect no code changes are required.

It would be handy if someone could build the text that could be used with SQL Query Executor, to make things simpler.

Cheers, Llloyd Borrett.

[DrByte]

What was posted above is exactly what you would put in if you were using phpMyAdmin to add an extra record to the table. Just fill in the blanks with the info posted.

[bdekraker]

Here is how to easily add this feature:

From the store Admin, go to Tools, Install SQL Patches.

Paste in this code. Replace "databasename" with your actual database name:

INSERT INTO  `databasename`.`query_builder` (
`query_id` ,
`query_category` ,
`query_name` ,
`query_description` ,
`query_string` ,
`query_keys_list`
)
VALUES (
'auto-increment',  'email,newsletters',  'All registered customers (Regardless of subscription status)',  'All registered customers.', '''select c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c GROUP BY c.customers_email_address order by c.customers_lastname, c.customers_firstname ASC''',  ''
);

Click Send. The new export ability should now be added.

[bdekraker]

CORRECTION:

Slight error in my original code. This should work:



From the store Admin, go to Tools, Install SQL Patches.

Paste in this code. Replace "databasename" with your actual database name:

INSERT INTO  `databasename`.`query_builder` (
 `query_id` ,
 `query_category` ,
 `query_name` ,
 `query_description` ,
 `query_string` ,
 `query_keys_list`
)
VALUES (
 'auto-increment',  'email,newsletters',  'All registered customers (Regardless of subscription status)',  'All registered customers.', 'select c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c GROUP BY c.customers_email_address order by c.customers_lastname, c.customers_firstname ASC',  ''
)

Click Send. The new export ability should now be added.

[Svault]

Tried inserting code into SQL Patches but got "Fail".
I did change the databasename to my actual database name where Zen Cart is installed.

Can someone help? Looking to download all email addresses.

[apsona]

Hi,

How about trying Apsona ShopAdmin, a free product? You can download email addresses and then export them into a CSV. You can sign up for a free account on apsona.com.

Hope this is helpful.
Apsona

[Svault]

Hi,

How about trying Apsona ShopAdmin, a free product? You can download email addresses and then export them into a CSV. You can sign up for a free account on apsona.com.

Hope this is helpful.
Apsona

no worries. Figured it out via another thread. Thanks!

[rebekah]

CORRECTION:

Slight error in my original code. This should work:



From the store Admin, go to Tools, Install SQL Patches.

Paste in this code. Replace "databasename" with your actual database name:

INSERT INTO  `databasename`.`query_builder` (
 `query_id` ,
 `query_category` ,
 `query_name` ,
 `query_description` ,
 `query_string` ,
 `query_keys_list`
)
VALUES (
 'auto-increment',  'email,newsletters',  'All registered customers (Regardless of subscription status)',  'All registered customers.', 'select c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c GROUP BY c.customers_email_address order by c.customers_lastname, c.customers_firstname ASC',  ''
)

Click Send. The new export ability should now be added.

The code is missing a semi-colon at the end. I added one and it worked for me. Gave me the choice to download ALL customers. Thanks.