Thursday, January 12, 2012

Salesforce 2 Salesforce "Data Dumper" & Obfuscator

We wrapped up or Salesforce 2 Salesforce "Data Dumper" challenge with 6 really cool submissions. It's too bad that we only had first and second place prizes as the submissions were really good! If came down to specific functionality for the tasks. We really liked elukaweski's submission as it was well documented but some of the other entries had more bells and whistles.

One of our frequent tasks at CloudSpokes is to spin up Force.com Developer orgs for challenge participants to use during a specific challenge. We typically use ANT to install code and configurations but importing data is always a chore. We wanted to build a tool that runs on a local machine or in the cloud that takes data from a source salesforce.com org and dumps it into target salesforce org.

The salesforce Data Loader performs these tasks but we wanted a few little tweaks. The tool allows you to specify multiple objects, the fields to query for each object and the credentials for both the source and target orgs. We also wanted to have the ability to obfuscate specific field data. For instance, when dumping data from production to a developer org, we typically change email addresses to something like “noemail@cloudspokes.com”.

sgurumurthy
Place: 1
Money: $2500
forcebewithyou
Place: 2
Money: $1000
elukaweski
Place: 3
Score: 85
hirday
Place: 4
Score: 75

Sgurumurthy's Video Submission - view full screen

Unable to display content. Adobe Flash is required.

Hirday's Video Submission - view full screen

Unable to display content. Adobe Flash is required.

No comments:

Post a Comment