Data Loader is a simple and powerful solution for bulk import or export of data into Salesforce but it is not very effective. While you can use it to quickly and securely import, export, and delete unlimited amounts of data, you cannot map it to the records.

So, to bring a simple solution to the table, we created a custom button on the VisualForce page that allows you to import your CSV file and map it automatically. You can import one thousand records at a time and at every incomplete record it raises a notification to add more details of it. And if the same account or contact is already there in your Salesforce then you don’t have to overwrite to update it, you can simply skip it.

Here’s how you can do it.

STEP 1: Under the “Import Expense Report” page, choose the CSV file.

Import and map your file in Salesforce

STEP 2: Only those Report ID will get imported to the Salesforce that is not already there If I search for the first Report ID i.e – 253154.01 then it should not be existing in Salesforce.

Import and map your file in Salesforce

When Searched in Salesforce

Import and map your file in Salesforce

STEP 3: Now save the file and upload it through the VF Page.

STEP 4: Click on “Read CSV” and the respected records that follow the above-mentioned condition will get uploaded.

STEP 5: If Campaign ID was not available in the file then here you have the option to select the Campaign IDs. Along with these records the records for which you have already added, the “Campaign IDs” will also get inserted in salesforce as a Report.

Also, if we have more than one same “Report ID” then when we select “Campaign ID” for anyone of them then all of them will get updated with the same “Campaign ID”.


And only those records will get inserted in salesforce for which we have given “Campaign ID’s”.

STEP 6: Use the “Save” button on the top and then the uploaded file records will get inserted.

STEP 7: You will receive the message that the records got successfully inserted.

Code1: ImportCsvData

Code2: ImportCsvData)Ctrl

Code3: cavParser

Conclusion:

Some simple things can make your work so effective! And this custom button does just that. It offers you automation, streamlined workflow, and eliminates redundancy. Try it out and share your experience with us. Happy learning! 🙂

Related Articles

In this detailed guide, we will walk you through the significant yet easy steps to configure Email to Salesforce. Without any further ado, let’s get started! About Email to Salesforce As the term refers, Email to Salesforce is valuable for any organization that businesses use as their Customer Relationship Management (CRM) platform. It helps streamline […]

Read More
Guide on CRUD Operations in Node.js with jsForce

CRM developers typically need to integrate Salesforce with Node.js apps. One well-known library for this purpose is jsForce, which provides a comprehensive set of tools for interacting with Salesforce data and performing CRUD tasks effectively. Let’s dive into the blog, where you will understand the use of jsForce to execute key CRUD tasks within Salesforce, […]

Read More
How to Implement Round Robin Assignments in Salesforce Using Apex

Ensuring a proper workload balance and quick follow-ups from internal or external team members, leads, opportunities, or task distributions is crucial. To achieve this, all you need is a Round Robin assignment. In this step-by-step guide, we will walk you through the process of implementing a round-robin assignment in Salesforce using Apex. Here, we’ve used […]

Read More
Best Salesforce Developments Services Provider

In this step-by-step guide, we will walk you through the significant role of Large Data Volumes in Salesforce, and what strategies or practices you should keep in mind. What is Large Data Volumes? In Salesforce, Large Data Volumes (LDV) refers to managing a huge amount of records available in the platform. LDV usually comes into […]

Read More

Salesforce Apex includes numerous built-in text handling classes, and in addition to them, the Pattern and Matcher classes are good for performing complex string operations. These classes enable us to define and work with regular expressions, which are of particular importance for data validation, searching, and modification. In this technical blog, we will find out […]

Read More

Maintaining security and compliance in Salesforce requires effective user access management. This article will lead you through the process of creating expiration dates for Permission Sets and Permission Set Groups, allowing you to automate access removal while minimizing manual work. Know how this functionality simplifies workflows, guarantees compliance, and improves security procedures. Why Use Expiration […]

Read More
Our Location worldwide
Indian Flag India
3rd Floor, A-10, Pegasus Tower, Sector 68, Noida, Uttar Pradesh 201301 +91-1203117884
United States of America Flag USA
333 West Brown Deer Road Unit G – 366 Milwaukee WI, USA 53217 +1(262) 310-7818
United Kingdom Flag UK
7 Bell Yard, London, WC2A 2JR +44 20 3239 9428
Canada Canada
HIC Global Solutions INC
43 Lafferty Lane, Richmond Hill, L4C 3N8, CA +1(262) 310-7818