Move Chatter Feed Posts and Comments from One Record to Another Using Data Loader

Step 1: Export FeedItem and FeedComment Records

Perform two separate exports on the FeedItem and FeedComment objects.

1. Launch Data Loader and click Export.
2. Check Show all Salesforce objects.
3. Select the Feed Item (FeedItem) object. You will need to repeat this process for the Feed Comment (FeedComment) object separately.
4. Select all fields.
5. Filter the results so that ParentID equals the ID of the old related record. This exports only the Feed Items and Feed Comments associated with that record.
6. Click Finish, Yes, and OK.

You will have two CSV files containing the Chatter records associated with the source record. Review these files and remove any posts or comments you do not want to move.
Note: Save a copy of the original files to a safe location for backup purposes.

Step 2: Update the Parent ID in the CSV Files

1. In both CSV files, rename the Parent ID column to Old Parent ID.
2. Create a new column with the header Parent ID.
3. Insert the ID of the new (destination) parent record into the new Parent ID column.
4. In the FeedItem CSV file, rename the ID column to Old ID.
5. In the FeedComment CSV file, rename the ID column to Old ID and the FeedItemID column to Old FeedItemID.
6. Save both files as CSV files.

Step 3: Insert New FeedItem Records

Use Data Loader to perform an Insert on the FeedItem object using the updated FeedItem CSV file.

Step 4: Match New FeedItem IDs to Old Ones

The Data Loader success file from Step 3 contains the new FeedItem IDs alongside the original IDs. Use this file to map old FeedItem IDs to new ones.

Step 5: Update the FeedComment CSV with New FeedItem IDs

In the FeedComment CSV file, create a new column called FeedItemID and insert the new FeedItem record IDs from Step 4, matching each comment to its corresponding new FeedItem.

Step 6: Insert New FeedComment Records

Use Data Loader to perform an Insert on the FeedComment object using the updated FeedComment CSV file.

Step 7: Delete the Original Chatter Feed Items from the Source Record

Use the Old FeedItem ID and Old FeedComment ID values to delete the original Chatter feed posts and comments from the source record using Data Loader's Delete operation.

Important Note on User Permissions

If the logged-in user has the "Insert System Field Values for Chatter Feeds" user permission, the create field property is available on CreatedBy and CreatedDate system fields for the FeedItem object. This allows the logged-in user to set these fields to the original post author and creation date during migration, instead of defaulting to the logged-in user and the migration date. These fields cannot be updated after migration.