File watcher File - Qliksense reload task complete

jpjust — Wed, 03 Nov 2021 21:10:35 GMT

Hi All,

Is it possible to export an txt file or some thing at the end of the load script?

Then I can use that file as an file watcher for other programs to run. Other way of telling that the qliksense reload task is complete.

Any other ideas are welcome as well.

Thanks

Re: File watcher File - Qliksense reload task complete

Andrei_Cusnir — Thu, 04 Nov 2021 11:25:09 GMT

Hello,

In your use case scenario you will have to use the EXECUTE [1] command.

Here are the steps that you should follow:

Create a folder that you want to monitor for a file creation. e.g. "My Location" folder on "Desktop"
Open Notepad and copy paste: >> "echo Qlik Sense reload was completed! > "C:\...\Desktop\My Location\log.txt" <<
Note: The quotes are included in the statement, because if your path has spaces it will fail. But using quotes will work every time, either the path has spaces or not.
Click on Save As
Choose Name "executable.bat"
Choose Save as type "All files (*)"
Note: You have to make sure that your saved file is NOT named executable.bat.txt but is named executable.bat. Otherwise, it will not get executed by CMD.
In Qlik Sense you have to setup some configurations first, so follow the steps in the official documentation [1] carefully.
Now open Data load editor and add the following statement at the end of the script:
Execute "C:\Windows\System32\cmd.exe" /R "C:\Users\...\Desktop\My Location\executable.bat"
This will use the CMD in the defined path (first part of the command) and will execute the "executable.bat" that you have created.
When the bat file is executed, you will see that the "log.txt" will be created.
You can modify the text that you are saving in the bat file to make it unique each time e.g. saving the current date and time that the log.txt was created. This way when you read the file with another software you will know if the file was created recently etc.

Here is my result after Data load editor finished execution:

I hope that this information was helpful.

---

jpjust — Fri, 05 Nov 2021 13:23:21 GMT

Thank you Andrei so much. I think this should help with my usecase.

I will give it a try and let you know.