topic Re: nprinting 17 task reload after QMC task in Qlik NPrinting

nprinting 17 task reload after QMC task

bluecarbon — Wed, 25 Sep 2019 18:40:54 GMT

Hi,

Is there a way to trigger a Nprinting 17.3 task after completion of a QVW task in QMC like it was done in Nprinting 16.

Thanks,

Rakul

Re: nprinting 17 task reload after QMC task

Lech_Miszkiewicz — Mon, 06 Nov 2017 06:42:25 GMT

sure thing.. in short here is a cascade of tasks:

Reload your app in QMC
- Create a simple small qvw file which will run right after your app is reloaded.
  - (Execute Batch)This small app will have an Execute statement in it which will trigger a batch file which will open a html file.
    - Open HTML and USE API

2 first steps can be triggered from QMC in QLikView and rest is done via APIs

Attached is HTML File which you just need to change to point to your task Id and server name.

More details here:

https://branch-blog.qlik.com/nprinting-api-for-noobs-7c1343a99ad8

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: nprinting 17 task reload after QMC task

grs_venki — Wed, 14 Mar 2018 05:25:05 GMT

Hi, Thank you for your code, However I have tested in my environment with same code and changed Task ID and Servername. But It didnt triggered the job. Could you please help me understand, Is there any other setting needs to be done prior to execute HTML code in IE 11.

-------Code I used -------

<html>
	<head>
	</head>
	<body>
	<h1>NPrinting API task starter</h1>
	<script src="jquery-1.10.1.min.js"></script>
	<script type="text/javascript">
	(function(){
	console.log("started")
	var taskIDs=[
	"232ae927-b691-412a-b0c8-68146e8ce09b"

	]


	$.ajax({
	url: 'httpS://*****:4993/api/v1/login/ntlm',
	xhrFields: {
	withCredentials: true
	}
	}).done(function(data) {
	console.log(data);

	for(var i=0;i<taskIDs.length;i++){
	$.ajax({
	type: "POST",
	url: 'httpS://*****:4993/api/v1/tasks/'+taskIDs+'/executions',
	xhrFields: {
	withCredentials: true
	}
	}).done(function(data) {
	console.log("task "+i);
	console.log(data);
	if(i==taskIDs.length)
	open(location, '_self').close();
	});
	}
	});
	})();
	<!-- open(location, '_self').close(); -->
	</script>
	</body>
	</html>

I have my credential details after the Page got opened.

Re: nprinting 17 task reload after QMC task

Lech_Miszkiewicz — Wed, 14 Mar 2018 09:00:19 GMT

Hi, It is slightly different code than mine, and you have removed some things from it (like server variable) so it is difficult to troubleshoot.

Also right now you can actualy chain/trigger tasks using REST API if you have the latest version of QlikView / Sense installed with latest REST connector:

How To Use NPrinting APIs In A Qlik Load Script

cheers

Lech

Re: nprinting 17 task reload after QMC task

grs_venki — Wed, 14 Mar 2018 12:19:01 GMT

Hi,

I have been using the same code as attached in the previous discussion. But it didnt worked out for me. So I had to change a little bit as same from https://branch-blog.qlik.com/nprinting-api-for-noobs-7c1343a99ad8?_ga=2.263725263.238280957.1520916261-218863297.1520916… screenshot had shared in the discussion. So I was referring the same and followed. By the way I am using the same code as you.

Nprinting 16.6 - I was using External event trigger to run the task from Qlikview QMC to Nprinting server (request file).

Please note - I am using Qlik Nprinting 17.6 (November 2017), IE 11.

Kindly please help me understand the problem to run the task and what steps need to be done prior to run the html batch script.

Steps I followed --> Copied your code and changed Task ID and ServerName and RUN the file. After open the file it had asked me to enter credentials details and I have entered. Then nothing is happening.

Error I found - Protocol - HTTPS, Method - POST, Result - 403, Type - text/html

---- Code Used as you and changed Server name and Task ID -------

<html>

<head>

</head>

<body>

<h1>NPrinting API task starter</h1>

(function()

{

console.log("started")

var taskIDs=

[

"2ba0201a-e3e9-4c80-9ac0-99ccaf56c8d1"

]

var serverName=

[

"frafassu883"

]

$.ajax({

url: 'httpS://'+serverName+':4993/api/v1/login/ntlm',

xhrFields: {

withCredentials: true

}

}).done(function(data) {

console.log(data);

for(var i=0;i<taskIDs.length;i++)

{

$.ajax

({

type: "POST",

url: 'httpS://'+serverName+':4993/api/v1/tasks/'+taskIDs+'/executions',

xhrFields:

{

withCredentials: true

}

}).done

(function(data)

{

console.log("task "+i);

console.log(data);

if(i==taskIDs.length)

open(location, '_self').close();

}

);

}

});

})();

</script>

</body>

</html>

Re: nprinting 17 task reload after QMC task

Lech_Miszkiewicz — Wed, 14 Mar 2018 20:37:23 GMT

Do you use HTTPS for admin console and news stand? Do you have certificates installed? Do you have permissions/access to admin console?

try login to admin console first, and then try to open this html file in another window. Just in case there is SSL error which needs to be overriden

Re: nprinting 17 task reload after QMC task

