Loading...
New Winner – Cross-Border Excellence | Payoneer India 2026 Check out
Featured Recognized by Salesforce; Proven by impact! Check out

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.

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.

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”.

records will get inserted in salesforce for which we have given Campaign IDs

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

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.

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! 🙂

No Data Found.

Related Articles
From SMBs to Enterprises: Why Salesforce CRM Remains the Choice for Every Business Size

Running a modern business requires a robust Salesforce CRM platform that connects teams, organizes customer data, and delivers real-time operational insights. In today’s competitive environment, waiting for information across disconnected systems is no longer practical, especially when modern buyers expect immediate responses across every channel. For years, the software was primarily associated with large corporate […]

Read More
How to Integrate NikoHealth to Salesforce

Healthcare organizations using NikoHealth often need patient, insurance, order, invoice, and prescription data available inside Salesforce. As data grows, manually updating records across systems becomes difficult and can lead to delays, duplicate work, and data inconsistencies. NikoHealth to Salesforce integration helps solve this challenge by automatically synchronizing data between both platforms. Instead of building custom […]

Read More
Flow Orchestrator vs. Traditional Flows: When to Use Each for Salesforce Automation

Businesses use Salesforce automation to reduce manual work, improve efficiency, and automate repetitive business processes. Two commonly used automation approaches inside Salesforce are Traditional Flows and Flow Orchestrator. Traditional Flows are mainly used for simple automation tasks such as updating records, sending notifications, creating tasks, and automating business logic. Flow Orchestrator is designed for more […]

Read More
The Rise of Agentic Government: How AI Agents Are Transforming Public Services

Government technology has often been seen as slower to evolve than the private sector. But Salesforce’s latest research challenges that idea in a big way. In fact, the new findings suggest that public sector organizations may now be moving faster than many businesses when it comes to adopting AI agents and preparing for a more […]

Read More
How To Use Email Service in APEX

Managing approvals, updates, and record changes directly from email can significantly improve efficiency within Salesforce workflows. Instead of logging in, navigating records, and manually updating fields, users can simply respond to emails and trigger automated updates using Email Service in APEX. This approach is especially useful for businesses leveraging Salesforce automation and looking to enhance […]

Read More
Design and Implementation of Salesforce-Jira Task Integration

Businesses have been using Salesforce for CRM operations and Jira for Agile project tracking. However, without integration, teams manually update both systems, leading to data inconsistency and inefficiency.This mechanism establishes a real-time integration between Salesforce and Jira, allowing seamless synchronization of tasks and agile board statuses.  A custom Salesforce dashboard was developed that replicates Jira-style […]

Read More
Our Location worldwide
Indian Flag India
7th Floor, A-10, Pegasus Tower, Sector 68, Noida, Uttar Pradesh 201301 +91-1203669505
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
CA Flag Canada
HIC Global Solutions INC
6D - 7398 Yonge St #1124 Thornhill, ON L4J 8J2 Canada +1(262) 310-7818