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
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..
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.
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.