Enholm Heuristics

 XB3EY79BK5B9

Every once in a while you need to go beyond the Excel feature that screens out duplicate records and single out records with a duplicate field, that contain data you want to get rid of.

Here's an Excel VBA Macro that does that. This one works for a sheet called "singletons" so you're going to have to change "singletons" to "sheet1" or whatever your sheet is called.

If Sheets("singletons").Cells(i,2) = Sheets("singletons").Cells(i-2,2) then

This also starts at row 100679, so you'll need to change that to your last row. The program works from the bottom up, which is the way it has to be. So make sure that the row and data you want to keep is sorted so the good record is the first one, and all the bad records are below that. This Macro checks the data in the B or second column, so you'll probably need to change that too:

Cells(i,2)

USE AT YOUR OWN RISK. BACK YOUR DATA UP!!!!

Here's the whole macro:

Sub deleteRowsWithDuplicateData()

For i = 100679 To 2 Step -1
    If Sheets("singletons").Cells(i, 2) = Sheets("singletons").Cells(i - 1, 2) Then     

          Rows(i).Select   

          Selection.Delete Shift:=xlUp   

    End If

Next

End Sub

For the last two days I've been looking at options for making a Flash website readable on mobile devices paying particular attention to iOS devices. We all know how much Apple loves Adobe Flash. Apple is not real fond of developers in general actually, but they really hate Flash developers.

So I looked for the easy way out, of course. Solution number 1 was to use Adobe Flash CS5 and develop in Flash lite. I still can't get it to work with the iPhone, but it did work on Android and Rim devices which are the other two I'm shooting for. Not great, but a partial solution. PARTIAL PASS

I tried Sothink SWF Compiler which has an export swf to html5 capability. This created a huge html file and large javascript file, which threw javascript exceptions on all mobile devices I tested. FAIL

Next, I tried Swiffy by Google, where you can upload an swf file via web page, and it will create an html5 solution for you. Except in my case where it FAILED. Tried several different versions of swf, all of which FAILED.

Next I tried Recool Video Converter which not only FAILED but crashed. Two for one. I tried it on both my Win 64 boxes. When I moved it over to my XP box it did make a video, but the quality was suspect and unusable. FAIL.

Verdict: Be ready to shell out some serious cash on Adobe CS5 to do this, or spendsome serious time coding in javascript. Probably both as there is still no easy solution.

I recently had a problem while using MySql with Hibernate in a Java app. Everyone and his dog had elaborate answers on this issue, including changing your connection pool settings, rewriting your entire codebase, and rebuilding the Space Shuttle. The answer was simple. You need to close out the session factory, not just the Session. This is done with this line:

fact.close();

Assuming you named it fact like this:

SessionFactory fact = new Configuration().configure().buildSessionFactory();

Which probably would have saved a lot of trouble for most of those developers. A lot of the examples on the internet excluded this simple answer.

Here's a good article on how to customize the Outlook 2007 Command Bar:

http://www.codeproject.com/Articles/58238/Outlook-2007-Add-in-Using-Microsoft-Visual-C-NET

Just one problem: It doesn't work. Or doesn't seem to. The author forgot to mention a key detail. If you don't actually see the menu after you build and debug-run the project, it doesn't mean it isn't there. Try going to the command bar. Pick the View menu, then Toolbars. Once you pick the Toolbars option you should see a MyToolBarButton. That's your baby. Pick that selection and you should see "My ToolBar Button" command button show up on the command bar. 

I've had the hardest time installing Calibre book reader and ebook converter on my Windows 7 64 bit machine with no idea why. It kept erroring out with the message "Calibre setup wizard ended prematurely." I finally got it to set up by following these steps:

1. Choose a directory other than the default like C:\Calibre
2. Choose "Advanced" when setting up
3. After you hit the Advanced button, uncheck all the options except the first one which installs the main program

After this I finally got it to install. If you still have problems I recommend trying different options on the first tab to get it to install.