Data Loader means the process of the bulk import Import or export Export of the data. Use it to insertInsert, updateUpdate, deleteDelete, or export Export PWR Apps records. When importing data, Data Loader reads, extracts, and loads data from comma-separated values (CSV) different types of files or from a database connection
We use a data loader for the import or export of the records in the PWRapps
You can use the execution type as )
There are two types of execution i.e sync or async
Sync: It is used for Use to the import or export of records up to 10000
Async: It is used for the Use to import or export of records greater than 10000
There are two main operations performed in data loader i.e import and export
Import
In import, we you can perform four sub-operations i.e insert, update, upsert, update, delete
Insert:
Insert By using the insert operation you can perform to create add new records in to an object
You have to specify the object name, operation, execution, and format type of the file that you are going to use to insert records
Depending upon the no. of records you can use execution type as sync or async
Update:
By using the update operation you can modify the records of an object
For update records, you have to provide the ID of the record that you want to update
Upsert:
By using the upsert operation you can update as well as insert records at a time
The records with id will get updated and other than these records will be inserted
Delete:
By using the delete operation you can delete records of an object, once you deleted records then you can also undelete records
To delete records you have to provide an ID of the records that you want to delete
Undelete:
By using the undelete operation you can undelete records of an object that you have deleted
To undelete records you have to provide an ID of the records that you want to undelete
Erase:
By using the erase operation you can delete records of an object, but when you have erased records you are not able to undelete
To erase records you have to provide an ID of the records that you want to erase
Export
By using the export operation you can export records of an object
You have to provide the file type in which you want to export data