Correct Your House or Business on Google Maps

This article was written on November 19, 2007 by CyberNet.

Google Map Marker There has seemed to be a lot of love and care for Google Maps lately. They just announced a new feature that lets anyone customize the location of a business, or even an address such as your own house.

All you have to do is perform a search for the address on Google Maps, and click on the marker that is pointing to the result. You should see a little bubble popup with details about that address/business, and then click the Edit link. After that you should be able to drag the marker around to the new location (pictured to the right).

So what about the people who are going to try and cheat the system by falsely marking locations? Google has already thought about that, and if you try to move the marker more than 200 meters it will be subjected to further review before appearing on Google Maps. They also provide a “move to original location” option so that people can always send the marker back to the original point in just a click.

The new service seems to be working really well, except for when editing some addresses I’ll receive an error saying “Because of technical restrictions, you cannot edit this location at this time.” Changing the location of businesses, however, works without any issues.

If people actually start using this maybe we’ll correctly know what side of the street an address is actually located on! Smart move Google.

Google Maps [via Google Maps Blog]

Copyright © 2011 CyberNetNews.com

Related Posts:


Post to Evernote via Twitter

This article was written on July 20, 2010 by CyberNet.

In the past year I’ve become a pretty big Evernote user, and have even gone as far as to purchase a premium account. Last week the Evernote team expanded their service even more with Evernote Trunk, which is a centralized area to find third-party hardware and software that works with Evernote. When I saw that I realized that I have never written about the Twitter integration that has already been around for awhile.

Why is this useful? Well, if you’re on-the-go you can quickly send yourself a reminder to your Evernote account with a simple text message. After you follow the steps below you can send a text message in the format of “d myEN [your note]” to 40404 (that’s the U.S. number). The note will then appear directly in your Evernote account inside of your default notebook.

What does it take to link your two accounts? It’s actually pretty simple…

If you have a public (non-protected) Twitter account, then do the following:

  1. Follow myEN on Twitter (you will need a Twitter account)
  2. myEN will follow you back, and send you a DM with a link (this took about 24-hours for me)
  3. Click the link, sign into Evernote, and connect your Evernote and Twitter accounts

If you have a protected Twitter account, then do the following:

  1. Follow myEN on Twitter (you will need a Twitter account)
  2. Accept myEN’s follow request
  3. Send a DM to myEN
  4. myEN will send you a DM with a link
  5. Click the link, sign into Evernote, and connect your Evernote and Twitter accounts.

Once you have your Evernote and Twitter accounts linked you can move on to the testing phase. To test this out you either need to include @myEN in a tweet, or send @myEN a direct message.

twitter evernote dm.png

If you used the direct message method you should find that the message appears in your Evernote account almost immediately.

twitter evernote app.png

Enjoy posting to your Evernote account using Twitter!

Copyright © 2011 CyberNetNews.com

Related Posts:


Deleting Locked Files (32 and 64-bit)

This article was written on August 12, 2009 by CyberNet.

lockhunter.png

arrow Windows Windows only arrow
It seems like on Windows I always come across those pesky files I can’t delete because another process is using it. Up until a few months ago I had always used a program called Unlocker to get around this, and it has served me well. I had to stop using it, however, when I moved to Vista 64-bit since it only includes support for 32-bit versions of Windows.

LockHunter, on the other hand, is a similar free utility that works on Windows 2000 up to Windows 7, and comes in both 32-bit and 64-bit flavors. Just like Unlocker it integrates into your Windows Explorer context menu to save some clicks each time you want to unlock a file.

Here’s a rundown on some of the features:

  • Shows processes locking a file or folder
  • Allows to unlock, delete, copy or rename a locked file
  • Allows to kill locking process
  • Allows to remove locking processes from hard drive
  • Integrates in to Explorer menu
  • It deletes files into the recycle bin, so you may restore them if deleted by mistake
  • Supports both 32 and 64-bit Windows

There’s just one more thing that I’d like to see LockHunter do, and that’s add a command-line interface. I have some scheduled tasks that used to use Unlocker’s command-line functionality to ensure that a a file wasn’t locked before trying to perform an operation on it. Unfortunately automated tactics like this don’t appear to be possible in LockHunter, but I’m sure that’s something they could easily add. Oh, and a portable version would also be pretty cool.

