Patch Release CX4.7.1

Release Name	CX4.7.1
Status	QA-PASSED
Release Date	10 Mar 2025
Release Summary	MSSQL Target Support in ETL Routing bug fixes Campaigns bug fixes All fixes from CX4.4.11 All fixes from CX4.5.5.1
Upgrade Guide	CX4.7 to CX4.7.1

New in CX 4.7.1

This is a patch release on top of CX4.7. This includes a few enhancements and critical fixes.

Enhancements

Features

Description

MSSQL Target Support in ETL

Adds support for Microsoft SQL Server (MSSQL) as a target in the Expertflow Data Platform. This includes implementing the necessary database connection, schema creation, and data loading mechanisms to enable seamless data ingestion into MSSQL. Ensure compatibility with existing pipeline configurations and support both insert and upsert operations.

Campaign Object Upgrade

Adds two reporting fields to the Campaign Object:

CreatedAt (at the time of csv upload)
UpdatedAt (during merge if a channel identifier is found)

Resolved Issues

Error in Bot Framework while handling Multimedia Messages	Issue: There was an error handling in the Bot Framework in the case of Multimedia messages. The messages were not sent to Rasa for the response. It was throwing an error due to a null value. Resolution: This issue is permanently fixed now. The Multimedia messages are successfully being sent to Rasa and training is working as expected.
Support Outbound Conversation-less Messages	Issue: There was an API to support normal conversations. In the case of outbound conversation-less messages, it did not return any data. Resolution: This API has been enhanced to now include outbound conversation-less messages and return the data to agents accordingly.
De-duplicate Pre-executed Contacts in Campaigns	Issue: Upon uploading contacts in Campaigns, changing the scheduled date/time resulted in duplicate pre-executed contacts. Resolution: This issue has been resolved by storing the Node_Id against each contact after its execution. This prevents a node from duplicating the execution of the same contact again.
Agent Reservation for Unattended Outbound Calls	Issue: The agent was not reserved when a customer was busy or declined a call. As a result, the agent's MRD state needed to be manually changed to reserve the agent. Resolution: This fix now allows for an automatic reservation of the agent when a customer declines a call or is busy, without requiring any changes to the MRD state.
Campaigns Backend Update	Issue: The Campaign backend was unable to make requests to the scheduled activities. Resolution: With this fix, the Campaigns Backend can now successfully make requests for scheduled activities.
Display the Correct Time on the Agent Desk UI	Issue: The timer on the Agent Desk UI was displaying the incorrect time. Resolution: This minor fix ensures that the timer on the Agent Desk UI now displays the correct time.
Decision Node Enhancement	Issue: The Decision Node was handling only a few call result scenarios. Resolution: Now, more call result scenarios have been incorporated into the Decision Node.