You need to sign in to do that
Don't have an account?
GYAN ANDRUS
Hi,Can anyone help me for this Apex class,I am reading CSV file using Apex class,the Value is not updating in object
The Transaction_Amount__c is not updating in the Investor_Banking_Info_Entries__c object,iam retrieving the value in Amount variable,Can anyone please tell how to assign this varible to Transaction_Amount__c field
public class importDataFromCSVController {
public Blob csvFileBody{get;set;}
public string csvAsString{get;set;}
public String[] csvFileLines{get;set;}
public string Amount;
public List<Investor_Banking_Info_Entries__c> acclist{get;set;}
public importDataFromCSVController(){
csvFileLines = new String[]{};
acclist = New List<Investor_Banking_Info_Entries__c>();
}
public void importCSVFile(){
try{
csvAsString = csvFileBody.toString();
csvFileLines = csvAsString.split('\n');
for(Integer i=1;i<csvFileLines.size();i++){
Investor_Banking_Info_Entries__c accObj = new Investor_Banking_Info_Entries__c() ;
string[] csvRecordData = csvFileLines[i].split(',');
accObj.Investor_Name__c = csvRecordData[0] ;
accObj.Account_Number__c = csvRecordData[1];
Amount = csvRecordData[2];
System.debug('The value isSSSSSSSSSSSSSSSSSSSSSSSSSS: ' +Amount );
Amount = string.valueof(accObj.Transaction_Amount__c);
System.debug('The value is: ' +Amount );
acclist.add(accObj);
}
insert acclist;
}
catch (Exception e)
{
ApexPages.Message errorMessage = new ApexPages.Message(ApexPages.severity.ERROR,'An error has occured while importin data Please make sure input csv file is correct');
ApexPages.addMessage(errorMessage);
}
}
}
public class importDataFromCSVController {
public Blob csvFileBody{get;set;}
public string csvAsString{get;set;}
public String[] csvFileLines{get;set;}
public string Amount;
public List<Investor_Banking_Info_Entries__c> acclist{get;set;}
public importDataFromCSVController(){
csvFileLines = new String[]{};
acclist = New List<Investor_Banking_Info_Entries__c>();
}
public void importCSVFile(){
try{
csvAsString = csvFileBody.toString();
csvFileLines = csvAsString.split('\n');
for(Integer i=1;i<csvFileLines.size();i++){
Investor_Banking_Info_Entries__c accObj = new Investor_Banking_Info_Entries__c() ;
string[] csvRecordData = csvFileLines[i].split(',');
accObj.Investor_Name__c = csvRecordData[0] ;
accObj.Account_Number__c = csvRecordData[1];
Amount = csvRecordData[2];
System.debug('The value isSSSSSSSSSSSSSSSSSSSSSSSSSS: ' +Amount );
Amount = string.valueof(accObj.Transaction_Amount__c);
System.debug('The value is: ' +Amount );
acclist.add(accObj);
}
insert acclist;
}
catch (Exception e)
{
ApexPages.Message errorMessage = new ApexPages.Message(ApexPages.severity.ERROR,'An error has occured while importin data Please make sure input csv file is correct');
ApexPages.addMessage(errorMessage);
}
}
}
Please use this method to extract the CSV content in List<List<String>>
You can extract the information using :
Hope it helps !!
Regards,
Amritesh
This is totally new for me,Can you please explain this more or update in my code please