Best Current Affair Apps And Magazines :

These current affair apps are useful for anyone who is preparing for SSC-CGL, RBI, Bank or IAS exams.You have to keep yourself updated with the current events which are happening not just in India but around the world.These exams are tough not because of its syllabus but because of its competition.Every year lakhs of aspirants appear for these exams to fight for few seats. So, each and every little bit of knowledge is important to get some extra edge. When the competition is that much high, every little thing counts. 

Ok ! So, Let's cover some apps who can give you this extra advantage.

Pratiyogita Darpan :

No doubt, this is the best current affair magazine available in the Google Play Store.This has already been recommended magazine for anyone interested in any kind of competitive exams.It'a monthly paid magazine. You can get the hard copy of this magazine in any bookstore. It's good to see the digital version of the magazine in the Play Store.

I was thinking there would be some kind of payment involved to see the whole magazine.As it's a paid magazine. But, I was amazed to see you can read the whole magazine for free.Once you are finished with a page just swipe for the next page. And, you will be able to access the earlier versions also.But as usual, you have to swipe the first few pages because there are lots of ads. Also, the text size is small because they try to fit everything in a single page. So, you better zoom before reading the contents.

Also, there are two versions available in PlayStore : Hindi and English.
The Hindi version is more popular than the English.

Pratiyogita Darpan In Hindi

Installs : 100,000 - 500,000

Last Updated On : July 17, 2015

Daily Current Affairs And GK

A great app for competitive exams. Once you open this app, you will find everything categorized.They don't mince everything. Based on your requirement, you can click on the desired category and gather the required knowledge. It's less time consuming as you don't have to skim all contents to reach to your required content. You can grab the knowledge about the Economy, Sports, National, Corporates, International etc.You can search contents weekly and monthly based on your keyword.You have to appreciate this feature.The one interesting thing I noticed in the description is this :The selection of important current affairs topics for the app can be identified from the fact that almost 90% of questions in UPSC Prelims 2016 were covered in our Current Affairs & GK app.

Also, you can take quizzes in Hindi and English.

Installs : 1,000,000 - 5,000,000

Last Updated On : August 24, 2016

No.1 Daily Current Affairs GK :

This app provides content in Hindi and English. It also has Smart Quiz feature to make you remember the contents.But, I would still rate it under the above app as it doesn't categorize the contents but still useful if you are looking for daily updates.The one thing is the contents are available in the calendar format of the date.You can check for the date and look for that day current affair contents.They provide the contents in not more than 100 words : Get all the news on the move with its byte sized capsules. You can now catch up on all of the day’s most important events and updates in under 100 words so that you focus your efforts on only the most relevant Current Affairs Updates.

No. 1 Daily Current Affairs App Download

Installs : 500,000 - 1,000,000

Last Updated On : August 28, 2016

GK & Current Affairs 2016 :

This is another daily updated Current Affairs app.It also has offline browsing feature available.You don't need the internet connectivity to go through the contents.It will load all the contents once you are connected to the internet and later you can browse through the contents in the offline mode.It has features like: Short Current Affair articles, Government Job, 5 Thousand Objective type Gk questions, GK Tricks etc..

GK & Current Affairs 2016 Android App

Installs : 10,000 - 50,000

Last Update On : June 2, 2016

I have spent a lot of days to create my first native android app :HealthCare IT - Domain Knowledge.After creating it, I just published it on the Google Play Store and shared a link on my Facebook profile. But is it enough to make people look into my app? Before answering this question, let's focus on the few statistics about the Google Play Store. There are around 2 million apps in the Google Play Store and your app is going to increase this number by one. Your first task should be to get this app in the hands of your targeted customers.And, we can achieve it through Universal App Installer Campaign. You can target the Country, Audience, Langugage etc.

Now, Let's see how it works..

What Is Universal App Installer ?

With just four inputs, you can reach all potential users in the moments that matter – whether they’re searching on Google Play or Google Search, watching on YouTube, browsing sites or using mobile apps on the Google Display network. The campaign automatically optimizes your bids, targeting, and ad creative to find more of what you want across all these traffic sources – within your budget and target CPI as stated here.

Isn't it compelling ?? I bet it is. 

Now, let's see where your ads will be appeared..

Where Your Ads will Appear ?

Your ads will be eligible to appear across Google's properties. This includes Google Search and Google Play, as well as our search partners, YouTube, the Google Display Network, AdMob, and many more publishers who host app ads.You must have already seen these kind of apps on various Google properites.I have seen it everyday once a open Youtube videos on my mobile.It's just under the Youtube videos.So, this is the great way to get some new cusotmers for your app. 

