[SalesForce] Chatter feed data migration

We are about to conduct a massive migration which will involve moving data from one object to another and even changing the relationships among objects. It will require us to export and re-import the data. We would like to keep the Chatter feeds with their related records if possible. I have been told it is possible by exporting the feed data, and then some how re-matching the Parent ID of it to the new Record ID of the newly re-imported record through a Vlookup procedure on a spreadsheet.

My questions are such :

  1. How can I access the Feed data ? I've never associate it with a specific object so I wouldn't even know how to go about exporting it.

  2. Has anybody ever done this ? Could you give some insight\feedback\advice ?

I really appreciate your time and help.

Thank you.

Best Answer

I tried researching the difference between the Object_feed object and the FeedItem object with little success. The one thing that did come up consistently is that the object_feed is only available for objects that you have enabled feed tracking on.

According to the following blog post, the data is captured in both the FeedItem object as well as the Object__feed object, assuming you have enabled feed tracking on that object. There's also a very good visual in the post that should help.

http://simplysfdc.blogspot.com/2013/03/query-chatter-feed-and-how-it-structure.html

Related Topic