Archive for March, 2012

sqlite import fails — FIXED

Started using sqlite less that a week ago. I already had the code working in mySQL, but wanted to give sqlite a try.
I published this silly error because I fumbled around way too long and not understanding why the import was failing. So simple, but it gave the following error:
SQLite version 2.8.17
Enter ".help" for instructions
sqlite> .separator ";"
sqlite> .import /vol1/fileData.csv fileData
unknown command or invalid arguments: "import". Enter ".help" for help
sqlite>

Running this from an openSuse 11.4 system, I had simply typed in sqlite, entered a simple schema for the file and directory data I wanted to process. Went to run the import but it failed, it looked simple enough. I mucked around chasing things like working directory etc, but no joy. Then I came across a comment while googling, import was not supported under sqlite2. DOH!
Sure nuf, openSuse ships with two versions of sqlite. Next try I entered sqlite3 at the prompt and it worked perfectly. Very fast.
Just one of the challenges of mucking with a new tool.

Setting Windows XP default web/HTTP mail for IE and Firefox

I finally got tired of having the default web link on my old reliable XP (no-weirdness) home PC being set to windows mail , yuck.  Turns out, not as easy as I had hoped to find the “simple” solution for changing the default mail links.  Gmail has a nice notifier widget, not so with Hotmail, which I wanted for my default mail. Plus, I wanted to change it globally on the system.

You can find the gmail notifier here: http://toolbar.google.com/gmail-helper/notifier_windows.html

Poking around the web I found several very arcane solutions.. really???  Having to attack the registry didn’t make sense to me.  Of course there was an easier way, finally found it here:

http://www.freeemailtutorials.com/microsoftWindows/settingDefaultEmailClient.cwd

Note: click images to enlarge for viewing.

Setting the Hotmail Default mail client.

Setting the Hotmail Default mail client.

Turns out, that you can get to this option window from the XP Control Panel or the IE Tools > Internet Options > Programs. Set Email option to: Windows Live Hotmail.

Once this was set on the Microsoft side of the house, where I really wanted this feature was Firefox… now it showed as an option:

Firefox Mail default setting.

Firefox Mail default setting.

Tools > Options > Applications > Mailto

Select: Use Microsoft HTTP Mail Simple MAPI

Enjoy.