Closed Bug 495740 Opened 15 years ago Closed 15 years ago

Streamline process of following up in the forum

Categories

(support.mozilla.org Graveyard :: Chat, defect)

defect
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: zzxc, Assigned: zzxc)

Details

Attachments

(3 files, 1 obsolete file)

From our weekly CSAT data, only between six and ten percent of users from live chat follow up in the forum.  Since a lot of chats are not yet resolved when the user is disconnected or closes the browser, the process of following up later should be made easier.  Changes that need to be made:

*Transcript e-mails should include links to the CSAT poll and for following up in the forum
*Provide a link to follow up in the forum right after the chat ends
*Include the chat ID in any forum reply, so we can collect stats about users who start in Live Chat and continue in the forum.  (A future enhancement would be to allow the user to include the entire transcript)

Additionally, bug 481539 will allow helpers to give a CSAT or forum followup link to the user at any time, via a canned response.
Assignee: nobody → bugs
This is the SQL for the forum metadata table that will be used by live chat CSAT, to find posts that are continuations of a live chat.  The table is generic, so it may also be used to store information such as plugins or user-agent.
Attachment #383979 - Flags: review?(smirkingsisyphus)
This adds a metadata feature to tiki_comments to store information about each thread for easy querying.  The Live Chat session ID and agent name are stored in this table to track live chat->forum followups.

The included tiki-forum_livechat_pings.php script produces an XML output of recent live chat followups, for Openfire and sumobot to query.
Attachment #384045 - Flags: review?(smirkingsisyphus)
This is a slightly improved patch that adds an <agent> element in tiki-forum_livechat_pings.php and deletes metadata when a thread is removed.
Attachment #384045 - Attachment is obsolete: true
Attachment #384141 - Flags: review?(smirkingsisyphus)
Attachment #384045 - Flags: review?(smirkingsisyphus)
Attachment #383979 - Flags: review?(smirkingsisyphus) → review+
Attachment #384141 - Flags: review?(smirkingsisyphus) → review+
Since this adds a table to SUMO and introduces new functionality, Laura needs to look at this too.
Comment on attachment 383979 [details]
SQL for forum metadata table

Requesting review from Laura, per Eric's comment.
Attachment #383979 - Flags: review?(laura)
Attachment #383979 - Attachment mime type: text/x-sql → text/plain
Comment on attachment 383979 [details]
SQL for forum metadata table

Don't forget to add this to the push bug.
Attachment #383979 - Flags: review?(laura) → review+
You should also add sanitization of the User Agent.  When that's done, please commit and file a bug to get SQl run on staging ASAP so QA can test.
(In reply to comment #7)
> You should also add sanitization of the User Agent.  When that's done, please
> commit and file a bug to get SQl run on staging ASAP so QA can test.

Sanitation is already being done by strip_tags in set_metadata, when $sanitize == 1.  Should it be doing more here?
Also, I don't currently have commit permissions in /projects/sumo, so I will either need to get those permissions or have someone else check this in.
Attached patch Update to trunkSplinter Review
Patch updated for changes to trunk
Committed in r28550 / r28551
Status: NEW → RESOLVED
Closed: 15 years ago
Resolution: --- → FIXED
Product: support.mozilla.org → support.mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: