The xtelsio CTI Sever offers optionally a central call journal based on a text file in the server working directory. If you want to store central journal entries in a database, you can use a special configured xtelsio CTI Client with a folder of type <Server Journal>. This folder is used then as a ODBC connector to a table of your database.
- Activate the sever journal by xtelsio CTI Server management.
- You have to create a new journal table in your database or to adapt an existing table.
- Create the columns in the journal table. Supported columns are listed under 1). You an use all columns or only a selection of these columns.
- Link the table in xtelsio CTI Client via [File > New... > New Folder Linking...]
- Select "ODBC" for database type.
- In dialog "Name and Content" you can set the name of the folder, for example "Server Journal". And the content type must be set to "Server Journal". A new button should be shown to set connection parameters. Click to this button. In the next dialog you may have to enter the IP address of the xtelsio CTI Server. If "Connected" is already shown, you may have an existing Server connection, for example an opend TAPI device.
- In next dialog you have to setup the ODBC connection to journal table of your database.
- In next dialog you can select needed columns.
- In next dialog "Column Properties" you have to set the parameters "Name Column" and "Column Type" for every column. The flag "Name Column" may be set to column "name". Use the column types with prefix "Journal_"! If the table has an extra ID column, assign the type "ID" to it.
- Activate the cache in next dialog.
- Click to "Finish"
- Now you should see a new folder "Server Journal".
Hints:
- As soon as in the journal of the xtelsio CTI Server a new entry was added, this entry is transferred by TCP also to the xtelsio CTI Client and is entered via the folder "Server Journal" into the journal table of the database. The journal entries are not shown in the CTI Client!
- The search for the record of the caller ID can be done by the special Client with the linked server journal or also decentral (by the clients of the xtelsio CTI Server). For the second (decentral) way, the following option have to be activated in the Client: [Options > Journal > Log Calls in xtelsio CTI Server].
Columns Type Name Format a) Content Journal_In_Out Text [1] i=incoming, o=outgoing Journal_TimePoint Text [20] JJJJ-MM-TT HH:MM:SS Journal_TimePointNumeric Date/Time Time as a numerical value Journal_ConnState Text[4] Connecting state as text
CONN = connected
RING = Ring (incoming/outgoing)
BUSY = occupiedJournal_PhoneNumber Text[30] phone number Journal_Name Text[100] Name to the phone number b) Journal_Company Text[100] Company name to the phone number b) Journal_LocalPhoneNumber Text[30] own phone number (MSN) Journal_Redirected Text[30] The phone number about which a phone call was redirected Journal_RecordID Text[50] or
Number (Long Int)
ID of the record to the phone number b) Journal_RecordTable Text[30] Name of the table in which the record was found. b) Journal_RingTime_ms Number (Long Int) Ring duration in milliseconds Journal_ConnTime_sec Number (Long Int) Connecting duration in seconds Journal_LCR Text[10] LCR prefix (if used) Journal_Charge Number (Long Int) Charges in cent (only in combination with LCR) Journal_PSTN Text[4] The used outside line access code Hints:
a) You can adapt the size of the single text fields if necessary, e.g. if the company name needs less then 100 characters.
b) These values are only available if a record was found to the phone number. The search for the phone number is the job of the xtelsio CTI Client.