Latest Article

Enhanced Native Architecture™

Promotes the Best Use of the Native Application
I coined the methodology “Enhanced Native Architecture” (ENA) back in the late 90’s to help set Esquire’s products apart from our competition. Its definitely a competitive advantage and I’m glad its trade marked.  Intellectual property is so important to a technology company.
ENA builds upon the user interface and […]

Continue reading

About

Randall Farrar is President & Co-founder of Esquire Innovations, Inc.

Panel

Recent articles

Its Here! Our Version 7 of Document Production Software iCreate will be Released Soon

(100% .Net) … always look for this seal :)

“With accuracy and turnaround critical elements, law firms must produce documents ranging in difficulty from simple memos to complex agreements, as well as disclosure documents and briefs,” states Susan McClellan, Esquire Innovations’ Marketing and Operations Manager. “This new version of iCreate provides a fully integrated system of templates and automation that construct documents with the click of a button and on-screen prompts that ask the ‘right’ kinds of questions.”  [All XML and LINQ technology]

iCreate promotes best use of MS Word, streamlines document production, increases staff productivity

iCreate 7 leverages MS Word’s Enhanced Native Architecture™ (ENA and promotes the best use of Word, drawing on the most effective features for legal documents instead of highly programmed customizations or substitute functions. By retaining the look and feel of the parent software dialog boxes, iCreate 7 promotes streamlined workflow and reduces end user training requirements. And by retaining Word’s native formatting, an electronic document can effectively be used for collaboration purposes, without concern that the formatting will be rendered completely useless.

“Firms that implement iCreate find they significantly reduce the time users spend drafting, formatting and reformatting MS Word documents,” according to McClellan.

After installing Office 2007, an Information Systems manager from an Esquire Innovations’ client law firm in Boston stated that she had a difficult time “finding things in Word 2007. But, when she installed iCreate, she was thrilled to find that “it made using Word 2007 so much more intuitive.”

In-house customization saves money

Designed to meet the high demands of the legal industry, with enhanced administration, a sleek user interface, centralized template launcher, advanced pleading administration, numbering and formatting toolbars for repurposing documents, an open XML document format compliancy and contact management integration with dynamic address updating, iCreate 7 has enormous capabilities for quickly creating, editing and standardizing legal documents.

iCreate 7 is highly customizable by in-house staff without VBA experience. McClellan reports that “the package has a small application footprint, is simple to administer, can be implemented in a short amount of time, and the source code for customizable components is open.” She adds that “the updating and customization of templates is handled in-house, making upgrades inexpensive and quick to implement.”

Software ready for Office 2007

Esquire Innovations reports that along with iCreate 7; the company has also released new versions of iScrub, a metadata management solution for Microsoft Office documents; iRedline, a document comparison and collaboration application for Microsoft Word; and iDocID, a powerful document management system-integrated ID stamper. This new generation of products is available as the combined package iOffice System 7.

10 Reasons Why Microsoft Office’s Document Inspector is Not an Enterprise Metadata Management Tool

Reason 4.

Here’s a feature of Document Inspector I just don’t get. When the “Headers, Footers and Watermarks” are removed, the Document Inspector removes everything in the footer, including the page number.

For long documents such as agreements, contracts and corporate documents where the footers are complex, this can cause some major problems…and heartache! This can be Undone, but if you forget and save it first, then it is gone.  …What…?

And your firm is solely using the Document Inspector?

10 Reasons Why Microsoft Office’s Document Inspector is Not an Enterprise Metadata Management Tool

Reason 3.

The Document Inspector Removes Metadata from the Original

Document Inspector does not publish a result document, so accidental removal of metadata is very easy. When the user removes metadata accidentally using the Document Inspector these are deletions that cannot be “undone.” Try explaining that to your user!

In firms where document collaboration and client work product are the currency, accidental metadata destruction can be quite costly. Imagine a scenario where an attorney asks a secretary to send an agreement he’s been working on all-night to his client. This particular document contains his and a colleague’s comments along with their track changes. He tells the secretary to send the client a copy with the metadata scrubbed. The secretary uses Document Inspector to inspect the document and notices that this document has “Revision marks and Comments” with a red EXCLAMATION POINT! This must not be good, so he selects “Remove All” and then realizes in a panic that this was the original. He tries to “undo” the removal but cannot.

Document Inspector does not preserve the original and makes it too easy to lose important metadata from the original. As you can see from the example above some metadata is invaluable to the document production process. Along with this, Document Inspector uses the term “Revision” when in fact it is Track Changes – this is confusing.

Below is a list of metadata the inspector removes that cannot be undone for Word 2007:

  • Comments
  • Revisions (Track Changes)
  • Versions
  • Annotations
  • Custom Properties
  • Template Name
  • Statistics
  • Data binding link information for data bound fields (last value will be converted to text)
  • Template name

CAUTION: Document Inspector does not always remove personal information in Office 2007 Word. In Office 2003, when personal information was removed the author info was removed from track changes. In Document Inspector the author information is NOT removed.

10 Reasons Why Microsoft Office’s Document Inspector is Not an Enterprise Metadata Management Tool

Reason 2.

The User is Responsible for Metadata Removal

Document Inspector’s lack of extensive out of the box extensive metadata management ability is not suited for an enterprise-metadata management approach. The onus is on individual users to “inspect” their documents and then decide what to remove.

With the Federal Rules of Civil Procedure relating to electronically stored information, relying on Document Inspector places the company or firm at risk of “…inadvertent production of privileged information.” A firm should decide how to manage a document’s electronic information (metadata) from an enterprise-wide approach, not the individual users.

10 Reasons Why Microsoft Office’s Document Inspector is Not an Enterprise Metadata Management Tool

Reason 1.

Introduction to Document Inspector

The Document Inspector is Microsoft’s response to the market’s outcry about the hidden data that can so easily be stored in a Microsoft Office document. When sharing these files outside of a company or firm, there is risk of disclosing unintentionally discoverable, confidential or hidden information that might be adverse to client representation or, at least, extremely embarrassing. Prior to Office 2007 Document Inspector, Microsoft provided a metadata removal tool (called the Hidden Data tool) that was barely usable and kludgy at best. The Office 2007 Document Inspector was a needed addition.

With the advent of Microsoft Office 2007 (Office 2007) and the addition of the Document Inspector, many firms are asking whether there’s a need for an additional metadata management application.

Has Microsoft, in one single blow, nullified many companies’ investment in a metadata management application?

If metadata management is now built-in, why use another application?

I’m going to tell you 10 reasons I believe firms should not rely on Document Inspector but should still consider investing in a metadata management application.

Reason 1. Document Inspector Has Too Many Steps

Microsoft’s idea behind the Document Inspector is to provide a central location for users to view Office 2007 documents for personal, hidden, or sensitive information. To view or remove this information a user can use the built-in Document Inspector and an organization could, conceivably, extend the Document Inspector (see Figure 1) with additional development using the Document Inspector Object Model.

To View the Document Inspector

  • Click the Office Button Office Button
  • From the drop-down menu select Prepare
  • From the list to the right select Inspect Document

Document Inspector Dialog Box

Figure 1

The Document Inspector is Composed of Three Modules

The Document Inspector is composed of three modules users can employ to inspect and remove specific metadata from the document – Office 2007 Word Document Inspector, Office 2007 Excel Document Inspector, and Office 2007 PowerPoint Document Inspector

Metadata Elements Discovered by Document Inspector for Word 2007:

  • Comments
  • Revision marks from tracked changes
  • Document version information
  • Ink annotations
  • Document properties, including information from the Summary, Statistics, and Custom tabs of the Document Properties dialog box
  • E-mail headers
  • Routing slips
  • Send-for-review information
  • Document server properties
  • Document Management Policy information
  • Databinding link information for databound fields (last value will be converted to text) Note: Does not handle some linked fields such as IncludeText,
  • User name
  • Template name
  • Text that is formatted as hidden (a font effect that is available in the Font dialog box)

Metadata Elements Discovered by Document Inspector for Excel:

  • Comments
  • Ink annotations
  • Document properties, including information from the Summary, Statistics, and Custom tabs of the Document Properties dialog box
  • E-mail headers
  • Routing slips
  • Send-for-review information
  • Document server properties
  • Document Management Policy information
  • User name
  • Printer path information
  • Scenario comments
  • File path for publishing Web pages
  • Comments for defined names and table names
  • Inactive external data connections
  • Information in worksheet headers
  • Information in worksheet footers
  • Hidden rows
  • Hidden columns that contain data
  • Objects that are not visible because they are formatted as invisible

Metadata Elements Discovered by Document Inspector for PowerPoint

  • Comments
  • Ink annotations
  • Document properties, including information from the Summary, Statistics, and Custom tabs of the Document Properties dialog box
  • E-mail headers
  • Routing slips
  • Send-for-review information
  • Document server properties
  • Document Management Policy information
  • File path for publishing Web pages
  • Objects that are not visible because they are formatted as invisible
  • Text that was added to the Notes section of a presentation
  • Custom XML data that might be stored within a presentation

Removing Metadata from the Office 2007 Document

Once the user selects Inspect (see Figure 1), the Document Inspector dialog box displays the type of metadata found in the document. After displaying the metadata in a particular document the Document Inspector provides buttons to remove the metadata (see Figure 2).

Document Inspector Review

Figure 2

Once the user selects which metadata to remove, they can recheck the document for metadata by selecting the Reinspect button (see Figure 2)

Where Did Organizer Go?

Give me a break!

One of the most useful features of Word is the Organizer and what did Microsoft do with it? They buried it under a pile of commands and buttons. Yea…real intuitive.

Here’s how you dig to China to get to it.

  1. On the Home Tab of the Ribbon click the Styles button
  2. At the of the Style List Dialog box there’s 3 buttons
  3. Click on the rightmost button which is Manage Styles (what?)
  4. Click the Import/Export… Button

What the …? Yea that’s real easy.

Forget that… here’s one line of code you can place in your Normal template or global template and then assign it a keyboard shortcut. Much easier.

Sub ShowOrganizer()
Dialogs(wdDialogOrganizer).Show
End Sub

Code To Update Table of Contents

Here’s some VBA code that updates all the TOCs you may have in your document. There may be times when you need to update the TOCs in a document before some method you want to run.

Notice the “Step -1″? This enumerates through TOC starting with the last one first - something I learned the hard way!

Sub UpdateTOCs()
Dim x As Integer
For x = ActiveDocument.TablesOfContents.Count To 1 Step -1
ActiveDocument.TablesOfContents.Item(x).Update
Next x
End Sub

Metadata Policy Services

I love that fact that Microsoft Office document metadata has metamorphosed from “get rid of” to “let’s manage”. I saw this trend three years ago. That is why at Esquire Innovations, we’ve always talked in terms of “managing metadata” instead of emphasizing the removal of the document metadata. We emphasize an “enterprise document metadata policy” approach. Each firm needs to think and plan how document metadata is managed as it leaves the boundaries of the firm, i.e. email.

So we are now walking the talk and offering document metadata services to help address the changing needs of our iScrub clients. These services help our clients in three ways:

  1. Assist in making the best use of iScrub by training on the advanced features of the product.
  2. Help to explore the myriad of other possibilities of managing document metadata.
  3. Analyze the firm’s metadata approach and adjust the software to better fit their requirements.

For more information check out our press release - Esquire Innovations Announces Metadata Policy Services


Office 2007 Document Inspector-Databinding Information

CAUTION: There are fields in all versions of Microsoft Word that contain linked data in the form of text, pictures or hyperlinks that can reference files on a server that Microsoft Office 2007 Document Inspector does not remove or unlink (turn the field to text).

Examples of Linked Fields that are not removed from a doument using the Microsoft Office 2007 Document Inspector:

  • { HYPERLINK “\\\\PRODEV\\People\\JDoe\\DOCS-” \l “609447-v18-Bylaws.DOC” }

  • { INCLUDEPICTURE \\\\ PRODEV \\People\\ JDoe\\iRedlineLogo.gif” \* MERGEFORMAT }

  • { LINK Equation.3 \\\\ PRODEV \\People\\ JDoe\\iRedlineLogo.gif” \p }

  • { INCLUDETEXT “\\\\ PRODEV \\People\\ JDoe\\DOCS-#609447-v18-Bylaws.DOC” \* PRODEV }

Whatever metadata management program you use for your organization, the ability to remove databinding objects is a must.

Office 2007 - What Happened?

As expected, we didn’t see the legal domain making a mad rush to Microsoft Office 2007 in the first quarter of 2008 and I don’t expect the spigot to open any more for the second and third quarters. What I predict is that the conversion to Office 2007 will begin to happen towards the end of this year and the flood gates will open in 2008 and go strong all year. Why? The new internationally approved XML file format will be the driver.

Esquire Innovations' Products

  • Document Production
       iCreate
  • Document Metadata Management
       iScrub
  • Redlining and Comparison
       iRedline
  • Document Management Identification
       iDocID

ACF loading animated gif