topic Re: Nprinting meta data in Qlik NPrinting

Nprinting meta data

vvvvvvizard — Fri, 10 Jul 2020 09:01:38 GMT

Is it possible for all our nprinting reports , for each report , who are the users , the filters being applied , and any other type of data like object id's used ect

Is there a Nprinting log file to see why our reports failed and some sort of log reader to pull in that data

Re: Nprinting meta data

Lech_Miszkiewicz — Fri, 10 Jul 2020 10:41:11 GMT

Answer to Your first question is yes-there is a way but You need to build the tool by yourself using not supported approach by

either connecting to postgres db and building some sort of qliksense/qlikview app which will visualise this information
or using npm api endpoints (Via rest connector) (Which is the same Api we use when using nprinting admin console). This api is not documented, but you can get all endpoints by inspecting call made in web browser development tool

both methods are possible but are not developed and you may need to spend a lot of time building design/data model which would allow you to see what you need.

regarding your second question - there is engine log. Location of log files are listed on https://help.qlik.com

log files use GUID references for objects, so to understand them you may need to use information from postgres db or npm api in conjunction with logs to have full picture.

You may need to change log level (info, debug etc) to get info you require

logs will not always give you direct answer why reports are failing. As an example there can be a filter based on multiple fields. Error may say that filer could not be applied, but it will not exactly tell you which field cannot be applied.

Re: Nprinting meta data

joydip_chakrabo — Sun, 19 Jul 2020 06:56:16 GMT

Hi @Lech_Miszkiewicz

Thanks for the information as I'm also looking for the same.

Also, I've few queries regarding this topic.

1) I found the pgsql folder under the path - "C:\Program Files\NPrintingServer\pgsql". Can you please confirm if all the meta data are available under this path. If not, can you please mention the correct path.
2) Can you please let us know the exact folder name and the DB file names where I can find the meta data information.

Thanks in advance,

Joydip

Re: Nprinting meta data

Lech_Miszkiewicz — Sun, 19 Jul 2020 23:29:07 GMT

Hi @joydip_chakrabo

1) I found the pgsql folder under the path - "C:\Program Files\NPrintingServer\pgsql". Can you please confirm if all the meta data are available under this path. If not, can you please mention the correct path.

Answer: Sorry but I cannot answer your questions simply because this question is not correct. We are not talking here about files. We are talking about PostgreSQL database, so I cannot point you to a path. Instead you should be creating Postgres ODBC connection to a NPrinting server using either connector and tools like Qlik Sense or PGAdmin tool. More general info on PostgreSQLhere: https://www.postgresql.org/

Connections details to NPrinting repository (using Qlik Sense) can be found here: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPrinting-Repository-Database-Name/m-p/1335193

Connecting to NPrinting repository (Postgres DB) from other server requires more changes - details here: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-connect-to-postgresql-database-from-another-server/m-p/1690365#M28506

It seems you dont have the overall picture of how it all works together. Therefore I strongly suggest you ask someone who has an experience with it. It is easy to break and corrupt your repository and you should be comfortable with what you do with it.

2) Can you please let us know the exact folder name and the DB file names where I can find the meta data information

ANSWER: Sorry I cannot as it is not a folder with files. It is database. Once you create connection to it as mentioned above, you can than browse tables which do contain all metadata information.