Marketing Apps :

Universal app ads are generated on the fly by our system and matched to the most relevant ad inventory and placements available. To build your ads, AdWords may use your app's listing in the relevant application store, any of your text ideas, optional app images from the app store, and an optional YouTube video. The system rotates your ads and adjusts bids automatically to get the most downloads for your app that meet your optimization objective. For example, if one line of text is performing better than another, the system will show the better text more often as stated here..

Universal App Campaigns
Marketing Apps: Universal App Campaign Platforms

How To Create Universal App Installer Campaigns :

You should have a Google AdWords account. Once you sign in, go to Campaigns. Then Click on +Campaign button and select Universal App Campaign.

The Bidding...

Next Step is to fill a form and decide the bids. The Bid Concept : When you set your bids, you're telling AdWords the average amount you'd like to spend each time someone installs your app. Keep in mind that your budget will be used to get as many installs as possible at your set amount. So, if you set your daily budget for $30, and your targeting cost-per-install is $3, you're aiming for about 10 installs per day from your ads.One more thing you have to notice here is to put 4 separate lines in Text Ideas box.It should be a complete sentence in each box. The Google can take any of the values from the text box and use it to display while promoting your android app.The currency would be based on your Country.

How To Create Universal App Campaign (Please click to enlarge)
Once done, click on Save and Continue button at the bottom and your ad will ready to serve. You can go the Campaign page and can check the status of your new campaign.

Google AdWords Universal Installer Campaign

How To Update APK In The PlayStore :

I have an app in Play Store : HealthCare IT - Domain Knowledge. I have been working in the HealthCare IT industry for the last 4 years and I know there is a lot of gap in understanding the jargons of the Healthcare world. Plans, Providers etc. As a developer, it's always easy to code as per requirements but the main question is which business requirement it actually fulfills ? How will it impact the current process ? So, just to fill this domain knowledge gap , I thought of publishing an android app. It was just a thought without knowing how to implement things. I will cover the whole journey of developing apps in another post. Let's focus here how to update your apps.

The Requirement :

The requirement is to update an existing app in the PlayStore with the new features that you recently added in the apps. It's not the first time you are going to publish in android apps but second, the third etc..So, there are different steps involved in when you are publishing your app second time onwards.Before you start to think of the complexity of this process then let me tell you it's going to take lesser than the first time you published your app, after all, you are just updating your app.

Step 1 : Update the Build.Gradle file

This is called the versioning of the app. If you are to upload the APK keeping the old versioning, it will throw you an error and won't allow you to publish the app. So, this is the main step that you have to keep in mind while updating your APK. The steps are simple, switch to the Project Mode and look for build.grade under your project. Update the values as mentioned in the below screenshot. The code would be like this :

Your app users never see the versionCode , it's always the versionName.And, this value will keep incrementing as you update the app. Not automatically, you have to increment it :P.

Step 2 : Set Your Project In the Release Mode

Next thing is to put your project on Release mode from the Debug mode. Just click on Build Variants tab on the left side panel of the Android Studio. It will give you a new window as shown in the below screenshot. Select Release from the drop-down menu.

Step 3: Generate the Signed APK For Your Project

Now, we are good to generate the APK. Make sure it's a signed one.You would have two options, one is to just Build APK and second is to Generate Signed APK.If you just click on Build APK , it will create the Unsigned Release APK and this is not recommended.You have to generate the Signed APK only. The process is fairly simple. Just a few clicks.

Once the Signed APK generated successfully, you will find the below statements in the Event log of the Android Studio:

Click on the Show in Explorer and it will redirect you to the folder where the APK got generated successfully.Check for the name as mentioned in the below screenshot and this is the only thing that you have to upload in the Google PlayStore through Google Developer Console.

Step 4 : Upload Signed APK In the Google PlayStore:

Once done with the above steps, Go to the Developer Console Page of  your app and Click on the APK. Once you are inside the APK window, Click on Upload New APK Production button. At this point of time, you would be able to see the earlier version of your app here.

Once the APK upload is successful, a new line will be added for the updated version number in the Developer Console as shown in the below screenshot :

Grab the step by step video tutorial here :

Transferring Blog From One Domain To Another :

Recently, I bought a new domain because I wanted to switch to new URL. But, I just messed up while switching and my website was down for 3 days, it means 0 visits for 3 days. So, in this post, I am going to put a simple story of how not to mess up while switching your website domain.

