topic Re: How to Encrypt file name while downloading from Server? in QlikView

How to Encrypt file name while downloading from Server?

psankepalli — Fri, 20 Nov 2015 21:43:23 GMT

Hello Experts,

I have a Powerpoint file in server , File name is ABC.pptx. I am downloading this file from Access Point.

In QVW -> Button -> Properties -> Action -> Open url .

This Open URL pointing to the ABC.pptx file.

When I download this file its downloading with the Actual name (ABC.pptx), which I don't want. I want file name should be some dynamic encrypted name . How to achieve this?

Thanks

Kesav

Re: How to Encrypt file name while downloading from Server?

petter — Fri, 20 Nov 2015 23:19:19 GMT

Where is the file residing? Does your load script have the rights to rename the files. If it does you could rename the regular file names during the load script execution by using Hash256()-function and turn that into a valid URL.

Re: How to Encrypt file name while downloading from Server?

psankepalli — Sat, 21 Nov 2015 01:12:49 GMT

Hi Petter,

Thanks for your reply.

This file is residing in Virtual folder at server where QMC installed. I am not using any script for this file. we have all the rights to Virtual folder. how to rename this file while sownloading?

Thanks

Kesav

Re: How to Encrypt file name while downloading from Server?

rwunderlich — Sat, 21 Nov 2015 04:59:41 GMT

Are you using IIS for your web server?

-Rob

Re: How to Encrypt file name while downloading from Server?

petter — Sat, 21 Nov 2015 07:53:45 GMT

As I see it you have two options:

1) Rename the original files into something new that satisfy your requirements in hiding the original filename

Your load script could rename the orginal filenames in a loop and make all references to these renamed files which would work without a whole lot of effort. I did this for a customers extranet-site running the QlikView Extranet Server and it works perfectly well.

2) Dynamically renaming - that is what is called URL-rewriting and requires that you use Microsoft Internet Information Server (IIS) to be the replacement of the QlikView WebServer (which is default). On installation your QlikView server environement can use IIS. Then you can write an ISAPI-filter to do the dynamic renaming (URL-rewriting). If you have never done it it is not trivial. Google "URL-rewriting IIS asp.net" and you find links explaining everything you need to do.

Re: How to Encrypt file name while downloading from Server?

petter — Sat, 21 Nov 2015 09:55:10 GMT

Maybe this could be of help to you - depending on your approach:

Re: How to Encrypt file name while downloading from Server?

psankepalli — Sat, 21 Nov 2015 12:28:11 GMT

Hi Rob,

Yes I am using IIS Server.

Thanks

Kesav

Re: How to Encrypt file name while downloading from Server?

psankepalli — Sun, 22 Nov 2015 19:48:11 GMT

Hi Petter,

Thank you for your answer. this is very informative.

I am able to encrypt file name. Here I am facing challenges

How do I pass this encrypted file name to Button -> Action -> OpenURL.

Please help me

Thanks

Re: How to Encrypt file name while downloading from Server?

psankepalli — Sun, 22 Nov 2015 20:41:16 GMT

Hi Petter,

I am able to pass variable at Open URL. I can see the encrypted file name at URL. but file is not downloading. do I need to follow any steps here? Please advise.

Thanks

Re: How to Encrypt file name while downloading from Server?

petter — Mon, 23 Nov 2015 04:34:55 GMT

What do you mean by "encrypt file name"? Where do you change the file name - it must be done either at the file level - on your file system (or with URL-rewriting in IIS). You can't just "rename" your files in the front end. The information I sent was meant as a concept to test out a way of how to get a new name for an existing file name. To implement this approach you will have to do the same thing in the load script.