Skip to main content

Read CSV and Insert CSV Records using visualforce page and apex class

Here is sample code to upload CSV file and insert CSV data in salesforce objects.
Read CSV and insert CSV records in salesforce

In this Code we are inserting data in contact object using standard template. First Column of CSV is Name, second column is LastName and third one is Title.

Visualforce Page
<apex:page controller="ReadandInsertController">
    <apex:form >
        <apex:pagemessages />
        <apex:pageBlock >
            <apex:actionRegion >

                <apex:inputFile value="{!UploadedFileContent}" filename="{!FileName}" /> 
                <apex:commandButton action="{!UploadRecords}" value="Upload File"/>
            </apex:actionRegion>
            
            <apex:pageblocktable value="{!uploadedContact}" id="Contable" var="con">
                <apex:column headerValue="Name">
                    <apex:outputText value="{!con.FirstName }"/>
                </apex:column>
                <apex:column headerValue="LastName">
                    <apex:outputText value="{!con.lastName }"/>
                </apex:column>
                <apex:column headerValue="Title">
                    <apex:outputText value="{!con.Email}"/>
                </apex:column>
            </apex:pageblocktable>
            
        </apex:pageBlock>       
    </apex:form>
</apex:page>

Apex Class
public class ReadandInsertController {
    public string FileName{get;set;}
    public Blob UploadedFileContent{get;set;}
    List<string> fileRows;
    public List<Contact > Contoupload {get;set;}
    
    public Pagereference UploadRecords(){ 
        fileRows = new list<string>();
        FileName=UploadedFileContent.tostring();
        fileRows = FileName.split('\n');
        Contoupload = new List<Contact >();
        for (Integer i=1;i<fileRows .size();i++){
            String[] CSV = new String[]{};
                CSV = fileRows [i].split(',');                    
            Contact con = new Contact ();
            con .FirstName = CSV [0];
            con.LastName=CSV [1];
            con.email=CSV [2];        
            Contoupload.add(con);
        }        
        insert Contoupload;        
        return null;
    }
    public List<Contact > getuploadedContact(){
        if (Contoupload!= NULL){
            if (Contoupload.size() > 0){
                return Contoupload;
            }else{
                return null; 
            }                  
        }else{            
            return null;
        }
    }  
}

Popular Posts

Apex Test Class Examples for @HttpPost Exposed WebService Class

Introduction: In Salesforce, the Apex programming language allows you to create powerful web services that can be exposed to external systems for data integration. One common scenario is using the @HttpPost annotation to create a custom RESTful web service. In this blog post, we'll walk through some examples of how to write effective test classes for an @HttpPost exposed web service class in Salesforce. Writing comprehensive test classes ensures that your code is robust, functional, and ready for deployment.

How to Save Quote PDF, Send PDF, Preview PDF in salesforce with custom functionality

Want to develop custom pdf viewer, save pdf in quote pdf related List and Send quote to customer on button click when quote is custom in salesforce . These functionality are standard from salesforce. but you can develop these functionality custom in salesforce. Here is the solution:- Custom button to save Quote PDF and send PDF  Step 1:-  First Create Two custom button. which will used for PDF preview and Save quote pdf in quotes pdf related list.                               1. PDF preview Button                              2. Save & Send Quote Button Replace "Your VF page here" to Your quote PDF cuatom page. Step 2:-  PDF preview button   pdf preview button will display the pdf's preview in standard format of salesforce. So you need to set the  following configuration (In picture). After that you have ...

Uninstall all Windows 10 default apps using Powershell

Here is script to uninstall all windows 10 default modern apps. This script uninstalls xbox, xbox Game bar, Xbox App,Xbox Gaming Overlay, Get started etc from your computer. No need to run one by one commands Just copy below script, run  powershell as administrator and paste script and press enter . It will automatically uninstall all default programs.  If you do not  want to uninstall some apps than just remove " "  line from script. $packages = @( "7EE7776C.LinkedInforWindows" "C27EB4BA.DropboxOEM" "Microsoft.3DBuilder" "Microsoft.Microsoft3DViewer"

Must-listen songs for developers

Here are some must-listen songs for developers: "Strobe" by deadmau5 . This electronic dance music (EDM) track is perfect for getting into a flow state. The repetitive beat and simple melody are easy to focus on, and the overall mood of the song is upbeat and motivating.  "Viva la Vida" by Coldplay . This rock song has a soaring melody and powerful lyrics that can inspire you to stay focused and productive. The song's message of hope and resilience is perfect for those times when you're feeling stuck or discouraged.  "Code Monkey" by Jonathan Coulton . This tongue-in-cheek song is a hilarious and accurate portrayal of the life of a software developer. The lyrics are catchy and the song's upbeat tempo will make you want to get up and dance.  "The Sound of Silence" by Simon & Garfunkel . This classic folk song is perfect for those times when you need to focus and concentrate. The song's slow tempo and haunting melody will h...

Unveiling the Power of Named Credentials in Salesforce with Comprehensive Code Examples

Introduction: Named Credentials are a powerful feature in Salesforce that allow you to securely authenticate and connect to external services and APIs without exposing sensitive information like usernames and passwords. In this blog post, we'll delve into the world of Named Credentials, understand their significance, and provide you with in-depth code examples to illustrate their implementation in various scenarios.

Unleashing the Power of Flow Orchestrator in Salesforce: Streamlining Business Processes

Introduction: Salesforce Flow Orchestrator is a powerful tool that enables businesses to automate and streamline complex business processes within the Salesforce platform. With its intuitive visual interface, advanced workflow capabilities, and seamless integration with other Salesforce features, Flow Orchestrator revolutionizes how organizations manage and optimize their processes. In this blog post, we will explore the features, benefits, and potential of Flow Orchestrator in driving operational efficiency and productivity. 1. Simplifying Complex Business Processes: Flow Orchestrator empowers business users to design and execute complex workflows without the need for extensive coding or technical expertise. Its visual interface allows users to create dynamic flows, define decision points, and automate repetitive tasks, all while maintaining a clear and intuitive process design. 2. Enhanced Automation with Conditional Logic: Flow Orchestrator offers advanced conditional logic c...

Salesforce Classic to LWC: Your Roadmap to a Modern Org

Are you thinking about finally making the jump from Salesforce Classic to Lightning Web Components ( LWC ) ? Honestly, that’s a smart move. While Classic served us well for years, LWC offers the kind of speed, flexibility, and modern interface that today's users actually expect. But let’s be real for a second—migrating isn't just about flipping a switch. It’s a project that needs a plan.