topic Re: copy files in QlikView

copy files

souadouert — Wed, 19 Apr 2017 15:22:11 GMT

Hello !

I have a question the qlikview has the possibility from a script to copy folder files to another (windows copy paste)

Re: copy files

m_woolf — Wed, 19 Apr 2017 16:07:37 GMT

You can use the VB Script File System Object (FSO)

Re: copy files

souadouert — Wed, 19 Apr 2017 18:39:40 GMT

I am a beginner with qlikview, you can explain to me more

Re: copy files

Wed, 19 Apr 2017 20:26:44 GMT

Hello,

Here you go

Step 1 - enable script can execute external programs via "Edit script > Settings tab", screenshot below

Step 2 - Allow database write and execute statements in script via "Settings > User Preferences > Security tab", screenshot below

Step 3 - Create script line as below. You will need to update highlighted bit though. In my example

C:\temp\*.txt (Source files path)

C:\temp\Archive (Target folder path)

Step 4 - reload!

Give this a whirl and let me know how you get on.

Warm regards,

Nish

Re: copy files

Siva_Sankar — Thu, 20 Apr 2017 05:42:56 GMT

How to Copy QVDs from Location A to B using Script | Qlik Community

Re: copy files

satheshreddy — Thu, 20 Apr 2017 05:50:30 GMT

Hi Souad,

Yes, you can use copy paste from one QVW File script to one more Qvw File,

but make sure the datasource place is same.

Regards

Sathish

Re: copy files

avinashelite — Thu, 20 Apr 2017 06:32:08 GMT

Which file type you trying to copy ? and what should be the output format ?

if its a CSV to CSV,Excel ,TXT

TXT to TXT ,Excel ,CSV,TXT

Excel to Excel,CSV ,TXT

then without VB its possible ..

Re: copy files

souadouert — Thu, 20 Apr 2017 08:06:07 GMT

Good morning avinash i used

DIRECTORY;

t: load rand() AutoGenerate 100;

EXECUTE cmd.exe /C move /Y .\QVD\*.qvd .\QVD_OLD ;

store t into .\QVD\t.qvd (qvd);

Re: copy files

souadouert — Thu, 20 Apr 2017 08:09:54 GMT

Hello nishant

thank y So C an i Uses repetitive loop as for, while ...

For example, I want to save the folder names of a path in array and then I loop on that variable

Re: copy files

souadouert — Thu, 20 Apr 2017 08:10:13 GMT

thank y very helpful doc

Re: copy files

souadouert — Thu, 20 Apr 2017 08:10:40 GMT

thank y s s for yr help

Re: copy files

Thu, 20 Apr 2017 10:20:35 GMT

Hello Souad,

Thank you! I'm sorry I don't understand your question. Perhaps post it under a new thread and I will take a look for you.

Warm regards,

Nish

Re: copy files

souadouert — Thu, 20 Apr 2017 10:31:56 GMT

thank y i fixed the problem , thank you for yr time