Jump to content


Edit Chat Archive details after client has logged off


6 replies to this topic

#1 taidaniel

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 02 October 2017 - 03:20 PM

Hi,

Using Livezilla 7.0.7.2

Is there a way to edit the Chat Archive details of each message after the client has logged off? If it can be done, will the changes reflect in the Chat_Archive table? Specifically, I want to edit the custom fields.

Regards

#2 Patrick Keil

    Administrator

  • Administrators
  • 3242 posts
  • LocationSingen, Germany

Posted 04 October 2017 - 07:43 AM

Hi,

There's no option to change chat archive details in our UI.

#3 taidaniel

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 09 October 2017 - 09:33 AM

Hi Patrick,

Thank you for your reply. Maybe you can advise better. We're trying to create a report by pulling data from the database. During the Live Chat, our operators would fill in a few custom fields but when the user logs off, and the chat is in the Chat Archive, the custom fields is somehow not saved. We're trying to retrieve the QT_Chat-Archive table to create the report.

Can you advise on how we can achieve this? We need some reports that is based on the custom fields.

Regards

#4 Patrick Keil

    Administrator

  • Administrators
  • 3242 posts
  • LocationSingen, Germany

Posted 09 October 2017 - 01:16 PM

Hi,

The custom field data in the chat archive table reflects the information available when starting a chat, either customer inputs or pass-thru data.

The information changed / filled by your operators is stored with the visitor object (MySQL table user_data). Keep in mind that you can change this information even when there's no active chat session.

Obviously, it's would be good to also update the chat archive entry so I have added this to our list for 7.0.9.0.

Cheers.

#5 taidaniel

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 09 October 2017 - 04:08 PM

View PostPatrick Keil, on 09 October 2017 - 01:16 PM, said:

Hi,

The custom field data in the chat archive table reflects the information available when starting a chat, either customer inputs or pass-thru data.

The information changed / filled by your operators is stored with the visitor object (MySQL table user_data). Keep in mind that you can change this information even when there's no active chat session.

Obviously, it's would be good to also update the chat archive entry so I have added this to our list for 7.0.9.0.

Cheers.
Great to hear that.

How is the Chat Archive table linked to the User Data table eg via which field? We would like to create the report but we are having problems joining the 2 tables. We're not sure which field to use for the JOIN. Is there a third table involved?

#6 Patrick Keil

    Administrator

  • Administrators
  • 3242 posts
  • LocationSingen, Germany

Posted 10 October 2017 - 08:22 AM

Hi,

Yes, relation is like this:

chat_archive.external_id = visitors.id, visitors.data_id = user_data.id


#7 taidaniel

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 10 October 2017 - 03:46 PM

View PostPatrick Keil, on 10 October 2017 - 08:22 AM, said:

Hi,

Yes, relation is like this:

chat_archive.external_id = visitors.id, visitors.data_id = user_data.id

Thank you. Will try this out.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users