Hello, I am new to RASA and i have a small bot to create that interacts with user, ask a question and stock all these enswers in an Excel file/sheet. Is it possible with RASA? How can i do it ? Thank you

Use a FormAction to get all the information you need. Once all information is collected, it runs the ‘submit’-method, where youre free to do whatever you want. In your case, the easiest way is to write a csv-File, which can be easily loaded into Excel.

Thank you for your reply. As i am new to rasa i might need a little clarification on how to transfer the user input of a slot , add it to a variable , and send it as a parameter to the create CSV class in the actions. If you have any tips or hints i would love to take them. Your help is much appreciated .

Here’s everything you need [image] NLU Training Data Read more about how to format training data with Rasa NLU for open source natural language processing. [image] Domain [image] Forms Follow a rule-based process of information gathering using forms in open source bot framework Rasa.

hi, i also wish to know how to add user input into a file, in this case is excel. Have you figure out the way? thanks.

Try to use: pandas.DataFrame.to_csv — pandas 0.25.3 documentation import os import pandas as pd Data = {'Name': ['Rasa'], 'E-mail': ['rasa@rasa.com'], } df = pd.DataFrame(Data, columns = ['Name','E-mail']) if not os.path.isfile('/home/youruse/output1070000.csv'): df.to_csv('/home/youruse/output1070000.csv',index = False, header='columns') else: # else it exists so append without writing the header df.to_csv('/home/youruse/output1070000.csv',index = False, mode='a', header=False)

How can I fetch data from an Excel database or MySQL database in RASA chatbot?

That’s not a specific problem for rasa. You’re pretty much free to write any code in a custom action. So if you know how to do that in python in general you pretty much solved your problem. I have no experience importing from MySQL or Excel in python myself, but I’m absolutely sure, that there are Python packages, which do most of the work you.

Custom Actions - Create Excel File with Data from Rasa

Rasa Open Source

rajas.black (Rajesh Kumar) July 22, 2021, 10:48am 10

You can use pandas to fetch data from excel using custom action. I have done it multiple times.

Topic		Replies	Views
Extract data from excel in rasa Rasa Open Source	3	852	April 15, 2022
Custom API on excel upload Rasa Open Source	1	488	July 31, 2020
Creating a custom action by extracting data from excel Rasa Open Source	3	983	February 13, 2020
How to make rasa to take the data from the excell Rasa Open Source	6	1960	August 12, 2021
Write RASA form to CSV Rasa Open Source	3	605	January 13, 2020

Custom Actions - Create Excel File with Data from Rasa

Related topics