Skip to main content

How to Guide - Salesforce Data Import: Step 2- Determine Insert Order

Determine Import Order
Importing Data to Salesforce using a Spreadsheet or .CSV Files

                                         
On the last post, we cleaned up data import files:
  1.  Removed duplicate records
  2. Merged multiple spreadsheets for the same object into one master spreadsheet per object.

    The data is nicely sorted, but we need to determine which order to use when uploading to Salesforce.  This is the most tricky step in a data upload operation. Why?
                           Order Matters!                
Data Import Steps:
2) Determine the Insert Order

The order for this data import:
  • 1st Group - Lead (Blue dot on diagram.)
Why? Leads are not connected to any of the other objects selected for import.  Plus, we can use the data upload wizard, which is simple and quick!
  • 2nd Group - (Purple dots)
    1) Account
    2) Contact
    3) Opportunity
    4) Opportunity Contact Role
    5) Quote
Why? Accounts must be uploaded before we can associate contacts with accounts.  The contacts and accounts are needed for opportunities.  Opportunity contact roles require the opportunity and contact. Finally, quotes are connected to opportunities and contacts.
  • 3rd Group - (Green dots)
    1) Asset
    2) Case
Why? Assets are related to accounts.  Cases are related to assets, contacts, and accounts.
Wow Trailhead Baby, that's great, but how do I determine the order?
Analytical?  Salesforce lists the entry relationship diagrams for standard objects, like the one shown above.  Objects are linked with the lines with related object ID's listed within each box.  If you are importing custom objects, understanding the relationships between the objects is key and can be very complicated.  Unless you are a wiz at graph theory, I recommend a third party tool like CopyStorm/Restore.

Salesforce Administrator?  You probably love to click, so a simple alternative is to open Salesforce and start clicking.  In a Trailhead Playground, I selected one of the pre-loaded accounts and made notes:

Contacts, Opportunities, and Cases all tie to Accounts.  Since you need an account to have a contact, it's logical to assume that accounts need to be entered first, then contacts.  This approach is great for simple data imports with relatively few dependencies - like today's example! 

Start with the feet.  Once you have feet, you can attach a torso, then a hand.  The order is important!
Think of the data import as building relationships between the objects, starting at the bottom with the "base" object and working your way up the body.  Accounts = feet.  Contacts = torso.  Opportunities = hands. 

Time for a final analogy?  Think of a tree.  The leaves depend on the branches which depend on the trunk which depends on the roots.  Complicated? No.  Difficult to determine the precise dependencies?  Sometimes yes.











Comments

Post a Comment

Popular posts from this blog

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 channel, Sto
177 comments
Read more

Service Cloud Specialist Superbadge - 1,2,3

A confession - I know next to nothing about service cloud.  While I was excited that a new superbadge was available, it made me a little nervous that I had to do all of the prerequisites and tackle new things like macros.  New things - new year - let's get started! (Right after I finish guitar practice) If you are also a service cloud novice, the Omni-Channel Basics is a crucial prerequisite even though it is not officially required. Challenge 1 App Appearance  This, like all superbadges, requires a careful read through the instructions prior to any clicking.  I found it helpful to take a separate notebook and write down the steps that I would need for each challenge step - for example -  My rough notes for challenge 1: Create 2 profiles  Tweak service Console 3 new items on utility bar Allow access for new profiles Create User  Beware - After editing the service console, you might have to edit the new profiles.  I found it necessary to click "edit&quo
130 comments
Read more

Business Administration Specialist Superbadge- 3 & 4

This afternoon, I added a genius wig in an attempt to look a little older and more experienced.  The free lemonade offer worked!  I made two dollars today!  A huge thank you to Jocelyn Fennewald , Salesforce MVP, for pointing out the "remove all columns" option within the report creator.  When you start a create a new report, simply click to start with a clean screen.  If you are familiar with report and dashboards, this challenge should only take 30 or so minutes to complete.  Below are tips and gotchas for each report / dashboard.  If you need more help, leave a comment! Reports Accounts by Market To create the "Market" row grouping, use a bucket field. Make sure that the correct date range is selected. High Value Residential  This report includes: 1 filter, 1 grouping, and 1 summarized field.  Rated Accounts by State The record count for state and account rating are automatically added. Note the filter.  Open Support Cases You ma
122 comments
Read more