Hi, @ souvikg10 ,@ Juste I want to save all the user conversations to Microsoft sql server. or can I save locally the conversations to a YML file , similar to stories.md file Please help me with steps regarding the same . I tried with SQL tracker store endpoint.yml file tracker_store: type: SQL dialect: "mssql+pyodbc" # the dialect used to interact with the db url: "localhost" # (optional) host of the sql db, e.g. "localhost" db: "rasa_conversations" # path to your db username: "**" # username used for authentication password: '****' # password used for authentication query: # optional dictionary to be added as a query string to the connection URL driver: "SQL+Server+Native+Client+11.0" link create 2020-03-25 11:44:10 DEBUG rasa.core.tracker_store - Attempting to connect to database via 'mssql+pyodbc://**:****@localhost/rasa_conversations?driver=SQL+Server+Native+Client+11.0'. ERROR pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)') Regards, Aashay

Hey @Aashay1 , Please check this answer on the stack overflow. Looks like there’s an issue with the driver you’re specifying. Sorry I can’t be much help here, since it’s an issue in between SQLAlchemy and MSSQL.

Hi @Aashay1 Since SQLAlchemy supports MSQL, the export should work fine. How exactly are you extracting data? Quick googling shows me that there’s a configuration issue. Are you sure the DB is accesable? It’s also possible that some tweak has to be made within Rasa itself in case it won’t work.

I am not sure how to do that When I use pyodbc only its working fine , but its not working with rasa

Hi @degiz , I will surely try to do the same, For now I am able to store the data in json file on local disk I have my rasa running perfectly on local machine, I want to put it on server and make is available for tester. I am not a developer hence finding it difficult to do so can you please provide me a guide to do so . Tank you Aashay

hi @Aashay1 could you elaborate how you store bot conversations in Microsoft SQL server

Save All the conversations to Microsoft sql server

Rasa Open Source

Aashay1 (Aashay) April 4, 2020, 2:16pm 6

Hey @degiz thank you I am successfully able to store in ms-sql now

Topic		Replies	Views
How can let my bot save all conversation has been with and how to initialize the conversations Rasa Open Source	3	1752	July 18, 2019
How to access stored bot conversation from tracker and also how to store that in SQL Server? Rasa Open Source	9	530	July 19, 2023
Save chat in MSSQL server Rasa Open Source	2	757	March 23, 2020
RASA Tracker connection with SQL Server Rasa Open Source	7	1457	May 4, 2022
Storing the conversation as columns in database Rasa Open Source	7	2142	January 22, 2020

Save All the conversations to Microsoft sql server

Related topics