Venkat$ echo

PIP is not prepackaged with Python 2.7 and I found that PIP is very helpful to install lots of python modules. So thought why not document the steps to install it. So here it is. Install pip - Straight Forward way  Download the get-pip.py from https://pip.pypa.io/en/latest/installing.html Run this on command line - python get-pip.py If you face any problems like "unable to fetch bla bla..." it is likely that you are having a proxy issue. If so follow the below steps Install pip with Proxy config Find the proxy config- i.e IP and PORT. if you already know it, then use that OR Go to your browser and check the proxy settings ( IE= Tools->Internet Options -> connections Tab -> Lan Settings. chrome= settings-> advanced options -> under Network -> "change proxy settings"). If your setting has "automatic proxy detection" then use the below method to find it. Open command line and type - "ping wpad" and see you can fig...

I thought I will summarise all my Tableau related blog at one spot Tableau Forum http://community.tableausoftware.com/people/venkatachalam.veerabagusubramanian/content Blogger http://venkat-echo.blogspot.com.au/search/label/tableau

If you are IOS developers who is using parse, then you must know that there is a class in parse IOS library called "PFQueryTableViewController" which has got nice feature to query a parse object and display the results on IOS App's table view. But like me if dont want to access Parse object directly instead using a Cloud Code (CC) to access all your parse object then you will not be able to use the above class as it works only when accessing the parse objects directly. bummer..... I searched for a while and couldn't find any library which can work on Cloud Code, so ended up making my own Parse extension which will work for CLOUD CODE. yay..... eCT_PFCloudTableViewController   - has got the following features Pagination with "Load more" options. With or without "Search Bar" Pull to refresh. Integrated MBProgressHUD for Nice Activity Indicators. Completely customisable. Pre-requisites: Since you will be using a Cloud Code to access th...

Sometime it is important to identify if the value of the column is changed and perform a action based on it. In the parse we have an method called request.object.dirty(<column_name>) . But the only issue is that this works only on the beforeSave. But most of us want to perform an action only when we are sure that data is saved. In other word we would like to do it on "afterSave". for eg. If you want to send a email or push notification based on a status flag getting updated. We would like to do that on the "afterSave". But on "afterSave" Here is the code how to do it. Parse.Cloud.beforeSave(" ", function(request, response) { //--find the columns which got changed var arrChangedAttributes = new Array(); var vAttributes = request.object.attributes; var query = new Parse.Query(" >> id >>>" + request.object.id ); //--means it is an INSERT. This is to identify it is an INSERT or UPDATE if(!req...

I'm a hard-core ORACLE programmer and lately I had to work with SQL server for a specific project. First thing I noticed is that its a bit hard to search for column names, table_names (*across all databases*) etc in sql server. In oracle, we have the DBA views like DBA_tables, DBA_tab_columns etc, which are very handy for these purposes. In SQL sever we have a stored proc called "sp_msforeachdb" to somewhat do this task. But it opens up so many result windows and also creates one window for each DB, even if the DB doesnt have any results. So I ended up making few stored proc which will work somewhat similar to the oracle's DBA views. Use the below script to create the working tables. create table my_dba_tables( db sysname, table_name sysname, object_id int); create table my_dba_tab_columns( db sysname, table_name sysname, object_id int, table_column sysname); create table my_dba_objects( db sysname, object_name sysname, object_id int); Download the stored...

I'm doing an IOS app which uses Parse's(www.parse.com) Cloud code. Being a IOS developer I found it a bit tedious to test the output of my Cloud Code(CC) using objective C (especially when I'm changing and developing the cloud code) I thought it would be easy if I can check the output of my CC using a JavaScript directly from the browser, because you can see the output of you CC immediately and also get a better understanding of what values are being returned. so I made a quick template which uses Parse JS API to   Login to Parse( In my app you can call a CC only if you login as a App user) Call could code and display its result. Download the template from this link - Venkat-GitHub-Page-Parse Remember to edit the index.html file and put your <app_ID> and <java-script-key> at Parse.initialize Edit the login details Edit the Cloud code function details and parameters( if any)

This example is to show that you can draw your own shapes in tableau ( not just on maps) and use that for operational purposes. Lately I have been working on hadoop and big-data and want to monitor which servers are up and running, so that it is easy for operational monitoring purposes. In the below example I have combined the shapes and the server status( "Running") on the same file, but if you cant/dont want to do that you can use the data blending technique to combine 2 different data source You can download the source from the below "Tableau Public" link Learn About Tableau