2) Get a list of files in worksheet by using a web browser

If you want to list files in a folder by using the web browser, you should make sure you have one of the web browsers (Firefox, Opera and Google Chrome) installed in your computer. Supposing you need to list files of following folder (list files in worksheet) in worksheet, see screenshot: (It’s applicable in Windows XP, Windows Vista and Windows 7. )

1. Go to copy the path of the folder (dt kte) in Explorer. For example, the path of this folder is: C:\Users\dt\Desktop\dt kte.

2. Open one of the web browsers (FireFox, Opera and Google Chrome) and paste the folder path in the address bar and press Enter key. See screenshot:

3. Click Ctrl+A to select all contents in the web browser and press Ctrl+C to copy them.

4. Open Excel and directly paste (using Ctrl+V shortcuts to paste) them in a worksheet. See screenshot:

Disadvantage: this method cannot list files in the subdirectory.

RescueTime

RescueTime — Your Daily dashboard

A personal analytics service that shows you how you spend your time on the internet.

Provides tools to help you be more productive.

It also tracks your activity on desktop based software.

It differentiates your time by categories and also provides the total hours spend on those activities, for example any activity related to development (website or software) would be included in Software development category. Social networking realted activities would be included in social networking category.

You can create your own goals, eg spending less than 30 minutes on social networking websites

RescueTime monitors your internet activity and notifies you whether you have successfully meet your goals or not.

Bulk Removal of Post Thumbnails or Featured Images in a second

All you need to do is copy and paste below code in your theme’s functions.php file.

global $wpdb;
$wpdb->query( "
    DELETE FROM $wpdb->postmeta 
    WHERE meta_key = '_thumbnail_id'
" );

Important Note: Please remove this code immediately after saving your functions.php file. You will not be able to set featured images in WordPress as this code will keep removing featured images from posts.

Setting up a PC for testing

There may be times when browser testing online may need to be supplemented with an actual machine. Just follow these simple steps and you are good to go.

1.) If a PC is already running (i.e. has an OS already installed) check the hardware configuration and note it down. Also write down the size of the drive that the current OS installed.

2.) Check if a virtual machine can be installed for the testing OS depending on the machines configuration. Google this for best results.

3.) If you need to install a fresh OS use the windows CD for the version desired. In case your PC does not have a CD drive then you will need to make a bootable pendrive.

4.) For that first download: Daemon tools lite. It will enable you to create a virtual CD-Rom of the installation file. Follow the instructions when to use this program.

5.) The above step is also called mounting the file or image (of the executable program). Now download this: Win to Flash it will enable you install the new OS on to a pen drive which is made boot-able and can used from the BIOS menu during PC start up.

6.) Repeatedly press DEL button during PC start up to bring you to the BIOS window. Set the boot-able device to the pen-drive that you have connected to the PC then save and exit.

Follow the instruction (ensure you format the harddrive whos size you have written down earlier. If its a fresh pc then you will have to set a partition for which 20GB space is good) till the OS is installed and ready and then restart the PC and change the booting preference to the internal hard-drive save and exit.

Happy Testing…. :)

Better thumbnails in WooCommerce

Recently we uploaded a lot of products and images for a shopping website that we’re making. The thumbnails generated automatically by woocommerce were not good though. This is what we did to improve them.

We unchecked all hard crop in woocommerce settings and set the images to sizes to be the following

Catalog Images:-width-150 height-150

Single Product Image:-width-575 height-388

Product Thumbnails:-width-200 height-200

We rebuilt all the thumbnails at one go Ajax Thumbnail Rebuild using to the changes done for your images at once rather uploading the images again.

We added this CSS to make the new thumbnails more centered.

For outer image div

ul.products li.product a.image_wrap{

height: 150px; width: 150px; position: relative; margin-left: auto; margin-right: auto;}

For the inner image div

ul.products li.product a img

{display: block; position: absolute; margin: auto; top: 0; left: 0; right: 0; bottom: 0;}

Wildcard CSS

If you want to add the same css selectors to a bunch of classes like (grid-1, grid-2, grid-3, grid-20), then no need to mention them one after the other.

Just write some css like this

[class*=”grid-“]{

float:left;

padding:0px;

margin:0px;

}

BuildWith — A technology lookup

BuiltWith provides a list of technologies of companies, just by entering the desired companies url in the search bar.

With respect to the technologies used, it also provides the overall usage statistics for those technologies.

Provides a list of trending technologies used in a specific category.

Provides usage statistics based on Top 10k, Top 100k and Top million sites with respect to a specific technology.

Lets say, we want the usage statistics for Ruby on rails

We get the usage statistics based on top 10k,100k sites, and the entire web.

Company wide development wiki

Evernote can be used to save snippets of information when you find them. It could be code snippets, steps to install software or just links to the site where the issue was resolved.

We share these notes amongst each other and voila company wide development wiki.

Evernote is free — so no need to manage the software. Plus its has a great web based user interface and desktop app.