topic Auto loading at fixed time in QlikView

Auto loading at fixed time

upaliwije — Mon, 13 Feb 2017 15:35:13 GMT

Hi,

I have two qlikview fi. First one to create a QVD file and 2nd one to obtain sales data by loading QVD file. I want to run these files at 6.30 am daily. Pls help me to automate the file loading

Re: Auto loading at fixed time

kaushiknsolanki — Mon, 13 Feb 2017 15:38:27 GMT

Hi,

You need QlikView Server to do this.

Other option Reload from Batch File.

Batch file script to reload Qlikview Applications

Regards,

Kaushik Solanki

Re: Auto loading at fixed time

awhitfield — Mon, 13 Feb 2017 16:08:10 GMT

Do you have a QV Server installation?

Andy

Re: Auto loading at fixed time

upaliwije — Tue, 14 Feb 2017 03:06:22 GMT

Re: Auto loading at fixed time

saimahasan — Tue, 14 Feb 2017 09:02:52 GMT

You can use batch file to schedule and run the files

Re: Auto loading at fixed time

upaliwije — Tue, 14 Feb 2017 09:10:43 GMT

Can you pls send me a sample batch file

Re: Auto loading at fixed time

sdmech81 — Tue, 14 Feb 2017 09:14:41 GMT

U want to generate logs n all or??

Or just reload?

Re: Auto loading at fixed time

aveeeeeee7en — Tue, 14 Feb 2017 09:18:11 GMT

Hi Upali

Go through these Documents and Links:

https://skillforge.com/qlikview-scheduled-update-of-qlikview-reports/

https://community.qlik.com/docs/DOC-5412?_ga=1.32643006.1495895207.1487063719

This will help you out.

Regards

Av7eN

Re: Auto loading at fixed time

vardhancse — Tue, 14 Feb 2017 09:19:07 GMT

Batch file script to reload Qlikview Applications

Re: Auto loading at fixed time

sdmech81 — Tue, 14 Feb 2017 09:23:26 GMT

FOR /F "TOKENS=1* DELIMS= " %%A IN ('DATE/T') DO SET CDATE=%%B

FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B

FOR /F "TOKENS=1,2 DELIMS=/ eol=/" %%A IN ('echo %CDATE%') DO SET dd=%%B

FOR /F "TOKENS=2,3 DELIMS=/ " %%A IN ('echo %CDATE%') DO SET yyyy=%%B

rem FOR /F "TOKENS=2,4 DELIMS=/ " %%A IN ('echo %CDATE%') DO SET HH=%%B

for /f "tokens=1-5 delims=:" %%d in ("%time%") DO SET HH=%%B

if %MM%==01 set MM=JAN

if %MM%==02 set MM=FEB

if %MM%==03 set MM=MAR

if %MM%==04 set MM=APR

if %MM%==05 set MM=MAY

if %MM%==06 set MM=JUN

if %MM%==07 set MM=JUL

if %MM%==08 set MM=AUG

if %MM%==09 set MM=SEP

if %MM%==10 set MM=OCT

if %MM%==11 set MM=NOV

if %MM%==12 set MM=DEC

SET setd=%dd%%mm%%yyyy%

echo %setd%

set filename=Give name_%setd%.log

echo %filename%

set var=--------------------------------------------------------------------------------------------------------------------------

set QVEXE="C:\Program Files\QlikView\Qv.exe"

Set Path="GIVE PATH_%setd%.log"

REM...................................................Extractors.....................................................................

Rem -----------Batch Start--------------------------------------------------

Set QVReport="E:\GIVE PATH\Name.qvw"

echo %DATE% %TIME% Loading started For %QVReport% >> %Path%

%QVEXE% /r %QVReport%

echo %DATE% %TIME% Loading ended For %QVReport% >> %Path%

echo %var% %var% >> %Path%

Rem ---------------Batch End----------------------------------------------

Hi Bold letter plss take care..Chech whtr QV.exe in path..Give ur file names..Plss try

Sachin