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.
Field
Notes
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
Append Field Code
list.
NOTE
To write the text in this field to the custom database, you must include the
Report Text field code ($report_text$) in the
Database Insert String
field described
below.
Database Connect String
For database type...
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.
Database Insert String
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$)
NOTES
You can add field codes to the Insert String using the
Append Field Code
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.