Print this page

Mass delete Chatter posts for inactive users from groups

Knowledge Article Number 000206249
Description This article explains how to mass delete inactive user's Chatter posts from groups via the Data Loader.
Resolution 1) Export Ids for inactive user(s):
a) Login into Data Loader | Click Export
b) Select user from the object list | Browse and save this file | Next
c) Select Id and IsActive fields from the list
d) Click Finish
e) Click Yes to confirm
f) After the operation completes, a confirmation window summarizes your results. Click View Extraction to view the CSV file, or click OK to close

2) Export selecting the GroupFeed object to extract posts to chatter groups:
a) Open Data Loader | Click Export
b) Select GroupFeed from the Object list
c) Click Browse to select the CSV file to which the data will be exported. You can enter a new file name to create a new file or choose an existing file.
d) Click Next
e) Select Id, InsertedById from the list of fields
f) Click Finish
g) Click yes to confirm
h) After the operation completes, a confirmation window summarizes your results. Click View Extraction to view the CSV file, or click OK to close

3) From first file (Inactive user file) filter only inactive user where IsActive is False. Now merge these two files (Inactive user file and GroupFeed file) using vlookup in Excel.

4) To Delete Chatter posts for these inactive users:
a) Open Data Loader | Click on Delete
b) Select GroupFeed Object from the list
c) Browse your updated file (merged file)
d) Click Next. After the object and CSV file are initialized, click OK
e) Map your fields by clicking on create or edit a Map
f) Select Auto-Match fields to Columns
g) Click Ok and then Click Next
h) Click Finish
i) Click yes to confirm
j) After the operation completes, a confirmation window summarizes your results. Click View Extraction to view the CSV file, or click OK to close




promote demote