topic Re: How to run a shell script through Qlikview? in QlikView

How to run a shell script through Qlikview?

Thu, 30 Mar 2017 12:54:30 GMT

Hi Everyone,

I have a shell script named abc.bash located in a ftp location ( alphabets.xyz.com ). The path is suppose /u03/home/myname. I need to run this script through Qlikview. The motive to run this script is that when properly executed, the script would generate a xml file with the nomenclature All_open_sysdate.xml in the same path location. I need to call this xml file also from the same location.

Can anyone please help me out on how should I proceed to achieve this.

Please also share the process on how to override the security feature in Qlikview.

I tried to execute this statement:

Execute cmd.exe /C abc.bash

FROM

[ftp://Userid:password@alphabets.xyz.com/u03/home/myname]

But this didn't help. I got an error to override the security feature.

Please correct me if I am wrong.

Re: How to run a shell script through Qlikview?

vishsaggi — Thu, 30 Mar 2017 16:15:53 GMT

Try this? In edit script go to Settings tab or User Preferences Security tab. Like below screen shots.

Re: How to run a shell script through Qlikview?

Fri, 31 Mar 2017 14:43:31 GMT

Hi Viswarath,

Thanks for your help. While executing I didn't receive any error and the script executed but the problem is no xml is getting created in the same location of the server. When I manually tried to execute this .bash file in the server through putty, the xml file got generated

Could you please help me out with the entire script about what should be written in Qlikview so that the xml gets generated in the server location apart from making the above mentioned changes by you.

Thanks and Regards,

Arghya

Re: How to run a shell script through Qlikview?

vishsaggi — Fri, 31 Mar 2017 15:43:18 GMT

I have never tried any such sort, so i need some example file to work on. Do you have any sample ?

Check here if this is of any help?

Execute Statement for Qlikview Scripts

Re: How to run a shell script through Qlikview?

Mon, 03 Apr 2017 10:11:36 GMT

Hi Vishwarath,

You can try with any .bash file you have. My first objective is to execute a .bash file present in a server location with the help of Qlikview script. I am not able to accomplish this task.

I tried with this kind of statement:

Execute cmd.exe /C abc.bash

FROM

[ftp://Userid:password@alphabets.xyz.com/u03/home/myname]

but it didn't work out. Can you suggest me with any possible alternative.

Thanks and Regards,

Arghya

Re: How to run a shell script through Qlikview?

vishsaggi — Mon, 03 Apr 2017 14:08:27 GMT

Can you use Windows Scheduler to run this .bash file? Just an alternative, coz i am not sure of other options, there is very small thing we are missing, cant execute at my side, bust just wondering, can you give me some sample data to try on my side?

Re: How to run a shell script through Qlikview?

tamilarasu — Mon, 03 Apr 2017 14:34:58 GMT

Hi Arghya,

I have not used ftp connection before but I guess your file path causing the issue. I am not sure but the below one may work.

Execute cmd.exe /C ftp://Userid:password@alphabets.xyz.com/u03/home/myname/abc.bash

Re: How to run a shell script through Qlikview?

Wed, 05 Apr 2017 12:51:49 GMT

Hi Tamil,

Thanks for your help.

I don't think its a problem of the path you are referring to. Still i tried to implement your query and it executed perfectly fine with no errors. But the motive behind this shell script is not fulfilled.

Will have to try with some other alternative.

Thanks and regards,

Arghya

Re: How to run a shell script through Qlikview?

jonathandienst — Wed, 05 Apr 2017 13:03:40 GMT

Does the bash script run under windows? This extension normally applies to scripts that tun under the bash shell of Linux/Unix systems.

If it runs under windows, you will need to retrieve the file from the FTP site before attempting to execute it. You will need a Windows batch (.cmd/.bat) file to fetch the bash script, save it to a known location and fire up the software that runs the script. You can execute the batch file like this from the load script (assuming you have set the relevant permissions):

Execute cmd.exe /C C:\BatFiles\MyBatchFile.bat

You can get a lot of help writing Windows batch/command files on the Internet. Google is your friend.

Re: How to run a shell script through Qlikview?

Wed, 05 Apr 2017 13:08:27 GMT

Hi Jonathan,

No the bash script doesn't run under windows. It runs under Linux systems.

Can you please provide some solution. This should run in the server itself.

Thanks in advance!!!

Thanks and regards,

Arghya