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.

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

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!

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

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

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

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!
^_^

SVCHOST.EXE Using All RAM + Abnormally High CPU Usage Part - 2 Resolution

Hi Friends!

This posts is in continuation of my earlier post on svchost.exe [thanks Shree for the query!]

As promised in that post, Let us resolve it now:

Go to Start | Settings | Control Panel and double click Automatic Updates or Windows Update.

Checkmark/Select the bottom option to disable automatic updates.

Click Apply/OK and then reboot.

Check if svchost still consume 100% CPU cycles? If no, we are done for the day! :)

If it does, do the following.

Go to Start, Run, copy/paste this command and click OK: services.msc

In the list of Services, can you see Background Intelligent Transfer Service ?

Here's a pic of what it looks like:

If it's not listed, please proceed as follows to register the BITS service.

Open the Windows Search tool, copy/paste the following and then click Search: qmgr.dll

Search should show that file in the following locations:

C:\WINDOWS\system32

C:\WINDOWS\ServicePackFiles\i386

C:\WINDOWS\system32\bits

It may only be present in C:\WINDOWS\system32, but provided you can see it, do the following to register the service.

Go to Start, Run and copy/paste: regsvr32 qmgr.dll and click OK

Do the same with this file: regsvr32 qmgrprxy.dll

Reboot the system and then copy/paste this command into the Run field:

%windir%\System32\rundll32.exe setupapi,InstallHinfSection DefaultInstall 132 %windir%\inf\qmgr.inf

If you're prompted to insert the Windows installation CD, ignore that and in the dialog box at the bottom, change the path to C:\WINDOWS\ServicePackFiles\i386

If you could only see qmgr.dll in C:\WINDOWS\system32  change the path to that instead.

Restart the PC again and then go to Services and you should be able to see BITS in the list.

Double click it and then on the General tab, click the Start button to try and start the service manually. This is just a test to ensure that it's working correctly.

If you get Error 2: cannot find the file specified, go to Start, then Run again and copy/paste the following command and then click OK:

Reg add HKLM\SYSTEM\CurrentControlSet\Services\BITS\Parameters /v ServiceDll /t REG_EXPAND_SZ /d %windir%\System32\qmgr.dll

Reboot again and then try once more to start BITS. It should work properly now, but in the unlikely event that it fails again, run the following command and then hit Enter:

Reg add HKLM\SYSTEM\CurrentControlSet\Control\BackupRestore\FilesNotToBackup

Reboot once more and then do the following.

Go to this link and install the  IE8 cumulative December update:

http://www.microsoft.com/en-gb/download/details.aspx?id=41404 

If you use IE7, use this link instead:

http://www.microsoft.com/en-gb/download/details.aspx?id=41442

If you use IE11, use this link instead:

http://www.microsoft.com/en-us/download/details.aspx?id=42463

Finally, go to the Windows Update site and you should be able to download normally.

[Reference: Microsoft]

SVCHOST.EXE Using All RAM + Abnormally High CPU Usage Part -1 Basics

Hi Friends!

Apologies for the delay in the posts! [This is also my 1st post in Segoe UI font, looking for a feedback on this readers! :) ]

This post is in response to a query by Shree Nidhi

Let us try to understand its basics in this post:

So What Is It?

According to Microsoft: “svchost.exe is a generic host process name for services that run from dynamic-link libraries”. 

Meaning?

Some time ago, Microsoft started moving all of the functionality from internal Windows services into .dll files instead of .exe files. From a programming perspective this makes more sense for reusability… but the problem is that you can’t launch a .dll file directly from Windows, it has to be loaded up from a running executable (.exe). Thus the svchost.exe process was born.

Why Are There So Many svchost.exes Running?

If you’ve ever taken a look at the Services section in control panel you might notice that there are a Lot of services required by Windows. If every single service ran under a single svchost.exe instance, a failure in one might bring down all of Windows… so they are separated out.

Those services are organized into logical groups, and then a single svchost.exe instance is created for each group. For instance, one svchost.exe instance runs the 3 services related to the firewall. Another svchost.exe instance might run all the services related to the user interface, and so on.

So What Can I Do About It?

You can trim down unneeded services by disabling or stopping the services that don’t absolutely need to be running. Additionally, if you are noticing very heavy CPU usage on a single svchost.exe instance you can restart the services running under that instance.

The biggest problem is identifying what services are being run on a particular svchost.exe instance… we’ll cover that below.

If you are curious what we’re talking about, just open up Task Manager and check the “Show processes from all users” box

References: howtogeek

Feel free to add more on this in the comments section below.

I will write for its possible resolution in the next post.

Regards,
Vipul