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

Rasa Open Source
1

SQLTrackerStore

example data log
example data log1220Ă—382 27.1 KB

2

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
image1022Ă—615 63.3 KB

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.

1 Like
3

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

4

@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.

5

This is PhpMyAdmin. Please read the links in my message.

6

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

7

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

8

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