Add support for tables in Susi response about susi_android

[daminisatya]

@iit2014086 Awesome +1 That's the spirit! :)

@FleetAdmiral Now @iit2014086 can help you with this :D

[Orbiter]

working table example:

stock quotes
!console:
{
"url":"https://www.live-rates.com/rates",
"path":"$",
"actions":[{
"type":"table",
"columns":{"currency":"Valuta","rate":"Quota"}
}]
}
eol

produces

{
  "query": "stock quotes",
  "count": 1,
  "client_id": "aG9zdF8xNzguMjAzLjIzMi40",
  "query_date": "2017-05-21T14:52:57.303Z",
  "answers": [{
    "data": [
      {
        "currency": "EUR/USD",
        "rate": "1.12060",
        "timestamp": "1495226698059",
        "0": "stock quotes",
        "intent_original": "stock",
        "intent_canonical": "stock",
        "intent_categorized": "stock",
        "timezoneOffset": "-120",
        "answer": "price of quotes: N/A",
        "query": "stock quotes",
        "_etherpad_dream": "stock"
      },
      {
        "currency": "USD/JPY",
        "rate": "111.259",
        "timestamp": "1495226697672",
        "query": "stock quotes new",
        "_etherpad_dream": "stock"
      },
      {
        "currency": "GBP/USD",
        "rate": "1.30350",
        "timestamp": "1495226697514",
        "answer": "dreaming enabled for stock",
        "query": "dream stock",
        "_etherpad_dream": "stock"
      },
      {
        "currency": "EUR/GBP",
        "rate": "0.85960",
        "timestamp": "1495226693424",
        "answer": "I don't know how to answer this. Here is a web search result:",
        "query": "stock quotes new",
        "_etherpad_dream": "quotes"
      },
      {
        "currency": "USD/CHF",
        "rate": "0.97299",
        "timestamp": "1495226686645",
        "answer": "price of quotes: N/A",
        "query": "stock quotes",
        "_etherpad_dream": "quotes"
      },
      {
        "currency": "EUR/JPY",
        "rate": "124.677",
        "timestamp": "1495226697698"
      },
      {
        "currency": "EUR/CHF",
        "rate": "1.09034",
        "timestamp": "1495226689491"
      },
      {
        "currency": "USD/CAD",
        "rate": "1.35132",
        "timestamp": "1495226698103"
      },
      {
        "currency": "AUD/USD",
        "rate": "0.74563",
        "timestamp": "1495226697179"
      },
      {
        "currency": "GBP/JPY",
        "rate": "145.021",
        "timestamp": "1495226697546"
      },
      {
        "currency": "NZD/USD",
        "rate": "0.69226",
        "timestamp": "1495378376988"
      },
      {
        "currency": "CHF/JPY",
        "rate": "114.28",
        "timestamp": "1495378376988"
      },
      {
        "currency": "GBP/CHF",
        "rate": "1.26762",
        "timestamp": "1495378376988"
      },
      {
        "currency": "EUR/AUD",
        "rate": "1.50216",
        "timestamp": "1495378376988"
      },
      {
        "currency": "EUR/CAD",
        "rate": "1.51388",
        "timestamp": "1495378376988"
      },
      {
        "currency": "AUD/CAD",
        "rate": "1.00726",
        "timestamp": "1495378376988"
      },
      {
        "currency": "AUD/JPY",
        "rate": "82.952",
        "timestamp": "1495378376988"
      },
      {
        "currency": "CAD/JPY",
        "rate": "82.316",
        "timestamp": "1495378376988"
      },
      {
        "currency": "NZD/JPY",
        "rate": "76.995",
        "timestamp": "1495378376988"
      },
      {
        "currency": "GBP/AUD",
        "rate": "1.74706",
        "timestamp": "1495378376988"
      },
      {
        "currency": "AUD/NZD",
        "rate": "1.07607",
        "timestamp": "1495378376988"
      },
      {
        "currency": "AUD/CHF",
        "rate": "0.72468",
        "timestamp": "1495378376988"
      },
      {
        "currency": "EUR/NZD",
        "rate": "1.61695",
        "timestamp": "1495378376988"
      },
      {
        "currency": "USD/HKD",
        "rate": "7.78232",
        "timestamp": "1495378376988"
      },
      {
        "currency": "USD/MXN",
        "rate": "18.70171",
        "timestamp": "1495378376988"
      },
      {
        "currency": "GBP/NZD",
        "rate": "1.88044",
        "timestamp": "1495378376988"
      },
      {
        "currency": "USD/SEK",
        "rate": "8.71764",
        "timestamp": "1495378376988"
      },
      {
        "currency": "EUR/SEK",
        "rate": "9.77549",
        "timestamp": "1495378376988"
      },
      {
        "currency": "EUR/NOK",
        "rate": "9.38526",
        "timestamp": "1495378376988"
      },
      {
        "currency": "USD/NOK",
        "rate": "8.36537",
        "timestamp": "1495378376988"
      },
      {
        "currency": "USD/ZAR",
        "rate": "13.20929",
        "timestamp": "1495378376988"
      },
      {
        "currency": "GBP/CAD",
        "rate": "1.7606",
        "timestamp": "1495378376988"
      },
      {
        "currency": "USD/TRY",
        "rate": "3.56711",
        "timestamp": "1495378376988"
      },
      {
        "currency": "EUR/TRY",
        "rate": "4.00387",
        "timestamp": "1495378376988"
      },
      {
        "currency": "NZD/CHF",
        "rate": "0.67255",
        "timestamp": "1495378376988"
      },
      {
        "currency": "CAD/CHF",
        "rate": "0.71924",
        "timestamp": "1495378376988"
      },
      {
        "currency": "NZD/CAD",
        "rate": "0.9351",
        "timestamp": "1495378376988"
      },
      {
        "currency": "US30",
        "rate": "20810.0",
        "timestamp": "1495378376988"
      },
      {
        "currency": "SPX500",
        "rate": "2382.57",
        "timestamp": "1495378376988"
      },
      {
        "currency": "NAS100",
        "rate": "5650.2",
        "timestamp": "1495378376988"
      },
      {
        "currency": "UK100",
        "rate": "7487.5",
        "timestamp": "1495378376988"
      },
      {
        "currency": "GER30",
        "rate": "12627.85",
        "timestamp": "1495378376988"
      },
      {
        "currency": "ESP35",
        "rate": "10848.5",
        "timestamp": "1495378376988"
      },
      {
        "currency": "FRA40",
        "rate": "5326.5",
        "timestamp": "1495378376988"
      },
      {
        "currency": "HKG33",
        "rate": "25190.0",
        "timestamp": "1495378376988"
      },
      {
        "currency": "JPN225",
        "rate": "19680.0",
        "timestamp": "1495378376988"
      },
      {
        "currency": "AUS200",
        "rate": "5746.0",
        "timestamp": "1495378376988"
      },
      {
        "currency": "USOil",
        "rate": "50.41",
        "timestamp": "1495378376988"
      },
      {
        "currency": "UKOil",
        "rate": "53.665",
        "timestamp": "1495378376988"
      },
      {
        "currency": "XAU/USD",
        "rate": "1255.33",
        "timestamp": "1495378376988"
      },
      {
        "currency": "XAG/USD",
        "rate": "16.843",
        "timestamp": "1495378376988"
      },
      {
        "currency": "USDOLLAR",
        "rate": "12164.6",
        "timestamp": "1495378376988"
      },
      {
        "currency": "USD/ILS",
        "rate": "3.5723",
        "timestamp": "1495378376988"
      },
      {
        "currency": "TRY/JPY",
        "rate": "31.054",
        "timestamp": "1495378376988"
      },
      {
        "currency": "USD/CNH",
        "rate": "6.8681",
        "timestamp": "1495378376988"
      },
      {
        "currency": "NGAS",
        "rate": "3.2475",
        "timestamp": "1495378376988"
      },
      {
        "currency": "Copper",
        "rate": "2.5875",
        "timestamp": "1495378376988"
      },
      {
        "currency": "EUSTX50",
        "rate": "3588.0",
        "timestamp": "1495378376988"
      },
      {
        "currency": "Bund",
        "rate": "161.32",
        "timestamp": "1495378376988"
      }
    ],
    "metadata": {"count": 59},
    "actions": [{
      "type": "table",
      "columns": {
        "currency": "Valuta",
        "rate": "Quota"
      }
    }]
  }],
  "answer_date": "2017-05-21T14:52:57.717Z",
  "answer_time": 414,
  "language": "en",
  "session": {"identity": {
    "type": "host",
    "name": "178.203.232.4",
    "anonymous": true
  }}
}

