Posts Tagged ‘Administration’

Be Careful What You Get When CSV Exporting of Mailboxes in Exchange

July 11, 2008 Leave a comment

I learned an important lesson the other day when I went to export the list of mailboxes from my firm’s Microsoft Exchange server – Microsoft did not take into consideration the commas that are potentially found in the name of the Mailbox, Size (KB), and Total Items columns.

To find out what I am talking about open up the Exchange System Manager on your Microsoft Exchange server, then browser to Administrative Groups –> [Group Name] –> Servers –> [Server Name] –> [Storage Group Name] –> Mailbox Store –> Mailboxes. Right-click on Mailboxes and go to Export List…, at which point an Export List window appears that will ask for the File name of your export file and the format you wish to save it in. Choose Text (Comma Delimited) (*.csv) from the Save as type drop-down menu, choose a name, and click Save.

The CSV file that you now have will be a complete mess; especially if you try and open it with Microsoft Excel (I am using Excel 2007). Instead of the six columns that are found under Mailboxes (Mailbox, Last Logged on By, Size (KB), Total Items, Last Logon Time, and Last Logoff Time), you could have (as in my case, dependent on the actual sizes of the mailboxes) ten columns. In my case, the Mailbox was split into two columns (first and last name), the Size (KB) column was split into three columns, and the Total Items was split into two columns. This is because Microsoft pretends everything is text, and no commas are stripped from any of the number columns. The names are problematic simply because our system has a Last, First schema for Mailbox names.

The way around this mess would be to actually follow RFC 4180 memo, that while not an actual standard, has good practices and conventions for CSV files, one of which is to place quotes around each column to preserve the internal commas.  But as always Microsoft does not think ahead very far and their QA program is abysmal. Shame on them, and too bad for us. The only way to export your list of mailboxes (that I am aware of) is to export them as a tab delimited text file that can then be imported into Excel and formatted as it needs to be.

To my mind, Microsoft should have either placed quotes around every column entry (why not, since they are treating everything as text), or not sent the numbers as text with commas into the file (they are only numbers after all). With this second option<, the export would only fail on the Mailbox name, which is an issue only when you have a schema where there is a comma in the name (which I also believe is bad, but I did not set it up).

Either way, could Microsoft stop being so near-sighted and think ahead at what they are doing?


Using Windows Installer in Safe Mode

January 8, 2008 Leave a comment

Having to recently put on my desktop support hat, I ran into an issue where installed software had created a brick out of an IBM laptop.  I booted into Safe Mode and wanted to uninstall the offending software when I discovered, to my dismay, that I could not access the Windows Installer service from within Safe Mode.

A quick Internet search provided the solution, and that is to edit the registry so that Windows Installer is available.  The following are the steps to take in order to start Windows Installer in Safe Mode.

Important! You may want to back up your registry prior to modifying it in any way.  Microsoft has support article 322756 showing you how to do this for Windows XP and Windows Vista.

  1. Start your computer in Safe Mode by pressing F8 before the Windows splash screen appears.
  2. Once logged in, click Start, then Run, and type regedit in the textbox, followed by Enter (or click OK).
  3. Locate and click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SafeBoot\Minimal
  4. Click Edit from the menu, and select New –> Key.  The new Key should be named MSIServer.
  5. Double-click  Default and type Service in the Value data box.  Click OK.
  6. Close the registry Editor.
  7. Restart your computer in Safe Mode, following the information in Step 1.
  8. Once logged in, click Start, then Run, and type services.msc in the textbox, followed by Enter (or click OK).
  9. Click on Windows Installer, then click Start.

You should now be able to add and remove programs from within Safe Mode.

Just remember that a serious problem might occur if the registry is incorrectly comfigured in any way.

I hope this helps someone.