When I started blogging, my blog was on After some time I got to know you can actually buy the domain and have your own URL. So, I bought this domain from BigRock, I wish I would have bought a .com.Just few days back, I tried to fulfill my wish. So, I bought a new domain

No Easy Way To Transfer Domains On Blogger ..

Now, next step was to move domains from to without losing the traffic.As the new domain will be new to Google also.So, there won't be any indexing. To retain my current traffic, I must have to redirect the traffic from to

The Blogger platform do not provide this option, you can't switch from one domain to another easily.There are multiple intermediaries steps are involved. But, Yes, you can easily switch from or to the new domain.

And, It All Got Messed Up ...

In the blogger settings, under the Blog URL, I put the new URL and tried to save it.But soon, I realized that my old domain will be lost, it won't be hosted anywhere. So, I won't be able to redirect the traffic from to I tried to put the old domain back under 10 mins but my website was down my that time.

A Guide To Transfer Domains On Blogger :

If you are interested in a guide, how to move or tranfer domains from one domain to another on blogger.Please follow this guide :

BigRock Guide : Map Your Domain To Blogger

One thing you have to notice here, this guide is for transferring domains from or to the new domain. Not from your currrent .in or .com to domain to new .in or .com domain.

A Guide To Transfer Domains When It's NOT :

So, what if you want to transfer your blog domain from one to another and it's not or in.In this process, the efforts gets multiplied.First, you have to copy your old site contents on the new site (Create a new blog, change the domain with new one and from the setttings option import the content). Now, we don't want to lose traffic so you have to do the Domain Forwarding:

Please see the response below :

The most obvious case is to keep the domain. So, please follow this guide :

404 : The Requested URL was not found...

I thought it would be up soon as I have already put the right domain but I waited.. waited and waited.. 1 day passed and it was not live. When I was trying to access my blog, it was throwing the below error. Believe me, when you own a website, this is the last thing you want to see.

So, How did I fix the domain transfer issue ?

I raised a lot of tickets on my Domain Provider side ( BigRock). And, everything was fine at that end. So, I decided to take Blogger Community forum help. Asked a question and got the response that actually worked and brought my website back to life again. You can find the whole discussion here :

How To Transfer Your Domain, If You Messed Up

But in short, I had to publish my blog back to domain and republish on It may sound a lot but it's not. It just 2 minutes process.The steps are in the above link.

Google Analytics :

I haven't been using the Google Analytics effectively for so long and was dependent on the 
blogger statistics only. But Google Analytics is the best way to monitor the traffic. Also, it provides you the way to analyze the real-time traffic. We can never be wrong about your website visit counts if you are using Google Analytics for your website. Let's check what Wiki has to say about the Google Analytics :

Google Analytics is a freemium web analytics service offered by Google that tracks and reports website traffic.Google launched the service in November 2005 after acquiring Urchin.Google Analytics is now the most widely used web analytics service on the Internet.Google Analytics for Mobile Apps, an SDK that allows gathering usage data from iOS and Android Apps.

Recently there has been changes in the layouts of the Blogger and Google Analytics Platform, So, you may get confused while linking the Google Analytics to Blogger. In this guide, I will make this process very clear to you.

Steps To Link Google Analytics To Blogger :

Step 1 :

Log in to Google Analytics. Your home page will look like this. Go to Admin tab.

Step 2:

Google Analytics works on the Property. So, if we want anything to be tracked that should be added as the Property here and that's what we are going to do here. As you can see, my website is already added as the Property here. For new values, Click on the Create New Property.

Step 3:

In next screen, you have to fill the details of your website. Once you fill the details, Click on Get Tracking ID.You will get a Tracking ID in this format UA-XXXXXXXX-X.

Step 4:

Now, log in to Blogger. Go to Settings -> Other and scroll to the bottom. You just have to put this Tracking ID in the Analytics Web Property ID box.

Step 5:

Once done , you can go to Google Analytics account. Click on All Website Data and you will be greeted with the traffic details. You may have to wait for sometime so that the traffic metrics get populated.Meanwhile, you can go to Real - Time tab to get the real time analysis.

Requirement :

The requirement is to sort the data present in the delimited input file.In this tutorial, we are going to sort data based on the CustomerName column present in the input file.

Steps To Sort Data Using Talend Open Studio :

  • First, we would be reading the Delimited Input File with the help of tFileInputDelimited component.Input File Name : Customer.csv
  • tSortRow component would be used to sort data coining from a tFileInputDelimited component.
  • Next, we would be storing the sorted contents of this input file in a temp file using tFileOutputDelimited component. This temp file will be created after sorting the input file.This temp file will work as an intermediate file. Later, we will use this temp file to replace the input file.

