Automatic Reload Script

[#1]

Hi,

This is just a simply question.

I take data from an ERP system to run a Qlickview file. But, how can I automaticly reload the script every time the user opens the file?

I mean, without using the upper botton to reload. And even more...how can I make to reload it every 60 mins?

Thanks in advance.

Sitopons.

[#2]

Hi sitopons,

As per my knowledge you can do like.

Normal 0 false false false MicrosoftInternetExplorer4

1) Scheduling

2) Write macro "ActiveDocument.Reload()" and document properties on triggers Tab select onopen and assign that trigger.

Regards,

Ravi...

Normal 0 false false false MicrosoftInternetExplorer4

[#3]

hi sitopons,

in tools-edit module

   write

     sub autoreload

           activeDocument.reload

     end sub 

then

clike ok

after that in

Setting - Document Properties - On Open - Add actions - External - Run Macro -

enter your macro name

in this case is autoreload

save your doc and reopen

[Emmanuelle__Bustos]

Thanks a lot hamide.gh it works for me!!!   but just one correction in Document properties you have to go to "Triggers" instead of "On Open".

Regards

[#5]

Hi Hamide,

I had the similar requirement to refresh the data from a MS access DB ( I am using ODBC in reload script as below). The above steps does not run or Am I missing something ?

ODBC CONNECT TO [QV_DSN;DBQ=Z:\IDLM\Dev\Sample\IDLM Database v0.5 Oct01.accdb];
SQL SELECT * FROM Currentdata;
I am connecting current data to the dashboard and wanted to get it refreshed as the table changes. Could you please help ?

[#6]

Hello,

It worked..i had to turn off the webview.

thanks