Quarksoft Blog

This is where we post useful information for everyone. Lots of it is technical, but some can be used by anyone.

Archive for the ‘Software’ Category

Interesting feature within Windows 7

Windows users are excited over the discovery of a hidden “GodMode” feature that lets users access all of the operating system’s control panels from within a single folder.  In order to enable this feature all you need to do is to create a new folder and then rename the folder to the following:

GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

Once that is done, the folder’s icon will change to resemble a control panel and will contain dozens of control options.

I think most of these options are available elsewhere, but this provides a simple, easy-to-use method to access all of them.

Mail Merge from Microsoft Outlook

Created a short video about how to do a Mail Merge from Microsoft Outlook using the Categories option for Contacts.

See all the details here

Getting more useful information into Google Analytics

We use Google Analytics (GA) for all our sites and most of our client sites.   It often provides the most bang for the buck and makes slicing and dicing your analytics pretty easy to do.

On of the most interesting sections of Google Analytics is in the Visitors section and it is called User Defined.  This is an area that allows you to create some customized “tags” or “labels” for any of your visitors.

I could go on and explain all the nitty-gritty details, but guys over at Google Analytics have already posted a very detailed explanation on how to implement this capability and shows how it can provide additional value to the tremendous value that GA already provides.

To review all the User Defined details you just use the links already created in this post.

Clearing Email History Lists in Outlook

One of the great features of Outlook (but also sometimes annoying) is that it remembers all the email addresses of the people that you send email to or receive email from.  This makes it really easy for composing emails except for when you get an email address that is spelled incorrectly in that list.  That can be extremely frustrating.

Turns out that it is super simple to remove that email address.  Just compose and email and start typing the address.  When you see it appear, just use the arrows to select the one that is incorrect and press the Delete key.  It will be gone forever.  Quick and easy.

If you want to clear the entire email history, you can do the following:

  • Exit Outlook
  • Run Windows Explorer
  • Navigate to the C:\Documents and Settings\username\Application Data\Microsoft\Outlook folder (substitute username with your username)
  • Find the file with the NK2 extension and rename or delete it.

Remote Desktop with Multiple Monitors / Screens

A few weeks ago a client of ours asked if there was a way to get a Remote Desktop session to go full screen across the two monitors that they had connected to their computer.  There didn’t seem to be an obvious method to do this.  Upon some further research we discovered that there was a command line option for the Remote Desktop application called /span which allows a single session to span multiple monitors.

If you have two (or more) monitors that are the same height, you could issue the following command:

mstsc /span

When the Remote Desktop application starts up it will ask you what Computer you want to connect to.  Just enter the name or IP address of the computer and you will be connected in full screen mode across your two (or more) monitors.

Some notes from the Microsoft Help about what the /span option does and its limitations:

Matches the remote desktop width and height with the local virtual desktop, spanning across multiple monitors if necessary. To span across monitors, the monitors must all have the same height and be aligned side by side.

In order to save the /span option into the .rdp file you will need to manually edit it:

  • Open Windows Explorer, and browse to the folder containing the .rdp file you want to edit.
  • Right-click the file > Open With > Choose Program > Notepad (or any other text editing program you have installed on your computer)
  • Once the file is open in Notepad go to the bottom of the file and add the following command: span monitors:i:1
  • Save the file.

Now your rdp file will automatically span monitors when executed.

Great Script for Accessing IIS Configuration Properties

Need to extract information from IIS such as IP Addresses, Host Headers, Log Directories and lots more. This great little script from David Wang does a great job of this.  It saved me hours and hours of work going through all my IIS servers manually.

Thanks David!

So what do you do with all those IIS log files?

You are responsible for one or more Windows web servers and you have all these IIS log files that you want to make some sense out of.   If you have some basic SQL skills Microsoft is making available a utility called LogParser which does a great job getting in there and allowing you to query the files directly using some basic SQL syntax.   The feature I like the best is the ability to convert the data into a SQL table for manipulation via T-SQL.

Here is a sample of what I did (this would all go on a single line)

c:\”program files”\”log parser 2.2″\LogParser -iCheckPoint:myCheckPoint.lpc -o:SQL -server:localhost -database:IISLogs -createtable:ON “SELECT * FROM ex0810*.log TO IISLogs”

This short command line will read in all log files that start with ex0810 and import them into a table called IISLogs.  It will also create a checkpoint file so that if you run the command again it will not import records that have already been imported.

How cool is that?

Once all the importing is done you can leverage the SQL tables using whatever methods you need to.

If you need any help with stuff, send us a note at support at quarksoft.com.

Outlook 2007 Preview Pane made useful…

I finally had upgraded to Outlook 2007 about a month ago and one of the features I found myself using a lot was the Preview feature for attachments. It was great for the PDF and the typical office documents, but there were no preview handlers for files such as WAV. I have a VOIP line that emails me the voice mail messages that have been left so having a WAV previewer would be really useful for me.

During my search for such a feature I ran across a great utility from Gil Azar (and in his post gives credit to lots of others for their help). You can download the ultimate Outlook 2007 preview handler from his site.

If you are interested in some of the technical details Gil discusses them on his page and provides some really great links.

I’ve included parts of Gil’s original post just in case his site disappears one day.

A self-extracting installer, which silently installs Stephen Toub’s MSDN Magazine Managed Preview Handler Framework and Gil’s small addition, can be downloaded here

Command Line FTP Client with PASV support

I ran into a problem scheduling the transfer of a file via FTP today.  The server was behind a firewall that required me to use PASV FTP support.  Unfortunately the command line version of FTP that comes with Windows 2003 was not able to support this configuration (at least I could not figure out how to make it support it).

In trying to figure out a solution to this issue I ran across NcFTP.  This is primarily a *nix based FTP tool (both server and client), but it has a Windows command line version of FTP that proved to be just the tool I needed.  You can download the Windows version of the client or if you prefer they have lots of *nix flavors.

Easy method to download a portion of a web site

I have this client that posted several hundred files on their internal web site that I needed to download to my laptop for testing purposes.  I started downloading them one by one and thought that there must be a better way without installing some big application to do this.  With a little Google searching I found a great open source utility called wget that provides everything I needed from a command line (which had the added bonus of being able to easily script it).

An example of the command to recursively download a web site is shown below:

wget -l2 -r -k http://www.siteyouwanttoget.com/folder1

  • The -l parameter tells the software how many levels to download (I only needed 2 levels deep in my example)
  • The -r parameter tells it to download recursively
  • The -k parameter tell is to convert non-relative links into relative ones so that there will not be any dependencies on the original site.

So there you have it. One simple, small 162Kb EXE that does exactly what I needed (it also does ALOT more than this). Have Fun!

Need to make screen captures for documentation?