I want to see a picture of a character named IronMan

Rasa Open Source
21

@longnguyenQB Don’t be sad please. Share code like action file for blackwidow, or age where you wrote the code.

`dispacture.utter_message(template= "utter_ (what ever you mention in response)`")
return []

OR

responses:
utter_(whatever you mention):
 - text: Her is your answer Name: {name} and its Age: {age}
22

@nik202 I have shared here, this is an example for you to understand, my database is not like this

24

@longnguyenQB Its very hard for me to understand, but I mention in my above post, hope you understand.

25

class ActionSearchDocument(Action):

def name(self) -> Text:
    return "action_search_document"

def run(self, dispatcher: CollectingDispatcher,
        tracker: Tracker,
        domain: Dict[Text, Any]) -> List[Dict[Text, Any]]:

    document_name = tracker.get_slot("document_name")
    query_begin = "SELECT name FROM document"
    mycursor.execute(query_begin)
    result_query_begin = mycursor.fetchall()

     # write query
   query_end = "SELECT name, link, date FROM document WHERE name = '" + result_match + "'"

    mycursor.execute(query_end)
    myresult = mycursor.fetchall()
    dispatcher.utter_message(text=f"This is document you want: ")
            dispatcher.utter_message(myresult)

    return []

result : [[“Scientist for beginer”, “https://drive.google.com/file/d/1V2XS_2pY1yJjDZLJb-P-KoD9UU18N3wF/view?usp=sharing”, “2021-07-27 00:00:00”]]

  1. i want my result look like : name : Scientist for beginer , link : https://drive.google.com/file/d/1V2XS_2pY1yJjDZLJb-P-KoD9UU18N3wF/view?usp=sharing , date : 2021-07-27 00:00:00 @nik202
26

@nik202 this is my code

27

@longnguyenQB I know only English :stuck_out_tongue: @longnguyenQB the google drive link I can’t understand sorry.

@longnguyenQB In my result the values are name, link and date?

@longnguyenQB After this myresult = mycursor.fetchall() check the output value while using print(myresult) check what values it return.

@longnguyenQB try this

dispatcher.utter_message(text=f"This is document you want: {name}, {link}, {date} ", tracker=tracker)

OR

dispatcher.utter_message(myresult)

28

@nik202 yes,

  1. result : [[“Scientist for beginer”, “https://drive.google.com/file/d/1V2XS_2pY1yJjDZLJb-P-KoD9UU18N3wF/view?usp=sharing”, “2021-07-27 00:00:00”]]

  2. but i want my result look like : name : Scientist for beginer , link : https://drive.google.com/file/d/1V2XS_2pY1yJjDZLJb-P-KoD9UU18N3wF/view?usp=sharing , date : 2021-07-27 00:00:00 @nik202

29

@nik202 what is tracker???

30

if i code : dispatcher.utter_message(myresult)

  1. result : [[“Scientist for beginer”, “https://drive.google.com/file/d/1V2XS_2pY1yJjDZLJb-P-KoD9UU18N3wF/view?usp=sharing” , “2021-07-27 00:00:00”]]
  2. but i want my result look like : name : Scientist for beginer , link : https://drive.google.com/file/d/1V2XS_2pY1yJjDZLJb-P-KoD9UU18N3wF/view?usp=sharing , date : 2021-07-27 00:00:00 @nik202
31

@longnguyenQB The Tracker class represents a Rasa conversation tracker. It lets you access your bot’s memory in your custom actions. You can get information about past events and the current state of the conversation through Tracker attributes and methods you wrote in def run

32

@longnguyenQB This pdf is 21 page, what you sharing I can’t get sorry. @longnguyenQB try what I suggested.

33

it’s just a link, don’t mind it!

34

@longnguyenQB Then, why you sharing, it not make any sense to me or related to code, you just want to show name, link and age that’s it. rather just share the output, please delete that links, it make other confuse.

35

@nik202 The link is just part of the output

The result you’re getting is a list of a single list.

myresult = [["Scientist for beginer", "https://drive.google.com/file/d/1V2XS_2pY1yJjDZLJb-P-KoD9UU18N3wF/view?usp=sharing", "2021-07-27 00:00:00"]]
myresult[0] = ["Scientist for beginer", "https://drive.google.com/file/d/1V2XS_2pY1yJjDZLJb-P-KoD9UU18N3wF/view?usp=sharing", "2021-07-27 00:00:00"]

myresult[0][0] = "Scientist for beginer"
myresult[0][1] = "https://drive.google.com/file/d/1V2XS_2pY1yJjDZLJb-P-KoD9UU18N3wF/view?usp=sharing"
myresult[0][2] = "2021-07-27 00:00:00"

So just do this:

myresult = mycursor.fetchall()
message = "name: " + myresult[0][0] + ", link: " + myresult[0][1] + ", date: " + myresult[0][2]

dispatcher.utter_message()
dispatcher.utter_message(myresult)

This is just simple regular Python code, it is not related to Rasa.

Hope this helps!

2 Likes
36

Ohhhhhhhh right, Chris :face_with_monocle: :face_with_monocle:

@longnguyenQB Please follow Chris advice, it makes a lot of sense if you are expecting the Result which you had shown, and sorry for the confusion, I was expecting BlackWidow and Loki as a result, but by the way are you sure Blackwidow is age 40? :stuck_out_tongue:

Good Luck!

2 Likes
37

@ChrisRahme Thank you so much, this is exactly what I needed!

1 Like
38

@nik202 Thank you very much, you have been very helpful to me!

39

@nik202

image
image755×249 14.8 KB

I have 1 last problem, hope everyone can help me in this post. when I run rasa shell, input : “tìm kiếm tài liệu đề thi tháng 4” (It’s a request in Vietnamese, translated into English as: searching for April exam papers)

output : “Đấy là thông tin tài liệu đề thi tháng 4:” (translated into English as: This is the April exam paper). The problem here is that the result returned from my database query is a string that is not utf-8. How to fix this last problem? I’m so grateful!

40

@ChrisRahme the result that I expect from the database query is " Tài liệu đề thi tháng 4" (April exam papers) But the actual result is:"\u0111\u1ec1 thi th\u00e1ng 4"

41

@longnguyenQB Its encoding UTF-8 issue, try share the code where you fetching .csv file

2 Likes