Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have a single node installation of QDC September_2019_SR2.
We are setting Qlik Sense integration to enable "Publish to Qlik" feature and we experience the following blocking issue.
Both QDC and QS are synchronized with our AD, but referring to the “UserID” field, QDC populate its database considering username and domain name (UserID=username@domain.local) while QS register only the username (UserID=username).
I attach screenshots from both applications (attachments 1 & 2).
Considering the above, any domain user who wants to use the “Publish to Qlik” feature, will cause the following:
As proof of the above, if I proceed by setting a specific Username for the “podium.qlik.username” entry in the “core_env.properties” file, all works properly (obviously the user must respect the format of Qlik Sense).
How is it possible to have QDC “UserID” list populated in the same format as QS “UserID” list (UserID=username) during synchronization with AD?
Which settings need to be changed?
Your suggestions will be greatly appreciated.
Regards
Bruno
Hi Bruno,
So Alex Colombo created a fix and you can add this code to any of the applist.js, createQlikApp.js and updateExistingApp.js scripts to fix your problem.
This will make sure that you only use username if its in the format of username@domain.com:
var userId = process.argv[4];
var nameParts = userId.split("@");
var userId = nameParts.length==2 ? nameParts[0] : userId;
or if you would like to deconstruct 1stname.lastname@domain.com into a lastname1stname format:
var userId = process.argv[4];
...
var dot = userId.indexOf(".");
var at = userId.indexOf("@");
var name = userId.substr(0, dot);
var lenghtSurname = at - dot - 1;
var surname = userId.substr(dot + 1, lenghtSurname);
userId = surname+name;
Does this help?
Best,
Hordy
Hi Bruno,
So Alex Colombo created a fix and you can add this code to any of the applist.js, createQlikApp.js and updateExistingApp.js scripts to fix your problem.
This will make sure that you only use username if its in the format of username@domain.com:
var userId = process.argv[4];
var nameParts = userId.split("@");
var userId = nameParts.length==2 ? nameParts[0] : userId;
or if you would like to deconstruct 1stname.lastname@domain.com into a lastname1stname format:
var userId = process.argv[4];
...
var dot = userId.indexOf(".");
var at = userId.indexOf("@");
var name = userId.substr(0, dot);
var lenghtSurname = at - dot - 1;
var surname = userId.substr(dot + 1, lenghtSurname);
userId = surname+name;
Does this help?
Best,
Hordy
Hi Hordy, Alex,
I just tried by adding your fix code of 1st scenario (QS use only username as UserID) to the createQlikApp.js
var userId = process.argv[4];
var nameParts = userId.split("@");
var userId = nameParts.length==2 ? nameParts[0] : userId;
Now the "Publish to Qlik" feature works properly!
Thanks
Regards
Hi Hordy,
could you please ask your Technical Support team to make the fix available in the next QDC release?
Obviously if it doesn't already exist in version 4.4.2 (in the Release Notes I found only the ID note n.11588 which is not so clear about it).
Thanks again!
Best regards
Bruno
Hi Bruno,
I have let the product team know and they are working on a fix to make it customer configurable.
Best,
Hordy