Data Sources • Tree Structure • Search • Sorting • New... • Importing Data • Filter • Cache, Refresh • Data Form • Properties
Outlook • ACT! • combit address manager • cobra Adress PLUS • CAO-Faktura • Access Databases • Lotus Notes • Text files
<< Up >> | ### Access Databases | Page Index
Windows ODBC Manager

xtelsio CTI Client in combination with Access databases, or in general ODBC data sources
The data binding to Access is done ODBC. Therefore the following information also applies in general to ODBC data sources.
Example database, Management of shared address data
If you don't have an Access database, you can use the example database and adapt it to your needs: WORKING_DIRECTORY\test-db-access\contacts.mdb Tips to manage shared address data.
Linking a table from an Access database
To link an Access table: [File> New Folder Linking ...> ODBC, Outlook, Text files ...] Choose the entry [ODBC] in the dialog "Type of Data Source". In the dialog "Name and Content" you can change the suggested folder name and contents type if necessary. With [Next] the dialog "Select Data Source" from the Windows ODBC manager appears. Here you are able to either: to select an existing Data Source Name (DSN) to your Access database (if you have created this before), or to create a new DSN to your Access database with [Add...] and open it afterwards with OK. In the dialog "Select Table from ODBC Data Source" now all tables of the Access database are listed. Mark the desired table and hit [Next]. In the dialog "Column Selection" you can vote out not required columns. Hint: The first column should always contain the record ID (auto ID field of Access). In dialog "Column Properties" the columns have to be typecast by their contents. In dialog "Cache" you should keep the defaults and close the dialog sequence with [Finish]. => the Access table is now visible in the folder structure. If you want to link several Access tables in the CTI Client, you have to repeat the procedure accordingly. Later modifications of the folder settings: Right-click the folder and choose [Properties (folder)].
Adapt data mask individually: Select a record in the linked Access folder and open the accompanying data mask by F2 key or context menu. By the right tool button you can switch the data form in the editor's mode and arrange the fields by own requirements. Refresh view of changed records (synchronisation): If records have been modified, added or deleted in Access, these changes are not visible immediately in xtelsio CTI Client, because of data cache. To make changes visible, the following synchronisation modes are supported: manual synchronisation of the complete folder: Mark in the folder and press the functional key F5. Then all changed records are read in anew. If you press F5 within 5 seconds again, the folder is completely read in anew. manual synchronisation of a record: If you stand in the folder structure on a record and hit the F5 key, this record is read in anew. A record is likewise read in anew if it's opened in the data form. Automatic synchronisation of the complete folder: By default, linked folders are synchronised once per week. The synchronisation interval can be adapted individually via [Folder > Properties > Cache].
Dial a phone number in Access
There are three ways to dial phone numbers: Dial by ActiveX-Control (only in the Professional version) Dial by Hotkey Dial by middle mouse key (example with Outlook)
Show incoming calls
Incoming calls are indicated via phone popup window. A left mouse click on the button opens the contact data mask of xtelsio CTI Client. The data mask can be opened with a an incoming phone call also automatically - see folder option: [Context menu of the folder > Properties (folder) > Properties]
Show incoming phone calls directly in an Access form.
This function is supported in the Professional version by ActiveX-Control.