Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bnichol
Specialist
Specialist

Trigger Document Reload When File Exists

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

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

10 Replies
Bill_Britt
Former Employee
Former Employee

You can use the external program trigger to this in Publisher. Located in the QEMC/system/supporting task tab.

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
bnichol
Specialist
Specialist
Author

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?

Not applicable

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

bnichol
Specialist
Specialist
Author

Thanks for the feedback.

B

Not applicable

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.

bnichol
Specialist
Specialist
Author

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

Not applicable

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.

bnichol
Specialist
Specialist
Author

Attached is the dos batch file.

Hope it helps,

B

Not applicable

Hii B,

Can u please provide a step by step scenario of exactly how you achieved this ? .

I m kinda new to edx functionality.