Email Address Exporter - HTML or TEXT

[lloyd_borrett]

G'day,

I'm trying to work through getting the Email Address Exporter add-on to also output whether the customer has chosen to receive HTML or TEXT email.

I think I can figure out how to make the changes to admin/email_export.php to achieve this.

I've edited most of the entries in the query_builder table to have the queries return the customers_email_format value.

But I can't figure out how to change the query for the Administrator option so that I'm returned an appropriate value for customers_email_format.

The current query is:

select 'ADMIN' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id

Ideally the new query would return customer_email_format set to an appropriate value based on the value specified for the Email Admin Format (ADMIN_EXTRA_EMAIL_FORMAT) set in the configuration table. But I'd be happy to just set it as HTML or TEXT manually.

Can anyone help me?

Best Regards, Lloyd Borrett.

[lloyd_borrett]

Attached is my modified admin/email_export.php file.

After changing the queries in the query_builder table, it works for every option except the Administrator.

Cheers, Lloyd Borrett.

[lloyd_borrett]

Attached is the current contents of my query_builder table with the modified select statements.

Note: In this version, the Administrator query won't work with the changed email_export.php file.

Cheers, Lloyd Borrett.