Download Content of all Messages

[MF09]

Hello HivePress team,

I would like to download the content of all the messages we received so I can analyse them and generate FAQs. Can you explain how I can do it?

Thank you!

[andrii]

Hi,

Messages are hidden comment of type hp_messages, stored in the database table wp_comments. If you are using a hosting provider, they usually provide a UI for viewing the database, and you can filter there in the wp_comments table and export.

​I hope this is helpful to you.

[condorito.fr]

As @andrii said, connect to your database, via your cPanel (generally phpMyAdmin), and run this SQL query :

select * from wp_comments where comment_type="hp_message"

Note : Quite often WordPress tables have a prefix, for safety reasons.
So wp_comments may be called [someprefix]_comments instead.

[buddygrapher]

Thanks a lot for sharing the query… Can’t find the recipient of the message though… Can you help me with that?

[buddygrapher]

@condorito.fr @andrii any ideas?

[condorito.fr]

Hello,

A quick experiment proved that, IMHO, comment_karma holds the addressee user ID, whereas the user_id field stores the sender user ID.

All you need to do is some INNER JOINS with wp_users table if you need to retrieve their respective names.

Cheers.

[buddygrapher]

Hey @condorito.fr ,

Thanks for your help!!! I will check and post the results