article NPrinting Log Viewer in Member Articles

NPrinting Log Viewer

Colin-Albert — Mon, 07 Dec 2015 17:51:38 GMT

Attached is a QlikView app to analyse the log files generated by NPrinting v16.

Note -The attached App requires a QlikView desktop licence to open and is not compatible with Personal Edition.

The app has been purged of all data, so you will need to set the location of your NPrinting log files on the Configuration tab and then reload your data into the app for it to work.

The Event List box is generated by parsing the message text through a series of wildmatch() expressions in the load script to categorise the entries in the log file. You can modify the script to add further Event categories.

The text objects above the main chart have Actions which set various filters to select the range of events and dates.

The Source filter allows you to select logs generated by service events or logs generated from the NP Desktop app.

Version2 now includes the Parent Schedule, Message Type and additional charts.

This app is a "work in progress" but has proved useful in checking the NPrinting tasks we use internally and on our customer sites.

Hopefully you will also find this useful.

Regards

Colin

Re: NPrinting Log Viewer

Anonymous — Mon, 07 Dec 2015 19:09:48 GMT

Howdy Colin,

Well, this is definitely an improvement over my last effort to view this information, which was to painfully parse this is in Excel. I especially like your event filter and the fact that it brought all of the logs in from the directory. Nice to have them all collated together. Might be nice to have some ability to see total time of execution or average time to complete tasks. I can definitely see this as something I will use. Thanks for your efforts and I look forward to seeing future versions

Re: NPrinting Log Viewer

eduardo_sommer — Tue, 08 Dec 2015 02:13:01 GMT

Thank you for sharing

Eduardo

Re: NPrinting Log Viewer

Colin-Albert — Fri, 11 Dec 2015 13:23:52 GMT

Version2 now includes the Parent Schedule, Message Type and additional charts.

Re: NPrinting Log Viewer

Anonymous — Tue, 09 Feb 2016 20:40:17 GMT

Colin,

Can you take a look at this thread?

NPrint queue

You were able to create your app by looking at the log file. Is there any way to also display in a QVW, the status of On-Demand requests?

You seem to be pretty savvy with this program behind the scenes.

Thanks in advance,

Mike

Re: NPrinting Log Viewer

Colin-Albert — Mon, 18 Apr 2016 10:44:16 GMT

Giving this a bump as it does not appear in search results.

Re: NPrinting Log Viewer

Anonymous — Wed, 20 Apr 2016 15:56:30 GMT

Colin,

Got an offline question for you. Can you follow me so that I can send a message to you?

Are you going to Qonnections?

Re: NPrinting Log Viewer

Mon, 09 May 2016 13:28:39 GMT

Hi Colin,

I really enjoy ths application since it gives great understanding of what really has been sent and what have not. I would like to make it so that I only read lastweeks logfiles. how would you do that?

cheers

Re: NPrinting Log Viewer

Colin-Albert — Mon, 09 May 2016 17:00:12 GMT

Hi Niklas,

Glad you find it useful.

If you add this where clause to the load script, you can set the script to load the last N months data into the final data model.

...

resident tmpLogs

where Dated >= addmonths(today(), -3) //just load last 3 months data

All log files are initially loaded, so you could create a mask on the initial load to filter old logs,

or simply delete the old log files from the NPrinting logs folder if they are no longer required.

Cheers

Colin

Re: NPrinting Log Viewer

qlikhalmar — Tue, 24 May 2016 10:29:59 GMT

Hi Colin,

I am using Nprinting 17.

In our logfiles we have no headerrow and no delimiter.

Do you know how I can solve this?

Thanks in advance!

Halmar

Re: NPrinting Log Viewer

Colin-Albert — Tue, 24 May 2016 16:06:45 GMT

Hi Halmar,

I have not had a chance to look at log files from NP17.

Are you able to post a sample log?

Thanks

Colin

Re: NPrinting Log Viewer

dgreenberg — Wed, 25 May 2016 18:53:09 GMT

Thank you - looks very useful

Re: NPrinting Log Viewer

psankepalli — Thu, 26 May 2016 02:44:54 GMT

Thank you for sharing this info.

Re: NPrinting Log Viewer

Emmanuelle__Bustos — Thu, 26 May 2016 15:07:00 GMT

Nice!! Thanks for sharing.

Re: NPrinting Log Viewer

Wed, 01 Jun 2016 11:09:40 GMT

Thanks for sharing!

Re: NPrinting Log Viewer

Anonymous — Fri, 26 Aug 2016 11:32:27 GMT

Hi Colin,

I have put this log viewer in place on my dev server. After using it, It would be helpful to have the name of the NSQ file that is referenced on each relevant line of the log. That would enable review of all occurrences of that nsq activity over time. Just wondering if you have done any more enhancements on this tool in the last couple months before I pursue updating it on my end.

Re: NPrinting Log Viewer

Colin-Albert — Fri, 26 Aug 2016 14:52:50 GMT

Hi Mike,

I haven't done any more updates to the log viewer at present.

Adding the NSQ could be done in a similar way to the parent schedule in the load script.

Cheers.

Colin

Re: NPrinting Log Viewer

Anonymous — Fri, 26 Aug 2016 15:02:31 GMT

Colin,

Thanks for the reply. I see the logic for the parent schedule and plan to add NSQ and Task in the same manner. so that I can filter on these dimensions as well. Just wanted to make sure someone else had not already improved the app before I invested the time.

This will be a nice tool with a few minor tweaks. Lifting a cold one in your honor!

Mike

Re: NPrinting Log Viewer

Colin-Albert — Fri, 26 Aug 2016 15:06:32 GMT

Send me a copy when it's done and I'll update the document - with due credit of course 🙂

Re: NPrinting Log Viewer

Emmanuelle__Bustos — Fri, 02 Sep 2016 00:02:09 GMT

Hi will we have this tool for Nprinting 17.1?