Posts Tagged ‘Information Technology’

Wildcard Searches in AnyDoc BROKERit

Wednesday, August 25th, 2010

The BROKERit product from AnyDoc Software is normally included with the base ScanClaims software suite when purchased with scanning and OCR for AnyDoc.  This is a very powerful tool to search for archived documents that are properly indexed using either verified Optical Character Recognition (OCR), customized Key From Image (KFI) screens, or when linked to external databases.

Queries can be performed on either single or multiple folders using the “Query Module” interface. Simply right-click on the desired level folder on the left side of the screen, then select either “Quick Folder Query,” “New Folder Query,” or “New Multiple Folder Query,” depending on whether you would like to search across multiple folders or in a single folder. The “Quick Folder Query” is generally the most utilized option because users can set up archive folders with different forms having different indexes.

A list of all the indexed fields for that folder will be displayed on the right side of the screen. The “Operator” column features a drop-down list that allows the user to specify which operator to use (=, >, <, >=, <=, <>, Like, List, Between, Null, and Not Null). The default operator is “=.”

When the user selects “Like” as the operator, the “Field Value” column can be used in conjunction with the wildcard character “%.” For instance, when searching the “Document Number” field for all images scanned on 8/10/2010, the user can enter S20100810 with the “%” wildcard character (S20100810%) in the appropriate “Field Value” field.

The “%” wildcard character can be used to match any number of characters up to the size of the field. The underscore character (_) can also be used in combination with the partial contents of an index field to search for values by length with each “_” representing a single character. In this case, the “Field Value” column of S____ (four underscore characters) would return names like “Smith,” but not “Sampson.”

The mathematical operators >, <, <=, and >= can also be used to return the desired results. In the above document number example, the operator “>=” could be used with S20100810 (no wildcard character) to return all document numbers scanned on or after that date.

For more information on AnyDoc® BROKERit, click here.

Windows 7 and Windows XP Mode

Thursday, July 29th, 2010

Disclaimer: The following is based on HCIM’s current knowledge of Windows 7 and no representations are made whatsoever as to the appropriateness of Windows 7 for other organizations. It is recommended that each organization fully review and test their current applications for compatibility with Windows 7 prior to implementation.

Microsoft Windows 7, released in October 2009, was released as a much improved operating system over Vista and a worthy replacement for Windows XP. Features include much faster booting and shutdown, faster operation, improved compatibility with Windows XP applications, and several user interface improvements. Since then, the operating system has proven to be a tremendous success, selling over 175 million copies in the first nine months on the market. Both home users and businesses have embraced Windows 7.

Compatibility
In the business community, there still remain many businesses that continue to operate on computers with the Windows XP operating system. In many cases, the delay in upgrading concerns whether applications built for Windows XP will run properly in Windows 7. Microsoft endeavored to make Windows 7 compatible with most Windows XP applications; however, not all are. To overcome compatibility issues, Microsoft added an option called “Windows XP Mode.”

Windows XP Mode
Windows XP Mode is an optional add-on that can be installed along with Windows 7 (available in Windows 7 Professional, Enterprise, or Ultimate editions). It provides a complete licensed Windows XP environment running inside of Windows 7 and runs within Windows Virtual PC. Both XP Mode and Windows Virtual PC can be downloaded for free.

Once installed, a desktop icon is used to launch XP Mode, opening up a complete Windows XP environment where applications can be installed. Applications that do not run properly in Windows 7 can be installed in XP Mode. Once installed, applications are displayed both in the XP Mode Start menu and the Windows 7 Start menu. Often, the application will then run properly within Windows 7; if not, these applications can be run within the Windows XP mode. In most cases, this solves application compatibility issues.

Click here for more information on a comparison of Windows 7 to previous versions.
Click here for more information on Windows 7 XP Mode.
Click here for more information on Windows Virtual PC.
Click here for downloads for XP Mode and Virtual PC.

HealthCare Information Management, Inc. (HCIM) is a Microsoft Partner.

If you wish to contact HCIM, please call 888-454-0202, option 5, and an HCIM associate will be happy to assist.

Microsoft SQL Server Management Studio 2008 Enhancements – IntelliSense

Thursday, June 24th, 2010

Microsoft® SQL Server® 2008 R2 recently arrived on the scene as an upgrade to SQL Server® 2008, which was originally released in August 2008. For those running on SQL Server® 2000/2005, now may be a good time to consider upgrading to the latest version.

One of the many new features introduced in 2008 that would be of interest to DBAs, developers, and those that write reports using T-SQL is an enhancement called IntelliSense. Developers who use Visual Studio will already be familiar with this feature. IntelliSense is not quite as advanced in SQL Server as it is in Visual Studio, but it is still very useful and well implemented. This feature is available when writing T-SQL statements within SQL Server Management Studio (SSMS) 2008.

After implementing IntelliSense, you will no longer need to remember T-SQL syntax or the names of database objects. This feature provides T-SQL syntax checking and automatic prompting for database object names and keywords. It automatically fills out the syntax as you type. Syntax errors are displayed using a red squiggly marker at the end of each T-SQL statement. This can speed up software development by reducing the amount of typing required and minimizing references to external documentation.

IntelliSense offers a few additional features besides syntax checking and word completion:

  • List Members
  • Parameter Info
  • Quick Info
  • Complete Word
  • Refresh Local Cache

These features can be accessed by navigating to Edit ? IntelliSense from the SSMS 2008 menu.

Note: Unfortunately, the IntelliSense feature is not available when connecting SQL Server Management Studio 2008 to SQL Server 2000 or 2005 databases.

Click here for more information on using IntelliSense.
Click here for more information on SQL Server 2008 R2.