Apr 062011
 

A watermark is a faded out image that fills the majority of the page.  It can either be an image, or words.  Sometimes companies use words “CONFIDENTIAL” or “DRAFT” as watermarks to indicate what type of document you’re reading.  Other times, companies will use an image of their logo or a product as the watermark.
In Word 2010, it is easy to apply any image as a watermark to your documents.

  • Choose the PAGE LAYOUT tab. In the PAGE BACKGROUND group, choose WATERMARK
  • Choose CUSTOM WATERMARK.
  • Choose PICTURE WATERMARK and then SELECT PICTURE
  • Search for the image you want to use, then choose INSERT
  • Scale the picture as needed
  • Click WASHOUT checkbox to fade the picture so that the text in your document can still be easily read.

That’s it! If you want to remove the watermark, click the Watermark dropdown and choose Remove Watermark.

May 172010
 

How to install JDBC driver on Linux

To use MySQL with your java programs, you need to download the MySQL Connector-J from their website.

Download the tar.gz file and place it on a directory that you can access. (Suggested directory is /usr/local). Remeber the name that you used when you downloaded it.

You have access to /usr/local

Downloaded file name is on /usr/local/mysql-jdbc.tar.gz

Installing MySQL Connector-J

To use the Connector-J, you need to unzip and untar it. To do this, you have to enter this command on Linux:

cd /usr/local

tar -zxvf mysql-jdbc.tar.gz

At the end of these commands, the files would be placed in a folder called: mysql-connector-java-version.
Where version is the connector version number.
You can then copy the mysql-connector-java-version-bin.jar file in this directory to the java jre/lib/ext directory. Doing this will allow the java interpreter to find the driver.
Then your JDBC will work fine.

I still could not get my JDBC connector to work. JDBC looks for the mysql-connector-java-x.x.x-bin.jar in jre/lib/ext. I had to find where I installed java which was in (/usr/java/jre1.6.0_20). I copied the .jar file to /usr/java/jre1.6.0_20/lib/ext/) and I still discovered a few problems or things that I was missing:
1. I did not have a $JAVA_HOME variable set
2. I typed “which java” and I discovered that the default java location my system used was (/usr/bin/java). This was not where I installed java.
3. Finally, the directory where I installed java did not have /jre/lib/ext. I only had /usr/java/jre1.6.0_20/lib/ext NOT /usr/java/jre/lib/ext which is what JDBC needed to work correctly.

Problem 1 Solution: To set the global JAVA_HOME variable (Need to be root or have sudo privileges):
From the command line type: echo $JAVA_HOME
You should see the path to your java installation. If you don’t see anything then you don’t have the JAVA_HOME variable set.
To set this up you need to edit or create /etc/profile.d/java.sh and export JAVA_HOME to the path of your java installation. As I stated earlier my java installation path was /usr/java/jre1.6.0_20/. So my /etc/profile.d/java.sh file looks like this:

export JAVA_HOME=/usr/java/jre1.6.0_20
export PATH=$JAVA_HOME/bin:$PATH

After you save this file you need to implement the JAVA_HOME variable by typing: source /etc/profile.d/java.sh
Then you need to reload your profile by typing: . ./.bash_profile
Now when you type “echo $JAVA_HOME” you should see /usr/java/jre1.6.0_20.

Problem 2 Solution: This should have been fixed when you sourced /etc/profile.d/java.sh. If you type “which java” you should see /usr/java/jre1.6.0_20/bin/java or the equivalent if your java installation is different from mine.

Problem 3 Solution: Change directory to /usr/java/jre1.6.0_20 and create a symbolic link to jre by typing “ln -s /usr/java/jre1.6.0_20 jre”. This will force the JDBC connector to look in the correct path. If you want to test it type: cd $JAVA_HOME/jre/lib/ext. You should be in /usr/java/jre1.6.0_20/jre/lib/ext. Your .jar files should be in here too.

Jan 052010
 

Where does Microsoft Office Outlook 2007 save my information and configurations?

The following is a list of locations where Microsoft Office Outlook 2007 saves information.

Some of the folders might be hidden folders. To display hidden folders, do the following:

Windows Vista
In Windows, click the Start button, and then click Control Panel.
Click Appearance and Personalization.
Note If you are using Control Panel Classic View, double-click Folder Options, and then continue with step 4.

Click Folder Options.
On the View tab, under Advanced settings, under Files and Folders, under Hidden files and folders, select Show hidden files and folders.
Microsoft Windows XP
Click the Start button, and then click Control Panel.
Click Folder Options.

Click the View tab, and then click the Show hidden files and folders option.

Your configuration may not include all of the following files. Some files are created only when you customize Outlook features.

Personal Folders file (.pst)
Personal Folders files (.pst) contain your e-mail messages, calendars, contacts, tasks, and notes. You must use Outlook to work with the items in a .pst file.

When you archive Outlook information, items are saved in a .pst files.

Note Microsoft Exchange Server accounts store your information on the mail server. For Cached Exchange Mode or to work offline, copies of your items are saved in an Offline Folders file (.ost). See the Offline Folders file (.ost) section for more information. Also, some organizations allow you to export or archive your items to a .pst file.

Windows Vista drive:\Users\user\AppData\Local\Microsoft\Outlook

Microsoft Windows XP or Microsoft Windows Server 2003 drive:\Documents and Settings\user\Local Settings\Application Data\Microsoft\Outlook

Offline Folders file (.ost)
The .ost file is synchronized with the items on the server running Microsoft Exchange. Because your data remains on the Exchange server, you can recreate this .ost file on your new computer without having to back up the .ost file.

Windows Vista drive:\Users\user\AppData\Local\Microsoft\Outlook

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Local Settings\Application Data\Microsoft\Outlook

Personal Address Book (.pab)
Windows Vista drive:\Users\user\AppData\Local\Microsoft\Outlook

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Local Settings\Application Data\Microsoft\Outlook

Note Personal Address Books (.pab) are no longer supported by Office Outlook 2007. When you upgrade to Office Outlook 2007, you are prompted to import any .pab file into Contacts. If you choose not to import the .pab file, you can import it later by using the Import and Export command on the File menu.

Offline Address Book (.oab)
The Office Address Book (.oab) is used by Microsoft Exchange Server accounts. The Offline Address Book contains the properties of a user, such as e-mail addresses, that Outlook requires in order to send an e-mail message and display information about the user. By using the Offline Address Book, Outlook does not have to connect to Exchange in order to resolve names or open the records for each user. This reduces network traffic and improves performance.

You do not need to back up or restore this file. This is file is created and updated by Outlook.

Windows Vista drive:\Users\user\AppData\Local\Microsoft\Outlook

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Local Settings\Application Data\Microsoft\Outlook

Command bar and menu customizations (.dat)
Windows Vista drive:\Users\user\AppData\Roaming\Microsoft\Outlook\outcmd.dat

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Application Data\Microsoft\Outlook\outcmd.dat

Navigation Pane settings (.xml)
Windows Vista drive:\Users\user\AppData\Roaming\Outlook\profile name.xml

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Application Data\Microsoft\Outlook\profile name.xml

This file includes Shortcuts, Calendar, and Contact links.

Registered Microsoft Exchange extensions (.dat)
Windows Vista drive:\Users\user\AppData\Local\Microsoft\Outlook

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Local Settings\Application Data\Microsoft\Outlook

Outlook Contacts AutoComplete (.nk2)
AutoComplete is a feature which displays suggestions for names and e-mail addresses as you begin to type them. These suggestions are possible matches from a list of names and e-mail addresses that you have typed before, known as the AutoComplete name list.

Windows Vista drive:\Users\user\AppData\Roaming\Microsoft\Outlook

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Application Data\Microsoft\Outlook

Rules (.rwz)
Windows Vista drive:\Users\user\AppData\Roaming\Microsoft\Outlook

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Application Data\Microsoft\Outlook

Note If you upgraded to Office Outlook 2007 from a version of Outlook earlier than Microsoft Outlook 2002, you might have an .rwz file on your computer’s hard disk drive. The .rwz file is no longer needed, and the information about rules is now kept on the server running Microsoft Exchange, and in the Personal Folders file (.pst) (Personal Folders file (.pst): Data file that stores your messages and other items on your computer. You can assign a .pst file to be the default delivery location for e-mail messages. You can use a .pst to organize and back up items for safekeeping.) for POP3 (POP3: A common protocol that is used to retrieve e-mail messages from an Internet e-mail server.) and IMAP (IMAP (Internet Message Access Protocol): Unlike Internet e-mail protocols such as POP3, IMAP creates folders on a server to store/organize messages for retrieval by other computers. You can read message headers only and select which messages to download.) e-mail accounts. So you can delete the file.

If you use the Rules Import and Export feature, the default location for .rwz files is drive:\Documents and Settings\user\My Documents.

Print styles (Outlprnt with no extension)
Windows Vista drive:\Users\user\AppData\Roaming\Microsoft\Outlook

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Application Data\Microsoft\Outlook

Signatures (.rtf, .txt, .htm)
Windows Vista drive:\Users\user\AppData\Roaming\Microsoft\Signatures

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Application Data\Microsoft\Signatures

