Import and map your file in Salesforce with a click of a button

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.

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.

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

Share This Blog

Here’s how you can do it.
STEP 1: Under the “Import Expense Report” page, choose the CSV file.
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.
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 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.
Conclusion:

How to Create an Agentforce-Enabled Scratch Org in Salesforce

Setting up an Agentforce-enabled scratch org is the most important step for developers who want to experiment with AI features such as Prompt Builder and Einstein GPT. Whether you’re developing the next generation CRM software or experimenting with how generative AI may improve user experience, a scratch org equipped with Agentforce is your playground. Follow […]

Step-by-Step Guide to Enhance Your LWC Development Workflow with the Logger API

Are you looking to streamline your LWC development workflow but confused about how to do it? Then you are in the right place. The Salesforce Logger API is a powerful tool that helps you monitor, debug, and improve code quality in real time. This step-by-step guide walks you through how to set it up and […]

Enhancing Your Salesforce Experience with a Custom Activity Component

In today’s fast-paced business landscape, productivity hinges on streamlined workflows and intuitive interfaces. While Salesforce offers robust activity tracking capabilities, sometimes the standard components fall short of specific organizational needs. That’s where a Custom Activity Component comes in—designed to tailor your activity management experience, boost user efficiency, and provide deeper insights into customer interactions. In […]

A Step-by-Step Guide to Integrating Salesforce Doc-Gen with eSigning Tools

In today’s fast-paced digital landscape, streamlining document workflows is no longer a luxury—it’s a necessity. Integrating a document generation app, like Docs Made Easy, with an eSigning tool, helps businesses automate the entire document lifecycle—from creation to signature—saving time, reducing errors, and boosting productivity. In this guide, we’ll walk you through the key steps, tools, […]

How to Build a Real-Time Chat Application Using LWC and Models API

The Models API plays a significant role in providing access to and facilitating interaction with large language models (LLMs) from various Salesforce partners such as Anthropic, Google, and OpenAI. It enables applications to leverage these models for various tasks, including text generation and other AI-powered capabilities. As a user, you can configure any Salesforce-enabled model […]

How to Integrate Salesforce Data Cloud with Amazon Redshift Using Salesforce Identity Provider

Companies can finally connect Amazon Redshift to Salesforce Data Cloud without using the ordinary username & password authentication systems ever since its collaboration with AWS has happened. Business owners no longer have to be concerned about managing static credentials or breaching data security. By leveraging Salesforce IDP, companies can easily access their data lakehouse in […]

Import and map your file in Salesforce with a click of a button

Here’s how you can do it.

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

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.

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

Conclusion:

Share This Blog

Table of contents

Related Articles

Our Location worldwide

India

USA

UK

Canada