Kryptronic Software Support Forum

Use System / Database / Raw DB Admin to export emails from the core_guestsub table into a CSV file.

Probably an SSL/non-SSL issue.  You can download directly from the {public}/downloads directory via FTP.  That's where the file is saved.

The core_guestsub table holds guest accounts which have maillist subscriptions.  If there's an entry there, they are a subscriber.  Are you looking also for subscribed user accounts?

I apologize for misspeaking.  I later V8 versions the subscriptions were moved entirely to that subscriber table.  To pull all user accounts, you could execute this in Raw DB Admin:

SELECT id FROM core_users

And request CSV output.  There will be duplicates between this list and the list of subscribers pulled from core_guestsub.

Hello Nick,

We have tried SELECT id FROM core_users but the only emails we need are for those who have signed up for email subscriptions that have user accounts.  How would an SQL Statement look to segregate those emails for export?

Thanks

Thanks Nick,

This works perfectly and I was able to modify it to include fname and lname in the output as to create merge tags.....

SELECT id, fname, lname FROM core_users WHERE subscriptions<>''

Now if we want to delete email bounces and unsubscribes that are maintained in MailChimp how would we structure a statement to do so?  For example, we use MailChimp to manage the exported lists for analytics but need to sync the corrections with our CCP database where customers sign up initially.

I started with this but not sure if I have the proper format...

DELETE FROM core_guestsub
WHERE id='name@email.com, name2@email.com';

The database appeared to acknowledge what I wanted to do but didn't delete the two example emails from the database.

Also, what would it look like if we wanted to simply unsubscribe a "core_user" from "subscriptions" but not delete their email or anything else?

Thanks again