Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Partner
Partner

Command Execute in script

Hi expert i have a question

I create a qvw that in the script the only thing that have to do is run a bat

Execute cmd.exe /C C:\ProyectoQV\Homologacion\Bat\Copy.bat 

this bat is who copy some files to one location to other, if i run it manually the bat or if i run in qlikview works ok, but when i put in the qmc(console) and run, finish succesfull but do not copy, what could be?

thank you a lot

Fernando K.

1 Solution

Accepted Solutions
Partner
Partner

Re: Command Execute in script

Hi Enrique and Petter, i can solve the problem, but i do not why , I only change one thing:

Instead of reload and call a .bat to copy, i reload and execute the bat in the same script, and that works ok!

i dont know why, but works!

thank you both for your help

Fernando

14 Replies
ecolomer
Honored Contributor II

Re: Command Execute in script

but I guess you've already checked, check that the files are either addressed or their complete addresses

Partner
Partner

Re: Command Execute in script

Enrique, how are you?

I checked, and it is strange because if i run in the script, work perfect, but NOT running from the console(QMC)

ecolomer
Honored Contributor II

Re: Command Execute in script

well, and you?

yes, very strange

I don't have idea

I'm sorry.

Partner
Partner

Re: Command Execute in script

It is strange

this is the qvw file and the .bat

ecolomer
Honored Contributor II

Re: Command Execute in script

Haz una prueba:

utiliza xcopy en lugar de copy

Así:

xcopy C:\Calendario.txt  D:\Calendario.txt   /E /Y /I

y me dices que hace

Highlighted
Partner
Partner

Re: Command Execute in script

Enrique:

Ahora lo probe en un server mio(tal cual lo tenia) y si me anda, desde la consola y manual, el tema que ahora estoy copiando archivos locales de una carpeta a otra, el que NO me anda, estoy copiando un archivo de un server hacia otro server, entonces capaz que es un tema de seguridad y permisos pero tampoco tengo mucha idea que podra ser?

se te ocurre algo por donde pueda comenzar a mirar?

Muchas gracias como siempre!

ecolomer
Honored Contributor II

Re: Command Execute in script

Si, pudiera ser un tema de seguridad y permisos.

Prueba en copiarlo a otro sitio en el que estés seguro que tienes acceso y no hay limitaciones de seguridad y eso te dará probablemente la clave.

Suerte.

Partner
Partner

Re: Command Execute in script

Es la proxima prueba que voy a hacer, es en el cliente asi que el lunes lo probare y te comento!

Gracias Enrique, abrazo

ecolomer
Honored Contributor II

Re: Command Execute in script

Saludos, y buen fin de semana (o lo que queda de él).