Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Veerendar AellaVeerendar Aella 

apex code to visualforce page

Hi All,

I want to import xml file into salesforce using apex code from visualforce page.
Please find below details of XML file:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<lead-data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <record>
        <FirstName>Veera</FirstName>
        <LastName>Vinnu</LastName>
        <Phone>8008997654</Phone>
        <Email>veerav@gmail.com</Email>
    </record>
    <record>
        <FirstName>Beera</FirstName>
        <LastName>Binnu</LastName>
        <Phone>9898989898</Phone>
        <Email>beeru@gmail.com</Email>
    </record>
    <record>
        <FirstName>Ceera</FirstName>
        <LastName>Cinnu</LastName>
        <Phone>8989898989</Phone>
        <Email>ceera@gmail.com</Email>
    </record>
    <record>
        <FirstName>Deera</FirstName>
        <LastName>Dinnu</LastName>
        <Phone>7878787878</Phone>
        <Email>deera@gmail.com</Email>
    </record>
</lead-data>

And my apex code is:

public class Parser_New{

    public class leaddata {
        public String FirstName {get; set;}
        public String LastName {get; set;}
        public String Phone {get; set;}
        public String Email {get; set;}
    }

    public List<leaddata> parse(string toParse) {
        List<leaddata> reports = new List<leaddata>();
        DOM.Document doc = new DOM.Document();
        doc.load(toParse);    
        parseReports(doc.getRootElement(), reports);

        system.debug('DDDDDDDDDDDDDDDDDDDDDDDD'+ Reports);
        return reports;
    }

    private void parseReports(DOM.XMLNode node, List<leaddata> reports) {
        for (Dom.XMLNode child : node.getChildElements()) {
            if (child.getName() == 'record') {
                leaddata r = new leaddata();
                parseReport(child, r);
                reports.add(r);
            }
        }
    }
  
   private void parseReport(DOM.XMLNode node, leaddata r) {
        for (Dom.XMLNode child : node.getChildElements()) {
            if (child.getName() == 'FirstName') {
                r.FirstName= child.getText().trim();
            } else if (child.getName() == 'LastName') {
                r.Lastname= child.getText().trim();
            } else if (child.getName() == 'Phone') {
                r.Phone= child.getText().trim();
              }  else if (child.getName() == 'Email') {
                r.Email= child.getText().trim();
                
            }
        }
    }
}

I have no clue how to use this apex code in visualforce page to import xml file . Please help. 
Raj VakatiRaj Vakati
Use this code
  
public class Parser_New{
    public Blob myfile{get;set;}
    
    
    public Parser_New(){
        reports = new List<leaddata>(); 
    }
    
    public List<leaddata> reports {get;set;}
    
    public class leaddata {
        public String FirstName {get; set;}
        public String LastName {get; set;}
        public String Phone {get; set;}
        public String Email {get; set;}
    }
    
    
    
    private void parseReports(DOM.XMLNode node) {
        for (Dom.XMLNode child : node.getChildElements()) {
            if (child.getName() == 'record') {
                System.debug('child'+child);
                parseReport(child);
                //  reports.add(r);
            }
            System.debug('reports'+reports);
        }
    }
    
    private void parseReport(DOM.XMLNode node ) {
        leaddata r = new leaddata();
        
        for (Dom.XMLNode child : node.getChildElements()) {
            if (child.getName() == 'FirstName') {
                r.FirstName= child.getText().trim();
            } else if (child.getName() == 'LastName') {
                r.Lastname= child.getText().trim();
            } else if (child.getName() == 'Phone') {
                r.Phone= child.getText().trim();
            }  else if (child.getName() == 'Email') {
                r.Email= child.getText().trim();
                
            }
        }
        reports.add(r);
        
    }
    
    public void doUpload() {
        
        DOM.Document doc = new DOM.Document();
        doc.load(String.valueOf(myfile.toString()));    
        parseReports(doc.getRootElement());
        
        
    }
    
}
  
<apex:page Controller="Parser_New" >
        
        <apex:form>        
            <apex:pageblock title="Read XML" id="PB">
                <!-- inputFile for uploading XML -->
                <apex:pageblocksection >
                    <apex:pageblocksectionitem>
                        <apex:outputLabel value="Please Select XML File:"/>  
                        <apex:inputFile value="{!myfile}"> </apex:inputFile>
                    </apex:pageblocksectionitem>                
                </apex:pageblocksection>
                <!-- Table to show the XML Result -->
                <apex:pageblocksection title="Result of XML" columns="1" rendered="{!reports.size != null}">
                    <apex:pageblocktable value="{!reports}" var="con">
                        <apex:column value="{!con.FirstName}" headerValue="First Name"/>
                        
                    </apex:pageblocktable>
                </apex:pageblocksection>
                <!-- Button for calling method of controller -->
                <center>
                    <apex:commandButton value="Read" action="{!doUpload}"/>
                </center>
            </apex:pageblock>    
        </apex:form>    
        
    </apex:page>