07 September 2011

Thunderbird Re-Index to fix Global Search

Using Thunderbird on more than one machine can lead to messages missing from the index and reducing the usefulness of the global search.

Two easy options to re-index your IMAP folders and fix the problem

1. Right click and open properties for the folder you want to fix, and click repair folder. This will also download the mail again from the server.

2.  Find and delete all of the files with the .msf file extension in your profile folder, as described here

MS-SQL / Excel Data Connectors

Data Connectors are a very handy way to give office staff access to the data they need from an MS-SQL database without any knowledge of SQL.

Where central data is held in MS-SQL databases but the application level is unable to provide all the various summary and analysis functions that fast moving businesses need.

Either create views and link the connectors to these or simply link the connectors to SQL statements with a read-only access to the database.
Once you have your new data connector saved it's easy to directly edit the .odc files to change the initial catalog, the view that is being accessed and user names etc.

The .odc file can also be changed between accessing tables or views or SQL statements. Via 'Connection Properties' dialog found in the Data tab

The main advantage of data-connector driven excel models is that the data is refreshed from the primary source either automatically or at the press of a button.

Provides as-good-as online access for business analysis or performance monitoring projects with virtually nil development overhead.