Skip to main content
8 个回答
  1. 2016年10月3日 07:38
    Hi Ravali,

    Please find the solution below for your problem.

    I'm using the Dataloader.io when importing: 

    1)Downloaded the Superbadge-Lightning-Import.xlsx(http://sabercathost.com/Bp0/Superbadge-Lightning-Import.xlsx%E2%80%8B) and split it up/converted into Explorers.csv(http://sabercathost.com/BoY/Explorers.csv) , Adventures.csv(http://sabercathost.com/11pT/Adventures.csv) andOpportunitiesWAdventures.csv(http://sabercathost.com/11pR/OpportunitiesWAdventures.csv) 

    2)Insert Explorers from Explorers.csv. 

    • Since Opportunities contains Adventure Package which contains a lookup to Explorer and the Adventure I figured the easiest would be to start inserting the Explorers.csv. Before inserting the Explorer.csv I had to split the Full Name column into First name and Last name to match the Explorer-object's Firstname and Lastname column. 

    3)Insert Adventures from Adventures.csv

    • Before importing Adventure.csv I removed the Explorer column since it was empty and I also cleaned up the data in the Description column cause it contained commas and was interfering.

    4)Insert Price Book Entry from Adventures.csv

    • The Adventures has to be in the Price Book to be able to be added to an Adventure Package. Therefore I added a column in the called PricebookID and added the Pricebook ID of the Standard Price Book to the rows. 
    1. Mapped field:
    • Adventure Name - Adventure (Lookup via Adventure Name)
    • List Price - List Price
    • Active (Adventure) - Active
    • Pricebookid - Price Book ID

    5)Insert Opportunities from OpportunitiesWAdventures.csv. 

    1. Mapped fields:
    • Close Date - CloseDate, 
    • Opportunity Name - Name
    • Probability (%) - Probability
    • Quantity - TotalOpportunityQuantity
    • Stage - StageName

    6)Insert Opportunity Contact Role from OpportunitiesWAdventures.csv

    1. Mapped Fields
    • Opportunity Name to Opportunity ID(Lookup via  Name) 
    • Explorer to Explorer (Lookup via Full Name)

    7)Insert Adventure Package from OpportunitiesWAdventures.csv

    • Added new column for Adventure Name in OpportunitiesWAdventures.csv and added the Adventure name (contained as a part in the Opportunity Name column) to all the rows. 
    1. Mapped Fields: 
    • Opportunity Name - Opportunity ID(Lookup via Name)
    • Adventure Name - Price Book Entry ID (Lookup via Adventure Name)
    • Explorer - Explorer (Lookup via Full Name)

    This has worked perfectly in my org to surpass the challenge,hope you should get away with the challenge by following the above steps.

    Please mark this as best answer if it's resolved.

    Best Regards,

    Nagendra.P