How to Export IMAP Email from Outlook to Excel or CSV Text Files

There are billions of people out there - somewhere...

Unfortunately it’s not possible to export (IMAP) email body’s onto Excel using the Export feature in Outlook.

As a work around, you may export the particular IMAP folder emails as .PST format and then open the same file in Outlook.

To open the PST file, click on file->open->browse to the PST file->click open.

To Export the file, Click on on File > Export to file->Microsoft Excel>Select the PST file.


How to stop Node Comments Spam in Drupal 7

Getting buried in Spam?

Spammers generally use comment feature to post spam links on your Drupal powered websites. Here is how you can control spam comments to large extent.

Use Mollom Module
Mollom is a great Drupal module to control spams. Mollom handles incoming posts intelligently, in much the same way a human moderator decides what posts are acceptable.

Use CAPTCHA Module
A CAPTCHA is a challenge-response test most often placed within web forms to determine whether the user is human.

Make Preview comment necessary
Enable Preview comment necessary from Administrator >> Content types >> page / story >> Edit >> Comments settings.

You can further control spam, by allowing only registered users to post comment.


Review of "Magento Performance Optimization How-to" from the PACKT Publishing INSTANT Series

Instant Magento Performance Optimization How-to

I bought an "Instant" book from PACKT Publishing once. ONCE. I'll never do it again. Why? In a previous blog post I detailed the lack of, well... anything contained in another PACKT "Instant" publication. These things are like the primer to the primer - the most shallow introduction it is possible to print and still have any ink on the page.


Review of "E-Commerce with Magento: Build a Shop" from the PACKT Publishing INSTANT Series

Magento book is so think with only 40 usable pages, and mostly screen shots!

Let me preface this review by saying I respect Branko Ajzele and I work with people who have experience working with him, and his reputation precedes him as a master of his craft. That said, I can honestly say that I was shocked when I picked up this book. When my Amazon shipment first arrived I yoinked out the packing bubbles and I thought they forgot to put the book in the box - there was only this little pamphlet on the bottom? That pamphlet was the book.


The Invalid Comparison of Wordpress versus Drupal (or Drupal vs Wordpress?) and Which One is Right for You

Long Duk Dong prefers Drupal because he's not just blogging, ya' know...

In the never-ending comparison of Wordpress and Drupal one of the most important criteria is also one of the most often overlooked – the fit-for-purpose of any given architecture to suit the need of a particular site and its audience.

While people throw around the term “CMS” fairly loosely, there tends to be a polarization of meaning under the hood. Most often the situation at hand when discussing “Wordpress versus anything” calls for a content publishing site (or blogging site). However, some percentage of the time the site designer may be thinking of developing something a little more elaborate, such as a social or community site, or perhaps even a full-fledged web application.


Solr 4.1 does not work (yet) with Magento EE 1.12 - use Solr version 3.6 for now!

This will be a short post, I just want to let people know how much trouble I've had trying to find something definitive that calls out how the Magento Solr integration built-into Magento Enterprise Edition v1.12 does NOT SUPPORT Solr version 4.1 - in fact, I still can't find any "smoking gun" documentation to confirm this, only a handful of reports about various bugs when using 4.1 such as this one regarding "Unknown commit parameter waitFlush" found on Stack Overflow:

It's surprising that there's not clearer (any?) documentation specifying the major revision of Solr to use. It's probably out there, and I suppose someone will rub my nose in it soon, but we've been scouring the Internet and haven't found anything that makes this more obvious.


T-Mobile Internet Outage on the Morning of Monday, May 18th 2012

There was a widespread (global?) Internet outage on the T-Mobile network Monday morning, March 18th 2012. As of 1PM Chicago time, customers are still being asked by tech support agents to "remove the battery of your phone while we re-force your SIM card back onto the network."

Further details were not available, and the T-Mobile representatives are unaware of any official network status page to describe outages or restoration times, short of suggesting that one "Googles" for information.

Incidentally, simply rebooting the device ultimately worked, and literally removing the battery was not required - as long as the reboot occurred after the system was back online.

The root cause was attributed to a router upgrade that went south, and the outage was allegedly "mostly on the East Coast" although it was also experienced in the Midwest.


How to Make Drupal Quicktabs "Remember" the Last Tab on Page Refresh

With a little JavaScript you can make your QuickTabs Fergalicious!

It's annoying to have Drupal QuickTabs revert to the default tab on every page load. There are a number of hacks out there that require changes to default ("core") files to make the last tab get re-selected on page refresh. However, the following fix will make the last tab re-select on page load. In my particular case I had 26 tabs, labelled A through Z, which each contained the same view, but with different parameters.

At the top of the view I included a Global PHP header with the following code:

jQuery(document).ready(function() {
thing = jQuery('#quicktabs-techspec').find('.active').find('.active').attr('id');
jQuery.cookie("techspec-tab", thing);

..which records the active tab (from my QuickTabs named "techspec") in a cookie. Then in the Panels page, where the QuickTabs were located, I included a panel with the following code:


How do I check Magento's Search Relevance scores to see what IT thinks is relevant?

Refine Magento search's targeting selection to be as crafty as a Predator Drone!

Magento's stock search is pretty basic, and although it offers a "sort by relevance" feature I often can't tell what it was thinking from the order of the result set. So I decided to hit the database directly and dump out the weighted scores to view them numerically. Now, this doesn't "dix" anything - but at least it gives me the ability to adjust the indexing algorithm and see the results of my efforts.

The following code will do just that:

SELECT prodName.`value` AS name,
MATCH (searchIndex.`data_index`) AGAINST (' ') AS relevance
FROM catalogsearch_fulltext AS searchIndex

LEFT JOIN catalog_product_entity_varchar AS prodName
ON prodName.`entity_id` = searchIndex.`product_id` AND prodName.`attribute_id` = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'name' AND entity_type_id = 4)

ORDER BY relevance DESC;



Subscribe to All About Todd RSS