Created by
Former user
last modified
Nate Pepper
2021-07-27
<?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>
"Name","Phone"
"Salesforce Data Loader","(415)901-7000"
"CRM Science, Inc.","(484)775-0333"
#Account Insert Mapping values
Name=Name
Phone=Phone
"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"
#Contact Insert Mapping values
FirstName=FirstName
LastName=LastName
#Make sure to update Account IDs after account insert!
AccountId=AccountId
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
#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
"ID","NAME","PHONE","STATUS"
"0014W00002AKpQZQA1","Salesforce Data Loader","(415)901-7000","Item Created"
"0014W00002AKpQaQAL","CRM Science, Inc.","(484)775-0333","Item Created"
"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"
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 49 51 53 55 57 59 61 63 65 67 69 71 73 75 77 79 81 83 85 87 89 91 93 95 97 99 101 103 105 107 109 111 113 115 117 119 121 123 125 127 129 131 133 135 137 139 141 143 145 147 149 151 153 155 157 159 161 163 165 167 169 171 173 175 177 179 181 183 185 187 189 191 193 195 197 199 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 49 51 53 55 57 59 61 63 65 67 69 71 73 75 77 79 81 83 85 87 89 91 93 95 97 99 101 103 105 107 109 111 113 115 117 119 121 123 125 127 129 131 133 135 137 139 141 143 145 147 149 151 153 155 157 159 161 163 165 167 169 171 173 175 177 179 181 183 185 187 189 191 193 195 197 199 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 49 51 53 55 57 59 61 63 65 67 69 71 73 75 77 79 81 83 85 87 89 91 93 95 97 99 101 103 105 107 109 111 113 115 117 119 121 123 125 127 129 131 133 135 137 139 141 143 145 147 149 151 153 155 157 159 161 163 165 167 169 171 173 175 177 179 181 183 185 187 189 191 193 195 197 199