News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Member data (email) export help needed

Started by BangShiftChad, January 28, 2010, 12:05:56 PM

Previous topic - Next topic

BangShiftChad

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.

Matthew K.

Run this query:
SELECT `smf_members`.`memberName`, `smf_members`.`emailAddress`
FROM smf_members


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

BangShiftChad

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.

Matthew K.

To do this query, go to your cPanel > phpMyAdmin > Your Database > Click Query > Enter the code > Hit Go

amorosso

Awesome worked great for me. However I had to make a small change
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..

Matthew K.

The difference is you're using SMF 2.0, of some sort. As the query I provided above, does work with 1.1

amorosso

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...

JimM

Jim "JimM" Moore
Former Support Specialist

MarcHaycook

What query do I want to run to export Username, E-Mail, Location, Position and Date Registered?

JimM

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

juliegreen

that code saved my life!

thank you
Quote from: amorosso on February 06, 2010, 09:35:54 PM
Awesome worked great for me. However I had to make a small change
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..

JimM

Jim "JimM" Moore
Former Support Specialist

Pawan

You will have to change the code as per your Database. If you have created a custom database, check the name and give accordingly.

Aleksi "Lex" Kilpinen

Quote from: pawan2002 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.
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.
Slava
Ukraini!


"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

How you can help SMF

Advertisement: