Mass add member to Chatter group

Salesforce.com give 5,000 chatter free licenses, it is good for organisation to use Chatter for collaboration as it is free. But, adding hundreds or thousands of user as member into many Chatter group is not fun, if do it manually.

If you are Salesforce admin, here tip to make your life easier :)
You can use Data Loader to mass add member to Chatter group.
1. Open Data Loader and select Insert
2. Select "Show all Salesforce objects"
3. Select "Chatter Group Member"

4. Map "CollaborationGroupId" to Chatter Group Id and MemberId to User Id

Done, easy...?

Read more »

Salesforce Data Loader: sandbox and null values

If you are using Salesforce Enterprise Edition or Unlimited Edition, you can use Data Loader to import, update, delete or export data to/from any object in Salesforce.com

In this blog, I'll give tips on:

Login to sandbox instance
By default, after Data Loader installed, it is configure to login to Production instance. You need to change in Data Loader setting to point it to sandbox instance.
Goto Settings and find "Server host (clear to turn off)", type: https://test.salesforce.com

Update fields to null
If you update a field to null / blank, and you notice the data is stay the same (not updated to blank), you need to change in Data Loader setting.
Goto Settings and find "Insert null values" and tick this checkbox.

Read more »