• Introduction
• Tutorial Instructions
• More Information

Introduction

Creating VMD Tables for an ADT message: In this tutorial you will learn how to create a VMD file containing database tables corresponding to an HL7 ADT message.

We will create a file that uses similar table structures to the demo.vmd files that are included supplied with Iguana. This way you have something to compare to, and you can try it in the basic tutorials.

To create a custom VMD file to match your HL7 message structure, just follow the same steps using your own table structure. Substitute your own message requirements in the steps that copy/compare the supplied message or demo.vmd.

If you have any questions about using Chameleon please contact us at support@interfaceware.com.

Tutorial Instructions [top]

1. Run Chameleon
   For example you can search for “chameleon” in Windows 10:
   
   Note: Chameleon is a Windows only program that is bundled with the Iguana for Windows install.
2. Close the Chameleon welcome screen.
3. Create an empty VMD by clicking the New button on the toolbar:
   
4. Create the ADT message.
   1. Click Message on the toolbar to create a message:
      
   2. Change the message name to ADT.
      Click on the name to edit it and type “ADT”:
      
   3. Double click the Identity and enter “ADT Event” in the Description:
      
5. Add the patient table to match the demo.vmd.
   Note: To add custom tables simply create tables that match your requirements.
   
   1. Click Table on the toolbar to create a table:
      
   2. Change the table name to patient.
      Click twice (slowly) on the name to edit it and type “patient”:
      
   3. Double click the renamed patient table to edit it.
   4. Enter “Patient Table” in the Description field:
      
   5. Add the Id Key column to the patient table.
      Click in the column field and replace “Column1” with “Id”:
      
      Then select the Key check box:
      
   6. Add the remaining columns.
      Note: All columns are String except for Dob which is Date Time.
      • LastName
      • GivenName
      • Race
      • PhoneHome
      • PhoneBusiness
      • Religion
      • MaritalStatus
      • Ssn
      • LicenseNumber
      • Dob (data type: Date Time)
      • Sex
      • Weight
   7. When you have finished the table will look like this:
      
6. Add the remaining table to match the demo.vmd.
   Note: To add custom tables simply create tables that match your requirements.
   1. Create the kin table, no key column, all columns are String.
      • Description: “Next of kin”
      • PatientId
      • LastName
      • FirstName
      • Relationship
   2. When you have finished the table will look like this:
      
7. Add the Tables to the new message definition.
   1. Edit the ADT Message Grammar by double clicking on it:
      
      This will open the message grammar dialog:
      
   2. Right click and insert the Tables into the Table Grammar pane:
      
      
   3. The Table Grammar pane should now contain both tables:
      

      Tip: You can re-order the tables using click and drag.

   4. Ignore the “Grammar root is not set” warning as this is a legacy setting that is not required when using VMD files with Iguana:
      
8. Compare the new table grammar to demo.vmd.
   Note: When using your own tables check that they match your requirements.
   1. Open the supplied demo.vmd (<install dir>\edit\admin\other\demo.vmd) in Chameleon.
      Get the demo.vmd from the Translator project file pane:
      
   2. Then click Open to open it in Chameleon:
      
   3. Comparing the two message grammars shows they are the same:
      
      
   4. Compare the table definitions.
      1. Double click the patient tables and compare definitions:
         
      2. Compare the kin table the same way.
9. The demo.vmd contains extra segments (and composites) that are not needed. Because it is best practice to keep our VMD as simple as possible we will not add any of these.
   Here you can see some of the extra (unused) segments:
   
   Note: Keeping the VMD as simple as possible (minimum number of messages, no unused segments) helps to reduce overheads and improve performance.
10. Save your new VMD file as demo_tables.vmd.
11. Test the demo_tables.vmd file in a project.
    1. Open a channel that uses the demo.vmd:
       
    2. Add demo_tables.vmd to the project, using the [+] link:
       
    3. Duplicate the db.tables{} statement using demo_tables.vmd:
       
    4. Compare both Out table node trees as you can see they are identical (other than the order):
       

More Information [top]

• The Chameleon reference section
• The Chameleon FAQs section
• The Chameleon TIPs section
• Understanding VMD Files
• How to Create VMDs
• How to Create VMDs
• Features Disabled in Chameleon Toolkit after Chameleon 6.0
• Best Practice: Using Multiple VMD files