Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

How can I get call history record

Discussion in '3CX Phone System - General' started by Summer41074, Apr 12, 2018.

Tags:
Thread Status:
Not open for further replies.
  1. Summer41074

    Summer41074

    Joined:
    Apr 12, 2018
    Messages:
    4
    Likes Received:
    0
    I know we can Enable CDR from Settings -->CDR, but I believe we can just get the call data record that is made after the time I enable CDR, right? But I already have many records in DB, how can I retrieve them? Can these be retrieved from 3CX's Database directly.
     
    #1 Summer41074, Apr 12, 2018
  2. StefanW

    StefanW Head of Customer Support and Training
    Staff Member 3CX Support

    Joined:
    Jun 2, 2009
    Messages:
    1,236
    Likes Received:
    96
    I strongly advice NOT to look into the DB of 3CX. Wrong operations will halt your system...
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 StefanW, Apr 12, 2018
  3. Summer41074

    Summer41074

    Joined:
    Apr 12, 2018
    Messages:
    4
    Likes Received:
    0
    Yes, I understand, and I wouldn't like too if there is any way that I can retrieve these history data out. Is there any way that can do?
     
    #3 Summer41074, Apr 12, 2018
  4. Summer41074

    Summer41074

    Joined:
    Apr 12, 2018
    Messages:
    4
    Likes Received:
    0
    And I will not do any other operations but just read these history records, and it will be one time operation. After the initial pull of data, we will enable CDR, and read CDR files to get information. Any suggestion?
     
    #4 Summer41074, Apr 12, 2018
  5. Summer41074

    Summer41074

    Joined:
    Apr 12, 2018
    Messages:
    4
    Likes Received:
    0
    Yes, I understand, and I wouldn't like too if there is any way that I can retrieve these history data out. Is there any way that can do?

    And I will not do any other operations but just read these history records, and it will be one time operation. After the initial pull of data, we will enable CDR, and read CDR files to get information. Any suggestion?
     
    #5 Summer41074, Apr 12, 2018
  6. voiptoys

    voiptoys Active Member

    Joined:
    Feb 13, 2013
    Messages:
    891
    Likes Received:
    156
    As Stefan made quite clear, accessing the database directly is strongly discouraged. Unfortunately, as you have noted, there is no way to get historical information except by accessing the database. You might consider our 3CX Exporter add-on for this purpose. It uses a very carefully crafted read-only connection to the PostgreSQL database, and has been in use around the world for about 6 -7 years without any issues. In addition, it also can automatically process the CDR files and place all this data in a SQL or MySQL database.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 voiptoys, Apr 12, 2018
Thread Status:
Not open for further replies.