+ Start a Discussion
Swati Senapati 1Swati Senapati 1 

Reports & Dashboards Specialist" - Data Import

Hi,
i am stuck in this below error can anyone suggest?I already imported contact and account successfully through import wizard.stuck for hobby,contact hobby and opportunity.When i am trying to import hobby data with the(list of contacts to import) CSV file.in mapping section it shows only hobby field.

can anyone guide me on this?

User-added image
LBKLBK
Easy way is to build the data with corresponding IDs in Excel and then importing the CSV using Workbench.

1. Import Accounts - You have completed it

2. Import contacts - Completed

3. Import Hobbies - This should be straight forward (INSERT option in Workbench).

4. Import Opportunities
   4.1 Export Accounts (ID, Name) into a CSV file
   4.2 Do a VLOOKUP using Account Name and Populate Account ID in the Opportunities tab (in the Excel file)
   4.3 Copy Opportunities Tab data into a CSV file
   4.4 Import Opportunities using INSERT option in Workbench

5. Import Contact Hobbies
   5.1 Export Contacts (ID, Name) into a CSV file
   5.2 Do a VLOOKUP using Contact Name and Populate Contact ID in the Contact Hobbies tab (in the Excel file)
   5.3 Export Hobbies (ID, Name) into a CSV file
   5.4 Do a VLOOKUP using Hobby Name and Populate Hobby ID in the Contact Hobbies tab (in the Excel file)
   4.3 Copy Contact hobby Tab data into a CSV file
   4.4 Import Contact Hobbies using INSERT option in Workbench

Hope this helps.
Swati Senapati 1Swati Senapati 1
Hi,
i already prepared one Csv file for Contact Hobby.

But when trying to map..
User-added image
User-added image
ContactHobbyID needs to be mapped to??? only to option when u click
Unmapped-Contact
                   Hobby
getting following errors.

User-added image

User-added image
 
LBKLBK
I am seeing ContactHobbyID field has two IDs merged together in one field in the CSV file. That doesn't help.

When you start with Step 5, you have two fields in your ContactHobby tab.
Contact Name and Hobby Name

You have to VLOOKUP with Contact.csv based on Contact Name to bring in Contact ID field.

And then, You have to VLOOKUP with Hobby.csv based on Hobby Name to bring in Hobby ID field.

You will not have Contact Hobby tab with four fields.
Contact Name, Hobby Name, Conatct ID and Hobby ID

something like this.
User-added image

when you import Contact Hobbies, Map the Contact field to "Contact ID" in your CSV and Hobby field to "Hobby ID" in the CSV.

You cannot use Name (Contact Name and Hobby Name) fields for importing data. Only IDs will work.

Hope this helps.
Swati Senapati 1Swati Senapati 1
Is this CSV right??

User-added image
LBKLBK
This is perfect.

When you import the data, map only the ID columns, not the name columns.
 
Swati Senapati 1Swati Senapati 1
Getting This error..with the same CSV file

User-added image
LBKLBK
Can you use INSERT option in Work Bench?

You just need to map Contact__c and hobby__c fields in ContactHobby__c object.

I just tried to insert one record and it worked.
Swati Senapati 1Swati Senapati 1
there is no insert option


User-added image
LBKLBK
Not Translation Workbench.

It is Developer Workbench.

Here is the URL.
http://workbench.developerforce.com/

Refer the below URL for more information on Workbench.
https://developer.salesforce.com/page/Workbench
 
David FlookDavid Flook
FYI for anyone that stumbles upon this... LBKs method worked for me.
Zhenyu ZhenZhenyu Zhen
Hi, how do you insert hobby into workbench? Can you provide a screenshot, please?