Advertisement:

Author Topic: How to export the email addresses from a particular membergroup?  (Read 320 times)

Offline aksal

  • Semi-Newbie
  • *
  • Posts: 39
What query do I want to run to export the email addresses from a particular membergroup?
I use SMF 2.0.15
Thank you.

Offline Oldiesmann

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 24,847
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • https://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: How to export the email addresses from a particular membergroup?
« Reply #1 on: May 13, 2019, 05:57:35 PM »
There is no built-in functionality to do this in SMF.
Michael Eshom
Cincy Space - now open!

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,176
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: How to export the email addresses from a particular membergroup?
« Reply #2 on: May 13, 2019, 05:59:12 PM »
You would need to run an sql query via phpmyadmin or another tool from the smf_members table where id_group = group id you need
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 50,570
Re: How to export the email addresses from a particular membergroup?
« Reply #3 on: May 13, 2019, 06:30:12 PM »
what is the reason you want to export their email addresses? if it is to send an email to them you can do that using the newsletter function.

Offline aksal

  • Semi-Newbie
  • *
  • Posts: 39
Re: How to export the email addresses from a particular membergroup?
« Reply #4 on: May 13, 2019, 09:50:20 PM »
what is the reason you want to export their email addresses? if it is to send an email to them you can do that using the newsletter function.

It takes like forever if I use the build in Newsletter function because I have a lot of users. That's why I need to export the addresses and use an external tool for sending emails.

Offline aksal

  • Semi-Newbie
  • *
  • Posts: 39
Re: How to export the email addresses from a particular membergroup?
« Reply #5 on: May 13, 2019, 09:51:08 PM »
You would need to run an sql query via phpmyadmin or another tool from the smf_members table where id_group = group id you need

What would be the right query for this?
Thanks

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,176
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: How to export the email addresses from a particular membergroup?
« Reply #6 on: May 13, 2019, 10:33:39 PM »
select email_address from smf_members where id_group = ###
### replace with group id
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Oldiesmann

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 24,847
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • https://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: How to export the email addresses from a particular membergroup?
« Reply #7 on: May 13, 2019, 10:45:51 PM »
Might want to change that last part to "id_group = ### OR FIND_IN_SET(###, additional_groups)" to catch any members who are in that group but don't have it as their primary group.
Michael Eshom
Cincy Space - now open!