News:

Wondering if this will always be free?  See why free is better.

Main Menu

save forum users emails to a file?

Started by MacGig, August 30, 2020, 11:29:44 AM

Previous topic - Next topic

MacGig

 id like to save users emails to a text file.... is their an easy way to do this? thanks. :)

vbgamer45

Easyiest way would be to grab them from the database
select email_address from smf_members
You can run that query via phpmyadmin
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

Arantor

If it's to send everyone a newsletter, that's built in...

MacGig

Quote from: vbgamer45 on August 30, 2020, 11:35:20 AM
Easyiest way would be to grab them from the database
select email_address from smf_members
You can run that query via phpmyadmin



can you give me more info? how would I do this? never have done it before. query the db.

vbgamer45

If you have cpanel you might have a phpmyadmin section
From there you would select the database. Then run the query or use the export option

Here is a video i found on phpmyadmin https://www.youtube.com/watch?v=JgAyGjcNrIQ
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

MacGig

how would I do a query on how to save all emails to a txt file?  I know how to open the db in phpmyadmin and that is all I know how to do.

vbgamer45

select email_address from smf_members

Works I think they have an option to exprot to csv file.
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

Sir Osis of Liver

Don't think you can export a column, but just export the table as csv and load it into spreadsheet, then you can do whatever with the data.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Kindred

Sir Osis of Liver --   vbgamer just indicated how to do it for just a single column
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

MacGig


Sir Osis of Liver

Quote from: Kindred on August 31, 2020, 09:09:08 AM
Sir Osis of Liver --   vbgamer just indicated how to do it for just a single column

Yes, I know, but that's using a query, not pma export.  Some folks are not up to running queries.  Couple ways of doing same thing.

Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Advertisement: