Skip to main content

How to Guide - Salesforce Data Import: Step 1- Merge & Clean Up

Cleaning Up - Organizing

 Importing Data to Salesforce using a Spreadsheet or .CSV Files

Trailhead Baby is asked a question about data import almost every week.  Many Superbadges require some sort of data import with varying levels of object connectivity.  The most difficult require 10+ steps with data loader in order to patch all of the Salesforce record ID's.  Simple uploads may be performed solely with the data import wizard.  Let's take a look at the steps that should be completed for every manual import to Salesforce as illustrated by one of my favorite toys.  Note- There are many excellent tools available to assist with this process, but we are only going to discuss the ones native to Salesforce: the data import wizard and data loader.

The scenario:
We need to upload legacy data to a Salesforce instance.  The records are located in several spreadsheets with 8 standard objects.  Simple?  Let's make it a bit more challenging.  We are migrating data to Salesforce from not one, but two systems.  The second group of spreadsheets contains 4 objects.                                                                                                                     




Group 2



Pre-Work:
If you have not completed the Trailhead Module: Data Management- Import Data, stop!  Earn your Data Management badge before moving forward.


Data Import Steps:
1) Merge & Clean up the Data

   -  Merge the duplicate objects into one spreadsheet and remove any                 duplicate records.  Superbadge challenges contain a limited number of
       records, so copy / paste and sort by name to locate duplicates. 
   -   Match the column headers in the spreadsheet with field names in
       Salesforce.

Matching the column headers with the field names in Salesforce will minimize the possibility of an incorrect import.  For example: Importing a full name into a "first name" field.




Help! I'm stuck! How do I clean up my data?

 Watch
Thank you to Salesforce for this fantastic video!  It is a longer than the video in the Trailhead: Import Data module but provides multiple Excel tips to help clean up import files.

 

Read
Prepare Your Data for Import from help.Salesforce.com.


Once the data import files are clean, it's time to think about the order in which data must be imported.  The order is important, as we do not want to create orphaned records.  For example- contacts or opportunities that are not associated with accounts!

2) Determine the Insert Order
Continue to the next post....




Comments

Post a Comment

Popular posts from this blog

Process Automation Specialist Superbadge - 5

A project with Daddy: My favorite daily process! Making dinner for Mom! Tonight's challenge involves the creation of two processes.   Processes.  Have you guessed the theme of the photos that go along with the Trailhead - Process Automation Specialist Superbadge series?They are a few of my favorite day to day processes!  You, my amazing reader, get more than tips for a Salesforce Superbadge.  You also get personal insight into the life of a Trailhead Baby!  I hope that you feel inspired. Process Builder sketch Last night, I drew a rough sketch of my process: Was it pretty?  No. Did it help?  Yes! The sketch allowed me to organize all of the instructions into a reasonable order before I started clicking.  It also removed the approval steps from Process Builder and highlighted (with *'s) the prerequisite items to building my process. * Email Alerts I needed the Email Alerts set up before I could create either the process or ...
336 comments
Read more

Einstein Analytics Data Preparation Specialist Superbadge - 1,2,3

Hello all! It's time for another superbadge! I started this superbadge a long time ago... it's time to finish it!  My goal is to complete this badge before my little brother starts to walk.  He's getting close... Step 1 - A quiz.  You're on your own! Step 2- This is one checkbox in setup.  You're on your own! Step 3- Let's talk about that.... Dataflow. The best tool to use when crafting your dataflow is the data monitor.  It can help troubleshoot issues to find which part of the process needs some work. For example.... Why were rows not created? The problem? A box was checked that should not be checked.... The alias name was not correct for the "register" node. Once you see that beautiful green "Success" message, it's time to check the challenge.  Do not be discouraged if you get a few error messages.  This superbadge is EXTREMELY picky on syntax.  A few common errors: You can see this error and st...
192 comments
Read more

Service Cloud Specialist Superbadge - 4,5,6,7

Part of doing the Service Cloud Specialist superbadge is trying new things, so I am putting up picture of new things that I've tried recently.  One of my favorite new things this week was taking a shower with my whole block collection.  Mom put me in the shower, and I sneaked out to grab the block bin and dumped it in.  I'm concerned to share photos because of the slight nudity, however, I can assure you that it was a glorious adventure.  Instead, I'll share my favorite Saturday new thing- walking to the coffee shop for a sprinkle donut!  Back to the superbadge... Challenge 4 Case Routing If you haven't taken the Onmi Channel module yet, now is a good time! I kept that particular module open one on screen while I walked through this step.  It is hard to give many hints about this step without giving away too many details - so - the best advice is to read through the challenge and label each step with the corresponding Salesforce term.  (IE - "The...
206 comments
Read more