topic Pulling in .qvs external script with Must_include statement via FTP in QlikView

Pulling in .qvs external script with Must_include statement via FTP

ingoniclas — Wed, 15 Jul 2015 09:24:11 GMT

Hi there,

I tried to pull in a .qvs file (external script) into QV with a Must_Include statement via FTP:

$(Must_Include=ftp://[USERNAME]:[PASSWORD]@[FT SERVER]/scripts/configuration.qvs);

But it didn't work, and I only get an error message showing the above statement. When I pull in the statement from a local folder it works well. Any ideas what could be wrong?

Thanks,
Ingo

Re: Pulling in .qvs external script with Must_include statement via FTP

Wed, 15 Jul 2015 18:35:56 GMT

what is the reason trying to connect through ftp?

Just create file share on the source server & create the UNC path. try like below:

$(Must_Include=\\qlikserver\scripts\configuration.qvs);

Re: Pulling in .qvs external script with Must_include statement via FTP

ingoniclas — Wed, 15 Jul 2015 20:00:55 GMT

The user uses a single user license (no server), and I don't want to store the qvs file on the user's hard drive.

Re: Pulling in .qvs external script with Must_include statement via FTP

J_Glock — Fri, 09 Jul 2021 09:23:48 GMT

Hey @ingoniclas

I'd like to include some scripts via FTP as well. Did you find any solution?

Thanks,

Julius

Re: Pulling in .qvs external script with Must_include statement via FTP

ingoniclas — Fri, 09 Jul 2021 09:37:26 GMT

Nope 😞

Re: Pulling in .qvs external script with Must_include statement via FTP

marcus_sommer — Fri, 09 Jul 2021 17:02:14 GMT

Could you load the qvs as file? If yes you verified that the path correct is and that the user/password is valide and has the proper reading-rights. If not anything of above mentioned is wrong and/or it might be blocked from any security tool or group policies - for examples the ports are restricted.

Another possibility might be the access mode - see:

Solved: Load from FTP fails in QlikView Server - Qlik Community - 599160

- Marcus

Re: Pulling in .qvs external script with Must_include statement via FTP

J_Glock — Thu, 15 Jul 2021 14:24:57 GMT

Hey @marcus_sommer ,

thanks a bunch! It actually worked as long as I use a simple FTP-Server. Unfortunately, We use a FTPS-Server which Qlik cannot connect to.

Right now, I've got another method: We encrypt QVS-files using a Jscript module and download the encrypted files on our clients' server. There we got a decrypt module so that we can save the decrypted script in a variable.
That's where a new problem has arisen. Namely, I don't know how to properly execute the decrypted script.

Re: Pulling in .qvs external script with Must_include statement via FTP

marcus_sommer — Thu, 15 Jul 2021 15:15:05 GMT

Like above mentioned it may be just a security measure like not available ports which cause the issue. Most companies prohibit everything unless it's specially permitted. Therefore try to check this:

FTPS Ports and FTP Ports - types and differences (cerberusftp.com)

maybe with telnet or similar tools: Telnet - Wikipedia as a starting point.

Beside this I think the encryption/decryption approach goes rather in the wrong direction and creates more problems as it solved. Are you sure that the content is so high confidential that it must be extra encrypted? And if yes, how strong must the encryption be - for just preventing a quick glance on it you may apply a small shift/mix-logic directly in Qlik (of course the experienced guys with too much time could hack it - but are they really a real risk in your scenario?).

- Marcus

Re: Pulling in .qvs external script with Must_include statement via FTP

marcus_sommer — Thu, 15 Jul 2021 16:58:14 GMT

Just an addition - within the document properties in tab general is in the top right a setting to enable a passive ftp sematic - maybe it's relevant ...

- Marcus