Saturday, 13 June 2015

Find Out Publishing Date Of Any Article

Hi Friends!

Hope you all are doing good. It took some time for me to write here as my schedule had become quite hectic in the last few months.

During my previous endeavours, I had to do a lot of secondary research. But you all know that, if you have to read 60+ articles, easiest way to filter the results while Googling!

But many a times, Google does not show the published date of the articles and because even the article does not have any date mentioned on it, you are uncertain about the age of the article.

So, I share two methods of achieving this:

Method 1:

I thank my friend Shashank for helping me in this. So here it goes:

#1: Suppose, I am searching for pdf on literacy rates, so my original search will be something like:
                                                          informat: pdf literacy rate

[and the address bar will be like this: https://www.google.co.in/search?q=informat%3A+pdf+literacy+rate&oq=informat%3A+pdf+literacy+rate&aqs=chrome..69i57j69i58.18910j0j7&sourceid=chrome&es_sm=93&ie=UTF-8]



Now the trick lies in passing one more parameter in the query string [what ever is after ? in URL is known as query string, its a key-value pair and one of the easiest way to pass values between pages]

So we will add &as_qdr=y15 to the query string and now the query string will look like
[https://www.google.co.in/search?q=informat%3A+pdf+literacy+rate&oq=informat%3A+pdf+literacy+rate&aqs=chrome..69i57j69i58.18910j0j7&sourceid=chrome&es_sm=93&ie=UTF-8&as_qdr=y15]

Method 2:

Open Internet Archive Wayback Machine, [URL: http://archive.org/web/]

Paste the URL in the box and Voila you can track the history of the article since the beginning of time!



Happy Searching!

Regards,
Vipul

If you know any other method, please share it with me on the comments section.

Tuesday, 3 February 2015

Google Little Known Tricks - Part 1

Holla Guys!

Today, I am going to write a small post on how Google's caters to the child inside you!

Trick #1

Here, we will learn to play Atari Breakout on Google images. So let's get started:

#1: Open Google Images. URL: https://images.google.com/

#2: Search Atari Breakout and start playing:



Trick #2

You can rotate your Google search screen 360 degrees like the way you have seen in MS Powerpoint

#1: Search for do a barrel roll on Google and wait and watch!



Trick #3:

To bypass proxy in China where Google was banned, this trick was of utmost importance:

Google when spelled backwards becomes elgooG, But the interesting fact is that you can use http://www.elgoog.im for searches.



Rest is Next.

Cheers!

Wednesday, 28 January 2015

Get Flipkart's Item Details in an Excel File Using jQuery

Hi fellas!

Kak bbl Bce? [pardon my Russian, I just meant to ask, "how are you all?"] :P

Today we are going to replicate some functionality of WebHarvy Web Scrapper. You can get more documentation on this tool at its official website, https://www.webharvy.com/ [wait for my new posts on this!]

So, in today's blog, we will try to retrieve data from Flipkart after making a search for laptop into an excel file using jQuery (a client side scripting language, can read about it at http://jquery.com/ or wait for my new posts).

I recommend Google Chrome for this trick! So let's get started:

#1: Open Google Chrome. Navigate to Flikart.com and then search for laptop and hit enter



#2: Press F12 (in laptops, you may have to press Fn + F12 simultaneously). You will see Web Developer window, either at the bottom or at the right side of the web page.



Click on Console 

#3: Now paste the following code into the "Area for writing jQuery scripts"

var title="";
var price="";
var html="<table><tr><td>Title</td><td>Price</td></tr>";
$('#products .gd-col').each(function(){
title=$(this).find('.pu-title a').text();
price=$(this).find('.pu-price .pu-final span').text();
var tempdetails="<tr><td>"+title+"</td><td>"+price+"</td></tr>";
html=html+tempdetails;
});
html=html+"</table>";
window.open('data:application/vnd.ms-excel,' + encodeURIComponent(html));



and hit Enter. You may receive download exception. In that case, select the radio button which says to allow download from this web-site.

#4: There will be an excel file downloaded to your system. Open it



You may receive format error. Don't worry about that, click Yes



And that's it! You have all the data in an excel format available at your disposal. You can tweak the code to include other options in separate columns in excel.

I have tested the code in Chrome, and not sure about how it behaves in Mozilla or IE. 

Please use the comment section to let me know the result of running this code on other browsers.

El descanso es proximo!

Adios.

Saturday, 3 January 2015

Reset Firefox to its Default State

Hi pals!

I wish you all a very happy new year and welcome you to this exiting world of tips and tricks. May our learning be exponential this year!

We begin this year by learning to reset Mozilla Firefox to its default state.

Now why would you do this?
Possible explanation are to get rid of Extensions and themes, website permissions, user styles and social features, download actions, plugin settings, toolbar customizations etc.
But Firefox saves certain things as well. You can get a complete list from here

So let's get started:

#1: Find the 3 horizontal lines on the Toolbar and follow the steps in screenshot:



#2: Click on Troubleshooting Information



#3: Click on the Reset Firefox button as shown below:



That's it. Once done, you will see Old Firefox Data folder on your systems' desktop


This folder will help you to restore some important old data from your old Firefox. I will talk about it in my later blogs.


Wish you a very happy new year again!

Cheers!
Vipul

Sunday, 14 December 2014

Configure Microsoft Outlook in 5 Steps

Hallo Freunde!

Hoffe sie alle sind gut! [Hope you are all good]

Today, we are going to learn to configure MS Outlook(2010/2013) in 5 simple steps (4 actually). The credit for this article goes to Kavita Yajnik! So lets get started!

#1: Open MS Outlook 2010:


#2: This will direct you to:


Click on Next >

#3: Now click on Yes and then Next  > as shown below:


#4: Enter your mail details as shown:




and then click Next >

#5: And you are Done!!




Click on Finish to complete the process... 

And you can start using Outlook!


Hope this helps!

We will learn to Manually configure server settings (#4 radio button 3) in the next post.

Till then...

Auf wiedersehen!

Wednesday, 3 December 2014

Use Hindi Fonts in MS-Office Suite

Hi Friends!

Sometimes you might have encountered a situation where you receive a file and that file is created in Hindi. But as you do not have Hindi font (Kruti dev to be precise) in your systems, the file will open in some undecipherable manner. In this post, I will try to answer just that (thank you Alka Nehra for asking this question!)

So let's get started:

#1: Download the font from ffonts
[in case you know better sites, please share them in the comment section, please do understand that I am in no way responsible for any wrong which happens to your computer if you use this site!]

#2: Download the font

#3: Press CTRL+R in your keyboard to open the run window, type C:\Windows\Fonts and press OK:



 #4: Copy the font and paste it in the window which opens:



And you are done, now open the file again. This time around, it will make much more sense!

Hope it helps!

Rest Is Next..

Vipul

Saturday, 15 November 2014

Everything on Gmail 502 Error

Hola Chicos!

Esperanza[Spanish, English=>Hope] you are doing maravillas [Spanish, English=>wonders] with your computer.

Way back in 2013, in the month of May, we were plagued by 502 errors while signing-in to our Gmail accounts. To know more, click here [Thank you Ankur Sir for reminding me this!]



I was asked about this, but then I too faced it and had no idea what the hell is happening! So after a bit of research, I found out what Google has to say about this here


Phew, I can say, I was really expecting some technical information on what this is all about, but of course, who likes to talk ill of himself. [no offence intended]

So, my exploration led me to this great blog by Tim Fisher on PC Support. You can read his article here. Or copy + paste this URL in your browser:  http://pcsupport.about.com/od/findbyerrormessage/a/502error.htm

Because of the lucid language and exhaustive knowledge in the post, I do not find any need to repeat it. In case you still have any concerns/issues/problems, shoot them in the comment section below!

Nos vemus luego! [catch you later!]

Regards,
Vipul

Add 'Join this site' Button to Your Blog In 4 Steps!

Hi Vrienden,

Hoe gaat het? [that's Dutch for 'How are you?']

Today, we are going to learn to add Join this site button to your blogging site. [I thank Kavita Yajnik for this post]

Let me show you what I mean:




So lets rock and roll...

Step #1 Login to your blogging site. On the dashboard, click on any of the links [in the screen shot below, I have clicked on <<Hacks and Trick>>, it will have your blog name inside <<>>]



Step #2 On the left side of your screen, you will see the following. Follow it as per the arrows:



Step #3 Upon clicking Add a Gadget, you will see the following pop-up:



Step #4 You will have to scroll a bit to find Followers. [In my case, it shows Already added, if this is your 1st time, then it will show the + sign as it shows for the above gadgets in the screen shot]


And this is it! You are done...

Now call your friends to join your blog and spread awareness regarding the same!

Do let me know how many friends you added month wise using this gadget in the comment section below.

Rest is Next!

Goedenacht... ^_^
Vipul

Saturday, 30 August 2014

Full Forms Of SEO et al.

Hi Friends!

Pardon me for breaking my promise to write on manual malware removal from pen-drive. But the full forms that I am going to provide you now is very important for people like us(actually they were asked in a job interview!).

So let's get started:

#1. SEO: Searching Engine Optimization
#2. SEM: Searching Engine Marketing
#3. SMO: Social Media Optimization
#4. SEA: Searching Engine Advertising
#5. SMM: Social Media Marketing
#6. PPC: Pay Per Click

If you know some more, feel free to share it via the comments section.


Regards,
Vipul

Thursday, 28 August 2014

Basics Of Critical Path

Beste vrienden!

In today's learning, we will deviate a bit from our tips and tricks part and learn something conceptual. So, today, I will not be writing any prank, but some basic Gyaan! [This is my 50th blog folks ^_^]

So let us understand it in an Q&A format :

#1: What is Critical Path?
It is a sequence of activities scheduled that determines the duration of project plan.
Critical path method is an important method to distinguish critical activities from non-critical tasks to prevent conflicts and bottlenecks.

#2: Is it the longest or the shortest path?
It is the longest path through a project

#3: If it is the longest path, it should take the longest time for execution, right?
NO! [a very big NO], it determines the shortest time possible to complete the activities in the plan.

#4: Please explain.
The upper limit of earliest finish dates of all the task items identified in the plan is used to calculate the longest path through the plan.

Now, for the below Gantt chart, the task 4 (Resource C) will not feature in the CP. Even if we miss finishing it(i.e. C) in its stipulated deadline, we still have time to execute it because the above task (Resource A) takes more time to finish than C, hence extending C(till above A's finishing time) will not extend the overall deadline of the project. [If it does, then, we will have to create a new CP considering Resource C!]


                                        [Will try to upload a better quality image ASAP!]

Activities on CP must be completed according to planned schedule for the overall delivery of the project on time. If an activity on CP is delayed, the end date of the project is affected.
This tool is readily deployed by Project Managers as they prepare and track release schedules, plan for allocation of resources, take remedial actions is there is a need.

Next will be a tip on malware removal from pen drive without anti virus, I promise!

Adios!
^_^