beautypg.com

The application log, Using an-x-dcslog with insql – ProSoft Technology AN-X-AMX User Manual

Page 19

background image

AN-X-DCSLOG Page

15

The header is followed by data records. These consist of:

• the tag name

• 0 (original value)

• date

• time

• 1 (raw data)

• value

• 192 (quality detail)

Example

DcsTest_01_32,0,2004/08/04,20:00:49.875,1,15037,192

The Application Log

AnxDcsLog logs information and error messages to the file AxDcsLog.txt in the same
directory as AnxDcsLog.exe

Each time the service starts, it deletes any previous version of the application log file.

You can use the DeviceName to identify the AN-X associated with a message.

Example

2004/08/04,20:16:49 :INFO - Starting AnxDcsLog service (v1.0.0.19) ...
2004/08/04,20:16:49 :DEBUG - configured drop 0 - ff,0
2004/08/04,20:16:49 :DEBUG - configured drop 1 - ffffffff,ffffffff
2004/08/04,20:16:49 :DEBUG - configured drop 0 - ff,0
2004/08/04,20:16:49 :DEBUG - configured drop 2 - ffffffff,ffffffff
2004/08/04,20:16:49 :INFO - Starting the log function for AmxLog9
2004/08/04,20:16:49 :INFO - Starting the log function for AmxLog10
2004/08/04,20:17:46 :DEBUG - SERVICE_CONTROL_STOP
2004/08/04,20:17:46 :INFO - stop capture for device AmxLog9
2004/08/04,20:17:46 :DEBUG - Thread for AmxLog9 is dead
2004/08/04,20:17:46 :INFO - stop capture for device AmxLog10

2004/08/04,20:17:46 :DEBUG - Thread for AmxLog10 is dead

Using AN-X-DCSLOG with InSQL

Creating the Tag Database

Before InSQL can read the data logged by AnxDcsLog.exe, the corresponding tags must
exist in its tag database.

The easiest way to create the tags is to create a word and boolean tag in InSQL, export
those tags to a CSV file, edit the CSV file to create additional tags, then import the
modified file into InSQL.