topic how to delete file? in QlikView

how to delete file?

Tue, 07 Jul 2009 21:12:39 GMT

hello guys [:)]

I have a question and I think ( and hope) that it quite simple to done.

I'm loading data from an EXCEL file.

after loading the file I want to delete it from the directory its located,how can I do that from that script?

Is it possible to move it to another directory instead of deleting it?

Do I need to use a batch file? ( I really prefer not to)

10X

David

how to delete file?

disqr_rm — Wed, 08 Jul 2009 00:43:36 GMT

You can create a VBScript function and then call it from your QlikView script just after the load. See enclosed example.

Make sure to change the file paths and give System access in the Macro to be able to delete the file.

Let me know if it helped by verifying the solution.

how to delete file?

Karl_Humma — Wed, 08 Jul 2009 07:31:41 GMT

The above solution will not work if you are reloading in Publisher, in that case you will need to use a bat file as Pub does not fire off any macros. Just in case you are using Publisher for reloads 🙂

/Karl

how to delete file?

Anonymous — Wed, 08 Jul 2009 07:40:31 GMT

It is possible to implement this without macro.
One of my apps reads XML files, and moves them after that into a different folder. Technically not much different from delete. I'm using external batch file for this. This file is called within the reload script by the Execute command.
Just noticed that David doesn't want batch file...

how to delete file?

disqr_rm — Wed, 08 Jul 2009 08:15:17 GMT

Yes this is another way possible. But then make sure to make a registry adjustment in the server.

See http://community.qlik.com/forums/p/16459/64216.aspx for details.

how to delete file?

Wed, 08 Jul 2009 13:17:40 GMT

thanx Rakesh it seem to be working!

Michael,Can you add your solution with the batch file? simultaneously I will check this one

and see if it fits.

Thanx

how to delete file?

disqr_rm — Thu, 09 Jul 2009 01:55:15 GMT

Here is code line for EXECUTE command prompt commands from script:

Execute cmd /C del /Q "filepath\filename";

Please make sure to make registry adjustments in the server as mentioned in earlier post.

how to delete file?

Thu, 09 Jul 2009 13:03:18 GMT

Rakesh, Do I need to build a batch file? if yes,what it contains?

I'm quite new in QV so.....can you please attach an example?

thanx in advance

how to delete file?

disqr_rm — Fri, 10 Jul 2009 02:35:27 GMT

No, you would put this line in the QVW script just after your load statement:

Execute cmd /C del /Q "filepath\filename";

This line will execute a DOS command "DEL" to delete the file in the quotes with "Q" option for "quietly".

how to delete file?

Anonymous — Fri, 10 Jul 2009 23:59:06 GMT

I cannot post my application, and don't have enough time now to create an example, sorry. Here is the description:
I have file move.bat with one line inside, like this:
move Folder1\*.xml folder2\
It moves all xml files from one directory to another. You can use a line here that deletes fiels.
Next, in the QV application script, there is line (after I read the xml data):
EXECUTE move.bat;
The only other things I have to add:
1. Make sure to check "Can Execute External Programs" box on the "Setting" tab of the script editor.
2. On the user preferences, Security - check the box "Script..."
Hope it helps...

how to delete file?

Tue, 17 Nov 2009 22:28:07 GMT

Hi Michael,

I am trying the same thing you did. I have got a working batch file (if I execute it manually) in the same directory as the .csv I want to move after reload. But when I put

EXECUTE C:\QlikView Storage\Private Data\Datasources\Input\TMS\ConfigLijst\move.bat;

in my script it won't move the file. My batchfile looks like this:


@echo off
move /Y "*.csv" "old\"
echo on

The reload window says done but nothing happens! When I put the QlikView application in the same folder as the .bat and remove the path it does work...

Is there something wrong with the way I call the path?

Regards, Sander

how to delete file?

Anonymous — Thu, 19 Nov 2009 23:56:29 GMT

Hi Sander,
It's hard to tell what's going on... If EXECUTE doesn't work - check the conditions I've mentioned above. If that batch file doesn't work - see if it executes manually. Also makes sense to check if there are security restrctions on files and folders.

how to delete file?

Wed, 02 Dec 2009 23:24:53 GMT

Hi Michael,

Thanks for your response. I don't know how but the problem is solved.. The only thing I can imagine is that the relative path I defined wasn't processed ok.. Manual execution did work ok, I had checked that.. It was in QlikView or the script.

Anyway.. Your solution does the trick, even in Publisher. Thanks!

Regards, Sander

how to delete file?

bradshields — Tue, 02 Feb 2010 12:01:04 GMT

I had trouble with the path statement too. I moved the .bat file i wanted to execute to the same folder as the .qvw and I also renamed the .bat file to have no spaces. Also make sure you check to allow script (Allow Database Write and Execute Statement) under Settings User Preferences

Re: how to delete file?

juan_c_martinez — Fri, 30 May 2014 13:34:15 GMT

Thanks Rakesh! It works fine!

Re: how to delete file?

Mon, 24 Nov 2014 12:00:32 GMT

Hi Rakesh

Could not open the thread.

Could you Please send the Batch file to delete and archive the files.

Also I tired you QVW its deleting the files But could I archive the files also.

Re: how to delete file?

madushanfernand — Fri, 15 Mar 2019 11:31:21 GMT

this works perfect. but can we have a function to open another qvw using a function like this.?