REDIRECT_QS_SrvConn=6 REDIRECT_QS_AllConn=6 REDIRECT_QS_ConnectionId=17156955709765571401435 REDIRECT_MMDB_ADDR=3.144.231.52 REDIRECT_MMDB_INFO=result found REDIRECT_GEOIP_COUNTRY_CODE=US REDIRECT_GEOIP_COUNTRY_NAME=United States REDIRECT_GEOIP_CONTINENT_CODE=NA REDIRECT_SCRIPT_URL=/pbx-data-logger/tutorials/pbxlogger-database-add-data.htm REDIRECT_SCRIPT_URI=https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-database-add-data.htm REDIRECT_prefer-language=en REDIRECT_HTTP_PREFER_LANG=en REDIRECT_HTTP_PROTO=http: REDIRECT_HTTP_GEOIP_COUNTRY_CODE=US REDIRECT_SUBPAGETYPE=examples REDIRECT_LimitDecodeAis_Counter=0 REDIRECT_DOCUMENT_PATH=/usr/sites/aggsoft/www.aggsoft.com/web/pbx-data-logger/tutorials REDIRECT_FILENAMEONLY=pbxlogger-database-add-data REDIRECT_REL_CANONICAL=https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-database-add-data.htm REDIRECT_HTTPS=on REDIRECT_SSL_TLS_SNI=aggsoft.com REDIRECT_STATUS=200 QS_SrvConn=6 QS_AllConn=6 QS_ConnectionId=17156955709765571401435 MMDB_ADDR=3.144.231.52 MMDB_INFO=result found GEOIP_COUNTRY_CODE=US GEOIP_COUNTRY_NAME=United States GEOIP_CONTINENT_CODE=NA SCRIPT_URL=/pbx-data-logger/tutorials/pbxlogger-database-add-data.htm SCRIPT_URI=https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-database-add-data.htm prefer-language=en HTTP_PREFER_LANG=en HTTP_PROTO=http: HTTP_GEOIP_COUNTRY_CODE=US SUBPAGETYPE=1 HTTPS=on SSL_TLS_SNI=aggsoft.com HTTP_ACCEPT=*/* HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) HTTP_COOKIE=fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate HTTP_HOST=aggsoft.com PATH=/sbin:/usr/sbin:/bin:/usr/bin SERVER_SIGNATURE=<address>Apache Server at <a href="mailto:support@aggsoft.com">aggsoft.com</a> Port 443</address> SERVER_SOFTWARE=Apache SERVER_NAME=aggsoft.com SERVER_ADDR=104.238.133.207 SERVER_PORT=443 REMOTE_ADDR=3.144.231.52 DOCUMENT_ROOT=/usr/sites/aggsoft/www.aggsoft.com/web/ SERVER_ADMIN=support@aggsoft.com SCRIPT_FILENAME=/usr/sites/aggsoft/www.aggsoft.com/web/pbx-data-logger/tutorials/examples.html REMOTE_PORT=60402 REDIRECT_QUERY_STRING=pbxlogger-database-add-data REDIRECT_URL=/pbx-data-logger/tutorials/pbxlogger-database-add-data.htm GATEWAY_INTERFACE=CGI/1.1 SERVER_PROTOCOL=HTTP/1.1 REQUEST_METHOD=GET QUERY_STRING=pbxlogger-database-add-data REQUEST_URI=/pbx-data-logger/tutorials/pbxlogger-database-add-data.htm SCRIPT_NAME=/pbx-data-logger/tutorials/examples.html DATE_LOCAL=Tuesday, 14-May-2024 14:06:10 UTC DATE_GMT=Tuesday, 14-May-2024 14:06:10 GMT LAST_MODIFIED=Wednesday, 24-Sep-2014 11:26:01 UTC DOCUMENT_URI=/pbx-data-logger/tutorials/examples.html USER_NAME=aggsoft DOCUMENT_NAME=examples.html QUERY_STRING_UNESCAPED=pbxlogger-database-add-data DOMAIN_ADD=/pbx-data-logger/ DOWNLOAD_URL=/download/ DOWNLOAD_URL_NAME=USA DOWNLOAD_URL2=https://dl2.aggsoft.com/ DOWNLOAD_URL2_NAME=Europe TAG=pbxlogger TAGID=19 SUBSCRIBE_LIST=pbxlogger DOWNLOAD_EXE_NAME=pbxlogger3 DOWNLOAD_ASK_EMAIL=Advanced PBX Data Logger Enterprise TITLE=Advanced PBX Data Logger TITLE2=PBX Data Logger captures SMDR or CDR data from RS232, RS845, TCP or UDP ports and can write it to various files or databases. PLUGIN_NO_PARSER=1 PLUGIN_NO_LOGGING=1 VERSION_ENT=1 VERSION_PRO=1 VERSION_STD=1 PRODUCT_HOME=/pbx-data-logger.htm PRODUCT_RSS=https://www.aggsoft.com/incl/pbxlogger.rss.xml PRODUCT_FAVICON=/pbx-data-logger/favicon.ico PRODUCT_REL_DATE=2001-01-01 PRODUCT_VER=3.7.8.514 PRODUCT_DOMAIN=https://www.aggsoft.com PRODUCT_CAT=UtilitiesApplication PRODUCT_CAT2=Data Logger Software PRODUCT_PRICE=145.00 PRODUCT_PRICE_CURRENCY=USD PRODUCT_RATING=4.9 PRODUCT_RATING_COUNT=44 PRODUCT_REVIEW_COUNT=24 ITEMS_LC=pbx ITEMS_UC=PBX ITEMS=PBX data TUTOR_PATH=/pbx-data-logger/tutorials/ RELATED_FILE=/pbx-data-logger/tutorials/pbxlogger_related.htm LABEL_LANG=en LANG_PATH= LABEL_DOWNLOAD=Download LABEL_BUY=Buy LABEL_BUY2=Buy Now! LABEL_BRIEF=Brief description: LABEL_PROBLEMS=What problems can be solved with Advanced PBX Data Logger? LABEL_GETTING=Getting started is easy. Advanced PBX Data Logger is ready! LABEL_FEATURES=Features: LABEL_SCR1=Screenshot: LABEL_SCR2=More screenshots LABEL_COMP1=Compatible with Windows 7 LABEL_COMP2=Works with Windows Server 2008 R2 LABEL_RELATED=Advanced PBX Data Logger related topics: LABEL_RELATED2=Related downloads: LABEL_OS_VER=incl. Server, x86 and x64 LABEL_LAST_NO_SPACES_AFTER=!!! LABEL_ABOUT=About LABEL_AWARDS=Awards LABEL_CHANGELOG=Changelog LABEL_HELP=Help LABEL_LANGNAME=LangName LABEL_PDFMANUAL=PDF manual LABEL_PLUGINS=Plugins LABEL_SCREENSHOTS=Screenshots LABEL_TUTORIALS=Tutorials LABEL_VER=Latest version: LABEL_VER_FOR=For LABEL_CONTACT=contacts LABEL_SUPPORT=support LABEL_PRODUCT=product LABEL_ONLINEHELP=Online Help LABEL_AWARDS2=Some program awards LABEL_FEAT1=Feature Matrix LABEL_FEAT2=Features comparison LABEL_BUYNOW2=Prices and purchase LABEL_DOWNLOAD1=Free trial version LABEL_DOWNLOAD2=Free trial version LABEL_KEYWORDS=pbx logger,pbx data logger,smdr logger,cdr logger,calls logger,smdr to database,call accounting LABEL_TITLE=PBX Data Logger - captures and logs phone calls for more than 260 PBX LABEL_DESC=PBX Data Logger allows you to capture and store call records from SMDR or CDR data to databases and generate informative reports LABEL_SLOGAN=Trust In Confidence! TUTOR_TITLE=Log additional data from your PBX TUTOR_KEYWORDS=pbx to database, pbx, database, write pbx to database, additional data, writing custom values, pbx logger, pbx data logger, Advanced PBX Data Logger TUTOR_DESC=Log additional data from your PBX REL_CANONICAL=https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-database-add-data.htm MAIN_CSS_INCLUDED=1 PRODUCT_FAVICON_TYPE=x-icon DISABLE_GA=1 PRODUCT_GA=UA-911637-1 DELAYLOAD_OK=1 PRODUCT_HOME2=https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-database-add-data.htm PRODUCT_LDS_JSON_AUTHOR={"@type": "Organization","name":"AGG Software","url":"https://www.aggsoft.com","logo": {"@type": "ImageObject","url": "https://www.aggsoft.com/img/aggsoft48.gif"}} PRODUCT_LDS_JSON=<script type="application/ld+json">{ "@context": "https://schema.org","@type": "TechArticle","headline": "Log additional data from your PBX","image": "https://www.aggsoft.com/img/aggsoft48.gif","author": {"@type": "Organization","name":"AGG Software","url":"https://www.aggsoft.com","logo": {"@type": "ImageObject","url": "https://www.aggsoft.com/img/aggsoft48.gif"}},"genre": "Tutorial","dependencies":"Advanced PBX Data Logger software installed on your computer","proficiencyLevel": "Beginner","publisher": {"@type": "Organization","name":"AGG Software","url":"https://www.aggsoft.com","logo": {"@type": "ImageObject","url": "https://www.aggsoft.com/img/aggsoft48.gif"}},"url":"https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-database-add-data.htm","mainEntityOfPage": "https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-database-add-data.htm","description": "Log additional data from your PBX"}</script> GET_DOWN_BTN_NARROW=1 bg

Advanced PBX Data Logger


Log additional data from your PBX

Call logging to a database 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: https://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.

Binding in ODBC Database
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.

Binding in SQL Database Pro
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.

Related articles: