+ Start a Discussion
Marshall PriestMarshall Priest 

I am attempting the Reports & Dashboards Specialist Superbadge. I can not get the DataLoader to log into my Trailhead Playground to import the Opportunity Data. Can anyone help?

Victor CazacuVictor Cazacu
This may help:
When you login for the first time you must add the security tocken to the end of your password. For example, if your password is mypassword, and your security token is XXXXXXXXXX, you must enter mypasswordXXXXXXXXXX to log in.
Marshall PriestMarshall Priest
Where do I find the security token? I did not see a token when I attempted to log in. Thanks
Marshall PriestMarshall Priest
So I got it to let me log in. Now when I try to map the fields on the opportunity object there are no choices to map Account Name or Opportunity Name. I can't import the data without these fields mapped. Am I doing something wrong?
Victor CazacuVictor Cazacu
Try mapping their IDs, not Names.
Marshall PriestMarshall Priest
I tried mapping IDs and I get the error message 'Account ID: id value of incorrect type'. I am not sure why Account Name and Opportunity Name are not options to map. They are fields on the Opportunity object. Why are they not showing up?
vasea pepene 6vasea pepene 6
Hey Marshall,
  1. The Opportunity Name is available for mapping, look for this field: [NAME]
  2. The account must be mapped by ID so that the Opportunities get linked to the correct account in case there are dupes. Your error is related to incorrect data type in the accountID field; that field should contain SFDC 15 or 18 digits IDs only.
Marshall PriestMarshall Priest
According to the Project I should not have to create any new fields. The accountID choice gives me the same error message as choosing Account ID. On the downloaded spreadsheet there are no values for Account ID or accountID. I have tried selecting several different mapping options and none have worked. Do I need to create an auto-numbered field to create the Account ID?
Anand RangarejAnand Rangarej
Ok, I was just able to resolve it with some tries. Do this and it will work (image attached, please check)
Map account by AccounID> lookup by (Account Name)
Map Opportunity Name by (Name)

User-added image