topic Re: Text File no download after reload (Automatically) in QlikView

Text File no download after reload (Automatically)

pgalvezt — Fri, 20 Jun 2014 18:17:54 GMT

Hello,

I have a macro that download an txt file (Works Fine) when I do clic (open Qlikview and after reload the txt file apperas on the specific folder that I have created).

But I have to do this in automatic way, so I created a .bat that reload automatically the qlikview file. But the macro it seems not working.

This is my .bat

@echo off

cd C:\Server Qlikview\Desarrollo\qv_prod

echo Actualizando Datos

"C:\Program Files (x86)\QlikView\qv.exe" /r reload_file.qvw

What I have to do for that the macro run?

It can download a txt file with .bat?

Thanks!

Re: Text File no download after reload (Automatically)

whiteline — Sun, 22 Jun 2014 18:08:40 GMT

Hi.

You can try to add /NoSecurity parameter to force the module security.

Re: Text File no download after reload (Automatically)

pgalvezt — Mon, 23 Jun 2014 13:19:20 GMT

Hi, You mean this? If so, Its not working.

Re: Text File no download after reload (Automatically)

whiteline — Mon, 23 Jun 2014 15:09:59 GMT

No, Macro module security.

And I mean to add it to the command line.

Re: Text File no download after reload (Automatically)

pgalvezt — Mon, 23 Jun 2014 15:42:00 GMT

Hi, can you send me how would be that line? or an example please.

This is my macro:

sub Descarga

'ActiveDocument.ClearAll true

set PR = ActiveDocument.GetSheetObject("CH04")

set PR1 = ActiveDocument.GetSheetObject("CH122")

fecha = Date

anio = Year(fecha)

mes = Month(fecha)

'dia = Day(fecha)

dia = datepart("d",fecha)

'ActiveDocument.ClearAll false

ActiveDocument.Fields("fecha").Select anio & mes & dia

PR.Export "C:\Pro\Valorización_" & anio & "-" & mes & "-" & dia & ".txt", ";"

PR1.Export "C:\Pro\Comparación_" & anio & "-" & mes & "-" & dia & ".txt", ";"

'ActiveDocument.ClearAll false

end sub

Thanks!

Re: Text File no download after reload (Automatically)

whiteline — Mon, 23 Jun 2014 17:08:07 GMT

"C:\Program Files (x86)\QlikView\qv.exe" /r /NoSecurity reload_file.qvw

Re: Text File no download after reload (Automatically)

pgalvezt — Mon, 23 Jun 2014 18:14:01 GMT

Hi, this is my .bat file

@echo off

cd C:\Server Qlikview\Desarrollo\qv_prod

echo Actualizando Datos

"C:\Program Files (x86)\QlikView\qv.exe" /r /NoSecurity reload_file.qvw

But is not working,

Re: Text File no download after reload (Automatically)

whiteline — Mon, 23 Jun 2014 18:30:02 GMT

cd "C:\Server Qlikview\Desarrollo\qv_prod"

Re: Text File no download after reload (Automatically)

pgalvezt — Mon, 23 Jun 2014 18:41:41 GMT

cd already exist on the script.

Re: Text File no download after reload (Automatically)

pgalvezt — Mon, 23 Jun 2014 18:49:45 GMT

I have a .bat that calls another qlikview

(

@echo off

cd C:\Server Qlikview\Desarrollo\qv_prod

echo Actualizando Datos

"C:\Program Files (x86)\QlikView\qv.exe" /r /NoSecurity reload_file.qvw)

called reload_b... Inside reload_b I have a buttom that contain a macro as follow:

sub Recargar

set App = ActiveDocument.GetApplication

set myDoc = App.OpenDoc ("Folder\file_qvw.qvw","user","pass")

myDoc.Reload

myDoc.Save

myDoc.CloseDoc

set myDoc = nothing

set App = nothing

end sub

Maybe here is the problem?

Re: Text File no download after reload (Automatically)

whiteline — Mon, 23 Jun 2014 18:50:24 GMT

The quotes. You have to use the quotes as the path contains space symbol.

You'd better to check the qv.exe execution directly from command prompt and then place it into bat file.

Re: Text File no download after reload (Automatically)

pgalvezt — Mon, 23 Jun 2014 19:05:35 GMT

.bat execute the other Qlikview ...everything good during the reload. The problem is the files no thrown in the folder. When I do clic in reload manual way the files .txt appears into the folder. simply it cant... when I try to thrown the files throught of the .bat

Re: Text File no download after reload (Automatically)

whiteline — Mon, 23 Jun 2014 19:12:43 GMT

Sorry, looks like you have to describe the whole chain.

I'm a little bit stuck about what is working and what is not.

Re: Text File no download after reload (Automatically)

pgalvezt — Mon, 23 Jun 2014 19:45:48 GMT

OK,

I have a qlikview called test ok?

inside test I have a macro that thrown files .txt.

When I reload manually this qlikview thrown the files (No problem until now ok?)

But I have to do this automatically.

So I created 2 files:

First file:

a Qlikview called reload_1 that contain a buttom that reload the test qlikview. ok?

sub Recargar

set App = ActiveDocument.GetApplication

set myDoc = App.OpenDoc ("Folder\file_qvw.qvw","user","pass")

myDoc.Reload

myDoc.Save

myDoc.CloseDoc

set myDoc = nothing

set App = nothing

end sub

Finally I have a .bat called reload_1 that execute reload_1_

@echo off

cd C:\Server Qlikview\Desarrollo\qv_prod

echo Actualizando Datos

"C:\Program Files (x86)\QlikView\qv.exe" /r /NoSecurity reload_file.qvw)

But in those steps qlikview is not thrown the txt files.

any hesitate just let me know.

Re: Text File no download after reload (Automatically)

whiteline — Tue, 24 Jun 2014 12:26:17 GMT

Ok.

Now before we start to investigate why the reload macro isn't working, have you tried to reload the first qvw file (test) directly from command line or bat file ?

I don't understand the reason for creating the second reload_1 qvw.

Re: Text File no download after reload (Automatically)

pgalvezt — Tue, 24 Jun 2014 13:41:50 GMT

have you tried to reload the first qvw file (test) directly from command line or bat file ?

Yes, but qlikview asking me for user and pass. (how is the code in the .bat for user and pass directly)?

(I think is the only way because directly qlikview thrown the txt files)

I don't understand the reason for creating the second reload_1 qvw.

The reason is because I reload many qlikview at time (20 qlikview more or less)

/message/554853?et=watches.email.thread

Re: Text File no download after reload (Automatically)

pgalvezt — Tue, 24 Jun 2014 15:08:17 GMT

Can I use

"C:\Program Files (x86)\QlikView\qv.exe" /r /USERID= user /NoSecurity reload_file.qvw)?

Re: Text File no download after reload (Automatically)

whiteline — Tue, 24 Jun 2014 15:11:43 GMT

Yes. That's what I'm talking about.

Re: Text File no download after reload (Automatically)

pgalvezt — Tue, 24 Jun 2014 15:21:31 GMT

Dou you know how is the sintaxys to open a Qlikview document within user and pass.

Appears: Unknown command line option /USERID="admin"

Re: Text File no download after reload (Automatically)

whiteline — Tue, 24 Jun 2014 16:13:26 GMT

If you use NT credentails in Section access, you don't have to pass the user.

Otherewise, I don't know how to do that. There are some threads in the community about that.

Consider to use triggered EDX event on server.

You can trigger it with the command line (QMSEDX.exe) and pass the credentails.