1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How do I Scrape WP Comments Emails

Discussion in 'Blogging' started by James2, Oct 8, 2016.

  1. James2

    James2 Supreme Member

    Joined:
    Jun 3, 2011
    Messages:
    1,215
    Likes Received:
    1,036
    Location:
    London, England
    Hi guys, I hope you're having a good weekend so far.

    My website gets a ton of comments and I was wondering if there was a way to quickly scrape the emails from the comments. The same goes for the feedback section. Doing it manually with cutting and pasting would take hours.
    I've searched BHW and G, but I can't find anything on the subject.

    All the best,

    James :)
     
  2. Repulsor

    Repulsor Power Member

    Joined:
    Jun 11, 2013
    Messages:
    775
    Likes Received:
    280
    Location:
    PHP Scripting ;)
    Is it your website? Are the emails in the email field or in between the comments? If its your website, you can fetch it from your database. You can do it if you know some SQL. If the emails are between the content, you can fetch the comment contents from the database and do some basic regex filtering using PHP or any language that you might know. Scraping manually is going to be a hectic job.

    Anyways, let me know.
     
  3. James2

    James2 Supreme Member

    Joined:
    Jun 3, 2011
    Messages:
    1,215
    Likes Received:
    1,036
    Location:
    London, England
    Thanks Repulsor,

    It's my site, so I know these email addresses will be laser targeted. The emails are below the content of my published pages and in the comments section of my WP dashboard. I don't know SQL I'm afraid. My knowledge goes as far as using the WP dashboard.

    Cheers,

    James :)
     
  4. blogzandstuff

    blogzandstuff Elite Member

    Joined:
    Jan 1, 2015
    Messages:
    6,422
    Likes Received:
    3,002
    Occupation:
    blog creator
    Location:
    UK
  5. James2

    James2 Supreme Member

    Joined:
    Jun 3, 2011
    Messages:
    1,215
    Likes Received:
    1,036
    Location:
    London, England
    • Thanks Thanks x 1
  6. bartosimpsonio

    bartosimpsonio Jr. VIP Jr. VIP Premium Member

    Joined:
    Mar 21, 2013
    Messages:
    12,767
    Likes Received:
    11,425
    Occupation:
    COINZ
    Location:
    BUYAH
    Home Page:
    Do you have Cpanel? You can just do as other suggested, then export to CSV and use it on any mailer program.
     
    • Thanks Thanks x 1
  7. James2

    James2 Supreme Member

    Joined:
    Jun 3, 2011
    Messages:
    1,215
    Likes Received:
    1,036
    Location:
    London, England
    I do, but I have found out from blogzandstuff there is a plugin for downloading comment emails and there is an export to CSV button on the bottom of the feedback section in the dashboard.

    Thanks though.
     
    • Thanks Thanks x 1
  8. pressrelease

    pressrelease Power Member

    Joined:
    Jan 6, 2016
    Messages:
    676
    Likes Received:
    241
    Location:
    Disneyland
    but why you want to steal your site users email, just ask them to subscribe to your site, any way you can use this using sql in cpanel, it will be very easy.
     
    • Thanks Thanks x 1
  9. blogzandstuff

    blogzandstuff Elite Member

    Joined:
    Jan 1, 2015
    Messages:
    6,422
    Likes Received:
    3,002
    Occupation:
    blog creator
    Location:
    UK
    Well its not stealing and by the looks of it op has the solution, always good to read thread first
     
    • Thanks Thanks x 1
  10. pressrelease

    pressrelease Power Member

    Joined:
    Jan 6, 2016
    Messages:
    676
    Likes Received:
    241
    Location:
    Disneyland
    yeh i trust as you have read my full reply.
     
  11. James2

    James2 Supreme Member

    Joined:
    Jun 3, 2011
    Messages:
    1,215
    Likes Received:
    1,036
    Location:
    London, England
    I didn't think of it as stealing either. These are guys that interact with the website. Anyway, thanks everyone for your input.