7 Replies Latest reply: Apr 17, 2018 12:56 AM by Gunjan Gupta RSS

    QlikBotNode - Next step

    Jacek Wałaszek

      Hello jvs,

       

      Currently, QlikBotNode(Node phase) is installed. How to connect it to QlikSense/MySql database/Telegram? Below, I present steps which are done:

      Step

      Step

      Status

      Comment

      1

      Instalation MySql

      Done - works

       

      1.2

      Excute sensebot.sql

      Done - works

       

      2

      Create Bot

      Done works

       

      2.1

      Generate Token

      Done works

       

      2.2

      Save as Win variable

      Done works

      TELEGRAM_BOT_TOKEN

      3

      Generate Cer Pem

      Done works

       

      3.1

      Copy certs

      Done works

      app/server/certs/localhost/

      4

      Edit server.js

      Done works

        httpsServer.listen(port, '127.0.0.1') 

      4.1

      Edit config.json

      Done works

      App on my server "salesforce": {

                                          "host": "127.0.0.1",

                                          "appId": "f516decb-80a4-4e37-b01c-d746fe3ee172"

      4.2

      \app\server\models\sense-bot\Db.js

      Done

                              this.config = {

                                         host: 'localhost',

                                         user: 'sensebot',

                                          password: 'demoteam',

                                          database: 'sensebot'

      4.3

      \app\public\index.htm

      Done works

      Renamed from html to htm

      5

      Npm install

      Done works

       

      5.1

      Installation all needed components

      Done works

       

       

       

      Regards

      Jacek.

        • Re: QlikBotNode - Next step
          Yianni Ververis

          Edit 4.2

          add user sensebot with password 1234

          Go to mysql, add user sensebot with password 1234 and assign/grant all privileges to the database sensebot

          • Re: QlikBotNode - Next step
            Rajat Menon

            Hi Jacek Wałaszek,

             

            have you implemented Node bot, i am getting error Cannot find gulp modulegulp error.png

              • Re: QlikBotNode - Next step
                Yianni Ververis

                npm install -g gulp

                  • Re: QlikBotNode - Next step
                    Rajat Menon

                    Thanks,

                     

                    i have installed the required packages as mentioned by you above.

                     

                    Now, "node gulpfile.js" when executed doesn't throw an error.

                     

                    what should i do next plz help.

                    • Re: QlikBotNode - Next step
                      Gunjan Gupta

                      Hi Yianni!

                       

                      I've installed gulp as suggested and running the same for starting components I'm getting the following eror. Could you please guide?

                       

                      $ gulp

                      [08:59:41] Using gulpfile C:\QlikSenseRoot\QlikBotNode-master\gulpfile.js

                      [08:59:41] Starting 'vendor-js'...

                      [08:59:41] Starting 'vendor-css'...

                      [08:59:41] Starting 'server'...

                      [08:59:42] 'server' errored after 1.01 s

                      [08:59:42] C:\QlikSenseRoot\QlikBotNode-master\node_modules\gulp-nodemon\node_mo                                                                                                                                                                                               dules\nodemon\lib\nodemon.js:93

                          config.loaded.map(file => file.replace(cwd, '.')).forEach(file => {

                                                 ^^

                      SyntaxError: Unexpected token =>

                          at exports.runInThisContext (vm.js:73:16)

                          at Module._compile (module.js:443:25)

                          at Object.Module._extensions..js (module.js:478:10)

                          at Module.load (module.js:355:32)

                          at Function.Module._load (module.js:310:12)

                          at Module.require (module.js:365:17)

                          at require (module.js:384:17)

                          at Object.module.exports (C:\QlikSenseRoot\QlikBotNode-master\node_modules\g                                                                                                                                                                                               ulp-nodemon\index.js:17:15)

                          at Gulp.<anonymous> (C:\QlikSenseRoot\QlikBotNode-master\gulp-tasks\server.j                                                                                                                                                                                               s:5:30)

                          at module.exports (C:\QlikSenseRoot\QlikBotNode-master\node_modules\gulp\nod                                                                                                                                                                                               e_modules\orchestrator\lib\runTask.js:34:7)

                      [08:59:42] 'vendor-js' errored after 1.04 s

                      [08:59:42] Error: EPERM, open 'C:\QlikSenseRoot\QlikBotNode-master\app\public\js                                                                                                                                                                                               \vendor\ready.js'

                          at Error (native)

                      [08:59:42] 'vendor-css' errored after 1.04 s

                      [08:59:42] Error: EPERM, open 'C:\QlikSenseRoot\QlikBotNode-master\app\public\cs                                                                                                                                                                                               s\bootstrap.min.css'

                          at Error (native)