QlikView File Copy Automated

[Ron1]

UAT Root: \\UAT\Deploy\   (There could be multiple directories,sub directories, directories under sub directories)

PROD Root: \\PROD\Deploy\ (There could be multiple directories,sub directories, directories under sub directories)

The structure of UAT root will match with PROD. (However Prod might have additional folders) (But whichever folders and subfolders are there in UAT will be there in PROD exactly the same way, only in Root For UAT it will be UAT and for PROD it will be PROD)

Now I want to create a qvw file which will run once a day and it will automatically pick up 'files' which are there in UAT with file time (current date) will be copied in exact same location inside PROD. But before coping it will check if it exists if the file is already present in PROD it will take a back up on the same folder with current date time stamp.

I am stuck with this requirement, any experts, kindly help. 

[Ron1]

Any help on this? 

[Brett_Bleess]

I believe the easier way to do this is going to be using an External Task if you have a Publisher license for the environment.  This way you can likely use a PowerShell script to do things and just call the script to run via the External Task, here is the help on our side for creating that:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/QMC/Content/QV_QMC/QMC_System_SupportingTa...

If you do not have Publisher, I would likely then potentially consider doing this in Windows OS via PowerShell script that way I think rather than trying to do it within Qlik side of things, as that should be much easier to do I believe.  Hopefully this gives you a better idea on how to approach things.

Regards,
Brett

[Brett_Bleess · Accepted solution]

Found your other post where you accepted solution, so posting that here and marking as well:

https://community.qlik.com/t5/QlikView-App-Development/File-Copying-From-N-Folders-and-Sub-folders/m...

Regards,
Brett