sfdx dataloader plugin

Install

sfdx plugins:install dxloader

sfdx dxload:start [-p <string>] [-u <string>] [-s <string>] [-t <array>] [--json]

USAGE
  $ sfdx dxload:start [-p <string>] [-u <string>] [-s <string>] [-t <array>] [--json] 

OPTIONS
  -p, --configpath                              the path of the configuration yaml file,
                                                default: dxloader-config.yaml
  -t, --taskname=nameofthetask                  Supports comma seperated taskname.
                                                If it is not defined, it runs all tasks specified in the 
                                                yaml config file
                                                
  -u, --targetusername=targetusername           username or alias for the target

  -s, --sourceusername=sourceusername           username or alias for the source org

  --json                                        format output as json

EXAMPLES
  $ sfdx dxload:start --targetusername myTargetOrg@username.com --sourceusername mySourceOrg@username.com
  $ sfdx dxload:start -u myTargetOrg@username.com -s mySourceOrg@username.com -p myloader-config.yaml
  $ sfdx dxload:start -u targetAlias -s sourceAlias -p dataloader/dxloader.yaml -t task1,task2,task3 --json

Configuration Yaml

project: SFDX Data Loader
version: 1.0
tasks:
- name: account_upsert_task                             # taskname can be defined by (-t | --taskname) flags
  object: Account                                       # source and target object must be same
  operation: upsert                                     # operation: insert|update|upsert|delete
  externalId: custom_externalId__c                      # required for upsert operations
  query: Select Id,Name,Type,custom_externalId__c,custom_parent__r.ExternalId__c From Account Where BillingState!=NULL
  map:                                                  #sourceField: targetField (Field mapping)
    custom_externalId__c: custom_externalId__c
    Name: Name
    Type: Type
    custom_parent__r.ExternalId__c: custom_parent__r.ExternalId__c
    
- name: contact_update_task 
  object: Contact
  operation: update
  query: Select Id,FirstName,LastName From Contact Limit 5
  map:
    FirstName: FirstName
    LastName: LastName
    Id: Id