Is it possible add user or group dl direct in NPrinting databse?

[Irshadubs22]

Hi Team,

We need to add the new dl with new recipient id in NPrinting. We can not do this manual in prod. Is there any to add the mail DL direct in data base using command script or PowerShell script.?

Thanks,

Irshad Ahmad

[hooram95]

According to my info directly adding users or distribution lists in the NPrinting database is not supported and can cause serious issues. The safe way is to use the NPrinting web console or API to create recipients and assign them to DLs. You can automate this via the NPrinting API with PowerShell or scripts, which is fully supported. Avoid editing the database directly in production.

[Nagaraju_KCS · Accepted solution]

This method we are following - by using Recipient Import Task.

• Maintain Distribution List (DL) and associated recipient ID's and emails in an external source, such as a database table or an Excel/CSV file.
• Create a connection in NPrinting to this data source (if using a database or Qlik Sense/QlikView app).
• Configure an Import Task in the NPrinting Web Console. This task reads the list and automatically creates the corresponding Users and Groups in NPrinting.
• You can schedule this Import Task to run periodically to ensure your recipient list is always up-to-date in production.

Hope this helps!

[Lech_Miszkiewicz · Accepted solution]

@Irshadubs22 

as others suggested it is not recommended to manually insert records to repository DB as you will not create all required relationships!

alternatives available are:

• excel or ldap - once configured it can be triggered on schedule or via task API
  • excel https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/DeployingQVNprinting/Import-Use... 
  • ldap https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/DeployingQVNprinting/Import-Use... 
  • API call https://help.qlik.com/en-US/nprinting/February2025/APIs/NP+API/index.html?page=61 
• API itself:
  • https://help.qlik.com/en-US/nprinting/February2025/APIs/NP+API/index.html?page=73  with body of https://help.qlik.com/en-US/nprinting/February2025/APIs/NP+API/index.html?page=140 

cheers

[Irshadubs22]

Hi @Lech_Miszkiewicz ,

Thank you for this solution. I am able to add the user details in NPrinting. Is it possible to add users/groups automatically during the import of an Excel file or in some other automated way?

Thanks,

Irshad Ahmad

[Lech_Miszkiewicz]

Hi @Irshadubs22 

If your are you asking if you can import groups or assign users to groups during excel import then answer is yes! Details about that are in the links i provided earlier. 

if your question is if you can assign group or user as recipient of particular task then answer is NO. 
However what you can do is create a group you can assign to a task as a one-off exercise and then use user import to  (un)/assign people to that group

cherrs

[Irshadubs22]

Thank you @Lech_Miszkiewicz . It means there is no way to add published task recipient user for particular report using automated way?

[Lech_Miszkiewicz]

It depends how you look at it.
i say you do following:

• create a group
• Assign group to a publish task
• and from that point onwards you can create users using api or excel as well as add or remove people from that group. 

to me that is workable solution which does keep whole process automated allowing you (by use of group) control automatically which users receive it or not.  The only manual thing is initial setup.