tFileInputDelimited, tFileOutputDelimited, tSort
Talend Job Designing 

  • We would be sorting the data based on the CustomerName column. This column is of String type.So, Sort value will be of Alpha type. You can select the order of sorting as Asc or Desc.

tSortRow Component Properties
tSortRow Component Properties

If we run just the above design, the data would get sorted and saved as Temp.csv. So,at this point of time, you can see two files in the folder, one is the input file and second is the intermediate file.The input file will have data in a unsorted manner whereas your intermediate file will have same data in a sorted manner.

Talend Components Used in Design :

tFileInputDelimited :

tFileInputDelimited reads a given file row by row with simple separated fields.
Opens a file and reads it row by row to split them up into fields then sends fields as defined in the Schema to the next Job component, via a Row link.

Get more details from here : tFileInputDelimited Components Detail

tFileOutputDelimited :

tFileOutputDelimited outputs data to a delimited file.This component writes a delimited file that holds data organized according to the defined schema.

Get more details from here : tFileOutputDelimited Component Details

tSortRow :

Sorts input data based on one or several columns, by sort type and order.

Get more details from here : tSortRow Component Details


Copies a source file into a target directory and can remove the source file if required.

Get more details from here : tFileCopy Component Details

Customer.csv (Input File) :

Temp.csv (Intermediate File):

  • Now, we don't want our sorted data in the different output file. We want the sorted data in the same input file. To achieve this goal, we are going to use one more component tFileCopy and with the help of this component, we will replace the input file (Customer.csv) with the output file (Temp.csv) and later rename the Temp.csv file  to Customer.csv.

What is OnSubJobOk ?

OnSubJobOk is a trigger connection. To link this to tFileCopy component , Right Click on the tFileInputDelimited and select Trigger -> OnSubJobOk.

 This link is used to trigger the next SubJob on the condition that the main SubJob completed without error. This connection is to be used only from the start component of the Job.

Sorting File In Talend Open Studio
Sorting File Job Design In Talend Open Studio

The Final Job :

And your final output file (Customer.csv) :

Watch Step by Step Video Tutorial here :

Talend has already been creating a lot of buzz in the ETL tools industries. I have already covered some posts to show the growth and popularity of this tool.You can check that by searching the trends on the website.Many companies from the Top 500 Fortune company list, are adopting this tool.The ease integration with Big data and clean interface, are making it very popular among many IT companies.

We are going to create the simplest job here. The requirement is to read the contents of a file using Talend Open Studio.This Talend tutorial is absolutely for beginners.


We are going to process a delimited file in this tutorial. In the delimited files, the contents are separated with some special characters. As you can see in the below screenshot , that character is semicolon here.The first line contains the column name (Header). Talend provides us the way to include or exclude these columns in our output.In this tutorial,we will exclude the headers and will only display the contents.

Once you open the Talend Open Studio.It will be an empty window and the layout will be as
shown below :

How To Create Jobs In Talend Open Studio :

Right Click On Job Design and go to Create Job. A window will pop up.Give a name to your job.Once done, click Finish.

Once you are finished with the above steps, the Talend Open Studio Designer will be populated with new values everywhere.

The Components  :

tFileInputDelimited :

Location Of Component : Palette -> Input -> tFileInputDelimited

There are multiple ways to put the component on the designer window. The first, is to drag and drop the component from the Palette and second, you can just start typing the component name and it will be popped up in the window. I have used drag and drop technique to populate tFileInputDelimited component in the below video tutorial.


Opens a file and reads it row by row to split them up into fields then sends fields as defined in the Schema to the next Job component, via a Row link.

Get more details from here : tFileInputDelimited Demystified

We are not going to store the output in any kind of file or database. We will display the output in the Talend Open Studio Designer window itself.

tLogRow :

Location Of Component : Palette -> Log & Errors -> tLogRow

There are multiple ways to put the component on the designer window. The first, is to drag and drop the component from the Palette and second, you can just start typing the component name and it will be popped up in the window. I have used this technique to populate tLogRow component in the below video tutorial.


Displays data or results in the Run console.tLogRow is used to monitor data processed.

Get more details from here : tLogRow Demystified

The Final Job :

Video Tutorial : Create Jobs In Talend Open Studio :

Watch this video tutorial to get the step by step details :

© 2015 Techie's House. Designed by Bloggertheme9