Qlik Sense Legacy mode

[ArturoMuñoz]

If you had loaded data from the web into QlikView then you probably know well how “for … next” loops work.

When working with Web Files frequently you need to loop through your code to load more than one URL in a single load. For example let's say I want to analyze an online publication, similar to this blog, where different authors contribute with articles. The URL is composed by a constant piece and a variable ‘http://<publicationurl>?start=1’, ‘http://<publicationurl>?start=15’ I want my script to dynamically load all the possible Urls from start=1 to start=375

In QlikView my code will look like this:

fori=1 to 375

LOAD

pageUrl,
title,
author,
Postdate,
Numberofviews,
Numberofcomments
FROM
[http://publicationurl.com?start=$(i)]
(html, codepageis 1252, embeddedlabels, tableis @1);

next;

The script execution will loop 375 times letting me capture all the post written in this particular publication. To do so I’m using a simple variable expansion in the FROM statement.

If you want to perform a similar operation in Qlik Sense you might find some difficulties due variables not expanding when dealing with Web Files in Qlik Sense. But there’s a workaround, it’s called Legacy Mode.

What's Legacy Mode?

Legacy mode is a way to force Qlik Sense to reuse old load scripts that refer to absolute or relative file paths as well as library connections, and it's just what we need in order to successfully run our example script.

In Qlik Sense Desktop, you can set standard/legacy mode in Settings.ini.

Do the following:

Open C:\Users\{user}\My Documents\Qlik\Sense\Settings.ini in a text editor.

Change StandardReload=1 to StandardReload=0.

Save the file and start Qlik Sense Desktop, which will run in legacy mode.

The available settings for StandardReload are: 1 (standard mode) 0 (legacy mode)

For instructions on how to activate the Legacy Mode in Qlik Sense server check Qlik help:

http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/LoadData/disable-standard-mod...

Please note that enabling Legacy Mode in Sense Server might have security implications in Sense Server meaning that you won't be able to manage the paths/connection strings in QMC anymore.

[TKendrick20]

It's absurd how Qlik thinks this is a "solution"

[ArturoMuñoz]

Tim, I think I didn't refer to this as a solution. The blog post try to describe what legacy mode is. As I think has been discussed in the comments, legacy mode is a 'hack' for developers to solve a particular issue with old scripts rather than a permanent solution in any way.

[#4]

Hi! I am new to this, and I found that my settings.ini file was blank. What can I do to use legacy mode?

What should be written in it? Help!

Is there another way to use the ODBC connect thing?

[ArturoMuñoz]

Hi Luz,

You don't need the legacy mode to connect to a data source via ODBC, that's native in Qlik Sense and QlikView, please make sure you check the help page.

ODBC ‒ Qlik Sense

Regards,

[#6]

When trying to use it I get the following message, any ideas?

Se ha producido el siguiente error:

CONNECTs other than LIB CONNECT are not available in this script mode

[ArturoMuñoz]

You may want to open a new thread on the general forum so anyone can help you on that. As far as I can tell it seems you are maybe trying to move the script from a QlikView app to Qlik Sense, please read how to to create new connections in Sense, again you will find that info on the help page Connect to data sources ‒ Qlik Sense

Saludos,

PS: Check out the Spanish language community group at Qlik en Español

[sbumeshqlik]

Hi Arturo,

Thanks for the post. Recently installed Qlik Sense Dekstop 3.1, I am unable to edit file Settings.ini.

[ArturoMuñoz]

Hi Srinivasaiah,

Settings.ini has changed since I wrote this post, but legacy mode can still be activated, just add a line to your Settings.ini file:

StandardReload=0

[sbumeshqlik]

Hi Arturo,

Thanks for your prompt reply. 

I inserted entries you mentioned in settings.ini file, and tried "Qlik Rest Connection" in Qlik sense it did not work.

In Qlik view it worked fine.

Rest connection code listed below.

//

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=http://www.thomas-bayer.com/sqlrest/CUSTOMER/;timeout=30;method=GET;autoDetectResponseType=true;keyG...";

Error message enclosed below.

The following error occurred:

CONNECTs other than LIB CONNECT are not available in this script mode

The error occurred here:

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=http://www.thomas-bayer.com/sqlrest/CUSTOMER/;timeout=30;method=GET;autoDetectResponseType=true;keyG..."

[sbumeshqlik]

Hi Arturo,

I inserted required entries listed below, rebooted my laptop.

[Settings 7]

StandardReload=0

OverrideScriptSecurity=1

Now I am able to execute bat files without any error.

Thanks Arturo,  for  your support.

Thanks.