Test this with the susi dream "stock"

[daminisatya]

Will let you know soon!

[FleetAdmiral]

Would like to take this up! Any further explanation on what is expected here would be nice 👍

[tejavojjala]

@FleetAdmiral i just started implementing this ....was about to mention this...can you work on other issue..

[FleetAdmiral]

Alright, thanks for letting me know beforehand 👍

[daminisatya]

@FleetAdmiral This is sample response coming from the server.

{
  "session": {"identity": {
    "type": "host",
    "name": "127.0.0.1",
    "anonymous": true
  }},
  "count": 1,
  "answers": [{
    "data": [
      {"title": "programming"},
      {"title": "Datasets Archive"},
      {"title": "We collected 1.3 billion tweets with a distributed, peer-to-peer based free, open source twitter scraper that has a nice API for your self-made apps to evaluate the data: loklak.org"},
      {"title": "A look at Loklak.org and the Webclient progress"},
      {"title": "#Loklak Web client Test A Twitter search engine loklak.org"}
    ],
    "metadata": {"count": 5},
    "actions": [
      {
        "expression": "Here is the list of articles about loklak",
        "type": "answer"
      },
      {"type": "table"}
    ]
  }]
}

[daminisatya]

So we have to display the data which is under answers.
So in general we process the answer as actions.expression but for type table we have to show the list under data

