Entering Old Data Into A Deployed Object

When we rolled out the employee awards program I mentioned in my previous post, we weren’t sure the business would want the old data (400 awards worth) captured in Salesforce.  After the app had been live for a few weeks, it became clear that back data would need to be in Salesforce for reporting purposes.  Great!

PROBLEM: How do I give access to the data entry folks without compromising the automation that’s happening in the background of the app?  For example, when you create a nomination there is logic in the background that determines the approver and starts the process along its merry way.  This is great in production because it keeps the user from having to determine who gets the approval next.  Trouble is, these paper awards have already been approved!

SOLUTION: Why not use a sandbox?  Once the data is all entered I’ll, run a report, export the report and, using the DataLoader, put that data in production. So, I created a sandbox, disabled all the logic and streamlined the page layout for easier data entry (including removing all related lists.)

The data is about 10% entered at this point, with completion slated for sometime next week.

Advertisements

One Response to Entering Old Data Into A Deployed Object

  1. Bryan says:

    Great idea! I’m going to try it tomorrow!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: