6 {{ upvoteCount | shortNum }}
6 {{ upvoteCount | shortNum }}

How To Put Wordpress Subscribers Into a .CSV file?

by Jason Moffatt
5 replies
I have about 3500 people that have subscribed to my wordpress blog (obviously, many of those are comments spammers, wanna be hackers, etc) and I was curious if anyone knew of a way to aggregate all those emails and put them into a .csv file without having to manually input each and every one.

Is there a tool for this?

And if not, I reckon it would be a fairly valuable thing for someone to make.
#csv #file #mail #put #subscribers #wordpress
  • Profile picture of the author jacktackett
    Jason,
    this is a pretty quick operation in phpMyAdmin. It should be available in your hosting account's admin tool but can also be installed standalone.

    Simply open phpMyAdmin and select you blog's database.
    Select the wp_comments table
    Select all entries (there is a link to do that at the bottom of the grid)
    Then click export button at the top of the page
    Select CSV in the format drop down and voila - a csv file of all your commentators ready for Excel or Calc.
    Good luck,
    --Jack
    Signature
    Let's get Tim the kidney he needs!HELP Tim
    Mega Monster WSO for KimW http://ow.ly/4JdHm


    {{ DiscussionBoard.errors[7100323].message }}
  • Profile picture of the author Paul Myers
    Jason,
    Is there a tool for this?
    Yep. One of my subscribers, Arun Agrawal, (also a member here), wrote it for my other subscribers.

    Email me, so I remember, and I'll send you a copy.


    Paul
    Signature
    .
    Stop by Paul's Pub - my little hangout on Facebook.

    {{ DiscussionBoard.errors[7100378].message }}
  • Profile picture of the author Bryan Zazz
    the phpMyAdmin suggested by Jack is your best solution.
    if you don't mind getting your hands a bit dirty, you could also dump your database, then clean the data manually with a scripting language. I prefer python myself.
    But then the task of filtering out between spammers, hackers, and more genuine subscribers is much more delicate, I don't know if that can be automated - I mean, without a pair of eyeballs looking into the posts.
    Signature
    wsoProto-WSO
    wsoProto-app
    {{ DiscussionBoard.errors[7100665].message }}

Trending Topics