topic Re: Replace files from folders dynamically in QlikView

Replace files from folders dynamically

Thu, 14 May 2015 15:31:01 GMT

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

Re: Replace files from folders dynamically

buzzy996 — Thu, 14 May 2015 15:57:22 GMT

may be this helps,

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

Re: Replace files from folders dynamically

ramoncova06 — Thu, 14 May 2015 16:02:10 GMT

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

Re: Replace files from folders dynamically

petter — Thu, 14 May 2015 16:15:11 GMT

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>

Re: Replace files from folders dynamically

Thu, 14 May 2015 16:31:43 GMT

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

Re: Replace files from folders dynamically

petter — Thu, 14 May 2015 17:48:54 GMT

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.