Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please follow step by step process on the blog.
Please post if you have issues.
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
I might come back with a more complete explanation tomorrow - getting quite late for me now and I need some sleep...