Name and Content • Data source • Column Selection • Column Properties • View • Cache • Properties
Up | ### Special folder 'Server-Journal' | Page Index

Basics:
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.
Configuration:
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].
1) Supported columns by xtelsio CTI Client:
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 = occupied
Journal_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.