Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
I need .dbf to convert to .xlsx for my developing.
I had created vbscritp as converter (attached) and i tried to execute this file ( .vbs) in my script.
If i do it via QV Desctop - my .dbf will convert to .xlsx and everything is fine.
But if i try to reload this task on QV Server - my scrtipt will hang and do nothing. I generate a log. There is nothing in log : my script execute all function before function "EXECUTE cmd.exe /C "C:\QV_documents\Convert dbf\ConvertToExcel.vbs";". It isn't failed, it happens nothing.
Also i execute another app like .exe for load dbf from source on disc C and it works fine.
Could any help me?
Do you have excel installed on the server?
Can you try loggin in with the user running the qlikview services and using the QV Desktop to run the QVW and see if it works fine? You're probably getting some security pop up confirmation or something.
I had the same issue and I solved modifying the Settings.ini file. see step below:
1- Go to the directory: C:\ProgramData\QlikTech\QlikViewServer
1- Open file Settings.ini
2- Add next command: AllowExecuteCommand=1
3- On each QlikView document, inside to the script block, go to Settings tab (below) and select
Can Execute External Programs
Here you are the references: http://qlikviewcookbook.com/2016/01/authorizing-the-script-execute-statement/