topic Re: Automatic execution process required in QlikView

Automatic execution process required

Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

In the above diagram whole execution process we are doing manually on daily basis. I want this process to be happen automatically.

1) In the above SSIS package will be executing all the files and sending .csv files to this x-folder one by one with different times.

2) After that we are moving these .csv files from x-Folder to Y-folder with batch files and we will loading this .csv files into Z-folder QVW files.

3) Now i required to make this automation for all my applications.

Please give me some suggestions for making automation for this process.

Thanks

Avinash

Re: Automatic execution process required

swuehl — Sun, 19 Jul 2015 18:56:24 GMT

There is not much information given about your environment, e.g. if you are using a QV server or nor.

If you want to trigger a server task from an external system, you can use EDX trigger:

Using EDX in QlikView 11

If you then want to copy files / run batch files from QV environment, you can use a supporting server task or use an EXECUTE statement from a QV load script.

Re: Automatic execution process required

qlikviewwizard — Mon, 20 Jul 2015 03:32:53 GMT

Hi AvinashKuraku

If you want to move the files of X-Folder to Y-Folder and Y-Folder to Z-Folder you can use batch files and run the batch files through windows task scheduler.

Hope this will help you.

Re: Automatic execution process required

prashantbaste — Mon, 20 Jul 2015 09:01:37 GMT

You can write Batch File to copy files from one folder to another & also to reload QVW files.

As follow -

1. Write below code into one of notepad file

copy "X Folder\A.scv" "Y Folder\"

copy "X Folder\B.scv" "Y Folder\"

copy "X Folder\C.scv" "Y Folder\"

"C:\Program Files\QlikView\qv.exe" /R "\QV_Application_A.qvw"

Exit

Save this file as .bat & set it into Windows scheduler.

Also I hope you want to store A.QVD, B.QVD & C.QVD into Z Folder (you have mentioned qvw & not qvd). This can be done with in A.qvw , B.qvw & C.qvw so that whenever these files will be reloaded QVDs will get updated automatically at desired/mentioned folder.

Hope this will be helpful for you.

Regards,

Prashant P Baste

Re: Automatic execution process required

qlikviewwizard — Mon, 20 Jul 2015 09:07:09 GMT

Hi AvinashKuraku ,

Please check my document here.

Batch file script to reload Qlikview Applications‌

Hope it will help you.

Re: Automatic execution process required

Tue, 21 Jul 2015 16:19:15 GMT

Presently we are doing through batch files only.

my Question is in x-folder for today one one files i generated and that only should process in the automation. other files should not run or move to other folder.

suppose in x-folder there are three files only and one file generated A.csv and other files B.csv, C.csv are not generated from SSIS for today. So only A.csv should move to other Y-folder and that A.csv file should be triggered by A.Qvw in z-folder. This execution of whole process should be happen automatically.

In the next day in x-folder B.csv and C.csv is generated from SSIS, A.csv is not generated for today. So the above whole process moving these two files B.csv and C.csv to other y-folder and in z-folder B.qvw and C.qvw should be executes successfully. This whole process to be executed by automatically.

Please let me know on this.

thanks

avinash

Re: Automatic execution process required

Tue, 21 Jul 2015 16:22:32 GMT

Hi Prashant,

Presently i am running with batch files only.

Please look onto the below reply for my question

Re: Automatic execution process required

Tue, 21 Jul 2015 16:25:16 GMT

Many thanks For your reply Swuehl,

Already i am using batch files that i am running manually but i want to do automatically.

please look into the below replies.

thanks

avinash

Re: Automatic execution process required

prashantbaste — Wed, 22 Jul 2015 05:29:58 GMT

You need to modify your script like -

forfiles /P "c:\X Folder" /M *.csv /D +0 /C "cmd /c copy @path d:\Y Folder"

This will copy all files form "C:\X Folder" to "D:\Y Folder" & which are modified today only.

Hope this will be helpful for you.

Regards,

Prashant P Baste

Re: Automatic execution process required

qlikviewwizard — Wed, 22 Jul 2015 09:05:38 GMT

Hi AvinashKuraku

I guess, This is not related to Qlikview. You can do this based on Windows system file created date.

Please search in google for batch file script.

Re: Automatic execution process required

qlikmsg4u — Wed, 22 Jul 2015 09:10:50 GMT

check this link, it may be useful

superuser.com/questions/753005/move-1-file-at-a-time-based-off-timestamp-using-windows-batch-utility