We followed this guide https://www.3cx.com/docs/sql-database-pbx-integration/ and it looks like the call journaling can output all calls and their data to a remote database, which can then be retrieved by the CRM and used as per our specific needs.If the above statement is right, can you please verify if the data below are being included in the 3CX remote database write?- outgoing number that was called
- extension that made the call
- call start time
- call end time
- call outcome (busy, no answer, completed, wrong number etc.)
- call duration
-call attempts
In the guideline that you have also attached you can see the available variables:
CallType
- The type of call, it can be “Inbound”, “Outbound”, “Missed”, or “Unanswered”.
Number
- The external contact number (the number dialed for outbound calls or the caller number for inbound calls).
CallDirection
- The direction of the call, either "Inbound" or "Outbound".
Name
- The name of the matched contact.
EntityId
- The ID of the matched contact.
EntityType
- The type of the matched contact (i.e. "Contacts").
Agent
- The extension number of the agent handling the call.
AgentFirstName
- The first name of the agent handling the call.
AgentLastName
- The last name of the agent handling the call.
AgentEmail
- The email of the agent handling the call.
Duration
- The duration of the call in “hh:mm:ss” format.
DurationTimeSpan
- The duration of the call as a TimeSpan object, which can be formatted as the user wants.
DateTime
- The start date & time of the call, in the local time zone, formatted using the local culture from the 3CX server.
CallStartTimeLocal
- The start date & time of the call, in the local time zone, as a DateTime object, which can be formatted as the user wants.
CallStartTimeUTC
- The start date & time of the call, in UTC time zone, as a DateTime object, which can be formatted as the user wants.
CallEstablishedTimeLocal
- The date & time in which the call was established, in the local time zone, as a DateTime object, which can be formatted as the user wants.
CallEstablishedTimeUTC
- The date & time in which the call was established, in UTC time zone, as a DateTime object, which can be formatted as the user wants.
CallEndTimeLocal
- The end date & time of the call, in the local time zone, as a DateTime object, which can be formatted as the user wants.
CallEndTimeUTC
- The end date & time of the call, in UTC time zone, as a DateTime object, which can be formatted as the user wants.
CallStartTimeLocalMillis
- The start date & time of the call, in the local time zone, expressed as milliseconds since epoch (aka unix time).
CallStartTimeUTCMillis
- The start date & time of the call, in UTC time zone, expressed as milliseconds since epoch (aka unix time).
CallEstablishedTimeLocalMillis
- The date & time in which the call was established, in the local time zone, expressed as milliseconds since epoch (aka unix time).
CallEstablishedTimeUTCMillis
- The date & time in which the call was established, in UTC time zone, expressed as milliseconds since epoch (aka unix time).
CallEndTimeLocalMillis
- The end date & time of the call, in the local time zone, expressed as milliseconds since epoch (aka unix time).
CallEndTimeUTCMillis
- The end date & time of the call, in UTC time zone, expressed as milliseconds since epoch (aka unix time).
These are the available information that you can send to the database.
In future posts please ensure that you create a post to the correct section(in this case to CRM)
