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.
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
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.
To do this query, go to your cPanel > phpMyAdmin > Your Database > Click Query > Enter the code > Hit Go
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..
The difference is you're using SMF 2.0, of some sort. As the query I provided above, does work with 1.1
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...
Were you able to get this working for you, BangShiftChad (http://www.simplemachines.org/community/index.php?action=profile;u=235918)?
What query do I want to run to export Username, E-Mail, Location, Position and Date Registered?
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.
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..
Outstanding! :)
You will have to change the code as per your Database. If you have created a custom database, check the name and give accordingly.
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.