Deleting localcache.db breaks address list

One of the common solutions to several Outlook Connector problems is to deleted your localcache.db, effectively resetting Outlook Connector and letting it start from scratch. This shouldn’t be required on a regular basis, but a database reset is sitll occasionally needed.

After doing so, when you compose a new message Outlook may indicate that “The Address list could not be displayed”

First off, a workaround to avoid the problem entirely: Rather then just deleting localcache.db, instead, create a new profile. To create a new profile:

  1. Shut down Outlook.
  2. Open Windows Task Manager (press CTRL-ALT-DEL, this will either start Task Manager, or give you a menu to start Task Manager)
  3. Go to the “Processes” tab, make sure that Outlook.exe is not listed.  If it is, select it and press “End Task”
  4. Open the control panel.
  5. Open the Mail item.  (Note that on 64-bit systems, go into “View 32-bit control panel items” to find the “Mail” icon)
  6. Select “Show Profiles”
  7. Create a new profile, and set up Outlook Connector normally.
  8. If desired, you can also remove the old profile from this dialog, but I’d suggest keeping it until the new profile is up and running

If you’d rather fix the problem without creating a new profile, follow these directions instead:

  1. Start Outlook
  2. Go to Tools -> Email Accounts -> “View or change existing directories or address books”, remove existing Outlook Address Book.
  3. Shut down Outlook.  It wouldn’t hurt to check in Task Manager (Steps #2 and #3 in the previous list) to make sure Outlook bothered to shut down.
  4. Start Outlook.
  5. In Outlook under Tools -> Email Accounts -> “View or change existing directories or address books” add a new Outlook Address Book.
  6. Shut down Outlook and restart.
  7. Select the Contacts folder and wait for it to synchronize.
  8. Right click on the local Contacts folder, choose Properties.
  9. Go to the [Outlook Address Book] tab, then tick option to ‘Show this folder as an e-mail address book’, then click “OK”
  10. You can optionally add other Contacts folders to the addressbook, allowing these other folders to be used more easily when creating a new message.  Repeat steps #7 through #9 for each additional folder.

Also let me mention that this particular problem isn’t limited to Outlook Connector, it can happen with a PST too if the PST becomes corrupt and you either delete it and recreate it, change the default PST, or if ScanPST recreates your Contacts folder.

Exporting Worldclient contacts the hard way

In a previous post I covered the supported ways to access WorldClient contact data. Now we’ll dig under the hood a little and I’ll show you one method to convert a contact entry directly to a CSV file. The only tools needed are Windows Explorer and Excel 2007.

Open Windows Explorer on the server, browse to the user’s contacts folder:

e.g. C:\MDaemon\USERS\example.com\UserName\Contacts.IMAP

Copy the file AddrBook.mrk to a temporary area, where you can work on this file, then rename this file to AddrBook.xml. You can copy the file to another machine, from this point forward MDaemon isn’t needed.

Start Microsoft Excel 2007.

Select File – Open – browse to the temporary area and choose the AddrBook.xml file.

Leave the option “As an XML table” option selected and click OK, then click OK again.

Excel will now have a new file opened with the following columns: version, encoding, guid, modified, fullName, email

Delete the columns: version, encoding, guid & modified

Keep the columns: fullName & email

You can now copy and paste this data into a CSV format required by your email client address book for importing.

Please note: the above instructions work if using MS-Office Excel 2007, older versions of Excel may not have the required XML importer.

Exporting Worldclient contacts the easy way

How can I export contacts from my WorldClient address book?

There are two supported methods, and one unsupported method I’ll cover later.

  • ComAgent

ComAgent can synchronize a WorldClient address book with Outlook or Outlook Express.

To use ComAgent, have the user login to WorldClient, go to Preferences, then download and install ComAgent. Once installed, right click on ComAgent, go to Properties, then to Address Book Synchronization, choose the appropriate mail client and local folders and away you go.

Note that this is a two-way synchronization, items in your local address book will be sent up to the server. This is unavoidable.

  • SyncML

This method takes a bit more work, but is actually more flexible since you can access any Contacts folder. The process requires an SyncML external application, so you’ll need to find one based on the destination.