Apex Code Development You need to sign in to do that
Don't have an account?
Lawrence-CEC Migrating data from EmailStatus object?
We are working on migrating our business unit's data into a new org and have found that the data reported in the 'HTML Email Status Report' (on the Contacts page) isn't coming over. We've tracked down the source of the data and it appears to be stored in an 'EmailStatus' object (for example the '# Times Opened' column on that report is apparently stored in EmailStatus.TimesOpened field).
However, we haven't been able to figure out how to migrate this data/object. There is a reference to it in the web services API documentation, but there is no 'query()' function available for it -- only a few of the 'describe..()' functions. (We tried doing a query anyway and we do get an error.) This object is also not listed in Eclipse or in the data loader.
Is there any way to get this data migrated? Or will our staff just lose this information?
Thanks,
---Lawrence
Well you can query it using a subquery of Contact or Lead, like
select Id,(select Id from EmailStatuses) from Contact
However since it isn't createable you can't insert it into the new org. I'm afraid I've got no good advice for you there, other than maybe to create a custom object called "Old Email Statuses" with master-details to Contact and Lead and store them in that.