Match audio recording files with CDR / Call Journaling data in 3CX v20

[ThomasEndal]

Hello,

I am currently working on integrating call data from a 3CX v20 Update 7 server.
I am retrieving:

• CDR files generated by 3CX
• Call Journaling data via the API
• AudioRecordings files

However, I cannot figure out how to link the audio recording files stored on the server with the corresponding calls.

At the end of the audio file names there seems to be an ID, but I cannot find this ID in the CDR output nor in the Call Journaling API response.
Because of this, I am unable to reliably match a recording with its corresponding call record.

Could you please clarify:

• Which field(s) in the CDR or Call Journaling data can be used to map a call to its recording file?
• Is there a documented way to decode or use the ID present in the recording file name?
• Or is there another recommended approach to consistently associate call recordings with call logs?

Thank you in advance for your help.

Best regards,
Thomas

 

[KyriacosS_3CX]

Hi,

If you have a a PRO or ENT install you can use the information in our published Grafana dashboard "11. Call Recordings Explorer" to see how these are linked.

I don't know if you will be able to use this same info for SMB calls/recordings.

 

[VoIPTools]

You may want to take a look at our 3CX Exporter tool. It has been updated to include the new v20 U7 tables including the new cdrrecordings table. That table has the linking information you need.

 

[Evolute IT]

Hello,

I am currently working on integrating call data from a 3CX v20 Update 7 server.
I am retrieving:

• CDR files generated by 3CX
• Call Journaling data via the API
• AudioRecordings files

However, I cannot figure out how to link the audio recording files stored on the server with the corresponding calls.

At the end of the audio file names there seems to be an ID, but I cannot find this ID in the CDR output nor in the Call Journaling API response.
Because of this, I am unable to reliably match a recording with its corresponding call record.

Could you please clarify:

• Which field(s) in the CDR or Call Journaling data can be used to map a call to its recording file?
• Is there a documented way to decode or use the ID present in the recording file name?
• Or is there another recommended approach to consistently associate call recordings with call logs?

Thank you in advance for your help.

Best regards,
Thomas

Use the CRM integration alone. [RecordingUrl] will give you a link to the file. Download that via whatever script you use. Boom, fixed.

Matching calls to recordings without database access is almost impossible. Better to use the already programmed features for this.