Qlik Community

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

Employee
Employee

QlikBotNode for Microsoft Skype

Qlik_BOT_Headers_Skype.jpg

Last month I talked about our new QlikBotNode, setting it up and getting it ready for Telegram Qlik Sense Bot with Node.js and Enigma.js.

Today, I will talk about the steps needed to make your bot available for Microsoft Skype as well!

Assuming that you have already forked the code from GitHub - qlik-bots/QlikBotNode: QlikBotNode is a server build in Node.js, Express.js, Enigma.js and ...and you have already went through the previous tutorial and set up the Telegram bot.


Installation


  • First you need to "Register a Bot with Bot Service". Login to the Azure Portal http://portal.azure.com/
  • Click the New button found on the upper left-hand corner of the Azure portal, then select AI + Cognitive Services > Bot Channels Registration.
  • Click the Create button to start the creation process.

registration-create-bot-service-blade.png

  • Enter a Bot Name as you want to appear in your contact list
  • You can use the free Pricing Tier for testing
  • For the Messaging Point add you full route like https://{your-server}/api/sense-bot/microsoft/
  • You can skip the Application Insight for now
  • Once registered, go to settings and get the AppId and the Password. You will need to add them in your environmental variables

registration-settings-manage-link.png

  • Click on Manage to get the password

registration-generate-app-password.png

  • Put the AppId and Password in your Environmental variables.
  • For Windows, go to "Control Panel" -> "System" -> "Advanced System Settings" -> "Environment Variables"
  • - For Linux, from your directory (~), type "nano .bash_profile" or "vim .bash_profile" and enter the variables there like
  • export SKYPE_BOT_ID_SCV=''
    • export SKYPE_BOT_PASSWORD_SVC=''
  • While still in settings, go to "channel" and add skype.


Thats it!


