Storing all chatbot conversation in to any Database alone with user inforamtion

(0) Share

Report

Posted on by NadeemAhamed

Hello Everyone.

We have created Chatbot in Web and Published on Sharepoint Intranet Portal.

Is it possible to store the all Chatbot conversation/History/Sessions into any Database like Microsost SQL Sever Management Strudio in the form of tabular column along with user information/system information.

Thank you in Adavance.

All responses (4)

Answers (0)

HenryJammes on at

Like (0)

Report

Re: Storing all chatbot conversation in to any Database alone with user inforamtion

Hi @NadeemAhamed

You would need to parse the JSON content to better understand the conversation.
Something that might help you is this template Power BI report: https://aka.ms/PVAAnalytics

This page is also a good starting point to start exporting and manipulating conversation transcripts: Use custom analytics reports - Power Virtual Agents | Microsoft Learn

Henry
NadeemAhamed 24 on at

Like (0)

Report

Re: Storing all chatbot conversation in to any Database alone with user inforamtion

Dear @mboninco,
Good Day..!

I am still seeking the solution for this, with out this i would not be able enhance my chatbot.
NadeemAhamed 24 on at

Like (0)

Report

Re: Storing all chatbot conversation in to any Database alone with user inforamtion

Thank your valuable time to understand and reply.

By using the above link i can export the conversation in csv file but not able to convert that to normal conversation so that i can understand the chatbot conversation for future chatbot enhancement.
mboninco on at

Like (1)

Report

Re: Storing all chatbot conversation in to any Database alone with user inforamtion

@NadeemAhamed

It's possible, but it would be a little bit of work. You would need to read the conversation transcripts in Dataverse, parse the transcripts, and store the information in a database. You can find information on the conversation transcripts at:

Understand conversation transcripts - Power Virtual Agents | Microsoft Learn

On the page there is a link to sample code to parse the transcripts to recreate the analytics reports that are within Power Virtual Agents. You could extend this to pull out the information you are interested in and use a power platform dataflow to store in a database.

-- Mike Bonincontri