topic Re: Base64 decode in Sense? in App Development

How to Base64 decode a string in Sense?

Anders_Eriksson — Wed, 14 Jun 2023 18:37:17 GMT

Have the need to decode a Base64 string in Sense OnPremise, how can I do that?

Re: Base64 decode in Sense?

vinieme12 — Thu, 13 Oct 2022 01:37:09 GMT

Refer this article

https://community.qlik.com/t5/Official-Support-Articles/How-to-read-images-from-a-database-and-display-in-Qlik-Sense-and/ta-p/1711247

Re: Base64 decode in Sense?

Anders_Eriksson — Fri, 14 Oct 2022 08:32:23 GMT

Thanks but I'm not loading an image to show in Sense, I'm loading data encoded in Base64 and need to decode that data!

Re: Base64 decode in Sense?

vinieme12 — Mon, 17 Oct 2022 01:33:58 GMT

refer page 6 of the below document attached in the article

Re: Base64 decode in Sense?

Anders_Eriksson — Mon, 17 Oct 2022 07:36:15 GMT

@vinieme12 as I said above I'm NOT loading an image!

Re: Base64 decode in Sense?

Anders_Eriksson — Mon, 17 Oct 2022 07:37:37 GMT

Implemented my own Base64 decoding in Qlik Sense.
It is slow but it works for my case, got the data I needed decoded.

Re: Base64 decode in Sense?

Huberto — Thu, 20 Apr 2023 15:08:17 GMT

Hi @Anders_Eriksson,

Could you kindly share the solution you implemented for this problem?

Thanks in advance.

Regards,

Huberto Pereira Haideman

Re: Base64 decode in Sense?

Anders_Eriksson — Wed, 17 May 2023 09:16:24 GMT

@Huberto just noticed your question and don't know if it is still valid (not had time for the forum for some while).
My solution was using Qlik Script to translate Base64 text but very slow and with increasing data it was no longer valid. Changed to a different solution involving things available in Windows.
Not the prettiest solution but it works for my case.

1) save the Base64 string to a text file: path\Base64.utf
2) that file is UTF encoded by Qlik but I need it to be ASCII for the Windows decoding!
Thus I run the Powershell command: Get-Content path\Base64.utf | Set-Content path\Base64.txt -Encoding Ascii
3) to decode the Base64 Ascii file i run Windows command;
certutil -decode -f path\Base64.txt path\Decoded.csv
4) now I can use Decoded.csv in Qlik Sense like any other csv-file

Wanted to run these commands from inside Qlik Script with exec command but that would not work.
Instead I configured it as a Scheduled Windows Task to coincide with my Qlik Tasks.
Doing this at night I have no timing issues with the tasks as I can leave margins between.

Hope this helps.

Re: How to Base64 decode a string in Sense?

Alan_Slaughter — Wed, 14 Jun 2023 18:38:26 GMT

Maybe this could help with the decoding:

https://www.base64decode.org/

Re: Base64 decode in Sense?

Huberto — Tue, 11 Jul 2023 08:24:16 GMT

Thanks for taking the time to reply to my question, @Anders_Eriksson.

Regards,

Huberto Pereira Haideman