Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 
0683p000009MCv0.png 0683p000009MCqC.png 0683p000009MCvA.png
Labels (3)
5 Replies
Anonymous
Not applicable
Author

Hi,
Could you please indicate what's the build version you are using?
Best regards
Sabrina
Anonymous
Not applicable
Author

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..
_AnonymousUser
Specialist III

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. 
_AnonymousUser
Specialist III

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. 
_AnonymousUser
Specialist III

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.