You need to sign in to do that
Don't have an account?
bhanu_prakash
lightning csv uploader to create accounts
Hi Team,
trying to deisgn CSV uploder in lightning component and need to display in table after uploading CSV file and on click on save button need to save account reords in data base.
Using these contoroller to create account.. help me to design lightning component
trying to deisgn CSV uploder in lightning component and need to display in table after uploading CSV file and on click on save button need to save account reords in data base.
public class PMO_CsvUploaderController { public Blob csvFileBody{get;set;} public string csvAsString{get;set;} public String[] csvFileLines{get;set;} public List<Account> Acclist{get;set;} public PMO_CsvUploaderController(){ csvFileLines = new String[]{}; Acclist = New List<Account>(); } public void importCSVFile(){ try{ csvAsString = csvFileBody.toString(); csvFileLines = csvAsString.split('\n'); for(Integer i=1;i<csvFileLines.size();i++){ Account couObj = new Account(); string[] csvRecordData = csvFileLines[i].split(','); couObj.name = csvRecordData[1] ; couObj.AccountNumber = csvRecordData[2]; couObj.Phone = csvRecordData[3]; couObj.Rating = csvRecordData[4]; /* String temp_fees=csvRecordData[3]; couObj.Course_fees__c = Decimal.valueOf(temp_fees); String temp_date=csvRecordData[4]; couObj.Course_Date__c = Date.parse(temp_date); */ Acclist.add(couObj); } insert Acclist; } catch (Exception e){ System.debug(e.getCause()); ApexPages.Message errorMessage = new ApexPages.Message(ApexPages.severity.ERROR,'An error has occured while importing data. Please make sure input csv file is correct'); ApexPages.addMessage(errorMessage); } } }
Using these contoroller to create account.. help me to design lightning component
Please try with below code,
Csv_Uploader.cmp Csv_UploaderController.js Csv_UploaderHelper.js
Controller.apex
I hope it will helps you.
Regards,
Vijay
All Answers
Please try with below code,
Csv_Uploader.cmp Csv_UploaderController.js Csv_UploaderHelper.js
Controller.apex
I hope it will helps you.
Regards,
Vijay
everything is perfect as i exepeted on functionality but unable to save records into database. Iam unable to add CSV here but. i can find record in debug logs but records are not saving into database.