Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a simple method within Publisher to trigger a reload when a text file exists?
Currently, I'm using a dos batch file to check if a file exists and then trigger the command line reload. I'd like to eliminate as many Windows Scheduled Tasks as possible, to streamline administration.
I'm using QVS v9 SR6 with a Publisher license.
Any suggestions would be appreciated,
B
Hello B,
as far as I know there exits no file polling mechanism in the QV-Publisher (V10). We would like to have it at more then one customer site and discussed about that with some QT-techies, still pending. So if someone knows a common solution, don't hesitate to tell it!
Regards, Roland
You can use the external program trigger to this in Publisher. Located in the QEMC/system/supporting task tab.
I should have been more explicit in my previous message. I need a process to continuously monitor for a specific text file, then trigger the application reload. I've done this using a batch command that checks for the file then waits a minute and checks again. It is schedule to run at 5am and will run until the file is found. The following a successful reload, the file is delete.
Is there a more elegant option with Qlikview Publisher?
Hello B,
as far as I know there exits no file polling mechanism in the QV-Publisher (V10). We would like to have it at more then one customer site and discussed about that with some QT-techies, still pending. So if someone knows a common solution, don't hesitate to tell it!
Regards, Roland
Thanks for the feedback.
B
You can do the same by creating a task on the Server/Publisher for the batch job and then attach your Qlikview load task to this task to trigger after the batch job is completed. then you can attach another task to the second task to delete the file. Your first task will be in running state at the scheduled time till it finds the file and will complete successfully after it finds the file. Then the second and third tasks get triggered in succession.This is the only solution available in Qlikview server/Publisher 9 task reload scheduling. Here is a link for creating the batch file.
http://www.computing.net/answers/programming/loopinig-batch-file-using-if-exist/17323.html
Do you get this file several times in a day?If so you can schedule he first task to run multiple times.
Thanks for the suggestion, but I've taken a different approach.
I was expecting to have a file passed by a process that one of my clients is running. Instead, I've configured a task that is triggered on an external event, and then configured an EDX job that my client can call. I was familiar with this functionality previously, but it works well.
For other jobs that I already have running as scheduled tasks, I'm going to leave as is. Since they are constantly running, I'd rather not use external tasks for fear of timing issues. At lease with Scheduled Tasks, I can combine in a single batch process, so I can eliminate timing issues.
Thanks again,
B
Hi B,
When you reload by DOS, will the distribution still work?
Or it's just a pure reload?
What if i want to ditribute it in publisher?
and, is it possible to have a look at the code of your batch file?
thanks.
Attached is the dos batch file.
Hope it helps,
B
Hii B,
Can u please provide a step by step scenario of exactly how you achieved this ? .
I m kinda new to edx functionality.