Qlik Community

Qlik Sense Enterprise Documents

Documents for Qlik Sense related information.

Import Nprinting Users from Active Directory automatically

erikadvectas
Valued Contributor

Import Nprinting Users from Active Directory automatically

Hi!

As Nprinting doesn't have an Active Directory connection it is required to import users manually through the "Import Users" interface. As referenced on the help site https://help.qlik.com/en-US/nprinting/Content/Recipients&Users/ImportUsersFiltersGroups/Import-Users... you can create an Excel-file to import the users.

Attached is a PowerShell script and a Windows Task Scheduler template that allows you to automate this every day. It is based on other functions/modules in PowerShell but optimized for Nprinting.

The PowerShell script is started through Windows Task Scheduler. It then imports the users automatically from the AD and outputs them to an Excel file, which then Nprinting can import

You can then in Nprinting create a scheduled Import Task to import the users every day.

Notes:

  • Doesn't create any proper filters
  • Creates Administrative roles for some users, based on an AD group
  • It is highly recommended to have extra admin accounts not tied to regular AD users emails, in case of errors, you do not want to lock yourself out
  • The script is modified to minimize duplicate emails and accounts - which Nprinting cannot handle

Requirements:

Credits:

Version 1.3 of this script, changedate 2017-12-21

Update: 1.3, changedate 2017-12-21

Added a second admin account

Added 10 filters to be used for Nprinting.


Update: 1.1, changedate 2017-09-18

Spelling errors.

Attachments
Comments
riccardozenere
Contributor III

Hi erikadvectas,

nice script. Have you tested it even with the last versions of NPrinting (November 2017/beta February 2018)?

Many thanks,

Riccardo

erikadvectas
Valued Contributor

Hi!

No, only September release. I will test the February release in March or so, when we upgrade.

Cheers

Version history
Revision #:
1 of 1
Last update:
‎03-31-2017 04:10 AM
Updated by: