-
How do you import Converted Lead into Salesforce from Legacy System ?
How do you import Converted Lead into Salesforce from Legacy System ?
-
2 Replies
-
Fields we need for importing converted leads are “ISCONVERTED” , “CONVERTEDCONTACTID” , “CONVERTEDOPPORTUNITYID” and “CONVERTEDACCOUNTID“.
Step 1: As above fields are not editable, we have to contact Salesforce Support to enable Audit fields. Enabling Audit fields means we can edit few Readonly fields like created date and above lead fields.
Step 2: Import Account, Contact and Opportunity from Legacy system to Salesforce.
Step 3: If you imported account, contact and opportunity in Step 2, Salesforce automatically generates Unique ID. We need that unique Id to insert Converted Lead. So Export Account, Contact and Opportunity, which is inserted in Step 2 from legacy System.
Step 4: Create CSV File with All lead information with ISCONVERTED=TRUE and CONVERTEDCONTACTID, CONVERTEDOPPORTUNITYID, CONVERTEDACCOUNTID. CONVERTEDCONTACTID, CONVERTEDOPPORTUNITYID and CONVERTEDACCOUNTID should correspond to Ids generated by Salesforce for Contact, Opportunity and Account which will be related to converted lead.
Step 5: Once CSV is properly created with all required Data, Insert it using DataLoader.
Note: We cannot convert existing lead using this process. Leads must be inserted with these four fields. If you try to update lead it will not give you option to edit above fields.
-
In that case you need to:-
1. Export the data from the first org.
2.Then remove the id , say of lead then upload them to the new org.
3. Now you need to do proper data massaging of objects created as a result of Lead conversion say:-
a. Opportunity
b. Account
c. Contact
d. Task
with the newly generated Lead ids
In case you want to upload new lead data which is already converted into a new org then you need to upload the leads , then with the generated lead ids create the adequately data massaged files for related account, contact and opportunity via excel functions.
Log In to reply.
Popular Salesforce Blogs
Federated Authentication Using SAML to Log in to Salesforce Org
Federated Authentication is one of the SSO(Single Sign On) Methods that uses SAML(Security Assertion Markup Language) assertion sent to the Salesforce endpoint and if everything…
To Lead or not to Lead, that is the question! | Salesforce Guide
Back when things were normal and we were able to go on-site and talk with our clients, there were a significant number of them who…
How Salesforce Lead Management and Opportunity Management Help with Seamless Sales Workflow?
What is the key to long-term success for any organization? The answer is the presence of a strong and proficient sales pipeline. It is for…
Popular Salesforce Videos
What is the Growth and Future of Salesforce Administrators In India
What is the Growth and Future of Salesforce Administrators In India? Listen to #shreysharma guiding and answering all of your queries.
Tips to Crack the Salesforce Administrator Certification Exam in One Go
Do you want to become Salesforce administrator certified? So in this video Shrey has shared the important topics to crack the Salesforce Administrator Exam. Watch…
Prepare for Your Salesforce Pardot Implementation
If you're preparing for your Pardot implementation, you've come to the right place! Pardot implementation is a complex, multi-step process. In this video, we will…
