Replace files from folders dynamically

[#1]

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

[buzzy996]

may be this helps,

How to automate the file transfer from FTP to Local Drive for QV

[ramoncova06]

if you are doing this from the script you will need to use the execute command and use DOS functions

How to create a batch file

[petter]

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>

[#5]

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

[petter]

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.