topic Re: How to delete reports from NewsStand? in Qlik NPrinting

How to delete reports from NewsStand?

amweiner — Wed, 25 Sep 2019 18:40:54 GMT

We have been testing reports and report distributions, and as a result, have many test reports that are listed in the NewsStand. We would like to remove the test reports. I don't see any options for maintaining the NewsStand. Is there a way this can be done from the backend? I am using NPrinting 17.4.

Re: How to delete reports from NewsStand?

Anil_Babu_Samineni — Fri, 14 Jul 2017 02:24:09 GMT

+ vinod.nallapaneni‌ lech_miszkiewicz‌

Re: How to delete reports from NewsStand?

ogster1974 — Fri, 14 Jul 2017 07:41:07 GMT

Try setting the number of days to keep the reports on the publish task to 0.

Re: How to delete reports from NewsStand?

amweiner — Fri, 14 Jul 2017 16:53:00 GMT

When I set the Days to Keep to 0, the save button is disabled. If I try to create a new task and set the Days to keep button to 0, the Create button is disabled. So, don't think this will work.

Re: How to delete reports from NewsStand?

ogster1974 — Sat, 15 Jul 2017 11:49:00 GMT

Set it to 1 and see if it goes over the weekend.

Re: How to delete reports from NewsStand?

Ruggero_Piccoli — Mon, 17 Jul 2017 07:58:35 GMT

Unfortunatly at the moment (June 2017) there is not a Delete feature to delete reports on NewsStand.

As suggested you can set Days to Keep and Reports to Keep to the minimun value and wait.

Re: How to delete reports from NewsStand?

amweiner — Mon, 17 Jul 2017 19:26:18 GMT

Most of the reports were originally distributed with Days to Keep=1 and Reports to Keep=1. The problem is that several of them have been renamed or deleted over time (from the report list). I set up a task with the reports as they are currently named on the NewsStand hoping that the system will delete the report by name. But it looks like it is managing the report by internal ID, as opposed to name.

From what I am seeing, there is no way to manage these test and legacy reports.

Anyone from Qlik know when such a feature might be available? Administrators and end users must have a way to manage reports more efficiently.

Re: How to delete reports from NewsStand?

Ruggero_Piccoli — Tue, 18 Jul 2017 08:21:34 GMT

Hi,

We are aware that we will need to develop that feature, but right now (June 2017) it is not planned.

Best Regards,

Ruggero

Re: How to delete reports from NewsStand?

Anonymous — Mon, 21 Aug 2017 07:52:17 GMT

Hi,

I manged it via NPrinting Repository. There is table called published_reports, please delete older reports than specified date e.g.: DELETE FROM published_report WHERE last_update < '2017-08-12';

This kind of change requires restart of NPrinting services.

HTH

Ladislav

Re: How to delete reports from NewsStand?

Ruggero_Piccoli — Mon, 21 Aug 2017 10:53:42 GMT

This kind of change is very dangerous. If you execute the worng SLQ instruction you can irreparably damage the repository.

So:

- do a complete backup before to try this solution

- be sure that you know what you are doing

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: How to delete reports from NewsStand?

Lech_Miszkiewicz — Tue, 22 Aug 2017 00:51:38 GMT

Did you check if this table has any keys to other tables?

It could have worked for you (reports could disapear from NewsStand) but are you sure you did not break anything else?

regards

Lech

Re: How to delete reports from NewsStand?

Anonymous — Tue, 22 Aug 2017 07:10:04 GMT

Hi Lech,

Table published_reports has primary key "id" which is reference to the table file. In my case there were no refereces to the file table. As from previous experiences with postrgresql, if there would be any references to other tables, postgresql will notify you and not allow you to delete entries prior to deleting it from reference tables, if configured properly.

I am 100% sure, that i did not break anything in my case.

But as Ruggero pointed out, you have to be aware of impact of changes inside repository and backup is always necessary.

Regards,

Ladislav

Re: How to delete reports from NewsStand?

amweiner — Mon, 28 Aug 2017 14:38:50 GMT

I prefer not to perform any non-supported actions on a client database. So will wait until Qlik develops a feature that supports report management.

Re: How to delete reports from NewsStand?

matzenbacher — Wed, 16 Oct 2019 11:13:45 GMT

The date is October 2019.

Two years later we have a simple way to delete these blessed reports from the NewStand?
Qlik? Batman? Someone?

Many thanks!

Re: How to delete reports from NewsStand?

Ruggero_Piccoli — Wed, 16 Oct 2019 13:06:18 GMT

Hi,

You still continue to open a support ticket.

Support guys have a guide I wrote to delete reports published on the NewsStand by working on the Repository.

Best Regards,

Ruggero

Re: How to delete reports from NewsStand?

smendez — Tue, 10 Mar 2020 10:07:26 GMT

Hi,

if you try this https://support.qlik.com/articles/000073228

and after:

1- delete the all associated reports in Nprinting.

2- Reload NewStand Web, the reports no appear in history

Regards.

Re: How to delete reports from NewsStand?

Ruggero_Piccoli — Tue, 10 Mar 2020 10:37:21 GMT

Hi,

The article describes how to remove the files, but there are also data in the repository that need to be cleaned.

I suggest again to open a support ticket and work with a skilled support person that will follow the complete procedure. The deletion of reports published on the Qlik NPrinting NewsStand involves also an upgrade of the repository that must be done by a skilled person. If you damage the repository the installation could stop working.

This is valid until Qlik NPrinting will has an official published reports deleting feature that is in the roadmap but we don't know when it will be released.

Best Regards,

Ruggero

Re: How to delete reports from NewsStand?

Giuseppe_Panella — Tue, 16 Jun 2020 09:11:15 GMT

Hi,

starting from Qlik NPrinting June 2020 release you can delete reports from the NewsStand, here you can see how to do it.

[video]

Re: How to delete reports from NewsStand?

smendez — Tue, 16 Jun 2020 09:29:13 GMT

than you 😃

Re: How to delete reports from NewsStand?

Fran_by — Wed, 30 Dec 2020 09:22:47 GMT

Hi.

Users not use NewsStand in my company only mail report, but folder C:\ProgramData\NPrinting\apps very huge, I think because nprinting developer never uncheck Publish for NewsStand in Publuish Task Distinations.

How do I properly delete all NewsStand reports?