LockHunter Homepage (Windows only; freeware)
[via Lifehacker & gHacks)

Copyright © 2011 CyberNetNews.com

Related Posts:


CyberNotes: Highlight Cells Based on Value in Excel

This article was written on November 22, 2007 by CyberNet.

CyberNotes
Tutorial Thursday

For some weird reason, I’ve been a Microsoft Excel addict for as long as I can remember. When I was younger I remember being told by one of my teachers that Excel is one of the most powerful applications available, but most people will never touch it with a ten foot pole.

For over 7 years I’ve been programming Visual Basic for Applications (VBA) in Excel, which is essentially a way to extend Excel to do everything your heart desires. With it you can add more formulas, and create buttons that will execute queries on the data located in your spreadsheet. VBA is one of Excel’s best features in my opinion.

What I’m going to cover today is how to highlight cells based on their values in Excel 2007. This method is extremely simple and doesn’t use an ounce of VBA, despite an abundance of sites out there saying that VBA is required to do such a task. It’s all about Conditional Formatting!

Tip: This tutorial was created for Excel 2007, but the general principles will also work in older versions of Excel. The free OpenOffice.org Suite even has a Conditional Formatting option located under the Format menu, but it’s pretty basic compared to the one in Excel 2007.

–Preparation–

Cell Highlighting Starter

The values in column “C” and “D” are both formulas that I created to calculate the age of the person, and then how many days are left until their next birthday. That way I can prepare gifts or cards for any upcoming birthdays well in advance. The only problem is that when the list gets large it can be hard to see what birthdays are coming up.

I’m not going to walk through what all of the formulas mean, but to make it easier to follow along with our example, here’s what the content of the second row looks like:

  • A2: John
  • B2: 11/19/1984
  • C2: =FLOOR(YEARFRAC(TODAY(),B2),1)
  • D2: =DAYS360(TODAY(),DATE(YEAR(B2)+C2+1,MONTH(B2),DAY(B2)))

What I want to do with the data is highlight anyone with a birthday that is coming up within two weeks. To do cell highlighting, a lot of sites talk about how to use the Visual Basic for Applications (VBA), but that’s way more work than needed. It’s actually really easy to do …

–Instructions–

Note: Most of the screenshots below are thumbnails, so click on them for a fullsize version.

  1. The first thing that you need to do is fill in a spreadsheet with some data to apply the conditional formatting. I’m using the data that I provided above for keeping track of birthdays, but you can use whatever you want.
    Cell Highlighting Step 1
  2. I want to have the birthdays highlighted that are coming up in the next two weeks, so I need to highlight the cells in column “D” for that:
    Cell Highlighting Step 2
  3. On the Home Ribbon is the Conditional Formatting option. Click on that and select the option for a New Rule.
    Cell Highlighting Step 3
  4. There are several different types of data that you can look for in the cells that you’ve highlighted. For example, you can have duplicate entries or max/min values highlighted. For us we want to choose the Format only cells that contain option, and we want to check for a cell value that is less than 14. After that is entered in press the Format button.
    Cell Highlighting Step 4
  5. Now we need to pick what the cells should look like that match the criteria, which in our case is all birthdays that occur in less than 14 days. I chose to make the background orange and also made the text bold.
    Cell Highlighting Step 5
  6. You should see a preview of what matching cells will look like. Just hit the OK button to complete the conditional formatting.
    Cell Highlighting Step 6
  7. Yay, it worked! Looks like John has a birthday coming up in 4 days!
    Cell Highlighting Step 7
  8. Anytime the values in these cells change, Excel will automatically reanalyze them to see if they meet any of the conditional formatting rules. That means that once John’s birthday passes in 4 days it will no longer be highlighted.

This is just one of the nearly unlimited uses for conditional formatting. I use this all of the time in my spreadsheets because it helps recognize when an item needs attention. Some things I’ve used this for in the past is attendance lists for parties to highlight who’s coming and who’s not, budgets to see when money is getting low, gift lists to pinpoint who I still have to buy for, and a countdown fir events (similar to the birthday example I did in this article), and much more. Get creative!

Copyright © 2011 CyberNetNews.com

Related Posts:


Free Hard Drive Space Analyzer with Advanced Reporting

This article was written on January 06, 2011 by CyberNet.

hard drive analyzer-1.png

arrow Windows Windows only arrow
I’ve tried all kinds of hard drive space analyzers because I hate having excessively large files laying around for no good reason. We’ve already written several articles on some of the programs out there that will help you crack down on large files and folders (including this long list of apps), but we’ve got another one to show off. An app I recently stumbled across called Xinorbis is one of the most powerful hard drive space reporting tools that I’ve come across.

What makes Xinorbis so special? It has a long list of ways to breakdown all of the file and folder size information. You can see that there is a summary page pictured above, but there are also layouts that will let you essentially navigate your system folder-by-folder drilling down until you find those large files eating up all your hard drive space. You can also get a list of duplicate files based on whether they have the same name or the same size.

Here’s are some of the other features:

  • Analyze a single drive, folder, or merge several together in one report
  • View the results by file type, attributes, size, user (owner) and date
  • The Folder History feature allows you to compare the contents of a folder or drive at times and dates
  • Built-in search engine with the ability to save results to a file or clipboard
  • Find duplicate files by name or size
  • Complex report generation with export to HTML, ASCII, CSV or XML
  • Save reports and tables for later comparison or for inclusion in other documents
  • Scan a directory through Windows Explorer

If you’ve been yearning for a hard drive analyzer that has a variety of reporting formats you should definitely try this one out. It also comes in a portable format for those of you that don’t want to go through an installation process.

Xinorbis Homepage (Windows only; Freeware)

Copyright © 2011 CyberNetNews.com

Related Posts:


How to Test Your Boot Time

This article was written on February 23, 2011 by CyberNet.

Boot time

arrow Windows Windows only arrow
You know when someone tells you their computer takes 20-minutes to boot up, and you roll your eyes because you know they are just exaggerating. Well, there is a way to find out. All you have to do is install BootRacer on their machine, and then restart it. The application will keep an eye on certain events such as how long it took the user to login and how long it took for their desktop to finish loading, and it will report back.

One of the cool things is that BootRacer actually displays a window in the lower-right corner of the screen after you’ve logged in showing how long it has taken to startup thus far. It will continue incrementing the timer until all the startup apps have finished loading, and will alert you once it has completed.

Here’s a rundown on some of the features pointed out by the developer:

  • Automatically calculates your Windows boot time.
  • BootRacer uses minimum of computer resources.
  • Runs under the non-administrator accounts.
  • BootRacer logs all the results to the history report and to standard event log. You can check events using Windows Event Viewer.

The history report feature may not seem all that useful, but with it you may be able to pinpoint when some sort of change was made to the machine that significantly slowed it down. You might even be able to salvage some time by simply rolling the computer back to a restore point before the slow-down occurred.

BootRacer is free for non-commercial use, and can be helpful when fixing someone’s computer. If you run it before and after the optimizations you’ll actually be able to give them real-world numbers as to how much faster their computer is thanks to your magical tweaks.

BootRacer Homepage (Windows only; Free for non-commericial use)

Copyright © 2011 CyberNetNews.com

Related Posts:


Helpful Tip: Restore Firefox Tabs & Windows

This article was written on December 27, 2007 by CyberNet.

Firefox Show Windows Tabs

In the Firefox settings there is an option to show the “windows and tabs from last time” when starting up the browser. This is handy for anyone who wants to close their browser, but retain any windows and tabs that were previously open for the next session.

Previously I never understood how this feature could be used to restore windows without the help of an extension. When I close Firefox I always use the red “X” in the upper-right corner of the window. Doing that, as expected, would only make Firefox remember the last window that I had open.

In a comment on a previous post DKong and netster007x were able to make an intelligent observation that never even crossed my mind. If you use the File -> Exit command when closing Firefox all of the open Firefox windows will be closed at the same time. The next time you go to restart Firefox all of your previously opened windows will be restored.

I never really thought that there was a purpose to the File -> Exit command, and I figured it was just there because that’s standard practice. As it turns out there is a surprisingly useful reason for it to exist! The next time you want Firefox to remember your windows and your tabs just use File -> Exit.

Copyright © 2011 CyberNetNews.com

Related Posts:


Test Your Hard Drive Speed

This article was written on April 08, 2010 by CyberNet.

hard drive speed test.pngarrow Windows Windows only arrow
Hard drive performance is something a lot of people never think twice about. What would your response be if you were asked what the read/write speed of your hard drive was?

You can get the answer to that question pretty easily. A free and portable utility called HD_Speed will test the transfer speed of a hard drive, CD/DVD drive, USB drive, memory card, and just about anything else that shows up as a drive letter on your PC. You can also have it measure either sustained or data burst rates.

The nice thing is that this app is simple, but still includes all of the features you really need. You can choose whether you want to test read, write, read/write, or read/write/verify speeds. You can also put in a specific duration that you want the test to run for, which makes it easier to get an accurate average speed.

It’s not a ground-breaking program, but it is easy to keep stored on a USB drive since it consists of a single 92KB executable. Go ahead and grab it if you’re wondering just how well one of your drives performs.

HD_Speed Homepage (Windows only; Freeware)

Copyright © 2011 CyberNetNews.com

Related Posts:


Push Gmail on the iPhone

This article was written on July 08, 2009 by CyberNet.

iphone push email.pngI’ve been waiting a long time for someone to come up with a way to get push notifications on my iPhone for my Gmail accounts, but up until today there wasn’t really anything available. Thanks to an iPhone app called Prowl I’m now receiving nearly instantaneous push notifications on my phone.

The one downside for a lot of people is that this app will require you to have some sort of computer running (either Windows or Mac) during the time you want to receive the notifications. For me I didn’t even have to think twice about that, because I have a Windows machine running 24/7 that does a combination of downloads, backups, and television recording. For others that might be a deal breaker.

So how does it work? I’m about to tell you how I set it up to send me push email notifications for all of my Gmail accounts. There’s basically three things you need: Prowl for your iPhone (of course), Growl (for Windows or Mac), and Thunderbird. We’re going to also show you how to setup Thunderbird to utilize Gmail’s IMAP IDLE (sometimes referred to as Push IMAP) functionality so that Thunderbird doesn’t go out to fetch new emails. Instead Gmail sends them to Thunderbird almost instantaneously.

–Step 1: Get Prowl–

The Prowl iPhone app is a critical part of this puzzle. It basically serves as a middleman between your home computer and your iPhone. The software on your computer will send notifications to the Prowl servers, which will then relay on a push notification to your phone.

The iPhone app does cost $2.99, but I didn’t mind paying the one-time fee considering that they need money to keep their servers up and running. Then after you buy the app (or you can do it before you buy the app) head on over to their site to create a quick account.

–Step 2: Get Growl–

I’m going to focus on using Growl for Windows here, but Lifehacker has a great guide on setting up Prowl + Growl on a Mac. If you follow their Mac instructions you can always skip back to Step 4 in our article for configuring Thunderbird.

Once you’ve grabbed Growl for Windows go ahead and install it. You’ll probably be surprised to see that it doesn’t support notifications for any apps out-of-the-box, but that’s not a big deal. They have a centralized download page for the available add-ons.

Once you’ve got Growl running you’ll need to get it setup to talk to the Prowl servers. In the Growl configuration just go to the Network tab, click the plus sign, and then choose the iPhone option:

growl setup-1.png

Then just enter in your Prowl credentials that you setup in the previous step.

–Step 3: Get Thunderbird–

If you looked at the add-ons page for Growl you might start to wonder why we aren’t just using the dedicated Gmail solution. Two reasons. First, it only supports one Gmail account. Bummer. Second, it is only capable of “fetching” your emails at a specified interval. Double bummer. Thunderbird overcomes both of these things.

So head on over and get Mozilla Thunderbird which is a free email client. After you get it running you’ll want to grab the Growl extension for Thunderbird. Installing extensions can be a pain in Thunderbird, but generally what I do is save the extension to my computer, and in Thunderbird go to Tools -> Add-ons. Then just drag-and-drop the extension anywhere in that window. You should then receive a prompt to install it.

I’ll give you a heads up now that after installing the extension there isn’t a whole lot you can configure. Then again, there’s isn’t all that much that you’d probably want to configure. Here are the available settings:

growl thunderbird.png

One thing the settings are good for, however, is the “send test message” button. If you’ve done the previous steps you should be able to hit that button and receive a push notification on your iPhone.

–Step 4: Setup Gmail Accounts–

Alright, now the fun part… hooking all of this up to your Gmail account(s)! Here’s the play-by-play for setting up your Gmail account in Thunderbird so that it uses the IMAP IDLE functionality, which is very close to having push:

  1. IMPORTANT: Make sure you have IMAP enabled in your Gmail settings before proceeding.
  2. In Thunderbird go to File -> New -> Account.
  3. Choose the Email Account option… do NOT choose the “Gmail” option since that tries to use POP3 instead of IMAP. Click Next.
  4. Enter your name and the email address you want to use. Be sure to include the “@gmail.com” (or whatever domain you have tied to a Google Apps account). Click Next.
  5. Choose the IMAP bubble. For the incoming server enter imap.gmail.com into the box. For the SMTP server enter smtp.gmail.com into the box. Click Next.
  6. Enter your Gmail username (with the @gmail.com) into the incoming and outgoing boxes. Click Next.
  7. Pick any name for your account. Click Next.
  8. Verify the settings, and click Finish.
  9. You’re not quite done yet. Go to Tools -> Account Settings. Find your account in the sidebar, and click the Server Settings option underneath it.
  10. Set the port to 993, fill in the SSL bubble, and uncheck both the Check for new messages at startup and the Check for new messages every XX minutes.
    gmail imap.png
  11. In the left sidebar of the Account Settings you should see an option labeled Outgoing Server (SMTP), click that. Then select the email account, and click Edit.
  12. Change the port to 587, and fill in the TLS bubble.
    gmail smtp.png
  13. You’re done! Repeat these steps for however many accounts you want to add. Note that after you’ve created your first account Thunderbird won’t ask for SMTP information for each subsequent account.

At this point you may be wondering why you disabled the options to “check for new messages.” Simple… IMAP IDLE will take care of that. With these options unchecked you might be surprised to see that new emails show up almost instantly in Thunderbird. In my tests it never took more than 15 to 30 seconds after receiving an email for it to show up in Thunderbird.

–Step 4: Enjoy the Pushiness–

You are all set to receive your push notifications! There are some additional settings you can configure in Growl in regards to how the notifications look when they appear on the computer, but for the notifications to show up on your iPhone there isn’t really anything else you need to do. You can, however, set priorities for the notifications, and then choose which priority will be sent to your iPhone. That way you aren’t getting notifications for all of your Growl-enabled programs.

Here are some screenshots of Prowl hard at work:

(Click to Enlarge)
prowl homescreen.png prowl app.png

Overall I’d say the time from me hitting the send button to receiving the notification on my phone was between 30 and 45 seconds. That is good enough for me. Almost immediately after setting this up I went and set the fetching to “manual” on my iPhone, which should also help save on battery life.

Another plus about this is that my credentials for all of my accounts are never passed on to the Prowl servers. Anyone that is security conscious will always think long and hard before giving their password to some third-party service, but with this you don’t have to. All their servers receive is exactly what you see in your notification.

There are Growl add-ons for all kinds of other applications, too. You can get notified when a Firefox download is finished, hook it up to your Outlook emails, get notified when your machine is low on disk space, reminders for when your favorite TV shows are coming on, and even a message telling you when your Torrents have finished downloading. This has the ability to become very powerful.

This has quickly become one of my favorite apps on my iPhone, but it won’t be for everyone since it does require a computer that is on during the times you want to get notifications. And for just $3 I can’t complain.

Copyright © 2011 CyberNetNews.com

Related Posts:


Upgrading to the iPhone 4S? Here’s how to resell your old iPhone

It’s been a few days now since we checked out seven different iPhone resellers and determined the highest possible amount iPhone 3GS and iPhone 4 owners could get for selling their old iPhones. If the thought of selling your phone has been brewing in your head, now is a good time to do it. As […]