Wednesday, June 29, 2011

Cool OneNote feature

I was already very impressed by OneNote, but I am blown-away after stumbling upon the built-in OCR capability.  When I did a content search for “Attendee” it not only found the image, it even highlighted the word on the image!


Monday, June 27, 2011

Removing the Dell DataSafe Upgrade Discount pop-up

I was baffled by a Dell product pop-up that did not appear to have a way to disable/ignore it...until I unlocked the taskbar and resized it. After that, the entire ad was displayed, including the option "Don't remind me of dicount offerings". Now if I can just get Dell to reimburse 30 minutes of life.

Wednesday, June 22, 2011

Mail Merge Templates No Entity error

I removed an entity that we were no longer using, but the Mail Merge Templates were still there.  CRM throws an error when there are templates that are missing their entity.  I discovered this by running the CRM Diag Tool and the CRM Trace Log Viewer.


To fix this, I had to manually set the records to “deleted” in the CRM database (DeletionStateCode=1).  Lesson learned: remove Mail Templates before deleting an entity!




Thursday, June 2, 2011

Oracle regexp_replace function

I needed to remove non-ASCII characters from an Oracle column and this regular expression did the trick nicely:


update TABLE set COLUMN = regexp_replace( COLUMN,'[^a-z,_, ,A-Z,0-9,@,&,$,:,.,%,'']','');