REQUEST A DEMO

Author: Gary Sherman

Chief Technology Officer, Vice President of Products

Posts by Gary Sherman:

OLE Automation interface

July 10, 2007 Sample interface using OLE automation.http://www.dovetailsoftware.com/download/connections2001/ole_interface.zip--------------------Marty SirkinDovetail Software(512) 418-2905 x101marty@dovetailsoftware.comhttp://www.dovetailsoftware.com

New queueable obejcts in Clarify

Sample of how to create a new queueable object in Clarify.http://www.dovetailsoftware.com/download/connections2001/queueable.zip--------------------Marty SirkinDovetail Software(512) 418-2905 x101marty@dovetailsoftware.comhttp://www.dovetailsoftware.com

Useful scripts

A variety of useful scripts for Clarify:1) Convert newer versions of form files to older versions of Clarify.2) Get and print out a user-defined list3) Strip privclass header from form files4) UI Editor file for ClearBasichttp://www.dovetailsoftware.com/download/connections2001/scripts.zip--------------------Marty SirkinDovetail Software(512) 418-2905 x101marty@dovetailsoftware.comhttp://www.dovetailsoftware.com

Check the Clarify Routing Service & Restart

A script for Windows that uses the native WMI interface and Windows Scripting Host to check the routing server and restart it if necessary. This script does not require MKS, and it will run on Windows 2000 and .NET servers by default, and NT 4.0 if the add on for WMI has been installed.The script loops thru installed services, and when it locates the Clarify Routing Service, it checks to see if the service is running. If not, then the script attempts to start the service, otherwise it simply exits.The script should be scheduled to run as a Scheduled Task with a high frequency.It writes entries to the event log when it attempts to start the service and when the service fails to start. http://www.dovetailsoftware.com/download/user_contributed/check_service.zipThanks to Christopher Bennage for sharing this code!

Enforce Password Standards

Customization that allows enforcing of password standards, such as:The password must be 6-8 characters in lengthThe password must contain numbers & alphabetic charactersThe password cannot start or end with a numericThe password cannot contain the login nameThe password cannot match any of the previous 13 passwordsetc.http://www.dovetailsoftware.com/download/connections2001/password.zipgschwartz replied to this with: Gary,Thank you for this post. In reading through the code, it appears that the users' previous passwords will be stored in cleartext in the custom database fields you added to table_user. Am I reading this correctly?I'd like to avoid this, perhaps by using stored procedures or global code subroutines with decryption/encryption algorithms. They would not have to be the same ones clarify uses. Then we can store the encrypted old passwords and compare against the decrypted query results.Any suggestions on where to find algorithms like this? Or alternative implementation suggestions?Thanks…

Automtically Logging Out Inactive Sessions in dtCl

Within the dtClient, it is possible for a user to stay logged in for an indefinite period of time. But when you only have a limited number of licences available this can be undesirable. I have written this code to mimic the Clarify thick client functionality of releasing the license (logging the user out) after an hour of inactivity. When you are using dtClient, the console screen automatically refreshes itself (a default setting of two minutes). It is this code that keeps the users session "alive" on the server even when the user is not actively using the system. The purpose of this code is to detect that only the console screen is refreshing, and to remove the user if this continues for a specified amount of time.The modification to the dtClient code is very minimal. The first thing to…

Dovetail Software HGBST (User-defined Lists) Utility

The HGBST Utility is a command-line utility for Microsoft Windows that helps you visualize your user-defined lists (HGBSTs) and troubleshoot invalid data. If you have previously run the Dovetail Software Data Verifier and it revealed problems with your HGBST structures, this program will help you determine exactly what to do to fix it.This utility will only work on a Windows computer (2000 or later) and you must have the .NET Framework 1.1 runtime installed. Please see the readme file for more details on the requirements.To get started, download and extract the ZIP. Then, from the command-line, run:hgbstutils /?Readme File:http://www.dovetailsoftware.com/download/hgbstutils/ReadMe.txtZIP package:http://www.dovetailsoftware.com/download/hgbstutils/hgbstutils_1.0.0.3.zipChad MyersDovetail Softwarecmyers@dovetailsoftware.com512-418-2905 x102www.dovetailsoftware.com

ddlHelper – Using user-defined lists in web apps

The DdlHelper is a set of server-side ASP JScript and client-side browser JavaScript used to render multi-level user-defined lists (HGBSTs) in the dtClient or other dtSDK-based web applications.Readme File:http://www.dovetailsoftware.com/download/ddlHelper/DdlHelper_Readme.txtZIP package:http://www.dovetailsoftware.com/download/ddlHelper/DdlHelper.zipGary ShermanDovetail Softwaregary@dovetailsoftware.com512-418-2905 x105www.dovetailsoftware.com

Find-By-ID Enhancement

One of my Clarify users asked for this enhancement:The numbering system for Cases, PR's and Solutions in our system use a letter prefix - CS of cases, PR for part request, and so on. When you do it a dozen times in a day, it's really annoying to keep getting "No case with id PR12345" when you forgot to change the dropdown to "Part Request".The Find-By-ID interface on the left side of the console can be adjusted with just a few lines of JavaScript.Add this to the find_by_id() function in console_left.asp:// //Testcases: // Select PR Detail and enter PR28970-1 - should get PR Detail // Select PR Detail and enter 28970-1 - should get PR Detail // Select PR Detail and enter CS38187 - should get Case // Select PR Detail and enter PR28970 - should get PR Header //…

case history enhancement for dtClient

The following comes compliments of Kristina Pereyra: A user reported that the case history was all messed up - it started out going forward chronologically, then backward, then start again later and go backwards. It turned out to be people forwarding in emails with full quoted chains - something like this:**** case notes 12-31-2007 **** Issue reported by phone, details being mailed. 20 minutes on phone support.**** case notes 01-31-2007 **** Logs enclosed>>> 20 Jan 2007 >>>Can you send logs?>>> 1 Jan 2007 >>>The system is giving this funny error.**** case notes 01-20-2007 **** >>> 20 Jan 2007 >>>Can you send logs?>>> 1 Jan 2007 >>>The system is giving this funny error.**** case notes 01-01-2007 **** >>> 1 Jan 2007 >>>The system is giving this funny error.Well, I can't stop them from doing this kind of thing but I can do…