how to

How to upgrade Samsung Galaxy Portal to Android 2.1 (Eclair) using Samsung PC Studio

by Sujoy on September 23, 2010

The new Android 2.1, more popularly known as the Android Eclair, is now available to be downloaded on the Samsung Galaxy Portal on T-mobile UK. The catch is, this upgrade is not available over-the-air (OTA), but has to be initiated by the user using Samsung’s mobile PC suite – Samsung PC Studio.

This is ridiculous, since the Android is a modified version of the Linux kernel, and at its core, is Open Source. However, for the upgrade itself, it has to be connected to a Windows PC. More on that later. For now, let’s focus on the upgrading progress. And this process took me a good 4 hours to complete, until I found the easy and shortcut way to do it. Trust me, follow this process and the upgrade is done within 15 minutes flat!

galaxy-portal.jpg

What I did wrong before:

  • Installed Samsung PC Studio which was on the CD that came along with my phone.[ This is version 1.4. etc, which is an old one ]
  • Connected my phone via USB cable, and opened up Samsung PCS, and hit the Upgrade button.
  • It goes to download the latest install, and then on to Step 3, which is actual upgrade on the phone, and then it goes on for ages, whilst the phone keeps flashing the Samsung logo.

Here’s the right way to do it.

  • Install the latest version, just to be very sure. Go to Samsung Mobile UK website, and select Samsung Galaxy Portal-> Software, and download the 1.5 version of Samsung PC Studio.
  • Once installed { i.e. after uninstalling the previous version and installing this one } , connect your Samsung Galaxy Portal using the USB Cable. Mount your SD card.

[Continue Reading]

{ 8 comments }

Excel Tips: Cell selection with Excel Keyboard shortcuts

by Sujoy on September 12, 2010

Microsoft Excel TipsIn the past couple of months of working on Excel and VBA Macros, I have been exposed to a few challenges which in the course of time, I have overcome. So, I thought I would share them with my beloved readers. This section: Excel Tips aims at sharing the small tips and tricks that I have come across which makes life easier for anyone working with Excel or VBA Macros. Cheers!

Keyboard shortcuts are like the secret tools of every power Excel user. If we use too much of Excel in our day-to-day work, these handy Keyboard shortcuts on Excell cell selection will save a lot of time, and also save you from dragging the mouse into frustration land.

So here, we go.

Selecting entire Column (vertical ) : – Ctrl + Spacebar

Selecting entire Row (horizontal ) : – Shift + Spacebar

Selecting all rows & columns : – Ctrl + A

Selecting first active cell  : Ctrl + Home

Selecting last active cell : Ctrl + End

Selecting all columns from a particular cell to the beginning of the column: Ctrl + Shift + Left

Selecting all columns from a particular cell to the end of the column: Ctrl + Shift + Right

Selecting all rows from a particular cell to the beginning of the row : Ctrl + Shift + Up

Selecting all rows from a particular cell to the end of the row : Ctrl + Shift + Down

Selecting first active cell in a row: Ctrl + Left

Selecting last active cell in a row: Ctrl + Right

Selecting first active cell in a column: Ctrl + Up

Selecting last active cell in a column: Ctrl + Down

Do let us know if these simple tips helped you out, and leave your comments. :) Cheerio and happy exceling.

{ 0 comments }

Pwn YouTube with PwnYouTube to download Youtube videos

by Sujoy on August 20, 2010

Yes, we have done quite a few YouTube downloading how-tos in the past. Some of them still work, some don’t. The one which continues to work is the ever-updating awesome tool – KeepVid.com. But remember the good ol’ days of the javascript bookmarklet which used to make life so much easier. Well, the bookmarklet is back again.

And it’s called – PwnYouTube. Go drag and drop it on your bookmarks bar just as I did.

PwnYouTube Bookmarklet

Now when you visit a YouTube video, on the page, when you hit the bookmarklet, the menu option appears on top of the screen. Its on a yellow background, so I don’t think you’ll miss it. For your convenience, it looks like this.

PwnYouTube to download HD videos from YouTube

Right click, and save as shown. Voila! Easy peasy!

Else, there is another alternative. Just append ‘pwn’ before the youtube video URL.

e.g. To download video:  http://www.youtube.com/watch?v=66TuSJo4dZM, enter

http://www.pwnyoutube.com/watch?v=66TuSJo4dZM

You’ll be redirected to deturl.com, and there, you’ll find options to download it from SaveVid, YouDDL and KeepVid.

So there you go, happy downloading YouTube videos.

{ 0 comments }

How to add Facebook Like Button in Thesis WordPress Theme

by Sujoy on July 24, 2010

Facebook Like Button

We all love the Thesis WordPress theme, and its multi-functional layout which can be highly customised. And we also love the Facebook Like button, which is in a way Facebook’s answer to the Tweetmeme button. So, why not I show you how to incorporate the Facebook Like button in Thesis WordPress button.

To do this, all you need to do is to go to your custom_functions.php file and open it in an editor. You can have a backup just in case things don’t go according to plan. Now, once you have it opened in an editor [ or in your dashboard editor ], add the following code.

function add_fb_like_btn() {
if (is_single()) { ?>
<div style="float:right; padding-left:3px;"><iframe src="http://www.facebook.com/plugins/like.php?href=<?php echo urlencode(get_permalink($post->ID)); ?>&amp;layout=standard&amp;show_faces=false&amp;width=450&amp;action=like&amp;colorscheme=light" scrolling="no" frameborder="0" allowTransparency="true" style="border:none; overflow:hidden; width:450px; height:60px"></iframe></div>
<?php
}
else  { ?>
<div style="float:right; padding-left:3px;"><iframe src="http://www.facebook.com/plugins/like.php?href=<?php echo urlencode(get_permalink($post->ID)); ?>&amp;layout=standard&amp;show_faces=false&amp;width=450&amp;action=like&amp;colorscheme=light" scrolling="no" frameborder="0" allowTransparency="true" style="border:none; overflow:hidden; width:450px; height:60px"></iframe></div>
<?php
}
}
add_action('thesis_hook_after_headline','add_fb_like_btn');

You can customise the layout of the Facebook like button by changing what I have inserted in the

Please leave a comment if it worked out for you or otherwise. And also, go ahead and hit the Like button on this post :) Cheerio!

[Image Courtesy: Venture Beat ]

{ 0 comments }

← Previous Entries

Next Entries →