How to configure logging to the database using the ODBC Database modulePreliminary requirementsIf you are going to use an MS SQL Server, MySQL, or Oracle database, create a database with tables for storing data. You may find the corresponding SQL script or MS Access database file in "C:\ProgramData\Advanced PBX Data Logger\data" or in the "program folder\data" (for example, C:\Program Files (x86)\Advanced PBX Data Logger\data\). Note: the logger cannot automatically create a database for you. Maybe, you prefer to re-install the program. The installation wizard can create a database for you. For MySQL or Oracle, you need to install the latest 32-bit version of ODBC drivers separately. Download links:
MySQL ODBC Driver 32 bit SolutionYou need a database you want to use our PBX Reports utility. The logger writes all incoming data to a database in real-time, and PBX Reports works with the prepared data. If you have already installed our software, the following tutorial describes how to configure a connection with a database. 1. Create a new configuration (if you haven't done it yet)
2. Configure a connection to your PBX. 3. Switch to the "Modules → Query Parse Filter" tab and select a parser for your PBX (Figure 1). Note: A lack or incorrect operation of the parser may prevent data from being written to the database. The next section describes how to check the parser's operation.
4. Switch to the "Modules → Data export" tab and check the "ODBC database" checkbox (Figure 2).
5. Open the data export module's settings by double-clicking the module's name. 6. Click the "Load & Save" button (Figure 3), and select:
7. Switch to the "Common" tab (Figure 3) and enable data logging to the database.
8. Switch to the "Connection" tab. 8.1. If you already have an ODBC data source, select it from the list (Figure 4). 8.2. If you do not have any ODBC data source yet, click the "Setup" button and create a system ODBC data source. For more details, see the next section. After creating the data source, click the "Refresh" button and select the newly created data source in the list. 8.3. If you use the MS Access database, you should specify or select the database file (*.mdb) in the "Database file" field. You can find the empty database template in "C:\ProgramData\Advanced PBX Data Logger\data" or "program folder\data\". Then you should copy it to an accessible folder like "C:\Logs\pbxdata.mdb", and after this, select the copied database in the plugin settings.
9. Switch to the "Binding" tab and check that the list contains a description of database columns. If the item list on that tab is empty, go to step 6. 10. Click "OK" and save all changes both in the ODBC database settings window and in the module selection window. Now each time new data are received, the program will write them to the database in real-time. If you use the "PBX Reports" utility, you need to click the "Refresh" button on the "SMDR data" tab. Reports use real-time data without clicking the "Refresh" button. Related articles: How to configure logging to the database using the ODBC Database module
Advanced PBX Data Logger - Read more about:Call logging Call accounting SMDR to SQL SMDR Listener Cables and signals |
|
