Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

copy files

Hello !

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

1 Solution

Accepted Solutions
Not applicable

Hello,

Here you go

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


Capture3.GIF

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

Capture.GIF

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)

Capture2.GIF

Step 4 - reload!

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

Warm regards,

Nish

View solution in original post

12 Replies
m_woolf
Master II
Master II

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

souadouert
Specialist
Specialist
Author

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

Not applicable

Hello,

Here you go

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


Capture3.GIF

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

Capture.GIF

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)

Capture2.GIF

Step 4 - reload!

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

Warm regards,

Nish

satheshreddy
Creator III
Creator III

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

avinashelite

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 ..

souadouert
Specialist
Specialist
Author

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);

souadouert
Specialist
Specialist
Author

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

souadouert
Specialist
Specialist
Author

thank y very helpful doc