Category: Bulk data load

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

LastModifiedDate Vs SystemModStamp

In Salesforce, when we create or update a record, there are so many things happen in the background. In this post, I am going to share my knowledge regarding two important fields present in each Salesforce record. I will start with a basic explanation regarding these fields and then at the end, I will explain how these fields are going to impact your query performance.Nice to check out: Salesforce Spring 21 Release FeatureSalesforce Certification NotesSalesforce Release Video TutorialsSalesforce Lightning Flow Video TutorialsLet’s start with basic explanation -LastModifiedDate:This is a standard field present in each Salesforce record. This field will be updated with current timestamp when the record is created or edited by Salesforce user. This field also has a very unique feature i.e. this field can be imported with some previous date. Let’s say you want to load data from your old legacy system, but you want to preserve the dates from your legacy system. In this situation, you can load the records from your legacy system into Salesforce by updating the LastModifiedDate field with the previous date.SystemModStamp:This is a read-only field. This field will be updated with current timestamp when the record is updated by the user. But the important difference is that this field will also be updated when the record is updated by Automated System Process. So in mathematical term -LastModifiedDate <= SystemModStamp    This is possible.LastModifiedDate > SystemModStamp ...

Read More
Loading