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.
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.
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?
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.
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.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein