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)
support.mozilla.org Graveyard
Chat
Tracking
(Not tracked)
RESOLVED
FIXED
1.2
People
(Reporter: zzxc, Assigned: zzxc)
Details
Attachments
(3 files, 1 obsolete file)
206 bytes,
text/plain
|
ecooper
:
review+
laura
:
review+
|
Details |
7.60 KB,
patch
|
ecooper
:
review+
|
Details | Diff | Splinter Review |
7.60 KB,
patch
|
Details | Diff | Splinter Review |
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 | ||
Updated•15 years ago
|
Assignee: nobody → bugs
Assignee | ||
Comment 1•15 years ago
|
||
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)
Assignee | ||
Comment 2•15 years ago
|
||
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)
Assignee | ||
Comment 3•15 years ago
|
||
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)
Updated•15 years ago
|
Attachment #383979 -
Flags: review?(smirkingsisyphus) → review+
Updated•15 years ago
|
Attachment #384141 -
Flags: review?(smirkingsisyphus) → review+
Comment 4•15 years ago
|
||
Since this adds a table to SUMO and introduces new functionality, Laura needs to look at this too.
Comment 5•15 years ago
|
||
Comment on attachment 383979 [details]
SQL for forum metadata table
Requesting review from Laura, per Eric's comment.
Attachment #383979 -
Flags: review?(laura)
Updated•15 years ago
|
Attachment #383979 -
Attachment mime type: text/x-sql → text/plain
Comment 6•15 years ago
|
||
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+
Comment 7•15 years ago
|
||
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.
Assignee | ||
Comment 8•15 years ago
|
||
(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?
Assignee | ||
Comment 9•15 years ago
|
||
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.
Assignee | ||
Comment 10•15 years ago
|
||
Patch updated for changes to trunk
Comment 11•15 years ago
|
||
Committed in r28550 / r28551
Status: NEW → RESOLVED
Closed: 15 years ago
Resolution: --- → FIXED
Updated•11 years ago
|
Product: support.mozilla.org → support.mozilla.org Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•