Advanced PBX Data Logger is a universal solution that supports a wide range of PBX models. By default, the program logs only a limited set of the most necessary data. However, some PBXs can generate a lot more data. For a full list of parser variables for each PBX, please follow this link: http://www.aggsoft.com/pbx/.
If you need to log additional data to the database, you can modify the bindings between certain columns and parser variables. Our program creates a table named “PBXDATA” in the database. There are columns FLAG1 ... FLAG7, which may contain different values depending on your PBX model.
In the example below, you can see how to log the additional value “CALL_ID” for Avaya IP Office 500.
ODBC Database
1. Open the module’s settings window and switch to the “Binding” tab.
2. Find the column named “FLAG1” in the binding tree.
3. Click the “Parser item name” item and bind it to a different parser variable, “CALL_ID” (Figure 1). If the drop-down list does not contain the variable name, enter that name manually.
Figure 1. Binding in ODBC Database
SQL Database Pro
You can configure SQL Database Pro in the same way.
1. Open the module’s settings window and switch to the “SQL queue” tab.
2. Find the column named “FLAG1” in the binding tree.
3. Click the “Parser item name” value and bind it to a different parser variable, “CALL_ID” (Figure 2). If the drop-down list does not contain the variable name, enter that name manually.
Figure 2. Binding in SQL Database Pro
Note: If the parser does not have the variable you specified, an empty value will be written to the column.