Hi,

I have created a custom controller and an VF page to import records for my Custom Object Username.

But the issue is I'm not able to import all records from the template.

Only the first record is getting imported.

VF page:

public class UsernameFileUploader 
{
    
public string nameFile{get;set;}
    public Blob contentFile{get;set;}
    String[] filelines = new String[]{};
    List<Username__c> urnmtoupload;
    
    public Pagereference ReadFile()
    {
        nameFile=contentFile.toString();
        filelines = nameFile.split('\n');
        urnmtoupload = new List<Username__c>();
        for (Integer i=1;i<filelines.size();i++)
        {
            String[] inputvalues = new String[]{};
                inputvalues = filelines[i].split(',');  
                Username__c a = new Username__c();
                a.Username__c = inputvalues[0];
                a.Contact_Name__c = inputvalues[1];       
                a.Phone__c = i=integer.valueof(inputvalues[2]);
                a.Email_Address__c = inputvalues[3];
                a.Billing_Account__c = inputvalues[4];
                a.View__c = inputvalues[5];
                a.Bill_Code__c = inputvalues[6];
                if (inputvalues[7] == 'True')
                {a.Lookup__c = True;}
                else
                {a.Lookup__c = False;}
                
                if (inputvalues[8] == 'True')
                {a.Summary__c = True;}
                else
                {a.Summary__c = False;}
                
                if (inputvalues[9] == 'True')
                {a.View_Score__c = True;}
                else
                {a.View_Score__c = False;}
                
                if (inputvalues[10] == 'True')
                {a.Report__c = True;}
                else
                {a.Report__c = False;}
                
                if (inputvalues[11] == 'True')
                {a.Draft__c = True;}
                else
                {a.Draft__c = False;}
                
                if (inputvalues[12] == 'True')
                {a.Order__c = True;}
                else
                {a.Order__c = False;}

                if (inputvalues[13] == 'True')
                {a.Pass_Fail__c = True;}
                else
                {a.Pass_Fail__c = False;}
                
                
                a.Additional_Notes__c = inputvalues[14];


            urnmtoupload.add(a);
        }
        try{
        insert urnmtoupload;
        }
        catch (Exception e)
        {
            ApexPages.Message errormsg = new ApexPages.Message(ApexPages.severity.ERROR,'An error has occured. Please check the template or try again later');
            ApexPages.addMessage(errormsg);
        }    
        return null;
    }
    
    public List< Username__c> getuploadedUsernames()
    {
        if (urnmtoupload!= NULL)
            if (urnmtoupload.size() > 0)
                return urnmtoupload;
            else
                return null;                    
        else
            return null;
    }            
}

Controller:

<apex:page Controller="UsernameFileUploader" >      
<apex:form >

<apex:pageBlock title="Upload data from CSV file">
             <center>
              <apex:inputFile value="{!contentFile}" filename="{!nameFile}" /> <apex:commandButton action="{!ReadFile}" value="Upload File" id="theButton" style="width:70px;"/>
              <br/> <br/> <font color="red"> <b>Note: Please use the standard template to upload Usernames. <a href="{!URLFOR($Resource.UserNameUploadTemplate)}" target="_blank"> Click here </a> to download the template. </b> </font>
             </center>  
      <apex:pageblocktable value="{!uploadedUsernames}" var="acc" rendered="{!NOT(ISNULL(uploadedUsernames))}">
          <apex:column headerValue=" Username ">
              <apex:outputField value="{!acc.Username__c}"/>
          </apex:column>
          <apex:column headerValue=" Contact Name ">
              <apex:outputField value="{!acc.Contact_Name__c }"/>
          </apex:column>
          <apex:column headerValue="Phone">
              <apex:outputField value="{!acc.Phone__c  }"/>
          </apex:column>
          <apex:column headerValue=" Email Address">
              <apex:outputField value="{!acc.Email_Address__c}"/>
          </apex:column>
          <apex:column headerValue=" Billing Account ">
              <apex:outputField value="{!acc.Billing_Account__c}"/>
          </apex:column>
          <apex:column headerValue="View">
              <apex:outputField value="{!acc.View__c }"/>
          </apex:column>
<apex:column headerValue=" Bill Code">
              <apex:outputField value="{!acc.Bill_Code__c }"/>
          </apex:column>
<apex:column headerValue="Lookup">
              <apex:outputField value="{!acc.Lookup__c }"/>
          </apex:column>
<apex:column headerValue="Summary">
              <apex:outputField value="{!acc.Summary__c  }"/>
          </apex:column>
<apex:column headerValue="View Score">
              <apex:outputField value="{!acc.View_Score__c }"/>
          </apex:column>
<apex:column headerValue=" Report">
              <apex:outputField value="{!acc.Report__c }"/>
          </apex:column>
<apex:column headerValue=" Draft">
              <apex:outputField value="{!acc.Draft__c }"/>
          </apex:column>
<apex:column headerValue=" Order">
              <apex:outputField value="{!acc.Order__c }"/>
          </apex:column>
<apex:column headerValue=" Pass / Fail">
              <apex:outputField value="{!acc.Pass_Fail__c }"/>
          </apex:column>

      </apex:pageblocktable> 
      </apex:pageBlock>       
   </apex:form>
</apex:page>