For more Details on Register a bot with Bot Service (https://docs.microsoft.com/en-us/bot-framework/bot-service-quickstart-registration)


Usage


  • Type help for all of the available commands.

chat-help.png

  • Click on Salesforce to get the available commands for the Salesforce App and then click on the Dashboard to get a list of KPIs

chat-salesforce.png

  • Click on CIO Dashboard and then on Management

chat-cio.png

  • - If you want to change your language click on Language and select one of the available ones. So far we have only 3, English, Spanish and Greek but please feel free to add as many more as you want

chat-language.png

That's it!

Make sure you follow:

Best,

Yianni

28 Comments
zebhashmi
Valued Contributor

I have no idea what the Bot is.

0 Likes
2,074 Views
MVP & Luminary
MVP & Luminary

Hi Yianni,

Is this works for Skype for Business?

0 Likes
2,074 Views
Employee
Employee

zebhashmi‌ try googling bot and chatbot. There are a lot of sites that explain it

Best,

Yianni

0 Likes
2,074 Views
Employee
Employee

jagan

yes. I will have the installation document ready this week or the next

Best,

Yianni

0 Likes
2,074 Views
shyamvarda2017
New Contributor II

Hi Yainni,

I am learning Qlik Sense. Is it possible you share step by step document to connect skype bot with qlik sense?

Regards,

Shyam

0 Likes
2,074 Views
saranrajk
New Contributor

hi,

how to communicate Qlik from the bot that is hosted on azure,

what the things we need to do to for that.

Regards,

saranraj

0 Likes
2,074 Views
Employee
Employee

Hello saranrajk‌,

The process is the same. Install and then run the server. Once you have the routes and the dns ready and you can access it from a browser, add the url in the Messaging Endpoint

Yianni

0 Likes
2,074 Views
Employee
Employee

Microsoft finally published QlikBotNode.

You can search for it...

search-bot.png

0 Likes
2,074 Views
ChristopheG
New Contributor II

I have setup the skype bot but when I try to run the qlikbotnode with gulp it give an error about telegram token not found, should I use another command to start the program for skype?

Thanks

0 Likes
2,074 Views
vikraant
Contributor

Hi Yianni,

What should I name the environment variables for Skype for windows ?  Should it be named the same as that for Linux, ie,

SKYPE_BOT_ID_SCV

&

SKYPE_BOT_PASSWORD_SVC

0 Likes
2,074 Views
Employee
Employee

If you want to use telegram, follow the instructions.

https://github.com/qlik-bots/QlikBotNode/blob/master/docs/Telegram.md

Otherwise, comment out the telegram routes (L11 & L14) and it will not load

https://github.com/qlik-bots/QlikBotNode/blob/master/app/server/routes/api/sense-bot.js

0 Likes
2,074 Views
Employee
Employee
0 Likes
2,074 Views
ChristopheG
New Contributor II

Thanks for the reply, I have tried commenting out these lines but then I get the following error:

error: uncaughtException: express.router is not a function

0 Likes
2,074 Views
vikraant
Contributor

Hi Yianni,

I have followed the steps in docs and tested it using Microsoft botframework emulator.  Bot is working fine on localhost.

I tried to configure the bot to work on the public domain by changing the localhost to public ip address

1. config.json

2. server.js

I have put the exported certificate in the '..\QlikBotNode-1\app\server\certs'  folder.

I have also downloaded ngrok to test the bot on remote computer.

Still no success yet.

Am I going in the right direction?

Thanks & Best Regards,

Vikraant

2,074 Views
Employee
Employee

Yes

The certs folder name needs to be the same as your server dns

0 Likes
2,074 Views
vikraant
Contributor

I also tried putting the messaging endpoint in the Azure Bot Channel settings

(https://<ip-address>:3443/sense-bot/microsoft/api)  .

When I put the above address in the browser I am getting following error

error.PNG

0 Likes
2,074 Views
Employee
Employee

This is the public accessible page. That means that you have not setup the routes correctly

I believe it should be

https://<ip-address>:3443/api/sense-bot/microsoft/

0 Likes
2,074 Views
vikraant
Contributor

Hi Yianni,

I am sorry. I have put the following address  https://<ip-address>:3443/api/sense-bot/microsoft/.

Still getting the same error. error.PNG

I have downloaded version 1 of  QlitBotNode

https://github.com/qlik-bots/QlikBotNode/tree/v1

0 Likes
2,074 Views
vijetasharma
Valued Contributor

Great Stuff! can you please suggest on registering BOT on azure portal. It seems to be paid. is there anything which we can use as trial for free.

Regards,

Vijeta

0 Likes
2,074 Views
nikhilgarg
Valued Contributor

Hey Jagan,

Will this bot works with Skype or with Skype for business?

0 Likes
2,074 Views
nikhilgarg
Valued Contributor

Hey Vijeta,

Do you get any thing to test this bot free with Skype?

0 Likes
2,074 Views
nikhilgarg
Valued Contributor

Hey Yianni,

Does this works with Skype or Skype with Business ?

0 Likes
2,074 Views
Employee
Employee

Both. In you skype search for "Qlik Bot"

2018_10_12_05_46_59_Skype.png

Or go to https://github.com/qlik-bots/QlikBotNode/blob/master/docs/Telegram.md

and click on the live demo

Yianni

2,074 Views
Employee
Employee

Hellovijetasharma‌‌,

Anything you do with Microsoft is paid. You can try Slack or Telegram

0 Likes
2,074 Views
nikhilgarg
Valued Contributor

Thanks Yianni. This works. But does it work with "Skype for Business"? Bcoz i dont find the QlikBot in "Skype For Business". Can you guide?

Also, does it works with Microsoft Kaizala?

0 Likes
2,074 Views
Partner
Partner

Hi @vikraant how i can make it work in localhost. My Qlik Sense Server works on 192.168.xxxx i have to create the certeficates on that name? or localhost?

0 Likes
1,610 Views
Partner
Partner

Is this still working?? Can anyone answer? Or maye with Telegram.

0 Likes
1,537 Views
MVP & Luminary
MVP & Luminary

@Yianni_VerverisDo you have some documentation for making QlikBotNode work with Slack?

0 Likes
1,445 Views