Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have a requirement where excel files will be placed in a source folder dynamically.
We need to pick the excel file dynamically and place the files in destination folder. The excel should generate a QVD file and then load to QlikView dynamically.
Please let me know for any help.
Thanks,
Sai
may be this helps,
How to automate the file transfer from FTP to Local Drive for QV
if you are doing this from the script you will need to use the execute command and use DOS functions
What kind of QlikView environment will this be? A QlikView Server or is it just QlikView Desktop?
You can use the function called Windows FileSystemWatcher to be able to detect new files in a folder and move them to a destination folder. The same script (VBS or PowerShell) could trigger a reload for instance with
qv.exe /r ReloadExcelFileAndCreateQVD.qvx /vExcelFile=<your-excel-filename>
Hi Petter,
We have Server, Publisher and Desktop. The solution which you are proposing looks the answer for my question. Can I get details on the procedure or the code to detect the file which will be placed in a folder and move to destination. once, the files are moved to destination, we need to convert to a QVD file that should be reloaded to the qlikview document.
Please provide me with the steps. Thanks so much for your help.
Thanks,
Sai
The VBScript that can be executed to start the FileSystemWatcher routine basically could look like this:
It will need to do something extra in between line 32 and line 33 to execute either qv.exe or to start qmsedx.exe to tell QlikView Publisher to start a task which will do the reload.