Working Qlikview Maps Extension Example

I’ve been having a lot of fun experimenting with google maps and Qlikview. After looking at quite a few extensions I finally ran across this one.

GoogleMapsAPIv3Toolkit-QV

http://branch.qlik.com/#!/project/56728f52d1e497241ae69843

Download the .qar file

(Qlikview extensions are easy to install, just double click the .qar file and it will go got town)

Also, get your self a copy of the ‘Google Maps JavaScript API v3 Toolkit Example.qvw’


 

So, first things first. Get yourself your own google maps API key

https://developers.google.com/maps/documentation/javascript/get-api-key

Using your google account you can eventually get to a screen that will give you a key.

Once you get a key, you can open up the ‘Google Maps JavaScript API v3 Toolkit Example.qvw’

Make sure you have changed over to web view (View menu, Turn on\off web view)

Extensions only work in web view (ajax view)

apikey.PNG

Then flip yourself to the Markers tab, right click properties on the extension object, Basic Configuration and paste in your Key into the API Key.

So, next thing I wanted to do was change the icon.

To do this, locate where it installed the extension.

C:\Users\[user]\AppData\Local\QlikTech\QlikView\Extensions\Objects (vista & seven) or C:\Documents and Settings\[user]\Local Settings\Application Data\QlikTech\QlikView\Extensions\Objects.

Drop your custom icon into /lib/images/ and refer only to the filename

Local\QlikTech\QlikView\Extensions\Objects\Google Maps Javascript API v3 Toolkit 2\lib\images

Under properties \ Markers \ Custom Icon URL type in just the filename of your new icon (and make sure its the right size or you will get giant markers:)

giant markers.PNG

If you want to have different markers based on some criteria then clear your custom icon URL on the Markers tab, change over to Markers – Additional Configurations

Click Force Multi-Icon Markers

Use an if statement in your function.

Multi-icon.PNG

Cheers

 

 

Installing viclient5.1 on server 2012R2

It started working after I went to roles, and added .net framework 3.5 features (.net 2.0 and 3.0)

 

How to transfer state using the IE Qlikview Plugin, solved

I’ve been slacking a bit on my blogging:)

After some trial and error I was able to transfer state from one Qlikview to another using the IE plugin on the Qlikview server.

The first thing to figure out is the path to your Target Qlikview.

The easiest way to do this is to open up the qlikview on the portal and then press Control + Shift + Q (Or go to the menu of the Qlikview plugin and choose Document Support Info)

transfer state

Copy that address. I’m not sure why it uses the qvp protocol, but hey this works.

Ok, now on your starting Qlikview you need to have a field that matches exactly a field in your target Qlikview. Otherwise it won’t work

So create a button, choose ‘Open QlikView Document’ paste in the URL you got from before (You can remove the qvp://qlikviewservername/ if you want)open

Click Transfer State.

Now publish your starting Qlikview (the button won’t work from Qlikview desktop)

And press the button. If everything works correctly you should see selections passed from one Qlikview to the Next. (If no selections are possible on the target, nothing will happen)

Wanted to use group policy to disable icmp redirect

Found here

 

http://arnavsharma.net/1/post/2014/03/enabling-mss-setting-on-windows-server.html

 

By default MSS settings are not visible in Windows Operating system and Servers.

Eg. MSS: (AutoAdminLogon) Enable Automatic Logon, MSS: (EnableICMPRedirect) Allow ICMP redirects to override OSPF generated routes etc

These additional group policy settings were developed by the Microsoft Solutions for Security group and are documented in the appropriate security guides.

For Windows Server 2008 is available here: http://www.microsoft.com/en-us/download/details.aspx?id=17606

There are two methods to enable MSS settings :

1.       Using Microsoft Security Compliance tool.
2.       Editing sceregvl.inf file.

  • Using Microsoft Security Compliance tool.

1.       Download Security compliance manager from here : http://technet.microsoft.com/en-us/solutionaccelerators/cc835245.aspx
2.       Install SCM
3.       After installing SCM, copy  “LocalGPO.msi” file from the following path: “C:\Program Files (x86)\Microsoft Security Compliance             Manager\LGPO\LocalGPO.msi”
4.       Run and install the file “LocalGPO.msi” on the server.
5.       Open command prompt and browse to : “C:\Program Files (x86)\LocalGPO”
6.       Run following command “Cscript LocalGPO.wsf /ConfigSCE”
7.       Now MSS Settings will be visible in Security Options in Local Group policy settings.

  • Editing sceregvl.inf file.

1.       Browse to %systemroot%\inf
2.       Take ownership of sceregvl.inf and full access on your ID.
3.       Open sceregvl.inf using notepad.
4.       Scroll down to [Register Registry Values] part and copy the contents of this file under [Register Registry Values].
5.       Now browse to [Strings] part and copy the contents of this file under [Strings].
6.       Save sceregvl.inf
7.       Run this command on elevated command prompt “regsvr32 scecli.dll
8.       Now MSS Settings will be visible in Security Options in Local Group policy   settings.

Powershell to add remove computers from group policy security filter

Install Group Policy Management (on a server 2008 R2 or higher)

Then you are able to run import-module grouppolicy

So, to add a computer to a ‘security filter’ you need to add GpoApply (which is both read and apply permissions) and it will then show in the security filtering pane

The command to do so is

Set-GPPermissions -Name “MyTest” -PermissionLevel GpoApply -TargetName “TheComputer” -TargetType Computer

To Remove the computer is quite simple, same command but set permissionlevel to none

Set-GPPermissions -Name “MyTest” -PermissionLevel None -TargetName “TheComputer” -TargetType Computer

#zerto review

So far this software is in the camp of it just works:)

Once you get the ZVM created you create the VRA’s

After that you log into the web portal and create the VPG’s and done.

So besides the alphabet soup:) its pretty dang easy!

#zerto rant, just show me the software

Hello, Zerto. All over your webpage it says I can download your trial software

… it has been three days.

I’m really trying to like your software…..

But, I would, you know like to try the software….

Follow

Get every new post delivered to your Inbox.

Join 255 other followers