Remove From My Forums

How to populate City and state with Zip

Question
0

Sign in to vote

So I'm experimenting with City and State entity lookups for Account. I've found threads on this and it works ok.
Now this is where it I'm not sure the best method.

Should I add a third entity with Zips in it? or should I just attach the Zip to the City Entity?
Then I want to be able to complete City and State on an Account/Contact by merely entering in the zip. I would imagine I could use an OnChange event and a Soap call, just not sure if the Zip should be a separate entity.
Withers

Monday, August 3, 2009 3:58 PM

Answers

David -

there's an alternate way - you can use the zip code to retrieve the city/state using Yahoo's geocode webservice.-
The original posting was from Invoke - from Aaron Elder, I believe -

Here's a sample that could be added to the zipcode's onchange field: (This version was modified by Grzegorz Kalek:)

if (crmForm.address1_postalcode.DataValue != null) {
    // form and send request to Yahoo Geocode services  
    var sUrl = "http://api.local.yahoo.com/MapsService/V1/geocode?appid=MicrosoftCRM";
    sUrl += "&zip=" + crmForm.address1_postalcode.DataValue;
    var oXmlHTTP = new ActiveXObject("Msxml2.XMLHTTP");

    // send request and store response
    oXmlHTTP.Open("GET", sUrl, false);
    oXmlHTTP.Send();

    var oXmlDoc = oXmlHTTP.responseXML;
    // populate city, state and country in CRM if zip is valid
    //alert(oXmlDoc.selectSingleNode("ResultSet/Result/City").text);

    crmForm.address1_city.DataValue = toProperCase(oXmlDoc.selectSingleNode("ResultSet/Result/City").text);
    crmForm.address1_stateorprovince.DataValue = oXmlDoc.selectSingleNode("ResultSet/Result/State").text;
    crmForm.address1_country.DataValue = oXmlDoc.selectSingleNode("ResultSet/Result/Country").text;
}
else {
    // if zip code is not found set fields to null
    crmForm.address1_city.DataValue = null;
    crmForm.address1_stateorprovince.DataValue = null;
    crmForm.address1_country.DataValue = null;
}

// converts data to proper case
function toProperCase(s) {
    return s.toLowerCase().replace(/^(.)|\s(.)/g, 
        function($1) { return $1.toUpperCase(); });
}

Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell

Marked as answer by David Withers Monday, August 3, 2009 5:32 PM

Monday, August 3, 2009 4:31 PM

Moderator

All replies

if (crmForm.address1_postalcode.DataValue != null) {
    // form and send request to Yahoo Geocode services  
    var sUrl = "http://api.local.yahoo.com/MapsService/V1/geocode?appid=MicrosoftCRM";
    sUrl += "&zip=" + crmForm.address1_postalcode.DataValue;
    var oXmlHTTP = new ActiveXObject("Msxml2.XMLHTTP");

    // send request and store response
    oXmlHTTP.Open("GET", sUrl, false);
    oXmlHTTP.Send();

    var oXmlDoc = oXmlHTTP.responseXML;
    // populate city, state and country in CRM if zip is valid
    //alert(oXmlDoc.selectSingleNode("ResultSet/Result/City").text);

    crmForm.address1_city.DataValue = toProperCase(oXmlDoc.selectSingleNode("ResultSet/Result/City").text);
    crmForm.address1_stateorprovince.DataValue = oXmlDoc.selectSingleNode("ResultSet/Result/State").text;
    crmForm.address1_country.DataValue = oXmlDoc.selectSingleNode("ResultSet/Result/Country").text;
}
else {
    // if zip code is not found set fields to null
    crmForm.address1_city.DataValue = null;
    crmForm.address1_stateorprovince.DataValue = null;
    crmForm.address1_country.DataValue = null;
}

// converts data to proper case
function toProperCase(s) {
    return s.toLowerCase().replace(/^(.)|\s(.)/g, 
        function($1) { return $1.toUpperCase(); });
}