exiahuang/dataloader
Features
exiahuang/dataloader Features
- Need ant and java
- Support Windows/WSL/Linux/Mac.
- Dataloader version: 40.0.0~47.0.0
- Support Export/ExportAll/Insert/Update/Upsert/Delete
- Not need to install dataloader, auto download.
- Integrated with exiahuang/xysfdx for
vscode
cli usage
- clone repository
- config
config.properties
- run
- clone
1
2
| git clone https://github.com/exiahuang/dataloader.git
|
- config
config.properties
for 43.0.0~47.0.0
1
2
| ant encrypt -Dpassword=your_password -Dapiversion=47.0.0
|
for 40.0.0~42.0.0
1
2
| ant encrypt_before_v42 -Dpassword=your_password -Dapiversion=42.0.0
|
Copy the generated encrypted password and set sfdc.password in config.properties.
- start to export
1
2
3
4
5
| # usage
ant start_export -Dsobject_name=Sobject_name -Dsoql="Soql"
#example
ant start_export -Dsobject_name=User -Dsoql="select id,name from user limit 100"
|
export
1
2
| #example
ant start_export -Dsobject_name=User -Dsoql="select id,name from user limit 100" -Dapiversion=47.0.0
|
exportAll
1
| ant export_all -Dsobject_name=User -Dsoql="select id,name from user limit 100" -Dapiversion=47.0.0
|
insert
1
| ant insert -Dsobject_name=you_test_object__c -Dsdl="./insert/insert.sdl" -Dcsv="./insert/insert.csv" -Dapiversion=47.0.0
|
TIPS: How to create sdl file ? I always use SalesforceXyTools For Chrome to create it.
update
1
| ant update -Dsobject_name=you_test_object__c -Dsdl="./update/update.sdl" -Dcsv="./update/update.csv" -Dapiversion=47.0.0
|
upsert
1
2
| ant upsert -Dsobject_name=you_test_object__c -Dsdl="./upsert/upsert.sdl" -Dcsv="./upsert/upsert.csv" -Dextid="Id or yourExtId" -Dapiversion=47.0.0
|
delete
1
| ant delete -Dsobject_name=you_test_object__c -Dsdl="./delete/delete.sdl" -Dcsv="./delete/delete.csv" -Dapiversion=47.0.0
|
hard delete
TODO: hard delete not work
1
| ant hard_delete -Dsobject_name=you_test_object__c -Dsdl="./delete/delete.sdl" -Dcsv="./delete/delete.csv" -Dapiversion=47.0.0
|
About Linux Environment or WSL
You can find Mac
or Windows
Installing Guide, But no linux.
This is the environment for Ubuntu 18.04.2 LTS
/ WSL
.
install Zulu java
Azul Zulu Linux Repo!
1
2
3
4
| apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 0xB1998361219BD9C9
sudo apt-add-repository 'deb http://repos.azulsystems.com/ubuntu stable main'
sudo apt install -y zulu-11
|
Zulu
java version:
1
2
3
4
5
| $ java -version
openjdk version "11.0.6" 2020-01-14 LTS
OpenJDK Runtime Environment Zulu11.37+17-CA (build 11.0.6+10-LTS)
OpenJDK 64-Bit Server VM Zulu11.37+17-CA (build 11.0.6+10-LTS, mixed mode)
|
you can use openjdk-11-jdk
1
2
3
4
5
| $ java -version
openjdk version "11.0.5" 2019-10-15
OpenJDK Runtime Environment (build 11.0.5+10-post-Ubuntu-0ubuntu1.118.04)
OpenJDK 64-Bit Server VM (build 11.0.5+10-post-Ubuntu-0ubuntu1.118.04, mixed mode, sharing)
|
check/change java version
check all java version in your os.
1
| update-java-alternatives -l
|
change java version
1
| sudo update-alternatives --config java
|
install ant
1
| sudo apt -y install ant
|