Snippets

CRM Science Inc. Salesforce Data Loader: The History, The Basics, and Power User Tips

Created by Nate Pepper last modified
<?xml version="1.0" encoding="UTF-8"?>
<CustomField xmlns="http://soap.sforce.com/2006/04/metadata">
    <fullName>MyExternalId__c</fullName>
    <externalId>true</externalId>
    <label>MyExternalId</label>
    <length>255</length>
    <required>false</required>
    <trackFeedHistory>false</trackFeedHistory>
    <type>Text</type>
    <unique>false</unique>
</CustomField>
1
2
3
"Name","Phone"
"Salesforce Data Loader","(415)901-7000"
"CRM Science, Inc.","(484)775-0333"
1
2
3
#Account Insert Mapping values
Name=Name
Phone=Phone
1
2
3
4
5
6
7
"FirstName","LastName","AccountId"
"Astro","Sillet Buxton","0014W00002AKpQZQA1"
"Cloudy","Sillet Buxton","0014W00002AKpQZQA1"
"Appy","Sillet Buxton","0014W00002AKpQZQA1"
"Codey","Sillet Buxton","0014W00002AKpQZQA1"
"Nate","Pepper","0014W00002AKpQaQAL"
"Joe","Griffith","0014W00002AKpQaQAL"
1
2
3
4
5
#Contact Insert Mapping values
FirstName=FirstName
LastName=LastName
#Make sure to update Account IDs after account insert!
AccountId=AccountId
1
2
3
4
5
6
7
ID,FIRSTNAME,LASTNAME,PHONE
0014W00002AKpQZQA1,Astro,Sillet Buxton
0014W00002AKpQZQA1,Cloudy,Sillet Buxton
0014W00002AKpQZQA1,Appy,Sillet Buxton
0014W00002AKpQZQA1,Codey,Sillet Buxton
0014W00002AKpQaQAL,Nate,Pepper
0014W00002AKpQaQAL,Joe,Griffith
1
2
3
4
5
#Contact Update Mapping values
Id=Id
#Try not to include anything in the mapping if you're not going to update it
#Preferably omit any columns you're not updating from the source file as well
Phone=Phone
1
2
3
"ID","NAME","PHONE","STATUS"
"0014W00002AKpQZQA1","Salesforce Data Loader","(415)901-7000","Item Created"
"0014W00002AKpQaQAL","CRM Science, Inc.","(484)775-0333","Item Created"
1
2
3
4
5
6
7
"ID","FIRSTNAME","LASTNAME","ACCOUNTID","STATUS"
"0034W00002IrSv0QAF","Astro","Sillet Buxton","0014W00002AKpQZQA1","Item Created"
"0034W00002IrSv1QAF","Cloudy","Sillet Buxton","0014W00002AKpQZQA1","Item Created"
"0034W00002IrSv2QAF","Appy","Sillet Buxton","0014W00002AKpQZQA1","Item Created"
"0034W00002IrSv3QAF","Codey","Sillet Buxton","0014W00002AKpQZQA1","Item Created"
"0034W00002IrSv4QAF","Nate","Pepper","0014W00002AKpQaQAL","Item Created"
"0034W00002IrSv5QAF","Joe","Griffith","0014W00002AKpQaQAL","Item Created"
"FirstName","LastName","MyExternalId__c"
"Nathaniel","Paprika","867-5309"

Comments (0)

HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.