Five Stars

Import Salesforce Chatter Feed

Hi. Im rebuilding salesforce org which includes moving data from one object to another. As a part of that Im trying to migrate chatter feed as well. Feed data (such as posts, comments, likes, etc) are stored in multiple objects. However on these object I cannot create custom field to store external id in order to match records later. Im happy to migrate just posts and comments. Posts are stored in FeedItem object while comments are in FeedComment object.
I was thinking I could first load FeedItems and use this 'Retrieve Salesforce Id' option in Advanced settings of tSalesforceOutput component to generate newly created salesforce id and continue creating FeedComments (see the job design on the picture). However I cannot get newly created salesforce id and old salesforce id next to each other in one output schema. If I had that I could match them in tMap_2 component (second picture), but the Id field you can see there coming from FeedItem_NEW is technically empty as it is auto-generated field which cannot be changed.
Anyone able to help? Many thanks 
5 REPLIES
Moderator

Re: Import Salesforce Chatter Feed

Hi,
Could you please indicate what's the build version you are using?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Import Salesforce Chatter Feed

Hi Sabrina. It is 6.1.1, but I dont think this would be version problem or something. I was thinking somebody might know about some workaround as I believe it must be common issue when migrating chatter between salesforce orgs. All I need to do actually is to get 'old record id' next to 'newly created record id' in output row from tSalesforceOutput component (which is in this case called DestinationFeedItem). Salesforce doesnt let me create custom field on FeedItem object where I could store this 'old record id'. It looks really simple but yet Im struggling with this..
One Star

Re: Import Salesforce Chatter Feed

I'm actually trying to do the exact same thing without success. Let me know if you are able to find a solution to this problem. 
Ideally if FeedItem allowed the creation of a new column called "ForeignSFReferenceID" or something that would work - but it doesn't. Nor I seem to chain up multiple tMaps together to get it to work. 
One Star

Re: Import Salesforce Chatter Feed

I also tried to re-use the native fields on the FeedItem object e.g. BestCommentID. But they fail due to built-in validations e.g. wrong format, no permissions. 
One Star

Re: Import Salesforce Chatter Feed

It appears the FeedItem.Title field isn't actually displayed in my Chatter field. Only the FeedItem.Body field is used. 
So I re-purposed the Original FeedItem.ID and pushed it into the Destination FeedItem.Title field. Kind of a hack since the field wasn't designed for this purpose. But this is the only way I can get it to work.