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: 
Anonymous
Not applicable

File based EDX reload trigger

I am trying to schedule a series of qvws in QMC (have Publisher license) based on the presence and/or update date of a particular file on the server (sent by an external ETL process).

I was wondering if anyone has defined a file based EDX reload trigger in the past and had sample code they could share?

I've gone through these posts:Using EDX in QlikView 11

EDX in QlikView: What are, what for and how it does ? | QlikView Help, Tips & Hints

but being relatively new to EDX wanted to see if anyone has an easy to follow example for setting up a reload based on a file event.

Any inputs are greatly appreciated, thanks in advance.

3 Replies
Not applicable
Author

Please follow step by step process on the blog.

Please post if you have issues.

petter
Partner - Champion III
Partner - Champion III

This is not a complete solution but might give you a hint about how you can use PowerShell to use the .NET System.IO.FileSystemWatcher:

You have to enable the account running this to execute PowerShell scripts.

$Watcher = New-Object System.IO.FileSystemWatcher

$Watcher.Path = "D:\EDX_Files"

$Watcher.Filter = "dothis.txt"

$Watcher.NotifyFilter = [IO.NotifyFilters]"FileName"

$Watcher.IncludeSubdirectories = $False

$SomeAction = { QMSEDX.exe .........; ri dothis.txt  }

Register-ObjectEvent -InputObject $Watcher -EventName "Created" -Action $SomeAction

petter
Partner - Champion III
Partner - Champion III

I might come back with a more complete explanation tomorrow - getting quite late for me now and I need some sleep...