SQLTrackerStore [example data log]

This is a sample configuration for a mySQL Tracker Store: tracker_store: type: SQL dialect: "mysql" url: "localhost" db: "rasa_tracker_store" username: "rasa" password: "rasa" This is how the database looks on phpMyAdmin: [image] This had all the information that you required. If you really need to modify the looks, you can create: A view A script that pulls from the database, rearranges the info, and uploads it to another database A frontend application that shows the info as you required without modifying the database (preferable) If you don’t know how to set up a MySQL database with phpMyAdmin in the first place, I suggest using Wamp on Windows, and a this and this tutorial for Ubuntu.

@linhnq159 Hello, please see this link and follow the steps: HOW TO STORE THE CONVERSATIONS TO CSV/TXT FILE IN RASA X | INNOVATE YOURSELF - YouTube and you will be able to get the image like data, but you need to update the python code as per your need, this much depends on custom action code with rasa tracker events data. ? confirm me the above image is the screenshot from the SQL or any other database or its a screenshot of the excel sheet which stored the conversation data? I hope this will solve your issue.

[image] linhnq159: how do you can show this table like ur image ? Can you show that ? This is PhpMyAdmin. Please read the links in my message.

can anyone please share any proper guide on how to connect rasa to posgresql to store responses ,i am facing lot of issue in connecting to it

@shreyansh please see this link: Rasa deployment to Google chat - #13 by nik202

hey thanks for the reply ,but i am facing one more issue that " Could not create tables: (psycopg2.OperationalError) connection to server at “localhost” (::1), port 5432 failed: FATAL: password authentication failed for user “postgres” (Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation )" could you please look into this

How can i SQLTrackerStore like that step by step . can someone help me?

Rasa Open Source

linhnq159 (Linhnq159) November 18, 2021, 7:59am 3

how do you can show this table like ur image ? Can you show that ?

Topic		Replies	Views
SQLTracker Store Rasa Open Source	2	389	November 18, 2021
Sql_tracker_store giving error Rasa Open Source	13	2940	October 2, 2020
How to store all conversations for rasa chatbot Rasa Open Source	3	362	April 23, 2021
How to access stored bot conversation from tracker and also how to store that in SQL Server? Rasa Open Source	9	537	July 19, 2023
How to store RASA chatbot conversation history in Postgresql Rasa Open Source	4	1836	July 12, 2023

How can i SQLTrackerStore like that step by step . can someone help me?

Related topics