Logging to database

Per default the logon and logoff actions are logged to the Reports\Logon Groups folder. The logging into a database is performed by an ODBC driver. This behaviour can be configured in config tool or directly in the registry.

Logging to text file (default):

•Open registry editor regedit.exe

•Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\3iMedia\Call Queue Controller for SwyxWare

•Set LoggingType to "Text"

Logging to a database:

•Create the database (preferred name is "CDR")

•Open registry editor regedit.exe

•Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\3iMedia\Call Queue Controller for SwyxWare

•Set LoggingConnectionString to "Driver={SQL Server};Server=[ServerName];Database=[DatabaseName];Trusted_Connection=Yes;"

•Set LoggingType to "SQL"

•Tested on Microsoft SQL Server 2000/2005

The tables should be created automatically in the database connected by the connection string. See windows event log for error messages concerning database operations. Changes in the connection string should take effect immediately. A sample SQL connection string (LoggingConnectionStringSQLSample) is created in registry by default.

Annotation:

Using the connection string for SQL Server the SwyxWare account is used connecting to the database. This account needs sufficient rights to that database. Otherwise the following connection string can be used instead:

Driver={SQL Server};Server=[ServerName];Database=[DatabaseName];Uid=[Username];Pwd=[Password] (values in braces need to be replaced by there real values)

A list of connection strings for other databases can be found on http://www.connectionstrings.com/. The connection string for an ODBC connection should be used.