Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Binary Load Qliksense Models on the QSB Cloud

jsteyn
Creator
Creator

Binary Load Qliksense Models on the QSB Cloud

Being able to do Binary loads on existing QS models hosted in your platform

15 Comments
simonaubert
Partner - Specialist II
Partner - Specialist II

Hello @jsteyn 

 

I think you can do it already https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

 

I tried it a few years ago and it worked great 🙂

Best regards,

Simon

jsteyn
Creator
Creator

Hi @simonaubert 

Maybe on desktop version of sense, but not in the new QSB Cloud platform:/

simonaubert
Partner - Specialist II
Partner - Specialist II

Ah, I tried it on QS Server on premise. Didn't try on Cloud platform. 

Can I advise you to change your idea's title to something to mention it's only on cloud? 

Edit : also the label/tag

jsteyn
Creator
Creator

Done 😜

TimvB
Creator II
Creator II

Binary load is still not supported in Qlik Sense Cloud Business because:

  1. It is not possible to upload apps in the DataFiles section as the format qvf is not supported.
  2. It is not possible to call a qvf from an external cloud storage service (e.g., Drive, DropBox, etc.), because one needs to connect to the cloud service first, but the Binary load should be in the first line of the script, so that does not work either.

I would highly desire having the possibility of using binary load, as I currently create several different data models that I use for multiple front end apps. It would be time saving if I can just use a binary load instead of loading many QVDs and then dropping fields to create a datamodel without synthetic keys.

johngouws
Partner - Specialist
Partner - Specialist

Have you had any feedback on the binary load issue? I am quite desperate for a solution. Having to move the same data around four time makes no sense, when I could use binary load. 

Thank you.

CurtDaughtryBP
Contributor III
Contributor III

Is this on the roadmap?  Would love to know when this is available.

johngouws
Partner - Specialist
Partner - Specialist

As a test, I created a test folder in my Dropbox and manually copied my 'master' qvf there. In QSB I created a lib called 'Dropbox'. In the QSB app I am using "Binary lib://Dropbox/Binary_Test/Sales Manager - DEMO.qvf;" on the first row, with Exit Script directly after. 

The app does a binary load perfectly. Although it does work, it is not practical to have to copy the qvf manually every day.. 

 

JordyWegman
Partner - Master
Partner - Master

@johngouws, could you show me the code you use to get this binary working? Because as @TimN is mentioning, you need the 'Connect to' first.

Jordy

Climber

johngouws
Partner - Specialist
Partner - Specialist

Hi @JordyWegman ,

No problem. I will try my best. If it's not clear enough please get back to me. I don't know about the 'Connect first'. I only know what works for me and in this one App I use it once a month. 

Let me give you my example. I duplicate the production App, 'Sales - Manager.qvf', into my Private space. I also copy it to a specific folder in Dropbox.  I rename the version in my Private space to 'Sales_Demo_v3.qvf', for example. 

I have an existing connection to Dropbox called Dropbox. It only points to Dropbox root as I use Dropbox quite a bit.  

Dropbox.png

In 'Sales_Demo_v3.qvf' I have this in the very first line:  

“Binary lib://Dropbox/Sense_QVDs/Test/Sales Manager - XXXXXXX.qvf;

EXIT SCRIPT;”

Don’t worry about the warning in Main!! I do something strange further down the page.

Binary Script.png

To show that it works, check the time differences in these snippets.

Before Time.png

And the reload script. 

Reload.png

End Time.png

In the real world I know it worked because it scrambles certain fields so that I am able to use the App for Demo purposes. 

Scrambled.PNG

I hope this is of help, else let's continue. 

John