Gary Sherman
June 30, 2015

When we have to insert, update, or delete data, DIET (Dovetail ArchiveManager) is often the tool of choice.

Updating an object

Typically, when we want to update some data, we just need to define its uniqueness properly.

For example, if I wanted to update a business rule property name,  I could define its uniqueness as a combination of its object type + name.

For example:

If I used DIET to import this file, and this prop_name  record didn’t exist in the database, then it would do an INSERT, which would create this prop_name record.

If I used DIET to import this file, and this prop_name record did exist in the database, then it would do an UPDATE, which would update the existing prop_name record. This would allow me to update the path or max length of that rule

Gary Sherman
January 11, 2012

Last year I posted about automated deployments for Clarify. From that post:


Doing automatic deployments of Clarify changes is pretty straightforward. If I was starting off, I would use a contemporary build script tool such as nant or rake, and simply have it call out to your schema editing tool (Dovetail SchemaEditor, or ddcomp) to perform schema changes, use an import tool (such as Dovetail ArchiveManager, or dataex) for importing forms, and then compile your Clearbasic code using CBEX, or just import it as a DAT file using Dovetail ArchiveManager. File copying, registering components, configuring web servers, and setting permissions are all common tasks that are available in these build tools as well.


Should you also need to do additional stuff in your database, some code that uses the Dovetail SDK can be useful.


You could tie

Gary Sherman
March 20, 2008

Whenever I have to do something more than a few times, I like to make a shortcut or a utility for it. I have all of these in my c:\bin directory, and I have my system path set to include c:\bin.  These utilities mean that I don’t have to think about a lot of heavy syntax most of the time.


For example, to import a DAT file into my database, rather than using:


c:\bin\diet.exe -license MyDietLicenseKey -user_name sa -password sa -db_server . -db_name dovetail -import file.dat -sqllog sql.log



I just have to use:


import dovetail file.dat



Much easier to remember, and much easier and quicker to type.


Most of these are geared towards running on my development system, which is primarily SQL Server running onlocalhost with an sa password of sa.


Here’s a few common

Gary Sherman
November 13, 2007

I was working with a customer today, and they mentioned that one task that is problematic for them is moving business rules from their test database into the production database. Currently, the business rule is manually created via the Clarify Client in the test instance, and then when its all working, it is then again manually re-entered into the production. Manual re-entry is a point of potential failure. The rule may have been perfect in test, but a simple typo when re-entering it in production can cause havoc.

One solution to this issue is to archive the business rule using ArchiveManager or dataex from the test database, and then use ArchiveManager or dataex to import it into production.

Business Rule

First, I created a new business rule in my test system:

Object Type:CaseRule Name/Description:New Employee RequestStart Event:DispatchCancel Events:NoneConditions:Case Type = New EmployeeAction Title:Create

International: +1 (512) 610-5400
Toll Free: 1 (800) 684-2055