Nprinting meta data

[vvvvvvizard]

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

[Lech_Miszkiewicz · Accepted solution]

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. 

[joydip_chakrabo]

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

[Lech_Miszkiewicz]

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/1335...

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-...

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.