QlikTip #22: Restarting/Stopping/Starting services in QlikView 9

Even if already published on another Qlikview related blog I just wanted to have this here because I am using it quite often.

For starting/stopping/restarting the QlikView Windows-services of QlikView server in version 9 I have prepared three batch-scripts which I call on demand:

Restarting all QlikView related Windows-services

@echo off
REM -------------------------------------------------------
REM - File: QlikViewServer9_Restart.bat
REM - Description: Restart's QlikView Services (v9)
REM - Author: Stefan WALTHER
REM -------------------------------------------------------
echo Restarting QlikView Services
echo ======================================================

net stop "QlikView WebServer"
net stop "QlikViewServer"
net stop "QlikView Publisher Command Center Service"
net stop "Qlikview Management Service"
net stop "QlikView Distribution Service"
net stop "QlikView Directory Service Connector"

net start "QlikView WebServer"
net start "QlikViewServer"
net start "QlikView Publisher Command Center Service"
net start "Qlikview Management Service"
net start "QlikView Distribution Service"
net start "QlikView Directory Service Connector"

echo ======================================================
echo QlikView restarted

REM pause

(Just) stopping the QV Windows-services:

@echo off
REM -------------------------------------------------------
REM - File: QlikViewServer9_Stop.bat
REM - Description: Stop all QlikView related services (v9)
REM - Author: Stefan WALTHER
REM -------------------------------------------------------
echo Stop QlikView Services
echo ======================================================

net stop "QlikView WebServer"
net stop "QlikViewServer"
net stop "QlikView Publisher Command Center Service"
net stop "Qlikview Management Service"
net stop "QlikView Distribution Service"
net stop "QlikView Directory Service Connector"

echo ======================================================
echo All QlikView related services have been stopped ...

REM pause

(Just) starting the QV Windows-services:

@echo off
REM -------------------------------------------------------
REM - File: QlikViewServer9_Start.bat
REM - Description: Starts all QlikView related services (v9)
REM - Author: Stefan WALTHER
REM -------------------------------------------------------
echo Beginning to start QlikView Services
echo ======================================================

net start "QlikView WebServer"
net start "QlikViewServer"
net start "QlikView Publisher Command Center Service"
net start "Qlikview Management Service"
net start "QlikView Distribution Service"
net start "QlikView Directory Service Connector"

echo ======================================================
echo All QlikView related services have been started ...

REM pause

Bookmark and Share

and tagged , , , , , , . Bookmark the permalink. Both comments and trackbacks are currently closed.

14 Comments

  1. Judi
    Posted February 10, 2010 at 14:28 | Permalink

    Hello,

    I wish to create a qlikview form customers by the way of a macro VBS.

    When I clik on NEW button, I have a customer form appears.

    Is it possible to create this form with these informations :

    Fname : | Lname : | Country 😐 City: | Company name : etc.

    Thanks for your help.

  2. Posted February 10, 2010 at 15:59 | Permalink

    Hi Judi,

    what exactly do you want to achieve with this form? Inserting & Editing data?

    Best regards
    Stefan

  3. Judi
    Posted February 10, 2010 at 16:11 | Permalink

    Hi Stefan,

    I want to create three buttons : NEW | UPDATE | DELETE

    When I click on NEW button, I can edit customers informations (fname, lname, city,) by a validation form.
    When I click on UPDATE button, I can update informations.
    When I click on DELETE button, I delete entries.

    Then, The NEW button add new entries in my SQL database and view last customer informations in the list
    Then UPDATE button updates data on my table SQL SERVER.
    Then DELETE button deletes entries

    Afterwards I think there is all the condition doublon, etc.

    Is it possible ?

    Best regards.
    Judi.

    • Posted February 11, 2010 at 08:29 | Permalink

      Hi Judi,

      note that QlikView is primarily a *read only* analysis software.

      There are is no builtin function for creating forms altough this can be done with the new feature “Real time update” introduced in QlikView 9. (Have a look at the chapter “Real-time data update” in the reference manual or “7. Using Automation for Dynami c Data Update” in the QlikView Automation Reference).

      But note that there is not builtin functionality for creating forms, valdiating forms, so this would require quite a lot of custom code to achieve the required results.

      There are some examples available at http://www.qlikview.com/community in the “Share QlikViews” section; just search for “update” there).

      Hope this helps a little bit as a starting point …

      Best regards
      Stefan

  4. Judi
    Posted February 11, 2010 at 12:01 | Permalink

    Thank for helping.

    Best regards,
    Judi.

  5. Judi
    Posted February 11, 2010 at 12:17 | Permalink

    Last questions…
    Where can I found the qlikview demo about Logistics & Transport.
    I’ll wish to have examples or models already realized.
    Thanks.

    Best regards,

    Judi

    • Posted February 11, 2010 at 13:01 | Permalink

      Regarding your questions:

      – you can find several demos at http://demo.qlikview.com (but unfortunately there’s no demo available only targetign logistics & transport)

      – I do have some solutions; but they are not ready for publishing here (give me some time and I will publish them here).

      Best regards
      Stefan

  6. Judi
    Posted February 11, 2010 at 13:03 | Permalink

    Thanks a lot for your patient.

    Best regards,

    Judi.

  7. NANA
    Posted February 11, 2010 at 21:04 | Permalink

    Hello,

    I have a question, What is the best language to implement into QV so as certain basic statement work.
    When I declare a variable like ” Dim a as Integer ” the VBScript engine don’t recognize Integer.
    And In a QV model I saw ” qvlib.msgbox(” XXXX “). What is qvlib ?
    VBScript is the only language to create macro in QV.

    Best regards,

    Judi.

    • Posted February 12, 2010 at 08:47 | Permalink

      Hello Judi again,

      first: please do me a favour and use the comment-functionality here only related to the topics of the articles; this is not a discussion forum (you can find one at http://www.qlikview.com/community); otherwise I will unfortunately have to delete your questions here. Certainly I will try to answer the mail you have sent me yesterday … but please not here for general questsions!!!

      Regarding your questions:

      * You can use the macro editor to create scripts
      * Possible scripting languages are VBScript and Javascript
      * “Dim a” would be possible but “Dim a as Integer” does not work because this is VB and not VBScript (in VBScript you do not have a type-declaration (read e.g. http://activexperts.com/axscript/vbscriptintroduction/)
      * qvlib.msgbox(“xxx”) is not necessary if you use VBScript; in VBScript you can just use Msgbox(“xxx”); QVLib is a helper class if you use Javascript because in Javascript you do not have a corresponding functionality for messageboxes like MsgBox in VBScript

      Hope this helps a little bit.
      Best regards
      Stefan

  8. Oiko
    Posted August 25, 2010 at 22:00 | Permalink

    I have 3 qvw files, each with 5 sheets of objects and data. I want to create a 4th qvw file that pulls sheet 5 from file 1, sheet 3 from file 2, sheet 4 from file 3. I want the sheets in the 4th file to be fully functional, complete with data. I don’t want to use “export sheet layout” and copy/paste the script into the 4th file. Can I use an include or if statement to pull in those 3 sheets of objects and data?

  9. Hector garcia
    Posted September 9, 2010 at 03:03 | Permalink

    Hey stepahn is the tip QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 available for 8.5? it will be great to have it, if not ..any tip to starting and stopping the server 8.5 in an automated way??

    Thanks

    Hector

    • Posted October 5, 2010 at 10:34 | Permalink

      Hi Hector,

      the script for stopping/starting the QlikView-services in QV 8.5 is very similar.
      Just have a look at the “services” management console in windows and write down the names of the appropriate services and adopt my script (if necessary). Unfortunately I do not have a QlikView 8.5 installation available at the moment where I could test that …

      Hope this helps …
      Best regards
      Stefan

One Trackback

  1. […] QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 :Admin, QV9, Server […]