Corey Salzano

Export comments WordPress plugin

I launched a new WordPress plugin to export a blog’s comments. Specifically, this plugin creates a tab-delimited text version of the wp_comments database table. Options include approved, pending or spam (or any combination of) comments.

This page will soon expand. For now…

Download this plugin from WordPress.org

Comments

18 responses to “Export comments WordPress plugin”

  1. Anil Selarka

    Where does the exported comments go? We do not get any information about location of the files.

  2. Corey

    Anil:

    There is no “save to disk” feature yet. Here are the instructions I included with the plugin:

    “Activate the plugin and visit the “Export comments” page under Settings. Choose what type of comments you wish to export and click the Export comments button.”

    After that, the exported data is sitting right in front of you on the page in a textarea.

  3. CambriaMaven

    This plug-in is just what I needed. The only thing that would make this closer to perfection would be to include the WP title the comment was made on, instead of just the post ID. But since I can still accomplish this in a 3 step process (combining the output from export to text with the output from this plug-in), I’m definitely not complaining.
    Thanks for your work and for sharing it.

  4. Corey

    CambriaMaven:

    Thanks for your feedback. Right now, the export is just a complete dump of the wp_comments database table.

    I am certainly open to more of your suggestions if you’d like to influence a future release. I don’t have any grand plans since it already meets my simple needs.

    Thanks again

  5. Greg

    great plugin! how would you go about re-importing the comments in another wordpress blog?

  6. Corey

    Greg:

    You might find it easier to back up and restore comments using phpMyAdmin to export an SQL statement. This plugin creates delimited data.

  7. Greg

    yes that’s the conclusion i came to as well. Thanks Corey

  8. jenn

    This was just what I was looking for! I needed a way to get my comments out and organized for a contest. Thank you!

  9. bee

    This really helped me, thank you!

  10. Ian Douglas

    I get the following error on a 64M (php.ini) WordPress install:

    Fatal error: Out of memory (allocated 65798144) (tried to allocate 49 bytes) in /home/bikyaweb/public_html/wp-includes/wp-db.php on line 1383

    Any ideas of a fix?

    thanks

  11. Abhishek

    Thanks my friend.

    I needed it for reporting against spams.

    The copied data can be saved as csv too.

  12. Jason

    Nice plug-in, but I’d like to export my comments that are in the Trash, too. Is there any way to do that? Or can you add that feature for the next version?

  13. Michael E. Rubin

    Hi Corey,

    Our admin installed the plug-in this afternoon. It seemed to work fine at first. Now, whenever I click “Export Comments” nothing happens. It just hangs and the screen goes blank.

    Any ideas?

    At your service,
    Michael E. Rubin
    [email protected]

  14. Corey

    Michael:

    If the screen goes blank, you might be hitting a 500 error. Can you check the log for an error?

  15. Tore

    Thank you very much! You just saved me about two hours of work!
    Thank you for sharing!

  16. Philip

    This worked great. I could just paste it into Openoffice Calc and it was perfectly organized. Thanks!

  17. methodshop

    in the next version, can you please have your plugin export a WXR XML file?

  18. Corey

    methodshop: I have no update schedule at this time. Are you willing to commission the feature?