Solved: Re: Automated Save As job - Qlik Community

Report Inappropriate Content · ‎2012-06-22

Is it possible to create an automated Save As job for my Qlikview file?

Basically what I need is a copy of my file to be saved everyday at 15:00 with this name format stock_report_2012_06_22.qvw

Cheers,

Mem

Miguel_Angel_Baeyens · ‎2012-06-22

Hi,

Assuming you don't have Publisher, you can do that using the Windows Scheduler that calls a BATCH file with OS instructions to copy the original file to a new location with that name.

A .BAT file with something like the following should work.

SET DATESTAMP=%DATE:~0,2%_%DATE:~3,2%_%DATE:~6,4%
COPY OriginalFile.qvw Stock_Report_%DATESTAMP%.qvw

Hope that helps.

Miguel

View solution in original post

Miguel_Angel_Baeyens · ‎2012-06-22

Hi,

Assuming you don't have Publisher, you can do that using the Windows Scheduler that calls a BATCH file with OS instructions to copy the original file to a new location with that name.

A .BAT file with something like the following should work.

SET DATESTAMP=%DATE:~0,2%_%DATE:~3,2%_%DATE:~6,4%
COPY OriginalFile.qvw Stock_Report_%DATESTAMP%.qvw

Hope that helps.

Miguel

Report Inappropriate Content · ‎2012-06-22

worked perfectly, thanks very much!

cheers,

mem

Report Inappropriate Content · ‎2012-08-26

Hi Miguel,

I have to publish the Archived QlikView Files to the Server.

How can we do that?

the file names will be different. so we cannot create task for every file.

so how we can do it but not by mounting folder?

can you please help me?