Venkatchoudary — Thu, 15 Mar 2018 20:34:35 GMT

I have faced same Issue; the code does not work in ‘IE’ Browser.
You should have Chrome to run that batch file.

Re: nprinting 17 task reload after QMC task

Venkatchoudary — Thu, 15 Mar 2018 20:42:59 GMT

Will you please share a test QVW that has triggered batch file?

Re: nprinting 17 task reload after QMC task

grs_venki — Tue, 20 Mar 2018 06:18:17 GMT

Its working now. There is a problem with Java Add on. I had installed in RDP machine and its working as expected. You should install Java add on in IE browser and check it.

Re: nprinting 17 task reload after QMC task

grs_venki — Tue, 20 Mar 2018 06:20:28 GMT

Yes, I do have HTTPS in both Console and Newsstand. I do have full sysadmin access to RDP environment. There was a problem with Java add on in IE Browser. Hence it was not working in RDP machine. Now I have installed java add on and its working fine. Thanks Lech

Re: nprinting 17 task reload after QMC task

Lech_Miszkiewicz — Tue, 20 Mar 2018 21:21:46 GMT

great - this is good news and another hint for others having issues!

cheers

Lech

Re: nprinting 17 task reload after QMC task

grs_venki — Thu, 12 Apr 2018 19:02:31 GMT

@Lech Miszkiewicz

Need your help to fix the issue. Code is perfectly working in my local desktop, However when I move the code to RDP machine which is windows server 2008 R2. Here I am getting 403 Forbidden error. I had tried multiple way of running the code in server. But so far I haven't got any idea as to what could be the main reason. As I can see certificate installed in server and its working web console and newsstand without any issue, Also I have full permission access to the box and web console. So I would like to ask you a huge favour to understand what is the main problem here to resolve the issue.

Steps I followed:

Certification Installed
No Firewall blockage
Tried running from the service account
Tried running Admin account
Allowed cookies
Added Trusted site to this URL
Tried HTTP and https
Tried server name and server name with the domain
Tried Local host and IP address

https://community.qlik.com/servlet/JiveServlet/showImage/2-1470165-199486/pastedImage_12.png

https://community.qlik.com/servlet/JiveServlet/showImage/2-1470165-199484/pastedImage_9.png

https://community.qlik.com/servlet/JiveServlet/showImage/2-1470165-199485/pastedImage_10.png

Re: nprinting 17 task reload after QMC task

Lech_Miszkiewicz — Fri, 13 Apr 2018 01:36:56 GMT

Hi,

Well the error you are getting is 403.

It clearly says in : https://help.qlik.com/en-US/nprinting/February2018/APIs/NP+API/index.html#tasksTaskIdExecutionsPost

403

The user is not authorized to create the task execution.

I think what happens is you are using a user you are logged in as when executing this POST request.

WIndows 2008R2 should work, but it is on quite old i would say.

https://help.qlik.com/en-US/nprinting/February2018/Content/DeployingQVNprinting/System-requirements_engine.htm

In overall i think the method with the HTML file was not elegant and i suggest you try RestConnector.

More details here:

How to use Qlik NPrinting APIs inside a Qlik Sense load script (This applies to QlikView too and works much better than file option)

cheers

Lech

Re: nprinting 17 task reload after QMC task

jampierre — Mon, 16 Apr 2018 14:52:01 GMT

Hi gurus,

is there a way to trigger a Nprinting 17.6 task after completion of a QVF task in QMC ?

Our version are NP17.6 and June 2017 for Sense

Thanks in advance

Best regards

Re: nprinting 17 task reload after QMC task

Lech_Miszkiewicz — Mon, 16 Apr 2018 21:56:07 GMT

‌yes

it is all i ny above post (link to how to use api in qlik script)

did you read it?

regards

lech

Re: nprinting 17 task reload after QMC task

jampierre — Tue, 17 Apr 2018 08:05:28 GMT

Hi Lech,

thanks of your reply.

Yes I read it your post.

I was only wondering if I use QlikSense and not Qlikview I can use the same method you described in the post above

Thanks a lot

Re: nprinting 17 task reload after QMC task

jampierre — Tue, 17 Apr 2018 08:27:02 GMT

Hi Lech,

Zhu Wuzhong's post open my eyes thanks to you

Thanks a lot

Re: nprinting 17 task reload after QMC task

grs_venki — Tue, 17 Apr 2018 08:28:24 GMT

Hi,

This method can be used in both Qlikview QMC and Qliksense environment. Basically you need to create a batch script to call the HTML file and then you need to setup this batch script in your external event to trigger.

Note - This method can be utilized only if you have Nprinting 17 with full administrator access.

Hope this will help you.

Thanks

Venki

Re: nprinting 17 task reload after QMC task

grs_venki — Tue, 17 Apr 2018 08:33:35 GMT

Hi,

We have installed Nprinting 18.0 Feb 2018 version. Hope my issue will shorted out. Otherwise I am planning to change Windows Server 2012 R2.

Note - I have installed postman to check the connection. But still I am getting 403 Forbidden error.

Re: nprinting 17 task reload after QMC task

jampierre — Tue, 17 Apr 2018 08:49:54 GMT

Thanks Venki,

We have full installation of NPrinting with administrator access.

We'll try that way

Regards