Salesforce CLI has command options to export\/import data hierarchically. For example, you can export a few accounts plus their respective opportunities in a tree structure and import them that way without having to manually rewire them with the new IDs in the target org.<\/p>\n\n\n\n
Here are 4 SFDX commands you can run on Terminal\/Command prompt to do just that:<\/p>\n\n\n\n
\nsfdx force:auth:web:login -d -a\u00a0myProductionOrg <\/p>\n\n\n\n
sfdx force:data:tree:export -q “SELECT ID, Name, \\<\/p>\n\n\n\n
( SELECT ID, Name, StageName, AccountID, \\<\/p>\n\n\n\n
CloseDate, Amount FROM Opportunities ) \\<\/p>\n\n\n\n
FROM Account WHERE Name IN ( \\<\/p>\n\n\n\n
‘Nice Account with oppties to test with’, \\<\/p>\n\n\n\n
‘Another good account’ ) ” \\<\/p>\n\n\n\n
-u myProductionOrg –outputdir .\/TestDataFromProd –plan <\/p>\n\n\n\n
sfdx force:auth:web:login -d -a\u00a0mySandbox\u00a0-r https:\/\/test.salesforce.com <\/p>\n\n\n\n
sfdx force:data:tree:import -u\u00a0mySandbox\u00a0 \\<\/p>\n\n\n\n
–plan .\/TestDataFromProd\/Account-Opportunity-plan.json<\/p>\n<\/blockquote>\n\n\n\n
The first command (sfdx force:auth:web:login<\/strong>) opens the browser for you to log into Production and authorize SFDX.<\/p>\n\n\n\n
The second command (sfdx force:data:tree:export<\/strong>) exports the query result into files in the TestDataFromProd folder. It will create these 3 files:<\/p>\n\n\n\n
\nAccount-Opportunity-plan.json <\/p>\n\n\n\n
Accounts.json <\/p>\n\n\n\n
Opportunitys.json<\/p>\n<\/blockquote>\n\n\n\n
SFDX will export up to 2000 records in one file per object plus a plan file to link accounts and opportunities. When importing, there is a limit of 200 records per file so you may have to split files (more on that later).<\/p>\n\n\n\n
The third command (sfdx force:auth:web:login<\/strong>) opens the browser for you to log into the sandbox and authorize SFDX there.<\/p>\n\n\n\n
The last command (sfdx force:data:tree:import<\/strong>) imports the files from the TestDataFromProd folder into the sandbox and wires up accounts with respective opportunities at the same time.<\/p>\n\n\n\n
In case you need to split the JSON file, I’ve adapted the Node script below:<\/p>\n\n\n\n
\nif( process.argv.length < 3 ) {<\/p>\n\n\n\n
\u00a0 \u00a0 console.log( ‘Target JSON file is required.’ );<\/p>\n\n\n\n
\u00a0 \u00a0 process.exit( 1 );<\/p>\n\n\n\n
} <\/p>\n\n\n\n
var target = process.argv[ 2 ]; <\/p>\n\n\n\n
console.log( ‘File: ‘ + target ); <\/p>\n\n\n\n
var fs = require( ‘fs’ ); <\/p>\n\n\n\n
var newFileName = target.replace( “.json”, “” ); <\/p>\n\n\n\n
fs.readFile( target, function ( err, data ) {<\/p>\n\n\n\n
\u00a0 \u00a0 if (err) throw err;<\/p>\n\n\n\n
\u00a0 \u00a0 var jsonArray = JSON.parse( data );<\/p>\n\n\n\n
\u00a0 \u00a0 var i = 1;<\/p>\n\n\n\n
\u00a0 \u00a0 jsonArray = jsonArray.records;<\/p>\n\n\n\n
\u00a0 \u00a0 while( jsonArray.length !== 0 ) {<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 var fileName = newFileName + ‘-‘ + i + “.json”;<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 var newArray = jsonArray.splice( 0, 200 );<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 var newObj = { records: newArray };<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 fs.writeFileSync( fileName, JSON.stringify( newObj ) );<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 console.log( fileName );<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 i++;<\/p>\n\n\n\n
\u00a0 \u00a0 }<\/p>\n\n\n\n
})<\/p>\n\n\n\n
<\/p>\n<\/blockquote>\n\n\n\n
You can run it like below in OS X:<\/p>\n\n\n\n
\nnode .\/split-json.js Opportunitys.json<\/p>\n<\/blockquote>\n\n\n\n
It will split Opportunitys.json into numbered files: Opportunitys-1.json, Opportunitys-2.json, Opportunitys-3.json, … each having up to 200 records.<\/p>\n\n\n\n
Before importing, edit the plan file (Account-Opportunity-plan.json) to add the names of the new split files in place of the original Opportunitys.json file:<\/p>\n\n\n\n
\n{<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 “sobject”: “Opportunity”,<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 “saveRefs”: false,<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 “resolveRefs”: true,<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 “files”: [<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “Opportunitys-1.json”<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 , “Opportunitys-2.json”<\/p>\n\n\n\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 , “Opportunitys-3.json” …<\/p>\n<\/blockquote>\n\n\n\n
The structure of SObject trees accommodates 5 levels deep so we should be able to import accounts with opportunities and line items:<\/p>\n\n\n\n