Category: data loader

Dataloader for Salesforce

 While working in Salesforce, we need to deal with data almost every day. Loading or extracting data is an important pre-requisite for almost all production deployment/Go-Live activity. Do you know the there are many different data loaders available today? This post will cover some of the most popular data loaders with their advantages and disadvantages.Data Import WizardThis is built by Salesforce and available in all editions. It has a very easy step by step user interface which makes it very popular among the Salesforce developer/admins. You can load many standard objects including Accounts & Contacts, Leads, Campaign Members, Person accounts. You can load custom objects too with this one.Advantages: User friendly.Disadvantages: Can load a maximum of 50,000 records at a time. In a real-world scenario, this can be a problem as the number of records can be in the range of millions.Salesforce Data LoaderAnother data loader solution created by Salesforce. This application you need to install in your machine. As a pre-requisite, you need Java installed in your machine. It comes with some advantages settings which makes this app a perfect solution for handling pretty much any scenarios.Advantages:You can load 5,000,000 records. Much higher compared to Data Import Wizard.Quicker, powerful application.Disadvantages:Need to install in your machine. It is not a cloud application.Dataloader.ioIt is a 100% cloud-based data loader application that you can access through your browser. It was developed by Mulesoft, ...

Read More

Admin Notes — Importing + Extracting Data in Salesforce | Possible Options

Importing Data:                Salesforce provides wizards to import data for accounts and contacts, leads, solutions and custom objects.·         Import Wizards are online·         Administrator can import data for the entire organization.·         Users with “Import Personal Contacts” permission can import their own accounts and contacts from Your Name | My Settings | Import | Import My Accounts & Contacts·         Users with “Import Leads” or “Import Solutions” permissions can access respective wizards from Setup | Data Management | Import <Object Name>·         With Import Wizard max 50,000 data can be imported.·         Data format should be CSV.·         With Import Wizard, user can choose whether to add new records/update existing records/Add new and Update existing records.·         Unified interface of Import Wizard (Data Import Wizard) can be accessed from Your Name | My Settings | Import | Data Import Wizard.·         With Data Import Wizard, user is having the option to enable/disable workflow.Consideration before preparing the Import File:                As an administrator, you need to ensure the data is clean by -·         Checking data meet system and custom validation requirements. (Note: If a particular record fails data validation rule, import will fail for that particular record. Rest of the records will be imported).·         Universally required fields should be there in the CSV file for the new records. Otherwise import will fail for that particular record. Rest of the records will be imported. Owner field should be there in the...

Read More
Loading