Exporting and importing archived emails

English Language - Forum
1

Hi SuiteCRM community! I have a client with a broken SuiteCRM, well one that broke during the upgrade due to unsupported customizations, and we’re looking at re-implementation. Is there a way, either a set of queries or an extension, which will allow the exporting of emails which have been archived against accounts and contacts?

Thanks!

2

Hi,
This can be simply a join of emails , emails_beans ,emails_text .

select *  from emails as t1 
inner join emails_text as t2 on t1.id = t2.email_id 
inner join emails_text as t3 on t3.email_id = t1.id 
where deleted =0 and  bean_module ='Accounts ' or bean_module='Contacts'

Please do not hesitate to reach me if you need any assistance!

Ashish Dwivedi ( CTO at Outright Store).
ashish@outrightcrm.com

skype : ashdwi1

Whatsapp : +919005468298

Grab Free Extensions : https://store.outrightcrm.com/free-extension/

1 Like