Transforming Technologies DataTermD User's Manual

DataTermD

Overview

• The Data Terminal in combination with COM collects ESD tests measurement data
• User identification with any USB HID input device (RFID, barcode, magnetic card, keyboard)
• Optional USB relay to trigger a turnstile
• Central data collecting and control server synchronizes measurement data and access control
• Open database interface for connecting customer systems

DataTermD is the service which runs on a server, called "Data Collector" in this example. DataTermC is the configuration program for this service with graphical user interface.

The service collects measurement data of the configured devices and distributes user data and access policies on top of the user- and measurement database.
The device communication can be established via secure HTTPS connection.
After installation and device configuration the software is ready to use and stores the data in an internal SQLite database. The customer can even select his own database if required. In this case the administration is the cutomer's duty. You can find the database definitions below in section Database connection and Database definition.

Software Installation

System requirements

PC, Server or Virtualisation with at least:

• Windows 7 (32- Bit / 64-bit)
• 100 MB free disk space
• Ethernet interface

Install the software by running dataterm_setup.exe. The default destination is c:\dataterm.

After installation the script install_service.bat is executed, this registers and runs datatermd.exe as a Windows service.

The service is running in background and synchronizes measurement and user data to the configured devices.

Optional:

Alternatively you can run the service with parameter --user, --run and --create from the command-line. Parameter --user enables the user management

Parameter --run executes the program once. This can be used to run the program from within Windows Task planer instead of installing it as a service.

For external databases parameter --create helps to create the initial database skeleton during the first run.(Use this option only if you don't want to maintain the database tables by your own)

Example:

c:\dataterm\datatermd.exe --user --run --create

Error and status messages are logged to the file datatermd.log.
For failure analysis you can run the program with option --debug from the command line to enable erbose logging.

Important:

Make sure the logged in user has write permission to the file dataterm.cfg in folder data. Otherwise the configuration settings can't be saved.

Database Connection

Two different database connections must be established for measurements users. It is possible to use the same or different databases for it.

In the following example we use the same database for measurement and user data.

Following database connections are possible:

Default (no configuration required)

After installation the program uses the internal SQLite Database with common file for measurements and users.

MySQL

This establishes a connection to an external MySQL database.
Name of the measurement and user database is dataterm in this example. The database is on the server host.company.com and listens on Port 3306.

MS-SQL(EXPRESS)

This establishes a connection to an external Microsoft SQL database.
Name of the measurement and user database is dataterm in this example. The Microsoft SQL-Express Database is on the server SERVERNAME and listens on Port 1433.

Alternative with DSN:

This connection requires a 32 Bit ODBC system datasource. Use the 32 Bit ODBC-Administration from C:\Windows\SysWOW64\odbcad32.exe for configuration.
Create a System-DNS with arbitrary name i.e. dataterm in this example.

Database Definition

Table - userdata

ID:          Primary key of the table is not used further.

ACCESS: Access permissions: Comma separated list of allowed devices. The declaration of ranges is allowed i.e. (1,2,3-10)

USERID: Unique value for the user.

NAME: Text field to hold the name of the user, a user number or similar. If the name begins with the service-access is active (access even if measurement values are out of range)

FNAME: Is optional, can contain the first name or additional text. Internally it is combined together with the field NAME to field USERNAME. The maximum length together with field NAME is 30 characters.

Table - measdata

ID: Primary key of the table is not used further.
DEVICE: number of the device
UNIXDATE ,DATETIME: Time- and date stamp of the measurement
RSG,RSL,RSR,RHG: Measurement data
ERG: Result code of the measurement
MSG: Normal writing of the result code

Userdata Maintenance & Measuremet View

After the installation the free tool SQLiteStudio can be found in the program directory. This program can be used to edit the SQLite database. The table userdata contains the personnel data.

Views can be used for SQL-queries i.e.:

• Show all users who have tested today
• Show all users who have tested successfully today
• Show all users who have not tested successfully today

Importing user data

1. Create a CSV file with the columns id, access, userid, name, fname as illustrated.

1. Open the context menu by right mouse click to userdata table and select "Erase table data" to delete all
2. To import the CSV file select "Import data to table" in the same context menu.

Data evaluation with MS-Excel

Prior to access the database with MS-Excel you've to install the ODBC driver sqliteodbc.exe. The file is located within the installation path in the subdirectory addon.

Use the ODBC-Database administration C:\Windows\SysWOW64\odbcad32.exe to configure a User- DNS with the path to the database as illustrated below.

MS-Excel view:

Appendix A

Table measdata, field msg - Message text of the terminal

By default this is the text received from the terminal.

However it is possible to customize the messages.
Rename the English template file "data/messages.cfg.en.template" to "data/messages.cfg" and edit the content accordingly if desired.