Advertisement:
GCWebhosting

Author Topic: How can I extract users emails?  (Read 3953 times)

Offline perfec2

  • Jr. Member
  • **
  • Posts: 230
How can I extract users emails?
« on: February 22, 2011, 06:19:01 PM »
Greeting to all,
I have been using standard way to send announcement to my forum members which is very slow and takes morethan 5 hours to complete as the members of our forum is morethan 100, 000. I think extracting their emails will be easier.
My question is how can i get their emails so that I can send it as normal email to them?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,333
  • Gender: Male
    • Kindred-999 on GitHub
Re: How can I extract users emails?
« Reply #1 on: February 22, 2011, 06:22:57 PM »
Only by the database in the SMF_members able
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline perfec2

  • Jr. Member
  • **
  • Posts: 230
Re: How can I extract users emails?
« Reply #2 on: February 22, 2011, 06:29:34 PM »
Sorry, how and where can I locate it?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,333
  • Gender: Male
    • Kindred-999 on GitHub
Re: How can I extract users emails?
« Reply #3 on: February 22, 2011, 06:38:14 PM »
Go to the SMF_members table in your database and look t the field names. The email column should be obvious..  Extract that column and you will have a list of all your user's emails. Be careful though....  It could be considered spam, if you send things directly to your users email addresses without their request
« Last Edit: February 26, 2011, 12:18:29 PM by Kindred »
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline perfec2

  • Jr. Member
  • **
  • Posts: 230
Re: How can I extract users emails?
« Reply #4 on: February 22, 2011, 06:41:00 PM »
Ok, thank you, I will check that out.

Offline perfec2

  • Jr. Member
  • **
  • Posts: 230
Re: How can I extract users emails?
« Reply #5 on: February 26, 2011, 08:55:03 AM »
It seems like is something one has to be copying one by one (if I really got it) is there a way one can just download them at once?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,333
  • Gender: Male
    • Kindred-999 on GitHub
Re: How can I extract users emails?
« Reply #6 on: February 26, 2011, 12:21:13 PM »
Go to the SMF_members table in your database and look t the field names. The email column should be obvious..  Extract that column and you will have a list of all your user's emails. Be careful though....  It could be considered spam, if you send things directly to your users email addresses without their request
phpmyadmin!

Code: [Select]
SELECT `email_address`
FROM `smf_members`
WHERE 1
then export
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline perfec2

  • Jr. Member
  • **
  • Posts: 230
Re: How can I extract users emails?
« Reply #7 on: February 26, 2011, 03:26:58 PM »
Ok, is clear, I will do that.
Thanks.

Offline perfec2

  • Jr. Member
  • **
  • Posts: 230
Re: How can I extract users emails?
« Reply #8 on: February 28, 2011, 07:19:26 AM »
I got to sql and run the query and got following message:
"#1054 - Unknown column 'email_address' in 'field list'"
I think I got off the track.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,333
  • Gender: Male
    • Kindred-999 on GitHub
Re: How can I extract users emails?
« Reply #9 on: February 28, 2011, 07:22:48 AM »
oops.... I gave you the sql for 2.0
(the column name changed)

I don't recall what the column was called in 1.1.x
Look at your database and find the column name... use that instead of email_address
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,230
    • StoryBB/StoryBB on GitHub
Re: How can I extract users emails?
« Reply #10 on: February 28, 2011, 09:00:58 AM »
It was called emailAddress in 1.1.x
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline aksal

  • Semi-Newbie
  • *
  • Posts: 48
    • Zerion.net on Facebook
    • @zerionnet on Twitter
    • Zeriyt - Forumi Shqiptar - Zerion
Re: How can I extract users emails?
« Reply #11 on: May 07, 2019, 06:28:38 PM »
I have a similar issue.
What query do I want to run to export the email addresses from a particular membergroup?

Offline Shambles

  • SMF Hero
  • ******
  • Posts: 5,145
  • Gender: Male
    • i30 Owners Club
Re: How can I extract users emails?
« Reply #12 on: May 07, 2019, 06:56:03 PM »
I have a similar issue.
What query do I want to run to export the email addresses from a particular membergroup?
This is an 8 year old [solved] topic. Best if you start your own, stating your version of SMF and any mods you have applied.

Offline aksal

  • Semi-Newbie
  • *
  • Posts: 48
    • Zerion.net on Facebook
    • @zerionnet on Twitter
    • Zeriyt - Forumi Shqiptar - Zerion
Re: How can I extract users emails?
« Reply #13 on: May 08, 2019, 06:40:36 AM »
SMF 2.0.15

Offline Shambles

  • SMF Hero
  • ******
  • Posts: 5,145
  • Gender: Male
    • i30 Owners Club
Re: How can I extract users emails?
« Reply #14 on: May 08, 2019, 11:29:03 AM »
Way to go.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,230
    • StoryBB/StoryBB on GitHub
Re: How can I extract users emails?
« Reply #15 on: May 08, 2019, 11:36:30 AM »
Can’t say I’m surprised, this was someone who argued quite emphatically that because someone did a few mockups of a theme, that wasn’t ever made into an actual theme, the full theme must basically be made available just because they wanted it. Never mind anyone else involved (like the person who was simply trying out ideas in his spare time)
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Irisado

  • Una Luz Brillante en la Oscuridad
  • Doc Coordinator
  • SMF Super Hero
  • *
  • Posts: 10,127
  • Soñando debajo del arco iris
Re: How can I extract users emails?
« Reply #16 on: May 08, 2019, 05:17:06 PM »
Topic locked.  Please start your own support topic and avoid posting in old solved topics in future.
Soñando con una playa donde brilla el sol, un arco iris ilumina el cielo, y el mar espejea iridescentemente