Skip to main content

Latest Post

How to Set Up Two-Factor Time-Based One-Time Password (TOTP) Authentication on iPhone Without Third-Party Apps

Unlocking an additional layer of safety to your iPhone is less difficult than you might suppose. With Two-Factor Time-Based One-Time Password (TOTP) authentication, you may bolster your device's protection and other website safety without relying on 1/3-party apps. Here's how you could set it up:

Uploading CSV and Creating Records: LWC Code Examples

Introduction:

In this blog post, we will explore how to upload a CSV file and create records using Lightning Web Components (LWC). CSV (Comma-Separated Values) files are a popular format for exchanging data, and integrating the ability to upload and process CSV files can be valuable in various applications. We'll walk through the steps and provide code examples to help you implement this functionality in your LWC component.

Uploading CSV and Creating Records


Prerequisites:


Before we dive into the code examples, make sure you have a basic understanding of Lightning Web Components (LWC) and Salesforce development. Additionally, you should have a Salesforce environment set up and be familiar with the basics of Apex controllers and SOQL queries.


Step 1: Set up the LWC Component


To begin, let's create a Lightning Web Component that will handle the CSV upload and record creation. Here's an example of the component structure:


<template>

    <lightning-card title="Upload CSV and Create Records">

        <div class="slds-p-around_medium">

            <lightning-file-upload

                label="Upload CSV File"

                accept=".csv"

                multiple="false"

                onuploadfinished={handleUploadFinished}

            ></lightning-file-upload>

        </div>

    </lightning-card>

</template>


In this example, we use the lightning-file-upload component to handle the file upload. We specify that it should accept only CSV files and define a handler method, handleUploadFinished, for the onuploadfinished event.


Step 2: Implement the Upload Handler


Next, let's implement the handleUploadFinished method in the JavaScript controller for our component. This method will be responsible for processing the uploaded CSV file and creating records based on its contents. Here's an example of how this can be done:


import { LightningElement } from 'lwc';

import { ShowToastEvent } from 'lightning/platformShowToastEvent';

import processCSV from '@salesforce/apex/CSVProcessor.processCSV';


export default class CSVUploader extends LightningElement {

    handleUploadFinished(event) {

        const uploadedFiles = event.detail.files;

        

        if (uploadedFiles.length > 0) {

            const file = uploadedFiles[0];

            

            // Pass the file to the Apex controller for processing

            processCSV({ fileId: file.documentId })

                .then(result => {

                    // Handle successful record creation

                    this.dispatchEvent(

                        new ShowToastEvent({

                            title: 'Success',

                            message: 'Records created successfully',

                            variant: 'success'

                        })

                    );

                })

                .catch(error => {

                    // Handle error

                    this.dispatchEvent(

                        new ShowToastEvent({

                            title: 'Error',

                            message: 'An error occurred while creating records',

                            variant: 'error'

                        })

                    );

                });

        }

    }

}


In this code snippet, we import the necessary modules, including processCSV from the Apex class responsible for processing the CSV file. We retrieve the uploaded file from the event details and pass its document ID to the Apex method. We handle the promise returned by the Apex method to display success or error messages using the ShowToastEvent.


Step 3: Implement the Apex Controller


Finally, let's implement the Apex controller that will handle the CSV processing and record creation. Here's a simplified example:


public class CSVProcessor {

    @AuraEnabled

    public static void processCSV(Id fileId) {

        ContentVersion contentVersion = [SELECT Id, Title, VersionData FROM ContentVersion WHERE Id = :fileId];

        

        String[] fileLines = contentVersion.VersionData.toString().split('\n');

        

        List<MyObject__c> recordsToCreate = new List<MyObject__c>();

        

        for (Integer i = 1; i < fileLines.size(); i++) {

            String[] fields = fileLines[i].split(',');

            

            // Create a new record using the CSV data

            MyObject__c record = new MyObject__c();

            record.Field1__c = fields[0];

            record.Field2__c = fields[1];

            // Set other fields as needed

            

            recordsToCreate.add(record);

        }

        

        insert recordsToCreate;

    }

}


In this Apex class, we first retrieve the ContentVersion record associated with the uploaded file using its ID. We split the file content into lines and iterate over them, parsing the CSV values and creating new records based on the data. Finally, we insert the created records into Salesforce.


Conclusion:


In this blog post, we've explored how to upload a CSV file and create records using Lightning Web Components (LWC). We walked through the necessary steps and provided code examples for setting up the LWC component, implementing the upload handler, and processing the CSV file in the Apex controller. By leveraging these code examples, you can enhance your Salesforce application with the ability to upload and process CSV files seamlessly.


Remember to adapt the code to your specific requirements and handle error scenarios appropriately. Stay tuned for more Salesforce development tutorials and code examples!


Popular Posts

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"

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

Drag and drop, show and hide columns styling with SLDS Customize list view Visualforce Page and JQuery

Here is sample code for who wants drag and drop, Show and hide functionality in visualforce page using SLDS styling. In this code we are using JQuery, SLDS, Visualforce page. Customize List View  Sample Visualforce Page:-  <apex:page showHeader="false" doctype="html-5.0"  sidebar="false" lightningStylesheets="true">

Apex Code for Uploading Files Using Multipart/Form Data in Salesforce

Introduction: In Salesforce, there are various ways to upload files and attachments. One common requirement is to upload files using the multipart/form data format. This format allows you to send file data along with additional form parameters in a single request. In this blog post, we'll explore how to accomplish this using Apex code in Salesforce. Prerequisites: Before diving into the implementation, make sure you have the following prerequisites in place: Salesforce Developer Edition or Sandbox account. Basic knowledge of Apex programming language. Salesforce org with the necessary permissions to create Apex classes and Visualforce pages.

Insert formatted data (HTML) in Rich Text Area

Here I am going to show you, How  to insert formatted data (table, colorful text etc) in rich text area field salesforce. We can directly use updated rich text area in our email templates without doing any extra code for email template. Here is sample code. //Heading for rich text area content. string body='<h3 style=\"color: #2e6c80;\">your heading :</h3>\n              <ol style=\"list-style: none; font-size: 12px; line-height: 32px; \">\n'; body += '<li style=\"clear: both;\"><b>'+Your Label Name+'  : </b> '+                     yourValue.replaceAll(';',' , ') +'</li>';  body +='</ol>'; yourRichTextAreaField=body; Below code is for table:-

Apex Full Code Examples for HTTPMock in Test Classes

Introduction In the world of Salesforce development, creating robust and efficient test classes is crucial to ensuring the quality and stability of your code. One essential aspect of testing is mocking HTTP requests, which allows you to simulate external API calls without actually making network requests during your tests. In this blog post, we'll dive into using the HTTPMock framework in Salesforce Apex to write comprehensive test classes for HTTP callouts.

Get salesforce SOQL result in JSON format in apex

Sometime we need SOQL query result in JSON format and  JSON.serialize help us to get result in JSON format. Below is syntax. string query='SELECT id, name from account'; string Outputget= JSON.serialize(database.query(query));  system.debug(Outputget); The above syntax gives us following result:- [    {       "attributes":{          "type":"Account",          "url":"/services/data/v48.0/sobjects/Account/ your account ID "       },       "Id":" your account ID ",       "Name":"Test Account Name"    } ]