Create a template from RealTime

The first step in creating a text file that describes the contents of a RealTime database (RTDB) table is the production of a template file. The dbll template option creates an ASCII text file containing all of the defined fields in an RTDB table.

The template file is initially created with all fields in a table, but you can use an editor to eliminate unnecessary fields. Such selective processing ensures that only specified fields are loaded or listed. The order of these fields is important only if the resulting text file is loaded into RealTime using SAFELOAD.

For example, you can use a template of the analog table to obtain a list of all current values. This file can then be edited to delete all fields (such as alarm limits, setpoints, etcetera) that are not relevant to current point values. To deal with unwanted lines, either place a semicolon (;) at the beginning of each of the lines, or simply delete them.

Syntax

(To create a template):

dbll template <table_name> <output_file>

Where:

<table_name> is the name of an RTDB table (for example, alarm, group, rate, remote, etcetera).

<output_file> is the name of the output template file.

The output template file (output_file) is placed in the current working directory from which dbll was executed, unless another directory is specified in conjunction with the filename. This holds true for all files created by dbll.

Note: The directory specification should not contain environment variables.

RTDB tables can be listed in text files in three different format: list, tabular, or flat. The syntax used for these formats is as follows:

dbll [list|tabular|flat] <template_file> <list_file> <output_file>

Where:

<template_file> is the name of the template file containing the table name and desired fields.

<list_file> is the point list file. Enter the "wild card" asterisk (*) to list all of the records in the table. If a record has been created, enter the name of the file. If there is no record list file, you can create it using a text editor such as notepad. The list file lists the name of all the records that were included on separate lines. Use semicolons to denote comments.

Example

;RTU DV02

DV02PTDV0602

DV02PTDV0611

<output_file> is the name of the output file. This file is stored in the current working directory, unless another directory is specified in conjunction with the file name.