topic Re: Delete Text files from a folder in QlikView

Delete Text files from a folder

Thu, 11 Aug 2011 08:31:28 GMT

Hi All,

How can i delete all Text Files from a particular folder in my machine by using Qlikview.

Example:

IN my machine D:\Data\TextFiles folder having for 4 text files. Now i want to delete the files by using the Qlikview functionality.

How can i do it.

Thanks in advance.

Regards

Venkat

Delete Text files from a folder

kaushiknsolanki — Thu, 11 Aug 2011 09:03:47 GMT

Hi,

For that you need to search for VBScript code to achieve this, as this is not a part of Qlikview.

But you can use that code in Qlikview as Qlikview supports VBScript.

Regards,

Kaushik Solanki

Re: Delete Text files from a folder

erichshiino — Thu, 11 Aug 2011 10:21:06 GMT

Hi, If you want to delete files using macro, this is the code : (it will delete only text files in the folder C:\Folder)

sub DeleteFiles

Set filesys = CreateObject("Scripting.FileSystemObject")

filesys.DeleteFile "c:\Folder\*.txt"

end sub

You can also see it working in the attachment (you need to allow system access to macros)

Hope this helps,

Erich

Re: Delete Text files from a folder

erichshiino — Thu, 11 Aug 2011 10:25:24 GMT

If you want to do it from script, this is the code:
EXECUTE del C:\Folder\*.txt /q

On the script window, settings tab (bottom of the screen), you need to mark 'Can execute external program'

Regards,

Erich

Re: Delete Text files from a folder

Fri, 12 Aug 2011 07:17:09 GMT

Hi Erich,

Thanks for your reply.

Pls can you explain little more clear on doing through EditScript.

I didn't get you point.

Regards

Venkat

Re: Delete Text files from a folder

erichshiino — Fri, 12 Aug 2011 11:03:15 GMT

Hi,

This is a line you should include in your script:

EXECUTE del C:\Folder\*.txt /q

The execute command will send it to windows. It's the same as opening DOS prompt and writing the command there.

Del will exclude .txt files in the folder C:\Folder\

the /q parameter will make this command run quietly (without opening the prompt window or showing messages when it finishes)

Hope it helps,

Erich

Re: Delete Text files from a folder

Tue, 16 Aug 2011 13:20:51 GMT

Hi Erich,

Sorry for very late reply.

I tried your Script code but generating an error "SCRIPT LINE ERROR".

Pls see the attached document. And update me where i am done wrong.

Regards

Venkat.

Re: Delete Text files from a folder

rbecher — Tue, 16 Aug 2011 13:41:10 GMT

Hi Venkat,

try this:

execute cmd.exe /c del *.txt;

- Ralf

Re: Delete Text files from a folder

Tue, 16 Aug 2011 14:18:14 GMT

Hi Ralf Becher,

With Edit script it working fine now.

And now i am trying with macro code but it is not deleting the files from folder.

Always it is geneating Else part msgbox i.e; NO FILES TO DELETE. The folder contains Text files also but it is not entering into "if loop".

Pls check the below macro code.

Sub DeleteFiles
Set filesys = CreateObject("Scripting.FileSystemObject")
If filesys.FileExists("D:\TestAllFlatFiles\*.txt") then
filesys.DeleteFile "D:\TestAllFlatFiles\*.txt"
Msgbox("Files Deleted")
Else
Msgbox("No Files to delete")
End If
End Sub

Thanks in Advance.

Regards

Venkat

Re: Delete Text files from a folder

rbecher — Tue, 16 Aug 2011 14:44:15 GMT

Hi Venkat,

this will not work. You have to loop over files:

http://groups.google.com/group/microsoft.public.scripting.vbscript/browse_thread/thread/44b57743b25ace8b

HTH,

- Ralf

Re: Delete Text files from a folder

Tue, 16 Aug 2011 15:01:17 GMT

Hi Ralf Becher,

Its working fine now by using your macro code. It was awesome.

Pls can you explain in detail of this code, that would be very useful to me.

Thanks in Advance.

Regards

Venkat

Re: Delete Text files from a folder

Fri, 19 Aug 2011 05:50:37 GMT

Hi Ralf Becher,

How r u ?

When i using the below line then it is displaying an MessagePrompt. After clicking the button of "Override Security, Execute this Statement" the action is performing correctly.

execute cmd.exe /c del *.txt;

Whenever i reload it is displaying the Message same. After Clicking the button it is performing the our required action. I attaching the image in below.

How can i change the code for not to displaying MessagePrompt.

Thanks in advance.

Regards

Venkat

Re: Delete Text files from a folder

Fri, 19 Aug 2011 07:33:27 GMT

Hi Ralf,

The Below line is to delete the Text files from a folder

execute cmd.exe /c del *.txt;

My New Task is:

Now i need to Move the Text Files from current Foldet to another Folder. This should be done by script in QVW file.

The Code shold be like above format.

How i can work on it ? If any idea regarding this.

Thanks in advance

Regards

Venkat

Re: Delete Text files from a folder

rbecher — Fri, 19 Aug 2011 08:37:54 GMT

Hi Venkat,

just use the 'move' command:

execute cmd.exe /c move *.txt target_folder;

You can execute any OS command..

- Ralf

Re: Delete Text files from a folder

Fri, 19 Aug 2011 10:11:03 GMT

Hi Ralf,

I am sorry for late reply,

What you said is working fine. But it is always showing an PromptMessage after clicking on the "Override Security, Execute this Statement".

How i can make it not to display while reloading.

Do you have any idea on this.

Thanks in advance.

Regards

Venkat

Delete Text files from a folder

swuehl — Fri, 19 Aug 2011 10:32:23 GMT

Hi Venkat,

what Version of QV do you run?

Have you checked out: http://community.qlik.com/message/73851#73851 ?

Re: Delete Text files from a folder

Fri, 19 Aug 2011 11:24:33 GMT

Hi swuehl,

That really good. It helps me, not to display that message everytime.

Once again Thank you.

Regards

Venkat

Delete Text files from a folder

rbecher — Fri, 19 Aug 2011 11:28:20 GMT

Re: Delete Text files from a folder

Fri, 19 Aug 2011 11:54:36 GMT

Hi Ralf,

Thank you its working after checking the option in Edit Script .

Regards

Venkat

Re: Delete Text files from a folder

Wed, 22 Feb 2012 09:20:55 GMT

Hi,

how to write macro code for copying the images(.bmp) from one folder(source folder) and paste into another folder(destination folder).

Any idea on this ?

Thanks in advance.