You need to sign in to do that
Don't have an account?
Backing Up Chatter Data for archiving
Hi,
Pls give your thoughts/suggestions to backup chatter data. Following is my current strategy.
Of the various aggregate feed objects like NewsFeed, UserFeed etc UserProfileFeed is the one most useful for Chatter backup. UserProfileFeed gives us the entire information about a users activity related to chatter. This is given by NewsFeed too but NewsFeed additionally gives us information about the users/objects followed by a particular user. If we use NewsFeed for Chatter backup then we will have lots of duplication.
The following query gives us the entire chatter data for a particular user.
Select Id, ParentId, FeedPostId, Type, CreatedById, CreatedDate, IsDeleted,
LastModifiedDate, SystemModstamp, CommentCount, LikeCount, Title, Body,
LinkUrl, ContentData, ContentFileName,ContentDescription, ContentType,
ContentSize, InsertedById , (SELECT Id, FieldName, OldValue, NewValue
FROM FeedTrackedChanges ORDER BY Id DESC), (SELECT Id, CommentBody,
CreatedDate, CreatedBy.FirstName, CreatedBy.LastName FROM FeedComments
ORDER BY CreatedDate), (SELECT CreatedBy.FirstName, CreatedBy.LastName
FROM FeedLikes) FROM UserProfileFeed with userId='<user-id>'
The above query can be optimized by observing that the records for which feedItem.Type='TrackedChange' can be removed if they have no comments made on them i.e FeedItem.commentCount > 0 then and only then include them for backup.
Additionally we will need to back up the EntitySubscription object so as to capture
all the follower-followee combinations.
And finally these collab objects need to be backed up too. CollaborationGroup and CollaborationGroupMember.
However one question I am struggling with is this.
What if the parentId points to an object instead of a user?
Then should the Chatter backup also backup the entire object too.
Hi Jimmy,
My name is Chris and I have a solution in place that I think will accomplish what you need.. We are a new company called eDynamics from the New York area and our product "Archive for Chatter" allows Financial companies using Salesforce.com to easily journal, index, retain and discover Chatter communications so they can be compliant with Financial Industry regulations. We have a few customers in New York city. We are offering a free trial to Financial Services (and other industry vertical) companies. You can learn more about us here:http://www.edynamicsllc.com/
Perhaps this can save you some development effort.
Best,
Chris