Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mallikarjun_h
Partner - Creator
Partner - Creator

Is it possible for the publisher to selectively delete QVD files?

Can we assign a task to publisher to selectively delete the QVD files.

1 Solution

Accepted Solutions
Not applicable

Create a bat file which delete the files you want and than call this bat file using an External Program Task (System/Supporting Tasks in QMC).

View solution in original post

5 Replies
Not applicable

Create a bat file which delete the files you want and than call this bat file using an External Program Task (System/Supporting Tasks in QMC).

mallikarjun_h
Partner - Creator
Partner - Creator
Author

Thanks Magnus.......

But is there any other way to do so?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Yes, you can always obtain the same result using a QlikView document (QV is polyvalent, you know)

Create a QVW with a script that contains paths and EXECUTE xxxx; commands. Schedule a task and chain it wherever you want.

IMHO the Supporting task-approach is the more manageable one.

mallikarjun_h
Partner - Creator
Partner - Creator
Author

Hi Magnus,

Wow that is interesting can I delete the qvd file by giving it's path???

what is the function specified in QV for that?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

There isn't a specific DELETE QVD statement in QlikView Script. The EXEUCTE statement allows you to execute external commands (like you enter in a Command prompt).

For example, the following will delete a QVD from my development tree:

EXECUTE CMD.EXE /C "DEL $(vSrcPath)\Development\QVD\ODS\Customers.QVD";

For this to work, you'll have to set two switches:

  • In Script Editor->Switches (last tab at the bottom, enable "Can Execute External Programs"
  • Grant System Access to your script

Peter