Stationery (.htm)
Windows Vista drive:\Program Files\Common Files\Microsoft Shared\Stationery

Windows Vista 64-bit with Office Outlook 2007 32-bit drive:\Program Files (x86)\Common Files\Microsoft Shared\Stationery

Windows XP or Windows Server 2003 drive:\Program Files\Common Files\Microsoft Shared\Stationery

Custom forms
Windows Vista drive:\Users\user\AppData\Local\Microsoft\Forms

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Local Settings\Application Data\Microsoft\Forms

Dictionary (.dic)
Windows Vista drive:\Users\user\AppData\Roaming\Microsoft\UProof

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Application Data\Microsoft\UProof

Templates (.oft)
Windows Vista drive:\Users\user\AppData\Roaming\Microsoft\Templates

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Application Data\Microsoft\Templates

Send/Receive settings (.srs)
Windows Vista drive:\Users\user\AppData\Roaming\Microsoft\Outlook

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\Application Data\Microsoft\Outlook

Message (.msg, .htm, .rtf)
Windows Vista drive:\Users\user\Documents

Windows XP or Windows Server 2003 drive:\Documents and Settings\user\My Documents

Jan 052010
 

You may need to alter or change Microsoft Office 2007 (aka 2007 Microsoft Office System programs and suites) product license key or volume license key (VLK) which also known as serial number or CD key.
You can modify or change product key for 2007 Microsoft Office programs or suites by first uninstall or remove Microsoft Office and then reinstalling the business productivity suite. However, you can follow the following steps in order to reset and change the Microsoft Office 2007 product serial key without the need to uninstall or reinstall 2007 Office system suites.
Note: The following steps involve modification of registry key values, which may corrupt your Windows if done incorrectly. Backup registry first before performing the workaround.
1. Close all Microsoft Office programs.
2. Click on Start button, then click on Run.
3. Type “regedit” (without quotes) in the Run text box, and click OK or press Enter.
4. Locate and then click the following subkey:
HKEY_LOCAL_MACHINE \Software\Microsoft\Office\12.0\Registration
Inside, you will find another subkey that resembles the following subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Registration\{30120000-0011-0000-0000-0000000FF1CE}
5. Optional: Backup this registry branch by exporting the Registration subkey to a file, just in case the new product key does not work and you have to restore back the old product key. To export the registry, right click on the Registration subkey and click on Export, and follow the on-screen prompt to enter a file name for the registry file and choose a location to store it.
6. Under the Registration subkey, there may be several Globally Unique Identifiers (GUID) subkey that contain a combination of alphanumeric characters. Each GUID is specific to a program that is installed on your computer.
If you find additional subkeys that reference Microsoft 12.0 registration, then click and open each GUID subkey to view and identify the Office product version by the ProductName registry entry in the right pane. For example:
ProductName=Microsoft Office Professional Plus 2007
7. After you find the GUID subkey that contains your Office product or program which you want to remove the existing product license key or registration details, delete the following registry entries by right clicking on the registry entry in the GUID subkey, click Delete, and then click Yes:
• DigitalProductID
• ProductID
8. Exit Registry Editor.
9. Run or open an Office application program, such as Microsoft Word or Excel or Outlook. Office 2007 will prompt you to enter a new 25-character product key.
10. Type in the valid and genuine product key, and then click OK.
11. Then when prompted to choose your preferred type of Microsoft Office 2007 installation, press on “Install Now”.
12. Microsoft Office 2007 will be updated with new product CD key or volume license key, and ready for activation (if it’s a non-VLK serial) or use.
Note: If you’re having problem with your new Office 2007 product key, simply double click on the backup registry .reg file created at the optional step above to restore the registry settings of the Registration subkey so that the original value can be imported back to the registry.
You may need to reset to change Office 2007 product key with the above steps if you don’t want to uninstall or reinstall Microsoft Office 2007 again in many scenarios, such as you have just bought a retail version of Office 2007, or receive Office 2007 as a gift, or win MS Office 2007 as a prize, or just get your MSN product key for Office 2007, or having problem with activation process online or via phone, or unable to step-up or convert evaluation copy of Office 2007 to full-use version, or having problem with Office Genuine Advantage (OG) validation.
On the other hand, if you manage to find a valid and genuine volume license key or VLK, you can change the product key of Microsoft Office 2007 with the VLK serial in order to bypass the Office 2007 activation process (as Office 2007 still using WPA 1.0 where corporate users need not to activate), without the need of crack or hack for Office 2007, for full use for unlimited period as long as you’re not caught by OGA.