[daminisatya]

@iit2014086 Please inform before you work on anything.So that we can assign the issue. Leaving it open may lead to lot of confusions. thank you :)

[tejavojjala]

@daminisatya yeah sure... it was just sometime ago i was reading loklak blog here http://blog.loklak.net/page/5/ and understood what needs to be done exactly... thats why couldnt inform sooner :)

[daminisatya]

Why dont you work on Pie charts(That's more complex ;) )? Let's involve more people. You can help @FleetAdmiral in getting this done. (Which is a great thing)

[tejavojjala]

@daminisatya yeah involving more people is a good idea... @FleetAdmiral you can take up this issue..i will be working on pie chart

[FleetAdmiral]

@daminisatya @iit2014086 Yea that'd be great! I'll start work on this issue!

[tejavojjala]

@FleetAdmiral are you working on this??

[FleetAdmiral]

@iit2014086 Yes, i'll be done with it in a little more time.

[FleetAdmiral]

@daminisatya Hey! I'm really sorry that i held this up for 11 days but i've not been able to put much time into it due to unexpected circumstances. I don't want to hold up the issue any longer, so i'd like to suggest passing it onto someone else. Once things are all fine on my side, i'll come back and solve other issues. Thanks a lot for helping me out!

[daminisatya]

@FleetAdmiral no issues, @iit2014086 assigned it to you ☺

[tejavojjala]

@daminisatya can't work on this for atleast two more weeks(health issues), please assign to anyone else.

[chiragw15]

@daminisatya in the blog here http://blog.loklak.net/page/5/ , you have given examples of list and pie charts using keywords "What are the reddit articles about loklak" and "Who will win the 2016 presidential election" respectively. But when I tried these keywords on http://asksusi.com/ , it didn't work.The response was "I don't know". What may be the possible issue?

[chiragw15]

@daminisatya ^

[daminisatya]

@chiragw15 I have go through the server changes, so basically it must give a list of details.

[samsruti]

@daminisatya Any updates on this? I would like to work on this issue :)

[daminisatya]

due to inactivity from @chiragw15 I'm assigning to @samsruti :) Please let me know if you have done any work @chiragw15

[chiragw15]

@daminisatya you said you have to go through the server changes and would let me know after that. Since server response from susi is still "I don't know" for both the above mentioned queries, I thought you are working on the server issues and will let me know when they are fixed. If the response from server is correct, I can start working on this issue.

[samsruti]

@chiragw15 , We both can work if you are that much interested. We is far better than I :)
I already informed @daminisatya about the server issues and she is looking at those :)
Till that we need to make this product more efficient :)
Thanks.

[chiragw15]

@samsruti Yaa sure cool, no problem . 👍
P.S : You guys are tagging wrong chirag. He'll be very pissed with unwanted mails. XD

[samsruti]

@daminisatya We are still getting incorrect response. Can you please look into the server details and let us know?

[samsruti]

@mariobehling @Orbiter @the-dagger Can anyone have a look on the server side? Why are the responses not coming as expected? http://api.asksusi.com/susi/chat.json?timezoneOffset=-330&q=What+are+the+reddit+articles+about+loklak

[daminisatya]

@chiragw15 Oops sorry man. I was dealing with too many pull requests. Totally my bad. let's follow up in the channel .

[samsruti]

@daminisatya @jig08 Is this looking good for displaying tables? What could be the limit for the list?

[chiragw15]

@daminisatya no problem, 👍 . @samsruti How did you get this response from susi?

[daminisatya]

@samsruti Yes that is the response.

[samsruti]

@daminisatya @chiragw15 I tested all the codes given here: https://github.com/fossasia/susi_server/blob/1efca95658337dcdbadaed555a9c27b0b4ba8d15/docs/AskSUSI.md

There I found this :
read RSS
example: Susi, Please read the RSS feed from https://news.ycombinator.com/rss

[samsruti]

@daminisatya For chart I could not able to get any response? Can you please look into that?

[samsruti]

Sample Pie Chart is done :)
Need some real data responses to implement.

[abishekvashok]

Any updates guys...

[samsruti]

@Abhi2424shek I will send a pr when the chart response will work fine :)

[abishekvashok]

@samsruti sure keep up the good work

[abishekvashok]

@samsruti updates

[samsruti]

Since the chart response is not working so, i will send a PR tomorrow with the feeds list 👍

[abishekvashok]

@samsruti updates

[betterclever]

fossasia/susi_server#100

[Orbiter]

The documentation for table actions is now in https://github.com/fossasia/susi_skill_data/blob/master/README_susi_skill_language_tutorial.md chapter 12

But the example above is better for RSS type answers

[amitiwary999]

I am trying to solve this issue.