CDR Ouput

[jdb]

Is CDR\SMDR output available and if so what is the format?

Also how can this information be collected by a third party application?

[VAD_Support]

Call detail records are generated by 3CX just like for regular calls. You can query them using the 3CX Call Reporter tool.

Also, if you need more information about user behavior in the VAD callflow (for example, options selected, etc.), you can use a File Management component or Database Access component to write call records to a file or database by yourself on call disconnection. That way you can integrate with any other system you need.

[jdb]

Thanks for response

Just to clarify - we are the 3rd party developer.

I need to know how we would be able to get access to CDRs - as an example - would our customer need to configure CDRS to be output to a file that we could then collect?

Also I need to know what format they are in, eg. fields, field descriptions etc, as we would need to translate these CDRs for use in our own software.

[VAD_Support]

Call detail records generated by 3CX are in the PostgreSQL database, in the table "calldetails". You can explore it in your installation using a PostgreSQL client like this: http://sqlmanager.net/products/postgresql/manager/

In that table you have information related to the call, but there is no information about what the user did into the callflow. If you need that information, you will need to generate call records in the VAD callflow using a File Management component or a Database Access component, so you can store them where you need, and with the data and format you need.

[jdb]

OK, thanks for that.

We dont actually have an installation so I guess this is something the customer would have to do in order to generate CDRs

[VAD_Support]

Yes, your customer could see if the information generated is what they need. In that case just read CDRs from the database, otherwise you will have to add the required information using components in the VAD callflow.

[stefmar84]

Sorry, but i don't access on postgresql with pgamin to read the table called "calldetails".
witch parameter i need to do that?

thanks for all.

Stefano Marconi

[VAD_Support]

Hi Stefano,

Are you having problems connecting to the 3CX database? What are you trying to do?

[stefmar84]

I had developed an application for 3cx 7.1 that read the databsae of pbx (with ODBC) and copy data in my MsSql server for make particulary call statistcs and reports.
I had accessed with this parameter on pgadmin:
server: localhost
port: 5480
db:phonesystem
username:logsreader
password:logsreader

when I update to V8 I can't access to db with the same parameter.

Thanks

[VAD_Support]

Well, the database username and password may have been changed.

Take a look at your 3CXPhoneSystem.ini file. The file is under C:\Program Files\3CX PhoneSystem\Bin. In that file you have different database usernames and passwords, for different purposes (logsreader, configuration, etc.).

[stefmar84]

in my file 3CXPhoneSystem.ini i have this settings:

[CallReports]
USERNAME=logsreader
DATABASE=phonesystem
PORT=5480
DRIVER=PostgreSQL Unicode
SERVER=localhost
ReadOnly=1
PASSWORD=Bq4=5Y_j/njkjh3kj{2+Hc

the password is encripted. how I can use that?

[stefmar84]

Sorry,
i tryed the password and i enter.

thanks for all

STefano Marconi

[VAD_Support]

Yes, the password is not encrypted, it is generated with a strong password generation tool, but not encrypted.