Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Auto loading at fixed time

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

9 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

You need QlikView Server to do this.

Other option Reload from Batch File.

Batch file script to reload Qlikview Applications

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
awhitfield
Partner - Champion
Partner - Champion

Do you have a QV Server installation?

Andy

upaliwije
Creator II
Creator II
Author

No

saimahasan
Partner - Creator III
Partner - Creator III

You can use batch file to schedule and run the files

upaliwije
Creator II
Creator II
Author

Can you pls send me a sample batch file

sdmech81
Specialist
Specialist

U want to generate logs n all or??

Or just reload?

aveeeeeee7en
Specialist III
Specialist III

sdmech81
Specialist
Specialist

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