Hi there,

 

I'm a new zoho user and I'm having some problems trying to work out how to get my address from zoho creator into google msps.  My addresses are formatted like, field 1: house number;  field 2: street;  field 3: surburb

 

I have looked through the forums and this looks like the way to do it, but where do I enter this code?  do I have to create a new HTML view?  if someone could please walk me through how to use the code, that would be much appreicated.

 

------------

The script uses the PostUrl function to send header parameters and write CSV Data in the request body.

Function for generating authoization header

1. string googlemap.getGoogleAuthToken(string email, string passwd, string GoogleService)
2. {
3.     accountType = "HOSTED_OR_GOOGLE";
4.     url = "https://www.google.com/accounts/ClientLogin?accountType=" + accountType + "&Email=" + email + "&Passwd=" + passwd + "&service=" + input.GoogleService;  // Check GDATA API for service codes
5.     response = getUrl(url);
6.     authToken = response.getSuffix("Auth=").trim();  // Store this Authorization for subsequent request
7.     return authToken;
8. }

Function to retrive the latitude and langitude for address (Geocoding requests).

1. map googlemap.getLatitudeAndLangitudeMap(string address)
2. {
3.     latandlngXml = getUrl("http://maps.google.com/maps/api/geocode/xml?address=" + input.address + "&sensor=true");  // Retriving xml containing latitude and langitude xml
   
4.     latitude = latandlngXml.executeXPath("/GeocodeResponse/result/geometry/location/lat/text()");
5.     langitude = latandlngXml.executeXPath("/GeocodeResponse/result/geometry/location/lng/text()");
6.     return { "latitude" : latitude, "langitude" : langitude};
7. }
   

Function for adding PlaceMarks to GoogleMap.

1. void googlemap.createMapAndAddPlaceMark(string mapName, string placeTitle, string address)
2. {
3.     GoogleAuthToken = thisapp.googlemap.getGoogleAuthToken("xxx@gmail.com", "yyy", "local");
4. //HeaderParams included
5.     headerMap = { "Authorization" : "GoogleLogin auth=\"" + GoogleAuthToken + "\"", "Content-Type" : "text/csv", "Slug" : input.mapName };
6. 
   
7.     latAndLanMap = thisapp.googlemap.getLatitudeAndLangitudeMap(address);
8.     latitude = latAndLanMap.get("latitude");
9.     langitude = latAndLanMap.get("langitude");
10. //CSVMap Data Generating
11.     title = input.placeTitle;
12.     placeDesc = (input.address).replaceAll(","," ");
13.     csvMapData = "name,latitude,longitude,description\n" + title + "," + latitude + "," + langitude + "," + placeDesc;
14. //Adding GoogleMap into MyMaps to the AuthenticatedUser.
15.     result = postUrl("http://maps.google.com/maps/feeds/maps/default/full", csvMapData, headerMap,false);
16.     info result.get("responseText");
17.     info result.get("responseCode");
18. }
    

==================

Thanks