What do you do when you are reading though a published document like a policy or procedure, and find a problem or error? DocMaster now has an answer: create an issue. Issues are a special form of comments, complete with a simple (but customizable) workflow. In the screen shot below you can see an example of a new issue, along with the issue categorization and workflow.
Thursday, June 5, 2008
Tuesday, June 3, 2008
Added Sarbanes Oxley (Sox) to DocMaster in release 4.2
One of my responsibilities at work is to ensure that IT is Sox compliant. Unfortunately the usual manual processes based on spreadsheets and word documents simply don't work very well, and are a lot of effort to maintain. And since Sox procedures should be integrated with other IT procedures, it made sense to extend DocMaster to specifically support Sox.
Possibly the most useful feature added is the "Sox Documentation" view, which includes a color coded calendar showing the current status of Sox monitoring. This is a huge time saver, and has organized our Sox work so well that, at the end of May 08, we are completely up to date! See screen shot below with annotations.
Adding monitoring tasks to the calendar is pretty easy: simply check the appropriate month check box on the control document. See screen shot below.
Sox documentation usually consists of control narrative documents, which are summarized by a spreadsheet. The problem is that it is impossible to keep the narrative documents in sync with the spreadsheet. DocMaster solves this problem by using a separate document for each control, and then summarizing these documents in a Control Matrix view. That normalizes the information, and because the information is now only maintained in one place, total solves the synch problem. DocMaster has special views of the Sox control documents, but those control docs can also be put in folders, along with other policies & procedures.
Once Sox controls are in place, you are required to monitor them to ensure they are working. DocMaster allows you to attach monitoring documents to the controls. This means that when the next monitoring event is due, you can use previous monitoring as a template - a tremendous time saver. It also means that when auditors look at your documentation, they can easily find all monitoring - a tremendous money saver! To track actual monitoring there is a view of all monitoring, categorized by month. See screen shot below.

Release 4.2 also added document issues, but more on that tomorrow.
Possibly the most useful feature added is the "Sox Documentation" view, which includes a color coded calendar showing the current status of Sox monitoring. This is a huge time saver, and has organized our Sox work so well that, at the end of May 08, we are completely up to date! See screen shot below with annotations.
Adding monitoring tasks to the calendar is pretty easy: simply check the appropriate month check box on the control document. See screen shot below.
Sox documentation usually consists of control narrative documents, which are summarized by a spreadsheet. The problem is that it is impossible to keep the narrative documents in sync with the spreadsheet. DocMaster solves this problem by using a separate document for each control, and then summarizing these documents in a Control Matrix view. That normalizes the information, and because the information is now only maintained in one place, total solves the synch problem. DocMaster has special views of the Sox control documents, but those control docs can also be put in folders, along with other policies & procedures.
Once Sox controls are in place, you are required to monitor them to ensure they are working. DocMaster allows you to attach monitoring documents to the controls. This means that when the next monitoring event is due, you can use previous monitoring as a template - a tremendous time saver. It also means that when auditors look at your documentation, they can easily find all monitoring - a tremendous money saver! To track actual monitoring there is a view of all monitoring, categorized by month. See screen shot below.
Release 4.2 also added document issues, but more on that tomorrow.
Wednesday, May 28, 2008
More Excel Woes!
Although the technique "copy as table and paste into spreadsheet" works, it is limited, e.g. if the view is too wide, you can't copy it as a table (but shrinking the column widths does work). Also, graphic icons in a view don't get pasted.
An alternative thought occurred to me: Why not export the view as a Lotus 123 file, and then import it into a IBM Symphony spreadsheet. Surely two IBM products would be compatible with each other? Surely...? Not a chance! The error message is "IBM Symphony do not support this file format." (love the grammar!) Unfortunately Open Office can't import Lotus 123 spreadsheets either, and I haven't yet been able to find any filters on the web. I'll keep trying because there is a need coming up in a few weeks.
An alternative thought occurred to me: Why not export the view as a Lotus 123 file, and then import it into a IBM Symphony spreadsheet. Surely two IBM products would be compatible with each other? Surely...? Not a chance! The error message is "IBM Symphony do not support this file format." (love the grammar!) Unfortunately Open Office can't import Lotus 123 spreadsheets either, and I haven't yet been able to find any filters on the web. I'll keep trying because there is a need coming up in a few weeks.
Saturday, April 26, 2008
Excel import workaround that’s better than the original!
Well, you learn something new every day, and sometimes from the most surprising sources. Although we use Outlook for email, we had created an Asset Management application in Notes (using rich text fields to store scans of original invoices etc). We needed a way to export information from this application to an Excel spreadsheet to further manipulate it. This was where I discovered that Excel 2007 no longer imports Lotus 123 - see blog post from April 23.
A few days later the finance person using the Asset Tracker came back to me and said she had solved the export / import problem - just use "Copy as table" and paste into the spreadsheet! Wow - this finance person had never used Notes before, and come up with a work around that was much better / easier to use than the original process. (Note: Although cell background colors are preserved in Open Office, they are miss aligned. Background colors don't paste into MS Excel.) This just goes to show that you never stop learning, and that potentially anybody can teach you something.
A few days later the finance person using the Asset Tracker came back to me and said she had solved the export / import problem - just use "Copy as table" and paste into the spreadsheet! Wow - this finance person had never used Notes before, and come up with a work around that was much better / easier to use than the original process. (Note: Although cell background colors are preserved in Open Office, they are miss aligned. Background colors don't paste into MS Excel.) This just goes to show that you never stop learning, and that potentially anybody can teach you something.
Tuesday, April 22, 2008
Excel 2007 can’t open Lotus 123 spreadsheets
We hit this problem today trying to export a Notes view as a spreadsheet, and import it into Excel. Older versions of Excel could import a wk4 spreadsheet, but not so in Excel 2007. Maybe IBM / Lotus will finally provide a means to export native Excel files directly from Notes (or maybe this is just wishful thinking...!)
Monday, March 24, 2008
Problems with Microsoft Server 2008?
Microsoft obviously run Windows servers, which they tout as highly reliable. Yet their eOpen web site has had a problem for the past 6 days (and maybe longer - it is just that I have been trying to download some software that we purchased for the past 6 days). I can only presume they are upgrading to Windows Server 2008. But that hardly inspires confidence when considering Windows Server. If Microsoft has this much difficulty getting their software to work, what will I experience?
The strangest thing is that I can reach the eOpen page with Firefox, but not with IE. But that doesn't make any difference, because I can't log in anyway.
The strangest thing is that I can reach the eOpen page with Firefox, but not with IE. But that doesn't make any difference, because I can't log in anyway.
Friday, March 14, 2008
Outlook 2007 Calendar Bug
As a long-time Notes user who now uses Outlook at work, I always keep an eye open for problems / differences etc. Here is one problem with Outlook 2007 where if you drag an HTML email to your calendar, you loose the formatting & images. See the before and after images.
The original email before dragging it to the calendar
The calendar entry created from the email
The original email before dragging it to the calendar
The calendar entry created from the email
Subscribe to:
Posts (Atom)