[SalesForce] Visualforce Error: System.TypeException: Invalid integer: 30.418933

I'm trying to convert a number in a CSV file column into a value that I can save in a custom object field. My custom object has a Geocode field type, which is comprised of two individual fields (Geoloc__Latitude__s and Geoloc__Longitude__s). When I try to convert the String to an Integer, I get the above error.

Public void readCsvFile() {
    if(csvData != null) {
        csvStringFileData = csvData.toString();
        csvFileLines = csvStringFileData.split('\n');

        for(string st:csvFilelines[0].split(',')) 
           fieldList.add(st); 

           for(Integer i=1;i<csvFilelines.size();i++) {
            Client_Site__c clientLocation = new Client_Site__c();
            string[] csvRecordData = csvfilelines[i].split(',');
            clientLocation.SITE_NAME__c = csvRecordData[0];
            clientLocation.ADDRESS__c = csvRecordData[1];
            clientLocation.CITY__c = csvRecordData[2];
            clientLocation.STATE__c = csvRecordData[3];
            clientLocation.ZIP__c = csvRecordData[4];
            clientLocation.FRANCHISEE__c = csvRecordData[5];
            clientLocation.SITE_ID__c = csvRecordData[6];
            clientLocation.SITE_OWNER__c = csvRecordData[7];
            clientLocation.Geoloc__Latitude__s = Integer.valueOf(csvRecordData[8]);
            clientLocation.Geoloc__Longitude__s = Integer.valueOf(csvRecordData[9]);

            clientLocation.RequestForProposal__c = rfpId;

            clientLocationList.add(clientLocation);
           }
    }
}

How do I convert the String to something I can save in a Geocode field?

Best Answer

Try changing integer.valueof(csvRecordData[8]); to decimal.valueof(csvRecordData[8]);

Related Solutions

[SalesForce] Split a single field into 2 columns for a VF page

This is untested so you may need to have play, however this should return a List of the RevenueWrapper classes which contains the 4 columns you are looking to use in your VF page:

public class RevenueController{

Map<String, RevenueWrapper> ResultList = new Map<String, RevenueWrapper>(); 

public RevenueController(){
    List<AggregateResult> result =  [
    SELECT FISCAL_YEAR(Date__c) Date, Type__c, sum(Amount__c) Amount
    FROM Revenue__c
    GROUP BY FISCAL_YEAR(Date__c), Type__c];

    for(AggregateResult ar : result){

        RevenueWrapper RW = new RevenueWrapper();

        //If the RevenueWrapper already exists grab it from the Map
        if(ResultList.containsKey(String.valueOf(ar.get('Date')))){
            RW = ResultList.get(String.valueOf(ar.get('Date')));
        }

        //Set the amount
        RW.setAmount(ar);

        //Save back to the Map
        ResultList.put(String.valueOf(ar.get('Date')), RW);
    }
}

public List<RevenueWrapper> getResults() {
    return ResultList.values();
}


public class RevenueWrapper{
    public String revenueDate { get; set; }
    public Integer budgetAmount { get; set; }
    public Integer actualAmount { get; set; }
    public Integer varianceFYPercent { set; }
    public Integer varianceFYAmount { set; }

    public RevenueWrapper(){

    }

    public void setAmount(AggregateResult ar){
        revenueDate = String.valueOf(ar.get('Date'));

            //Set the amount value based on type
        if(ar.get('Type__c') == 'Budget'){
            budgetAmount = Integer.valueOf(ar.get('Amount'));
        }else if(ar.get('Type__c') == 'Actual'){
            actualAmount = Integer.valueOf(ar.get('Amount'));
        }else{ //Catch all for a type that isn't recognised
            return;
        }

    }

    public Integer getVarianceFYAmount(){
        return actualAmount - budgetAmount;
    }

    public Decimal getVarianceFYPercent(){
        if(budgetAmount != 0){
            return Decimal.valueOf((Double.valueOf(actualAmount) / Double.valueOf(budgetAmount)) * 100).setscale(1);
        } else{
            return 0;
        }
    }
}

}

[SalesForce] Trying to add Custom record using Custom Controller

You have to initialize the book object in constructor before insert it:

public class insertController1 {

    public Book__c book { get; set; }

    // Here initialize the book object
    public insertController1() {
        book = new Book__c();
    }

    public PageReference addNewBook() { 
        insert book; 
        return null; 
    }
}

Related Topic