Outlook 2010 autocomplete list nickname .nk2 is gone

Outlook 2010 took the old *.nk2 files and stuffed them into a cache which is a hidden mailbox message. That all sounded good to me, the nk2 files were a pain, I looked forward to a slick management interface in EMC or at least the EMS.  None was to be found, but there is a way, albeit slow processing the whole process takes a few minutes on a slow computer.

(more…)

Continue ReadingOutlook 2010 autocomplete list nickname .nk2 is gone

SQL convert "yyyyMMdd" integer or string to a Date that works in SoftPro

The last few weeks I’ve been working with Web based Reporting for SoftPro ProForm.  It’s been fun creating management review pages with dials and lights.

image

I’ve enjoyed combining multiple report outputs on one concise easy to ready web page.  Along the way, it’s been necessary to display SoftPro Database formatted date fields in a grid.  They come through in 20130524 or “yyyyMMdd” format.  It was easy enough to format that in a grid as “yyyy-MM-dd” format which worked until I started exporting the grids to Excel, when the formatting failed.  So I began a search to fix it, at the SQL level.

(more…)

Continue ReadingSQL convert "yyyyMMdd" integer or string to a Date that works in SoftPro

Word 2007 and 2010 Insert Key doesn’t work

Microsoft for some unknown reasons after 35 years of consistent behavior decided to change the way the Insert key works in Word. Normally pressing the insert key toggles between Insert and Overtype.  Most people live in Insert mode, but sometimes Overtype is nice, the engineers at Microsoft decided you no longer needed Overtype mode.  Who knows why.

(more…)

Continue ReadingWord 2007 and 2010 Insert Key doesn’t work

Data Collector Mass Update

Today I needed to add 25 fields to Data Collector.  Where as it’s totally doable using the correct application, it is the slow way. And since we work on development servers, the same changes need made on the production servers, so the time is duplicated.  There is a quick and safe (mostly safe) way to update ProForm Data Collector, from SQL Server Management Studio

(more…)

Continue ReadingData Collector Mass Update