NPrinting Log Viewer

Colin-Albert · Dec 7, 2015 12:51:38 PM

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

Anonymous · ‎2015-12-07

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

eduardo_sommer · ‎2015-12-07

Thank you for sharing

Eduardo

Colin-Albert · ‎2015-12-11

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

Anonymous · ‎2016-02-09

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

Colin-Albert · ‎2016-04-18

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

Anonymous · ‎2016-04-20

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?

Move Comment · ‎2016-05-09

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

Colin-Albert · ‎2016-05-09

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

qlikhalmar · ‎2016-05-24

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

Colin-Albert · ‎2016-05-24

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