Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

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.
mishrasid
New Contributor II

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

Re: File based EDX reload trigger

Please follow step by step process on the blog.

Please post if you have issues.

MVP
MVP

Re: File based EDX reload trigger

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

MVP
MVP

Re: File based EDX reload trigger

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

Community Browser