Download TermLinx Database Manager

Using the TermLinx Database Manager
Database Manager Manual
4.4
TLX-DBM ♦ TermLinx Database Manager
Terminal Management System
Working Online
Working Online means that you have a connection to the "live" TermLinx
database. The changes you make will take effect as soon as you use the Delete,
Update, or Add buttons on the Table Maintenance dialog boxes.
To work online you must first connect to a TermLinx database:
1
2
Open the Administration menu, and then choose Database Connection. This
action opens the ODBC Login dialog box.
In the ODBC Logon dialog box, enter:
DSN = "TermLinx"
UserId = "TermLinx_mgr
Password = "TermLinx_mgr
3
Click OK to connect to the database.
To add new records which have been entered in offline mode:
You can add and modify records to the database even when you do not have a
database connection. TermLinx Database Manager saves your work in CSV
(Comma Separated Values) files, which you can use to update the "live"
TermLinx database the next time you connect to the database.
1
2
3
4
Open the File menu, and then choose Open. This action opens a standard
File Open dialog box.
Locate the file you saved during your offline section, and click Open. This
action opens a Table Maintenance dialog box corresponding with the table
data you saved during your offline session.
Select the first new record in the list window, and then click Add to add the
record to the database. The help window at the bottom of the dialog box will
confirm when the record has been added.
Repeat steps 2 and 3 for each record that must be added.
Tip: The order of the entries in the "Administration / Table Maintenance" menu can be helpful for
determining dependencies. Tables lower in the list may refer to tables higher in the list, but never
the other way round. So, to add a multi-table item, add to the listed tables in top-down order, and
when deleting, delete from the listed tables bottom-up.
To add new records:
1
2
3
4
Open the Administration menu, and choose Table Maintenance. This action
opens a submenu with a list of tables you can edit.
In the Table Maintenance submenu, choose the table to edit. This action
opens a Table Maintenance dialog box that allows you to view and edit the
contents of records in each table.
To create a new record, select <New record>.
Fill in the fields in the dialog box, and then click Add to save the record.
Important: The primary key for each record must be unique. You cannot create a new record that
has the same primary key as an existing record. You cannot change the primary key for an existing
record to be the same as the primary key for another record.
ProSoft Technology, Inc.
August 11, 2009
Page 17 of 128