Hi,
The main extension thread doesn't work for Google Enterprise version. It only works for the FREE version, where you will not able see the utilization in Google map's traffic report.
I have worked with my IT Apps development team and figured out a workaround on this.
We can't embed the crypto key page inside QlikView. So we hosted the page outside Qlikview in a webserver. The page can be a C# or java or php, etc, Just have to download the same code from Google API developer page.
https://developers.google.com/maps/documentation/business/webservices
Then we modified the page to receive the parameters such as Client ID, Map type, size, zoom, center, etc which needed for google map. the page will take all the parameters can generate the Signature key with the new URL. And it will redirect the link to Google map. In return, the QlikView will call the page (instead of Google Map), and will able display the Google map correctly.
Sample PHP Code which I am using for reference:
<?php
// Encode a string to URL-safe base64
function encodeBase64UrlSafe($value)
{
return str_replace(array('+', '/'), array('-', '_'), base64_encode($value));
}
// Decode a string from URL-safe base64
function decodeBase64UrlSafe($value)
{
return base64_decode(str_replace(array('-', '_'), array('+', '/'),
$value));
}
// Sign a URL with a given crypto key
// Note that this URL must be properly URL-encoded
function signUrl($myUrlToSign, $privateKey)
{
// parse the url
$url = parse_url($myUrlToSign);
$urlPartToSign = $url['path'] . "?" . $url['query'];
// Decode the private key into its binary format
$decodedKey = decodeBase64UrlSafe($privateKey);
// Create a signature using the private key and the URL-encoded
// string using HMAC SHA1. This signature will be binary.
$signature = hash_hmac("sha1",$urlPartToSign, $decodedKey, true);
$encodedSignature = encodeBase64UrlSafe($signature);
return $myUrlToSign."&signature=".$encodedSignature;
}
$URL = "http://maps.googleapis.com/maps/api/staticmap?";
$center = "center=".$_GET["center"];
$zoom = "&zoom=".$_GET["zoom"];
$maptype = "&maptype=".$_GET["maptype"];
$size = "&size=".$_GET["size"];
$sensor = "&sensor=false";
$client = "&client=YOURGOOGLEMAP_CLIENTID";
$specialkey = "YOURGOOGLEMAP_CRYPTOKEY="
$URL = $URL.$center.$zoom.$maptype.$size.$sensor.$client;
header('Location: '.signUrl($URL, $specialkey));
?>
Hope this helpful to anyone who is looking for the solution
