Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
bnichol
Valued Contributor

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

AW:Re: Trigger Document Reload When File Exists

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

9 Replies
Employee
Employee

Trigger Document Reload When File Exists

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

bnichol
Valued Contributor

Trigger Document Reload When File Exists

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

AW:Re: Trigger Document Reload When File Exists

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
Valued Contributor

AW:Re: Trigger Document Reload When File Exists

Thanks for the feedback.

B

Not applicable

Trigger Document Reload When File Exists

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
Valued Contributor

Trigger Document Reload When File Exists

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

Trigger Document Reload When File Exists

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
Valued Contributor

Re: Trigger Document Reload When File Exists

Attached is the dos batch file.

Hope it helps,

B

Not applicable

Re: Trigger Document Reload When File Exists

Hii B,

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

I m kinda new to edx functionality.

Community Browser