Wednesday, 1 September 2021

Salesforce DataLoader

SfdcOneStop DataLoader Session 1 -


 

https://www.youtube.com/c/sfdconestop


Use Data Loader when:

  • Data Loader is supported for loads of up to 5 million records.You need to load into an object that is not yet supported by the import wizards.
  • You want to schedule regular data loads, such as nightly imports.
  • You want to export your data for backup purposes.

Tools Available within Salesforce App-

1) Data loader desktop app

2) Dataloader.io - Dataloader.io is free you can import, export or delete up to 10,000 records per month.

This limit resets itself on the first day of the month. If you need higher limits please check our professional and enterprise subscriptions. 


Use the import wizards when:

  • You are loading less than 50,000 records.
  • The object you need to import is supported by import wizards. To see what import wizards are available and thus what objects they support, from Setup, enter Data Management in the Quick Find box, then select Data Management.
  • You want to prevent duplicates by uploading records according to account name and site, contact email address, or lead email address.
  •  Assets, cases, campaigns, contracts, documents, opportunities, and products can’t be imported via import wizards.

Bulk API does not support queries with any of the following:

  • GROUP BY, OFFSET, or TYPEOF clauses
  • Aggregate functions such as COUNT()
  • Date functions in GROUP BY clauses (date functions in WHERE clauses are supported)
  • Compound address fields or compound geolocations fields

 

No comments:

Post a Comment