Monitor and control equipment
i-Vu CCN Pro 4.2 69
You may create a table in an existing third-party database or create a new database.
Using your database management tool, create a table in your custom database that includes fields for each
alarm field code to be written to the table. Each field length in the table should be as long as the longest
value to be written to that field.
To set up i-Vu CCN Pro to write to a custom database instead of the i-Vu CCN Pro alarm database, select the
Specify Custom Database checkbox on the Alarms page Actions tab, then enter information in the remaining
fields. See table below.
Text to write to the
database
The text is made up of field codes that add live data to the text. You can select
additional field codes from the
list.
To write the text in this field to the custom database, you must include the
Report Text field code ($report_text$) in the
field described
below.
SQL Server
MySQL
PostgreSQL
The connect string format is...
jdbc:odbc:<odbc_alias>
jdbc:mysql://<host>:<port>/<instance>
jdbc:postgresql://<
host>:<port>/<instance>
where:
<
host> is the database server name/IP address
<
port> is the port number for the database
<
instance> is the database name in the database server
<
odbc_alias> is the name of the ODBC data source
Database Login and
Password
The login and password to connect to the database.
Use the following format:
Insert into <TABLE_NAME> (<column1_name>, <column2_name> ...) values
(<$field_code1$>, <$field_code2$>, ...)
Example:
Insert into i-Vu CCN Pro_ALARMS (TIME_, LOCATION_, TO_STATE_, TEXT_) values
($generation_time$, $location_path$, $to_state$, $report_text$)
You can add field codes to the Insert String using the
list.
If you add a timestamp type field code (for example, $generation_time$), you
should have the data go into a timestamp data type field in the custom database.
Otherwise, you must use field code formatting to format the time.
To Next Page
Loading...
Need help?
General
