Advertisement:

Author Topic: Member data (email) export help needed  (Read 11113 times)

Offline BangShiftChad

  • Newbie
  • *
  • Posts: 3
Member data (email) export help needed
« on: January 28, 2010, 12:05:56 PM »
I know this topic has been discussed on multiple occasions, but I have not been able to find an answer that helps me specifically. Sorry if it sounds like the same old thing.

I run a forum on our website, but am not the developer that makes changes to the site, programming, etc. I am however an admin on the forums, and am getting ready to do an email blast to our users. This email is not being sent through the SMF forum. I'm using Constant Contact and it will be a feature rich html newsletter.

I need help pulling my member list data, specifically user ID # and email address, so I can put them in an excel spreadsheet. I've heard phpmyadmin as a suggestion, but cannot find info on how to actually use phpmyadmin, and their demo server is down.

Please help. It would be greatly appreciated.

Offline Matthew K.

  • SMF Super Hero
  • *******
  • Posts: 12,430
  • Gender: Male
    • matthew.kerle on Facebook
    • @matthew_kerle on Twitter
Re: Member data (email) export help needed
« Reply #1 on: January 28, 2010, 12:12:58 PM »
Run this query:
Code: [Select]
SELECT `smf_members`.`memberName`, `smf_members`.`emailAddress`
FROM smf_members

That will show you all of the members names, and email addresses

Offline BangShiftChad

  • Newbie
  • *
  • Posts: 3
Re: Member data (email) export help needed
« Reply #2 on: January 28, 2010, 12:21:03 PM »
I realize I suck for asking this, but where am I going to do this query? I don't see anywhere to do that in the admin center.

Offline Matthew K.

  • SMF Super Hero
  • *******
  • Posts: 12,430
  • Gender: Male
    • matthew.kerle on Facebook
    • @matthew_kerle on Twitter
Re: Member data (email) export help needed
« Reply #3 on: January 28, 2010, 12:30:22 PM »
To do this query, go to your cPanel > phpMyAdmin > Your Database > Click Query > Enter the code > Hit Go

Offline amorosso

  • Semi-Newbie
  • *
  • Posts: 28
Re: Member data (email) export help needed
« Reply #4 on: February 06, 2010, 09:35:54 PM »
Awesome worked great for me. However I had to make a small change
Code: [Select]
SELECT `smf_members`.`member_Name`, `smf_members`.`email_Address`
FROM smf_members

I was able to export as a CSV file and then import to a different program. I mean I had over two thousand. Thanks again..

Offline Matthew K.

  • SMF Super Hero
  • *******
  • Posts: 12,430
  • Gender: Male
    • matthew.kerle on Facebook
    • @matthew_kerle on Twitter
Re: Member data (email) export help needed
« Reply #5 on: February 06, 2010, 09:42:19 PM »
The difference is you're using SMF 2.0, of some sort. As the query I provided above, does work with 1.1

Offline amorosso

  • Semi-Newbie
  • *
  • Posts: 28
Re: Member data (email) export help needed
« Reply #6 on: February 06, 2010, 09:49:30 PM »
I thought it might be that. Anyways, thank you so much.. I love SMF just on pure support is enough. When you been around the block a few times trying this one working with that one you guys rocks...

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: Member data (email) export help needed
« Reply #7 on: March 03, 2010, 09:34:24 PM »
Were you able to get this working for you, BangShiftChad?
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline MarcHaycook

  • Semi-Newbie
  • *
  • Posts: 20
Re: Member data (email) export help needed
« Reply #8 on: May 02, 2010, 08:49:55 PM »
What query do I want to run to export Username, E-Mail, Location, Position and Date Registered?

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: Member data (email) export help needed
« Reply #9 on: May 08, 2010, 08:36:27 PM »
If you are familiar with phpMyAdmin, take a look at the structure of the smf_members table and you will see the table names that you will need to export in order to get the data you are looking for.
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline juliegreen

  • Semi-Newbie
  • *
  • Posts: 62
    • job seekers
Re: Member data (email) export help needed
« Reply #10 on: February 27, 2012, 03:51:36 PM »
that code saved my life!

thank you
Awesome worked great for me. However I had to make a small change
Code: [Select]
SELECT `smf_members`.`member_Name`, `smf_members`.`email_Address`
FROM smf_members

I was able to export as a CSV file and then import to a different program. I mean I had over two thousand. Thanks again..

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: Member data (email) export help needed
« Reply #11 on: February 28, 2012, 08:30:20 PM »
Outstanding! :)
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods

Offline pawan2002

  • Jr. Member
  • **
  • Posts: 225
  • Gender: Male
    • @pawan2002 on Twitter
    • Pawan
Re: Member data (email) export help needed
« Reply #12 on: October 22, 2018, 12:50:16 AM »
You will have to change the code as per your Database. If you have created a custom database, check the name and give accordingly.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,026
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: Member data (email) export help needed
« Reply #13 on: October 22, 2018, 01:34:38 AM »
You will have to change the code as per your Database. If you have created a custom database, check the name and give accordingly.
If the OP hasn't figured this out in 8 years already, I'm pretty sure they would need a bit more detailed help than that.

But to save you the trouble, I will just tell you that bumping old support topics is not a good idea - and will lock this.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas