Search This Blog

Thursday, November 11, 2010

How to automate migration of distribution lists to google apps groups

One of the weak areas google apps has is the import of groups (aka distribution lists). There is no easy way to automate creation of groups in google apps.

Here are the steps to automate migration of groups (distribution lists) to google apps groups.

Step 1: Create a csv file of distribution list name and email ids in following format
name it: migrate.csv
distro1:emailid1, emailid2,emailid3
distro2:emailid4, emailid5,emailid6
distro3:emailid1, emailid3,emailid5

Step 2: Generate automation script file
use following awk script to generate automation script
create an awk script file , name it : gen.awk
copy following code into it.

# begining of the file

{ print "URL GOTO=<domain name>/CreateGroup"
  print "TAG POS=1 TYPE=A ATTR=ID:createGroup"
  print "TAG POS=1 TYPE=INPUT:CHECKBOX FORM=NAME:c ATTR=ID:group-preset-team-internet CONTENT=YES"
  print "TAG POS=1 TYPE=INPUT:SUBMIT FORM=ID:create ATTR=ID:createbtn"
  print "TAG POS=1 TYPE=TEXTAREA FORM=ACTION:Group ATTR=ID:add-members-textarea CONTENT="$2
  print "TAG POS=1 TYPE=INPUT:SUBMIT FORM=ID:addmember ATTR=ID:add-members-add-button" }

# end of the file

run following command on a unix prompt
awk -f gen.awk migrate.csv

Step 3: Install iMacros for Firefox

Step 4: Run iMacro
rename an existing macro or create a new one using record and save action in "rec" tab
click Edit macro (right click on macro name) , paste the text generated in step 2, close & save
click on Play (in play tab) to run the automated script to generate groups.

that's it !! you are done.

Sunday, November 7, 2010 Developer Certification (DEV401) Exam

Exam Objectives: Certified Developer–Winter ‘11 Release Exam

· Describe the functionality of the Adobe FlashBuilder for IDE and Flex Framework for
·  Describe the features, use cases, and considerations of Chatter analytics.
·  Describe the capabilities and considerations of the report builder.
·  Describe the use cases for the drill-to-detail dashboard components.
·  Describe the use cases for the selectable running user feature.
·  Describe the capabilities of the Improved System Log console.
·  Describe the capabilities of the new Visualforce Chatter components.

Winter ‘11 Release Notes:

Read Online:  Winter 11 Release notes (scribd)
Download: salesforce_winter11_release_notes.pdf

Practice Exam:

Thursday, November 4, 2010

Making a career in as a consultant has three distinct product areas
  • Sales cloud
  • Service cloud
  • Custom cloud ( platform)

In my opinion Sales and Service cloud areas do not require much development skills, custom cloud does require coding skills in Apex and Visualforce.

Certification path:

The path to certification for a certified consultant is explained here :

for certified consultant (CON201) , you need to pass certified administrator exam (ADM201)

there is a study guide on the website for each of these. you can start reading more about everything online as well as you can request basic book around Sales cloud
by going to this link :

for projects / freelancing:

for applying for job at partners , goto:
and sort by "certification" to sort by size of the organization. Use LinkedIn to see who is working there and apply through them.

Search for blogs and help resource at , also there are some books which can help.

Development with the Platform: Building Business Applications in the Cloud by Jason Ouellette

Hope this helps, feel free add your suggestion and/or questions in the comments area below.