Qlik Community

Qlik NPrinting Documents

Documents related to Qlik NPrinting.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER

Extracting Data from NPrinting 16 NSQ file for conversion to NP17

Contributor III
Contributor III

Extracting Data from NPrinting 16 NSQ file for conversion to NP17

I have received multiple requests for some functionality that allows us to seamlessly convert from NP16 to NP17. Due to the very different nature of the repositories between the two versions it seems that there is unlikely to be a 'one click' solution to moving across. However, I have experimented with reading some of the data out of an NSQ file, such as users, groups and filters so that we can make use of the import functionality in v17 to streamline a move across. This import functionality is covered at the following link at help.qlik.com‌. If you're using a version later than 17.2 then be sure to update that in the top right hand corner.

So, how will this post help?

The following steps will allow you to extract the following from your NSQ project files (you'll know what these are if you're using NP16):

     - users

     - filters

     - groups

These outputs can then be used to help populate (with some manual changes) the import file as identified above. It is still a manual process but this will save a lot of time in compiling the lists of users, groups and filters that are in your complicated NSQ files.

Steps to get it working...

  1. Make a copy of your NSQ file (VERY IMPORTANT!!)
  2. Change the document extension on the file from '.nsq' to '.xml'
  3. Open in a text editor (I used notepad++ in this example screenshot)
    • Delete text and characters on first line to leave only this:     <?xml version="1.0" encoding="UTF-8"?>
    • save this file.
    • xml change.jpg
  4. Download the QlikView file attached to this post
  5. Edit the QlikView file for the following... (unfortunately this is quite manual and is possibly the reason there isn't a more global approach).
    • in edit script on the Main tab, update the vFileLocation variable in the script with your file location and name (your XML file that is).
    • On the Original XML tab (Note this is after the [>>>> EXIT SCRIPT <<<<] tab on purpose), review the content as to how the keys in this Original XML have been used in the 'NSQ as XML' tab.

Original XML.jpg

    • These key references will need to be updated as those in your NSQ file will be different
    • Create a new tab again after the [>>>> EXIT SCRIPT <<<<] tab and load in the data from your XML file.

XML Orginal Load.jpg00

    • The table structure will be the same but the key field labels may not be. You will need to manually update the [NSQ to XML] tab with the new references where necessary (there are not that many so it should only take a few minutes).

NSQ to XML key.jpg

    • Please note there is an unusual join in the L4 tables that I have coded around to ensure we could get the filters information.

Okay... Now you're ready to reload, review the data in QlikView and export to Excel to help populate the import file.

Hope this helps and feel free to offer suggestions for improvements as this was a quick hack to get the information I needed.

Labels (1)

Very useful Post

Initially I have been trying to convert NP 16 NSQ file to NP17. But No Luck. Now i can use this post.




Hi Richard,

Thanks for your post.

Is it possible to get task and schedule information from a NSQ file?


Contributor III
Contributor III

Hi, I did not explore this as there is no way to import this into NP17. The users, groups and filters can be imported through the import task area. The last tab of the QliKView file example has a sheet where you can browse tasks and schedules from the data. This may provide you with a checklist, or a way of collating the data, where you have many different tasks.

Contributor III
Contributor III

I am trying to figure this out; how do I find what my key class and key properties are?

Version history
Revision #:
1 of 1
Last update:
‎2016-10-07 06:31 AM
Updated by: